biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Item - Prices - History
API AIT1
AIT1 - Item - Prices - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem NumbernVarChar
20OITM
Items		PRIMARYYes
PriceListPrice List No.Int
6OPLN
Price Lists
PricePrice ListNum
20
CurrencyPrice List CurrencynVarChar
3
OvrwrittenManual Price UpdateVarChar
Y) Yes
N) No
1
N
FactorFactorNum
20
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
AddPrice1Additional Price (1)Num
20
Currency1Currency for Add. Price 1nVarChar
3OCRN
Currency Codes
AddPrice2Additional Price (2)Num
20
Currency2Currency for Add. Price 2nVarChar
3OCRN
Currency Codes
Ovrwrite1Manual Price Entry (1)VarChar
Y) Yes
N) No
1
N
Ovrwrite2Manual Price Entry (2)VarChar
Y) Yes
N) No
1
N
BasePLNumBase Price List No.Int
6OPLN
Price Lists

Table relationship map

SELECT statement

SELECT AIT1.ItemCode AS 'Item Number', AIT1.PriceList AS 'Price List No.', AIT1.Price AS 'Price List', AIT1.Currency AS 'Price List Currency', AIT1.Ovrwritten AS 'Manual Price Update', AIT1.Factor AS 'Factor', AIT1.LogInstanc AS 'Log Instance', AIT1.ObjType AS 'Object', AIT1.AddPrice1 AS 'Additional Price (1)', AIT1.Currency1 AS 'Currency for Add. Price 1', AIT1.AddPrice2 AS 'Additional Price (2)', AIT1.Currency2 AS 'Currency for Add. Price 2', AIT1.Ovrwrite1 AS 'Manual Price Entry (1)', AIT1.Ovrwrite2 AS 'Manual Price Entry (2)', AIT1.BasePLNum AS 'Base Price List No.' FROM AIT1 AS AIT1

Related information


Price Lists OPLN SQL Table

Currency Codes OCRN SQL Table

Items OITM SQL Table

Object Settings - History ADP1 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