| 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 | |
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 | |
5 | SITM | Items | 240 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | |
6 | UITM | Items | 240 | ProductSrc | Product Source | VarChar | 1 | 0 | 1 | |