| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ANCM | NCM Code | 7 | GroupCode | Group Code | VarChar | 1 | 0 | 0 | |
| 2 | NFN1 | Not a Fiscal Sequence | 10 | GroupCode | Group | Int | 6 | 0 | 1 | |
| 3 | NNM1 | Documents Numbering - Series | 10 | GroupCode | Group | Int | 6 | 0 | 1 | 10=Series Group 10, 1=Series Group 1, 2=Series Group 2, 3=Series Group 3, 4=Series Group 4, 5=Series Group 5, 6=Series Group 6, 7=Series Group 7, 8=Series Group 8, 9=Series Group 9 |
| 4 | OCST | States | 9 | GroupCode | Group Code | Int | 6 | 0 | | |
| 5 | ONCG | State Groups | 1 | GroupCode | Group No. | Int | 6 | 0 | | |
| 6 | ONCM | NCM Code | 7 | GroupCode | Group Code | VarChar | 1 | 0 | L | |
| 7 | OPSG | Product Source Code Groups | 1 | GroupCode | Group No. | Int | 6 | 0 | | |
| 8 | OSTG | State Groups | 1 | GroupCode | Group No. | Int | 6 | 0 | | |
| TOPBusiness Partners |
| 9 | ACRD | Business Partners - History | 4 | GroupCode | Group Code | Int | 6 | 0 | | |
| 10 | OCOG | Commission Groups | 1 | GroupCode | Commission Group Code | Int | 6 | 0 | | |
| 11 | OCQG | Card Properties | 1 | GroupCode | Property Group Code | Int | 6 | 0 | | |
| 12 | OCRD | Business Partner | 4 | GroupCode | Group Code | Int | 6 | 0 | | |
| 13 | OCRG | Card Groups | 1 | GroupCode | Group No. | Int | 6 | 0 | | |
| 14 | OSLP | Sales Employee | 5 | GroupCode | Commission Group | Int | 6 | 0 | 0 | |
| 15 | TGG1 | Target Group Details | 4 | GroupCode | Group Code | nVarChar | 20 | 0 | | |
| TOPFinance |
| 16 | ODGL | Deduction Group List | 1 | GroupCode | Group Code | nVarChar | 2 | 0 | | |
| TOPGeneral |
| 17 | OBBI | Brazil Beverage Indexer | 3 | GroupCode | Beverage Group Code | nVarChar | 2 | 0 | | |
| 18 | OSTS | Service App Technician settings | 4 | GroupCode | Group Code | Int | 11 | 0 | | |
| 19 | RDGP | Development Groups | 2 | GroupCode | Development Group Code | nVarChar | 3 | 0 | | |
| 20 | RGRP | users groups | 1 | GroupCode | Group Code | Int | 11 | 0 | | |
| TOPInventory and Production |
| 21 | APLN | Price Lists | 6 | GroupCode | Group No. | Int | 6 | 0 | 1 | 1=Group 1, 2=Group 2, 3=Group 3, 4=Group 4 |
| 22 | OPLN | Price Lists | 6 | GroupCode | Group No. | Int | 6 | 0 | 1 | 1=Group 1, 2=Group 2, 3=Group 3, 4=Group 4 |
| 23 | OPSC | Product Source Code | 3 | GroupCode | Group Code | Int | 6 | 0 | | |
