biuan SAP® BUSINESS ONE SDK
API AIT6
AIT6 - Asset Item Distribution Rules Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
LineNumLine NumbernVarChar
11
ValidFromValid FromDate
8
ValidToValid ToDate
8
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrCode3Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrCode4Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrCode5Costing Code 5nVarChar
8OOCR
Distribution Rule
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4

Table relationship map

SELECT statement

SELECT AIT6.ItemCode AS 'Item No.', AIT6.LineNum AS 'Line Number', AIT6.ValidFrom AS 'Valid From', AIT6.ValidTo AS 'Valid To', AIT6.OcrCode AS 'Distribution Rule', AIT6.OcrCode2 AS 'Costing Code 2', AIT6.OcrCode3 AS 'Costing Code 3', AIT6.OcrCode4 AS 'Costing Code 4', AIT6.OcrCode5 AS 'Costing Code 5', AIT6.LogInstanc AS 'Log Instance', AIT6.ObjType AS 'Object' FROM AIT6 AS AIT6

Related information


Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR 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