| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | AGAR | G/L Account Advanced Rules - History | 19 | ItmsGrpCod | Item Group | Int | 6 | 0 | | |
2 | OGAR | G/L Account Advanced Rules | 19 | ItmsGrpCod | Item Group | Int | 6 | 0 | | |
TOPInventory and Production |
3 | AIGW | Item Group - Warehouse - History | 2 | ItmsGrpCod | Item Group Code | Int | 6 | 0 | | |
4 | AITB | Item Groups - History | 1 | ItmsGrpCod | Number | Int | 6 | 0 | | |
5 | AITM | Items - History | 4 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
6 | AQI1 | Inventory Opening Balance - Rows | 33 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
7 | IOD1 | Inventory Opening Balance Draft - Rows | 33 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
8 | IQI1 | Inventory Opening Balance - Rows | 33 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
9 | OIGW | Item Group - Warehouse | 2 | ItmsGrpCod | Item Group Code | Int | 6 | 0 | | |
10 | OITB | Item Groups | 1 | ItmsGrpCod | Number | Int | 6 | 0 | | |
11 | OITM | Items | 4 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
12 | SITM | Items | 4 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
13 | UITM | Items | 4 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |
TOPMarketing Documents |
14 | GPA2 | Gross Profit Adjustments - Parameters | 8 | ItmsGrpCod | Item Group | Int | 6 | 0 | 100 | |