| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeneral |
1 | ITMR | ITMR | 58 | BarCode | Print as Barcode | VarChar | 1 | 0 | 0 | 0=No, 1=Yes |
TOPInventory and Production |
2 | ABIN | Bin Location - History | 35 | BarCode | Bar Code | nVarChar | 100 | 0 | | |
3 | AIN1 | Inventory Counting - Rows | 13 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
4 | AIN2 | Inventory Counting - UoM | 4 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
5 | AQI1 | Inventory Opening Balance - Rows | 24 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
6 | AQR1 | Inventory Posting - Rows | 24 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
7 | AQR2 | Inventory Counting - UoM | 4 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
8 | ICD1 | Inventory Counting Draft - Rows | 13 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
9 | ICD2 | Inventory Counting Draft - UoM | 4 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
10 | INC1 | Inventory Counting - Rows | 13 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
11 | INC2 | Inventory Counting - UoM | 4 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
12 | IOD1 | Inventory Opening Balance Draft - Rows | 24 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
13 | IPD1 | Inventory Posting Draft - Rows | 24 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
14 | IPD2 | Inventory Posting Draft - UoM | 4 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
15 | IQI1 | Inventory Opening Balance - Rows | 24 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
16 | IQR1 | Inventory Posting - Rows | 24 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
17 | IQR2 | Inventory Posting - UoM | 4 | BarCode | Bar Code | nVarChar | 254 | 0 | | |
18 | OBIN | Bin Location | 35 | BarCode | Bar Code | nVarChar | 100 | 0 | | |
TOPReports |
19 | RITM | Reporting Element | 58 | BarCode | Print as Bar Code | VarChar | 1 | 0 | N | N=No, Y=Yes |