biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Counting Draft - Team Counter - Row UoM
API ICD6
ICD6 - Inventory Counting Draft - 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 ICD6.DocEntry AS 'Internal Number', ICD6.LineNum AS 'Row Number', ICD6.ChildNum AS 'Child Number', ICD6.CounterNum AS 'Counter Number', ICD6.UomQty AS 'UoM Counted Qty', ICD6.InvtQty AS 'Counted Qty of Inventory UoM', ICD6.LogIns AS 'Log Instance - History' FROM ICD6 AS ICD6

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