biuan SAP® BUSINESS ONE SDK
API OEI14
OEI14 - Outgoing Excise Invoice - Assembly - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OOEI
Outgoing Excise Invoice
PRIMARYYes
LineNumRow NumberInt
11
-1
ChildNumChild NumberInt
11
-1
ItemCodeItem no.nVarChar
20OITM
Items
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
QuantityQuantityNum
20
TotalQtyTotal QuantityNum
20
OpenQtyRemaining Open QuantityNum
20
ObjectTypeobject typenVarChar
20ADP1
Object Settings - History
140000009
LogInstancLog InstanceInt
11
0
BaseChildNBase Child NumberInt
11
-1

Table relationship map

SELECT statement

SELECT OEI14.DocEntry AS 'Document Internal ID', OEI14.LineNum AS 'Row Number', OEI14.ChildNum AS 'Child Number', OEI14.ItemCode AS 'Item no.', OEI14.WhsCode AS 'Warehouse Code', OEI14.Quantity AS 'Quantity', OEI14.TotalQty AS 'Total Quantity', OEI14.OpenQty AS 'Remaining Open Quantity', OEI14.ObjectType AS 'object type', OEI14.LogInstanc AS 'Log Instance', OEI14.BaseChildN AS 'Base Child Number' FROM OEI14 AS OEI14

Related information


Outgoing Excise Invoice OOEI SQL Table

Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Warehouses OWHS SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates