| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Inventory and Production | ||||||||||
| 1 | AIN1 | Inventory Counting - Rows | 33 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 2 | AITM | Items - History | 20 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 3 | AQI1 | Inventory Opening Balance - Rows | 29 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 4 | AQR1 | Inventory Posting - Rows | 28 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 5 | ICD1 | Inventory Counting Draft - Rows | 33 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 6 | INC1 | Inventory Counting - Rows | 33 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 7 | IOD1 | Inventory Opening Balance Draft - Rows | 29 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 8 | IPD1 | Inventory Posting Draft - Rows | 28 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 9 | IQI1 | Inventory Opening Balance - Rows | 29 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 10 | IQR1 | Inventory Posting - Rows | 28 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 11 | OITM | Items | 20 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 12 | SITM | Items | 20 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||
| 13 | UITM | Items | 20 | SuppCatNum | Mfr Catalog No. | nVarChar | 50 | 0 | ||