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

SQL Inventory and Production / Inventory Counting - Individual Counters

API AIN8

AIN8 - Inventory Counting - Individual Counters Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Internal Number	Int		11	OINC Inventory Counting		BUSINESS	Yes
CounterNum	Counter Number	Int		11
CounteType	Type of Counter	Int	12) User 171) Employee	11		12
CounterId	Counter ID	Int		11
CounteName	Counter Name	nVarChar		127
LogIns	Log Instance - History	Int		11
VisOrder	Visual Order	Int		11

SELECT statement

SELECT
   AIN8.DocEntry AS 'Internal Number', 
   AIN8.CounterNum AS 'Counter Number', 
   AIN8.CounteType AS 'Type of Counter', 
   AIN8.CounterId AS 'Counter ID', 
   AIN8.CounteName AS 'Counter Name', 
   AIN8.LogIns AS 'Log Instance - History', 
   AIN8.VisOrder AS 'Visual Order'
FROM AIN8 AS AIN8

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