| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AITB | Item Groups - History | 67 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | 1=Purchased from the domestic vendor, 2=Imported by company, 3=Imported Goods Purchased from the Domestic Vendor, 4=Produced by the Company |
2 | AITM | Items - History | 240 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | 1=Purchased from the domestic vendor, 2=Imported by company, 3=Imported Goods Purchased from the Domestic Vendor, 4=Produced by the Company |
3 | OITB | Item Groups | 67 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | 1=Purchased from the domestic vendor, 2=Imported by company, 3=Imported Goods Purchased from the Domestic Vendor, 4=Produced by the Company |
4 | OITM | Items | 240 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | 1=Purchased from the domestic vendor, 2=Imported by company, 3=Imported goods purchased from the domestic vendor, 4=Produced by the Company |
5 | UITM | Items | 240 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | 1=Purchased from the domestic vendor, 2=Imported by Company, 3=Imported Goods Purchased from the Domestic Vendor, 4=Produced by the Company |