| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | AIN1 | Inventory Counting - Rows | 8 | Counted | Counted | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | AITM | Items - History | 39 | Counted | Counted Qty | Num | 19 | 6 | | |
| 3 | AITW | Items - Warehouse - History | 7 | Counted | Counted Quantity | Num | 19 | 6 | | |
| 4 | ICD1 | Inventory Counting Draft - Rows | 8 | Counted | Counted | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 5 | INC1 | Inventory Counting - Rows | 8 | Counted | Counted | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | OITM | Items | 39 | Counted | Quantity Counted in Inventory | Num | 19 | 6 | | |
| 7 | OITW | Items - Warehouse | 7 | Counted | Counted Quantity | Num | 19 | 6 | | |
| 8 | OIWB | Items - Warehouse Counting Data Backup | 4 | Counted | Counted Quantity | Num | 19 | 6 | | |
| 9 | SITM | Items | 39 | Counted | Quantity Counted in Inventory | Num | 19 | 6 | | |
| 10 | SITW | Items - Warehouse | 7 | Counted | Counted Quantity | Num | 19 | 6 | | |
| 11 | UITM | Items | 39 | Counted | Quantity Counted in Inventory | Num | 19 | 6 | | |
| 12 | UITW | Items - Warehouse | 7 | Counted | Counted Quantity | Num | 19 | 6 | | |
