| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AIN1 | Inventory Counting - Rows | 32 | FirmCode | Manufacturer | Int | 6 | 0 | | |
2 | AITM | Items - History | 100 | FirmCode | Manufacturer | Int | 6 | 0 | -1 | |
3 | AQI1 | Inventory Opening Balance - Rows | 28 | FirmCode | Manufacturer | Int | 6 | 0 | | |
4 | AQR1 | Inventory Posting - Rows | 27 | FirmCode | Manufacturer | Int | 6 | 0 | | |
5 | ICD1 | Inventory Counting Draft - Rows | 32 | FirmCode | Manufacturer | Int | 6 | 0 | | |
6 | INC1 | Inventory Counting - Rows | 32 | FirmCode | Manufacturer | Int | 6 | 0 | | |
7 | IOD1 | Inventory Opening Balance Draft - Rows | 28 | FirmCode | Manufacturer | Int | 6 | 0 | | |
8 | IPD1 | Inventory Posting Draft - Rows | 27 | FirmCode | Manufacturer | Int | 6 | 0 | | |
9 | IQI1 | Inventory Opening Balance - Rows | 28 | FirmCode | Manufacturer | Int | 6 | 0 | | |
10 | IQR1 | Inventory Posting - Rows | 27 | FirmCode | Manufacturer | Int | 6 | 0 | | |
11 | OITM | Items | 100 | FirmCode | Manufacturer | Int | 6 | 0 | -1 | |
12 | OMRC | Manufacturers | 1 | FirmCode | Code | Int | 6 | 0 | | |
13 | SITM | Items | 100 | FirmCode | Manufacturer | Int | 6 | 0 | -1 | |
14 | UITM | Items | 100 | FirmCode | Manufacturer | Int | 6 | 0 | -1 | |