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

SQL

Inventory and Production /

Inventory Counting Draft - Individual Counters

API ICD8

ICD8 - Inventory Counting Draft - 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
   ICD8.DocEntry AS 'Internal Number', 
   ICD8.CounterNum AS 'Counter Number', 
   ICD8.CounteType AS 'Type of Counter', 
   ICD8.CounterId AS 'Counter ID', 
   ICD8.CounteName AS 'Counter Name', 
   ICD8.LogIns AS 'Log Instance - History', 
   ICD8.VisOrder AS 'Visual Order'
FROM ICD8 AS ICD8

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates