biuan SAP® BUSINESS ONE SDK
API AIN11
AIN11 - Inventory Counting - Individual Counters - Row SnB Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11OINC
Inventory Counting
PRIMARYYes
LineNumRow NumberInt
11
SnbIndexSnB IndexInt
11
ItemCodeItem CodenVarChar
20OITM
Items
WhsCodeWarehousenVarChar
8OWHS
Warehouses
ObjIdObject IDInt
11
ObjAbsObject Abs.Int
11
DrfWObjAbsDraft Whse Obj. Abs.Int
11
-1
QuantityQuantityNum
20
SubLineNumSubrow NumberInt
11
-1
ObjTypeObject TypenVarChar
20
LogInstancLog Instance - HistoryInt
11
CounterNumCounter NumberInt
11

Table relationship map

SELECT statement

SELECT AIN11.DocEntry AS 'Internal Number', AIN11.LineNum AS 'Row Number', AIN11.SnbIndex AS 'SnB Index', AIN11.ItemCode AS 'Item Code', AIN11.WhsCode AS 'Warehouse', AIN11.ObjId AS 'Object ID', AIN11.ObjAbs AS 'Object Abs.', AIN11.DrfWObjAbs AS 'Draft Whse Obj. Abs.', AIN11.Quantity AS 'Quantity', AIN11.SubLineNum AS 'Subrow Number', AIN11.ObjType AS 'Object Type', AIN11.LogInstanc AS 'Log Instance - History', AIN11.CounterNum AS 'Counter Number' FROM AIN11 AS AIN11

Related information


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