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

SQL Inventory and Production / Inventory Counting - Team Counters - Row Counted Qty

API AIN5

AIN5 - Inventory Counting - Team Counters - Row Counted Qty 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
CounterNum	Counter Number	Int	11
TotalQty	Total Qty of Inventory UoM	Num	20
LogIns	Log Instance - History	Int	11

SELECT statement

SELECT
   AIN5.DocEntry AS 'Internal Number', 
   AIN5.LineNum AS 'Row Number', 
   AIN5.CounterNum AS 'Counter Number', 
   AIN5.TotalQty AS 'Total Qty of Inventory UoM', 
   AIN5.LogIns AS 'Log Instance - History'
FROM AIN5 AS AIN5

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