Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Inventory and Production | ||||||||||
1 | AITM | Items - History | 12 | OnHand | In Stock | Num | 19 | 6 | ||
2 | AITW | Items - Warehouse - History | 3 | OnHand | In Stock | Num | 19 | 6 | ||
3 | OITM | Items | 12 | OnHand | In Stock | Num | 19 | 6 | ||
4 | OITW | Items - Warehouse | 3 | OnHand | In Stock | Num | 19 | 6 | ||
5 | SITM | Items | 12 | OnHand | In Stock | Num | 19 | 6 | ||
6 | SITW | Items - Warehouse | 3 | OnHand | In Stock | Num | 19 | 6 | ||
7 | UITM | Items | 12 | OnHand | In Stock | Num | 19 | 6 | ||
8 | UITW | Items - Warehouse | 3 | OnHand | In Stock | Num | 19 | 6 |