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