biuan SAP® BUSINESS ONE SDK
API AQI2
AQI2 - Inventory Opening Balance - 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
TakerTypeCounter TypeInt
0
1) Two Counters - Counter 1
2) Two Counters - Counter 2
11

Table relationship map

SELECT statement

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

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