biuan SAP® BUSINESS ONE SDK
API AIT9
AIT9 - Item - UoM Prices Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
PriceListPrice List No.Int
6OPLN
Price Lists
UomEntryUoM EntryInt
11OUOM
UoM Master Data
FactorReduced By %Num
20
PriceUoM PriceNum
20
CurrencyCurrency for UoM PricenVarChar
3OCRN
Currency Codes
AutoUpdateAutomatic UpdateVarChar
Y) Yes
N) No
1
Y
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
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4
Factor1Reduced By %Num
20
Factor2Reduced By %Num
20
UpdateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT AIT9.ItemCode AS 'Item No.', AIT9.PriceList AS 'Price List No.', AIT9.UomEntry AS 'UoM Entry', AIT9.Factor AS 'Reduced By %', AIT9.Price AS 'UoM Price', AIT9.Currency AS 'Currency for UoM Price', AIT9.AutoUpdate AS 'Automatic Update', AIT9.AddPrice1 AS 'Additional Price (1)', AIT9.Currency1 AS 'Currency for Add. Price 1', AIT9.AddPrice2 AS 'Additional Price (2)', AIT9.Currency2 AS 'Currency for Add. Price 2', AIT9.LogInstanc AS 'Log Instance', AIT9.ObjType AS 'Object', AIT9.Factor1 AS 'Reduced By %', AIT9.Factor2 AS 'Reduced By %', AIT9.UpdateDate AS 'Date of Update' FROM AIT9 AS AIT9

Related information


Currency Codes OCRN SQL Table

Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Price Lists OPLN SQL Table

UoM Master Data OUOM 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