biuan SAP® BUSINESS ONE SDK
API ADO16
ADO16 - Draft - SnB properties Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEDocument NumberInt
11ADOC
Invoice - History
PRIMARYYes
LineNumRow NumberInt
11
SnBIndexSnB IndexInt
11
ItemCodeItem CodenVarChar
20OITM
Items
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
ObjIdObject IDInt
11
ObjAbsSnB Object No.Int
11
DrfWObjAbsSnBW Draft Object No.Int
11
-1
QuantityQttyNum
20
SubLineNumSubrow NumberInt
11
-1
ObjTypeObject TypenVarChar
20
LogInstancLog InstanceInt
11

Table relationship map

SELECT statement

SELECT ADO16.AbsEntry AS 'Document Number', ADO16.LineNum AS 'Row Number', ADO16.SnBIndex AS 'SnB Index', ADO16.ItemCode AS 'Item Code', ADO16.WhsCode AS 'Warehouse Code', ADO16.ObjId AS 'Object ID', ADO16.ObjAbs AS 'SnB Object No.', ADO16.DrfWObjAbs AS 'SnBW Draft Object No.', ADO16.Quantity AS 'Qtty', ADO16.SubLineNum AS 'Subrow Number', ADO16.ObjType AS 'Object Type', ADO16.LogInstanc AS 'Log Instance' FROM ADO16 AS ADO16

Related information


Invoice - History ADOC SQL Table

Items OITM 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates