biuan SAP® BUSINESS ONE SDK
API AIT5
AIT5 - Asset Item Projects - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
LineNumLine NumberInt
11
ValidFromValid FromDate
8
ValidToValid ToDate
8
ProjectProjectnVarChar
20OPRJ
Project Codes
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4

Table relationship map

SELECT statement

SELECT AIT5.ItemCode AS 'Item No.', AIT5.LineNum AS 'Line Number', AIT5.ValidFrom AS 'Valid From', AIT5.ValidTo AS 'Valid To', AIT5.Project AS 'Project', AIT5.LogInstanc AS 'Log Instance', AIT5.ObjType AS 'Object' FROM AIT5 AS AIT5

Related information


Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Project Codes OPRJ SQL Table



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