biuan SAP® BUSINESS ONE SDK
API AIN6
AIN6 - Inventory Counting - Team Counter - Row UoM Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11OINC
Inventory Counting
PRIMARYYes
LineNumRow NumberInt
11
ChildNumChild NumberInt
11
CounterNumCounter NumberInt
11
UomQtyUoM Counted QtyNum
20
InvtQtyCounted Qty of Inventory UoMNum
20
LogInsLog Instance - HistoryInt
11

SELECT statement

SELECT AIN6.DocEntry AS 'Internal Number', AIN6.LineNum AS 'Row Number', AIN6.ChildNum AS 'Child Number', AIN6.CounterNum AS 'Counter Number', AIN6.UomQty AS 'UoM Counted Qty', AIN6.InvtQty AS 'Counted Qty of Inventory UoM', AIN6.LogIns AS 'Log Instance - History' FROM AIN6 AS AIN6

Related information


Inventory Counting OINC 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