Name
|
Type
|
Description
|
RoutingId
|
Edm.String(60)
|
Entity Relation: RoutingLine -> RoutingId
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_APL_HEADER"."ItemCode"
|
|
ForItemCode
|
Edm.String(50)
|
Linked to Items. It's only for information
Linked table: OITM
Linked column: ItemCode
Integration hub: Importable
Database: "BEAS_APL_HEADER"."ForItemCode"
|
|
MatchCode
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."MatchCode"
|
|
Type
|
Edm.String(20)
|
Type of routing. Current only "bom" allowed
Default Value: bom
Constraints:
bill of material=bom
Integration hub: Importable
Database: "BEAS_APL_HEADER"."TYP"
|
|
Description
|
Edm.String(255)
|
Integration hub: Importable
Mandatory field
Database: "BEAS_APL_HEADER"."DESCRIPTION"
|
|
Remarks
|
Edm.String(255)
|
Long description for this routing plan
Integration hub: Importable
Database: "BEAS_APL_HEADER"."Remarks"
|
|
Color
|
Edm.Int32
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL_HEADER"."COLORID"
|
|
Bitmap
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."BITMAPNAME"
|
|
RevisionLevel
|
Edm.String(30)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."RevisionLevel"
|
|
IVersionId
|
Edm.String(20)
|
Version number. Is only for information. This function have not additional functionality.
Database: "BEAS_APL_HEADER"."Version"
|
|
Status
|
Edm.String(20)
|
Database: "BEAS_APL_HEADER"."Status"
|
|
CanModify
|
Edm.Boolean
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."CanModify"
|
|
ReleasePersonellName
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."ReleasePersName"
|
|
ReleaseStationId
|
Edm.String(20)
|
Database: "BEAS_APL_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_APL_HEADER"."ReleaseDate"
|
|
DateFrom
|
Edm.DateTimeOffset
|
Database: "BEAS_APL_HEADER"."DateFrom"
|
|
DateTo
|
Edm.DateTimeOffset
|
Database: "BEAS_APL_HEADER"."DateTo"
|
|
Block
|
Edm.Boolean
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL_HEADER"."Block"
|
|
BlockReason
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_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_APL_HEADER"."BlockDate"
|
|
AccessGroupId
|
Edm.String(20)
|
Database: "BEAS_APL_HEADER"."AccessGroup"
|
|
UDF1
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF1"
|
|
UDF2
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF2"
|
|
UDF3
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF3"
|
|
UDF4
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF4"
|
|
UDF5
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF5"
|
|
UDF6
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF6"
|
|
UDF7
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF7"
|
|
UDF8
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF8"
|
|
UDF9
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF9"
|
|
UDF10
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF10"
|
|
UDF11
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF11"
|
|
UDF12
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF12"
|
|
UDF13
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF13"
|
|
UDF14
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_HEADER"."UDF14"
|
|
UDF15
|
Edm.String(100)
|
Database: "BEAS_APL_HEADER"."UDF15"
|
|
