Name
|
Type
|
Description
|
DocEntry
|
Edm.Int32
|
Database: "BEAS_PLANDOCUMENT_LINE"."DocEntry"
|
|
LineNumber
|
Edm.Int32
|
Database: "BEAS_PLANDOCUMENT_LINE"."LineNum"
|
|
DocType
|
Edm.String(20)
|
Transaction type
Import: allways "import"
Database: "BEAS_PLANDOCUMENT_LINE"."DocType"
|
|
PersonnelId
|
Edm.String(20)
|
Linked table: BEAS_PERS
Linked column: PERS_ID
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."PERS_ID"
|
|
StationId
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."STATION_ID"
|
|
DocDate
|
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_PLANDOCUMENT_LINE"."DocDate"
|
|
Quantity
|
Edm.Decimal
|
Integration hub: Importable
Mandatory field
Database: "BEAS_PLANDOCUMENT_LINE"."Quantity"
|
|
ItemCode
|
Edm.String(50)
|
Entity Relation: Item -> ItemCode
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."ItemCode"
|
|
WhsCode
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."WhsCode"
|
|
IVersion
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."Version"
|
|
DistNumber
|
Edm.String(40)
|
Batch Number (OBTN.DistNumber)
Or internal Serial Number (OSRN.SysNumber)
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."DistNumber"
|
|
SysNumber
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."SysNumber"
|
|
BinCode
|
Edm.String(40)
|
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."BINCODE"
|
|
RFID
|
Edm.String(40)
|
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."RFID"
|
|
ToWhsCode
|
Edm.String(20)
|
Database: "BEAS_PLANDOCUMENT_LINE"."TOWHSCODE"
|
|
ToBinCode
|
Edm.String(40)
|
Database: "BEAS_PLANDOCUMENT_LINE"."TOBINCODE"
|
|
ToRFID
|
Edm.String(40)
|
Database: "BEAS_PLANDOCUMENT_LINE"."TORFID"
|
|
BaseDocType
|
Edm.String(20)
|
Type of base document
Example: WO = Workorder
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."BASE_DOCTYPE"
|
|
BaseDocEntry
|
Edm.Int32
|
Document entry
Example: work order = BEAS_FTHAUPT.BELNR_ID
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."BASE_DOCENTRY"
|
|
BaseLineNumber
|
Edm.Int32
|
Document entry
Example: work order position = BEAS_FTFTPOS.BELPOS_ID
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."BASE_LINENUM"
|
|
BaseLineNumber2
|
Edm.Int32
|
Document entry line 2
Example: work order bom position = BEAS_FTSTL.POS_ID
Integration hub: Importable
Database: "BEAS_PLANDOCUMENT_LINE"."BASE_LINENUM2"
|
|
LifeDate
|
Edm.DateTimeOffset
|
Database: "BEAS_PLANDOCUMENT_LINE"."LIFETIME"
|
|
