ICD6 - biuan.com SDK Developer - SAP® Business ONE (SBO)

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

Field	Description	Type	Size	Related	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Internal Number	Int	11	OINC Inventory Counting	PRIMARY	Yes
LineNum	Row Number	Int	11
ChildNum	Child Number	Int	11
CounterNum	Counter Number	Int	11
UomQty	UoM Counted Qty	Num	20
InvtQty	Counted Qty of Inventory UoM	Num	20
LogIns	Log Instance - History	Int	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

OINC SQL Table

biuan SAP® BUSINESS ONE

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