| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AIT1 | Item - Prices - History | 17 | PriceType | Price Type | VarChar | 1 | 0 | M | I=Inventory UoM Price, M=Both I and P, O=Other UoM Price, P=Pricing Unit Price |
2 | AIT9 | Item - UoM Prices | 17 | PriceType | Price Type | VarChar | 1 | 0 | O | I=Inventory UoM Price, M=Both I and P, O=Other UoM Price, P=Pricing Unit Price |
3 | ITM1 | Items - Prices | 17 | PriceType | Price Type | VarChar | 1 | 0 | M | I=Inventory UoM Price, M=Both I and P, O=Other UoM Price, P=Pricing Unit Price |
4 | ITM9 | Item - UoM Prices | 17 | PriceType | Price Type | VarChar | 1 | 0 | O | I=Inventory UoM Price, M=Both I and P, O=Other UoM Price, P=Pricing Unit Price |