biuan SAP® BUSINESS ONE SDK
API AIT2
AIT2 - Items - Multiple Preferred Vendors - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
VendorCodeVendor CodenVarChar
15OCRD
Business Partner
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
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


Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Business Partner OCRD SQL Table



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