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

SQL Inventory and Production / Items - Warehouse Counting Data Backup

API OIWB

OIWB - Items - Warehouse Counting Data Backup Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Abs. Entry	Int		11			PRIMARY	Yes
ItemCode ^KEY ^UNIQUE	Item No.	nVarChar		20	OITM Items		SYSTEM_KEY	Yes
WhsCode	Warehouse Code	nVarChar		8	OWHS Warehouses
Counted	Counted Quantity	Num		20
WasCounted	Counted Yes/No	VarChar	Y) Yes N) No	1		N

Table relationship map

SELECT statement

SELECT
   OIWB.AbsEntry AS 'Abs. Entry', 
   OIWB.ItemCode AS 'Item No.', 
   OIWB.WhsCode AS 'Warehouse Code', 
   OIWB.Counted AS 'Counted Quantity', 
   OIWB.WasCounted AS 'Counted Yes/No'
FROM OIWB AS OIWB

Related information

OIWB SQL Table

OITM SQL Table

OWHS 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