| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AIQI | Inventory Opening Balance | 18 | PriceSrc | Price Source | VarChar | 1 | 0 | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost |
2 | AIQR | Inventory Posting | 18 | PriceSrc | Price Source | Int | 11 | 0 | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost |
3 | OIOD | Inventory Opening Balance Draft | 18 | PriceSrc | Price Source | VarChar | 1 | 0 | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost |
4 | OIPD | Inventory Posting Draft | 18 | PriceSrc | Price Source | Int | 11 | 0 | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost |
5 | OIQI | Inventory Opening Balance | 18 | PriceSrc | Price Source | VarChar | 1 | 0 | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost |
6 | OIQR | Inventory Posting | 18 | PriceSrc | Price Source | Int | 11 | 0 | 3 | 1=By Price List, 2=Last Evaluated Price, 3=Item Cost |