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

SQL Inventory and Production / Items - Multiple Preferred Vendors - History

API AIT2

AIT2 - Items - Multiple Preferred Vendors - History Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
ItemCode ^KEY ^UNIQUE	Item No.	nVarChar	20	OITM Items		PRIMARY	Yes
VendorCode	Vendor Code	nVarChar	15	OCRD Business Partner
LogInstanc	Log Instance	Int	11		0
ObjType	Object	nVarChar	20	ADP1 Object Settings - History

Table relationship map

SELECT statement

SELECT
   AIT2.ItemCode AS 'Item No.', 
   AIT2.VendorCode AS 'Vendor Code', 
   AIT2.LogInstanc AS 'Log Instance', 
   AIT2.ObjType AS 'Object'
FROM AIT2 AS AIT2

Related information

OITM SQL Table

ADP1 SQL Table

OCRD 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