Present the DocumentLines from Document Alias
Transfer -> TransferLines
Entity Collections Properties
Typ
Description
Table
WTQ1
Primary
DocEntry
Primary mandatory
no
GET
yes
POST
yes
UDF Support
yes (get and post)
ReceiptLines
Property
Description
Table
IGN1
Primary key
DocEntry/i,LineNum/i
$transaction
no
$branch
no
$mask
no
Fields
Name
Type
Description
DocEntry
Edm.Int32
Database: "IGN1"."DocEntry"
LineNum
Edm.Int32
Database: "IGN1"."LineNum"
LineStatus
Edm.String(1)
Database: "IGN1"."LineStatus"
LineType
Edm.Int32
Database: "IGN1"."LineType"
LineType
Edm.Int32
Database: "IGN1"."LineType"
VisualOrder
Edm.Int32
Database: "IGN1"."VisOrder"
ItemCode
Edm.String(50)
Entity Relation: Item -> ItemCode
Database: "IGN1"."ItemCode"
ItemDescription
Edm.String(100)
Database: "IGN1"."Dscription"
ItemDetails
Edm.String(16000)
OpenQty
Edm.Decimal
Database: "IGN1"."OpenQty"
Quantity
Edm.Decimal
Database: "IGN1"."Quantity"
UoMCode
Edm.String(20)
Entity Relation: UoM -> UoMCode
Database: "IGN1"."unitMsr"
QuantityPerStockUnit
Edm.String(20)
Database: case when coalesce("IGN1"."NumPerMsr",0)=0 then 1 else "IGN1"."NumPerMsr" end
WhsCode
Edm.String(20)
Entity Relation: WareHouse -> WhsCode
Database: "IGN1"."WhsCode"
ShipDate
Edm.String
Database: "IGN1"."ShipDate"
BarCode
Edm.String(16)
Database: "IGN1"."CodeBars"
BaseType
Edm.String(10)
Database: "IGN1"."BaseType"
BaseEntry
Edm.Int32
Database: "IGN1"."BaseEntry"
BaseLine
Edm.Int32
Database: "IGN1"."BaseLine"
BaseOpenQuantity
Edm.Decimal
Database: "IGN1"."BaseOpnQty"
WorkOrderNumber
Edm.Int32
Database: "IGN1"."U_belnrid"
WorkOrderPosition
Edm.Int32
Database: "IGN1"."U_belposid"
WorkOrderBoM
Edm.Int32
Database: "IGN1"."U_posid"
PrjCode
Edm.String(20)
Database: "IGN1"."Project"
Relations
Join to Entiy Object
Relation
Item
ItemCode
UoM
UoMCode
WareHouse
WhsCode
POST:
Follow fields available
Property
Type
GET
POST
Description
DocEntry
Number
X
Internal DocEntry Number
ItemCode
String(50)
X
X
Item Code
ItemDescription
String(100)
X
X
Item Description
IVersionId
String(20)
X
Item Version Number
Quantity
Decimal
X
X
UoMCode
String(20)
X
Stock Unit
WhsCode
String(20)
X
X
Define the Warehouse
PrjCode
String(20)
X
X
Define the Project Code
UDF1...4
String(20)
X
UDF Fields 1...4
Price
Decimal
X
Price, only if Document.PriceType="fromplandocument"
Currency
String(6)
X
Currency
ResDocEntry
Number
X
Define link to Reservation DocEntry / Line Number
On header level you must define "delReservation":true. In this case the system will update / delete all defined reservations after creation of document
Note: This is not the SAP Document Number. This is the Reservation.DocEntry
ResLineNumber
Number
X
Reference to Reservation LineNum
Base_Link
String(1)
X
S=SAP Link
B=beas Link (Default)
SAP Link
Use this, if you want to create a document to a base document
Example Delivery Note from Sales Order
In this case you define
Base_DocType=17
Base_DocEntry=RDR1.DocEntry
Base_LineNumber=RDR1.LineNum
BEAS Link
Use beas link, if you want to create only a reference
In Base_DocType you define the base type
wo = beas work order
17 = SAP Sales Order
13 = SAP Pre Invoice
Base_DocType
String(5)
X
Document will create from BaseType... example for Work order BoM Position
Base_DocEntry
Number
X
Base Document DocEntry (Example RDR1.DocEntry) or Work order BEAS_FTHAUPT.BELNR_ID
Base_LineNumber
Number
X
Link to BEAS_FTPOS.BELPOS_ID or Base Document RDR1.LineNum
Base_LineNumber2
Number
Link to BEAS_FTSTL.POS_ID
Base_BaseDocument
Number
X
Base document from Base document
Base_BaseLine
Number
X
Base document from Base document
U_xxxx
Any
X
X
Define own UDF fields
CloseEntry
Boolean
x
only for receiptWo document type
if true, the system use price valuation for "last receipt" and close the work order position or Bill of Material position
Note:
if receipt document part of a time receipt, then it's not allowed to close the work order position in the receipt document. "doNotClosePosition" : true in the receipt part:
TimeReceipt { "CloseEntry" : true , /* Last entry. We will close time receipt and work order position */ "Receipt" :{ "doNotClosePosition" : true , /* We want to close, but on time receipt level. Don't close in receipt document */ " Lines ":[{ "ItemCode" : "FP" , "WhsCode" : "01" , "Quantity" : 2 , "CloseEntry" : true /* Close document. We need this only for price valuation */ }]
PTICode
String(5)
X
Reference to table USR8/OPTI. For location Argentinia. Allow to define this on Header and line level. But the system will write this always on Header level. If you define this in more then one line, the system use PTICode always from last line.
Scrap
Number
X
External PO to External PO Delivery: We can define the scrap.
The System save this on line level i n column u_beas_von_lag. beas2020.09
Batch- and SerialNumber Informations
Note: You can define 1 document line per Batch/Serial or you can define the Batch/Serial information separatly in
object BatchNumbers, SerialNumbers. See example
Property
Type
GET
POST
Description
DistNumber
String(32)
X
If not defined and the item / batch defintion is not "manual entry", then the system can create the Batch / Serial number automatically
Note: Don't use Batchnum or BatchNumber.
If serial number, you can define more then one Serial number
With Comma
serial-a,serial-b,serial-c ...
With String
The Numbering must be inside brackets: { and }
Example: AB{0001}C produce follow serial numbers:
AB0001C, AB0002C, AB0003C,AB004C,...AB012C ...
SystemNumber
Number
X
Internal Batch Number or Serial Number (for Issue Documents, only Serial numbers) OBTN.SysNumber Beas 2020.06
LinkedDistNumber
String(32)
X
Reference to related Serial/Batch Number
Status
String(1)
X
Status of BatchNumber (0-2) only Batch Numbers
BatchAttribut1
String
X
This field became in last year different names:
Batch attribut 1, Manufacture Serial Number, Sub Serial Number
Table: OBTN.MnfSerial Beas 2020.06
BatchAttribut2
String
X
This field became in last years different names:
Lot Number, Internal Serial Number
Table: OBTN.LotNumber Beas 2020.06
Notes
String
X
Notes, Details
AdmissionDate
DateTime
X
In Date (OBTN.InDate) Beas 2020.06
ManufacturingDate
DateTime
X
Production Date (OBTN.MnfDate) Beas 2020.06
ExpirationDate
DateTime
X
ExpirationDate (OBTN.ExpDate) Beas 2020.06
WarrantyStart
DateTime
X
Warranty Start (OSRN.GrntStart) Beas 2020.06
WarrantyEnd
DateTime
X
Warranty End (OSRN.GrntEnd) Beas 2020.06
BinLocation Informations
Property
Type
GET
POST
Description
BinCode
String(20)
X
Bin Code
RFID
String(20)
X
RFID Number
Additional fields for Transfer Lines
ToWareHouse
string(20)
X
Transfer object: Target WareHouse
ToBinCode
string(20)
X
Transfer object: Target BinCode
ToRfid
string(20)
X
Transfer object: Target Rfid
