Name
|
Type
|
Description
|
BillOfMaterialId
|
Edm.String(60)
|
The id of bill of material list
It can be the same as the item but can have a own number
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_STL_HEADER"."ItemCode"
|
|
Type
|
Edm.String(20)
|
Default Value: bom
Constraints:
standard=bom
Integration hub: Importable
Database: "BEAS_STL_HEADER"."TYP"
|
|
Description
|
Edm.String(255)
|
Description for the bill of material definition
Integration hub: Importable
Mandatory field
Database: "BEAS_STL_HEADER"."DESCRIPTION"
|
|
ForItemCode
|
Edm.String(50)
|
Describe, for which item you use this bill of material (linked to OITM)
Linked table: OITM
Linked column: ItemCode
Integration hub: Importable
Database: "BEAS_STL_HEADER"."ForItemCode"
|
|
MatchCode
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."MatchCode"
|
|
Remarks
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."Remarks"
|
|
Color
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."COLORID"
|
|
Bitmap
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."BITMAPNAME"
|
|
DrawingNumber
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."ZNR"
|
|
RoutingId
|
Edm.String(50)
|
Linked table: BEAS_APL_HEADER
Linked column: ItemCode
Integration hub: Importable
Database: "BEAS_STL_HEADER"."RoutingId"
|
|
IVersionId
|
Edm.String(20)
|
Version field is not visible in the program
Default Value: 1
Integration hub: Importable
Database: "BEAS_STL_HEADER"."Version"
|
|
RevisionLevel
|
Edm.String(30)
|
Default Value: 1
Integration hub: Importable
Database: "BEAS_STL_HEADER"."RevisionLevel"
|
|
Status
|
Edm.String(20)
|
Status field is not visible in the program
Default Value: 1
Integration hub: Importable
Database: "BEAS_STL_HEADER"."Status"
|
|
Release
|
Edm.Boolean
|
Default Value: 1
Constraints:
yes=1
no=0
Integration hub: Importable
Database: "BEAS_STL_HEADER"."Release"
|
|
CanModify
|
Edm.Boolean
|
Default Value: 1
Integration hub: Importable
Database: "BEAS_STL_HEADER"."CanModify"
|
|
ReleasePersonellName
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."ReleasePersName"
|
|
ReleaseStationId
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."ReleaseStationId"
|
|
ReleaseDate
|
Edm.DateTimeOffset
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
Integration hub: Importable
Database: "BEAS_STL_HEADER"."ReleaseDate"
|
|
DateFrom
|
Edm.DateTimeOffset
|
Valid Date.
Attention: beas check this field, but current it is not visible in the program
Database: "BEAS_STL_HEADER"."DateFrom"
|
|
DateTo
|
Edm.DateTimeOffset
|
Valid Date.
Attention: beas check this field, but current it is not visible in the program
Database: "BEAS_STL_HEADER"."DateTo"
|
|
Block
|
Edm.Boolean
|
Default Value: 0
Constraints:
yes=1
no=0
Integration hub: Importable
Database: "BEAS_STL_HEADER"."Block"
|
|
BlockReason
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."BlockReason"
|
|
BlockDate
|
Edm.DateTimeOffset
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
Integration hub: Importable
Database: "BEAS_STL_HEADER"."BlockDate"
|
|
AccessGroupId
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."AccessGroup"
|
|
UDF1
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF1"
|
|
UDF2
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF2"
|
|
UDF3
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF3"
|
|
UDF4
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF4"
|
|
UDF5
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF5"
|
|
UDF6
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF6"
|
|
UDF7
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF7"
|
|
UDF8
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF8"
|
|
UDF9
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF9"
|
|
UDF10
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF10"
|
|
UDF11
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF11"
|
|
UDF12
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF12"
|
|
UDF13
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF13"
|
|
UDF14
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF14"
|
|
UDF15
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL_HEADER"."UDF15"
|
|
