| 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 | ONCM | NCM Code | 7 | GroupCode | Group Code | VarChar | 1 | 0 | L | |
| TOPBusiness Partners |
| 5 | ACRD | Business Partners - History | 4 | GroupCode | Group Code | Int | 6 | 0 | | |
| 6 | OCOG | Commission Groups | 1 | GroupCode | Commission Group Code | Int | 6 | 0 | | |
| 7 | OCQG | Card Properties | 1 | GroupCode | Property Group Code | Int | 6 | 0 | | |
| 8 | OCRD | Business Partner | 4 | GroupCode | Group Code | Int | 6 | 0 | | |
| 9 | OCRG | Card Groups | 1 | GroupCode | Group No. | Int | 6 | 0 | | |
| 10 | OSLP | Sales Employee | 5 | GroupCode | Commission Group | Int | 6 | 0 | 0 | |
| 11 | TGG1 | Target Group Details | 4 | GroupCode | Group Code | nVarChar | 20 | 0 | | |
| TOPFinance |
| 12 | ODGL | Deduction Group List | 1 | GroupCode | Group Code | nVarChar | 2 | 0 | | |
| TOPGeneral |
| 13 | OBBI | Brazil Beverage Indexer | 3 | GroupCode | Beverage Group Code | nVarChar | 2 | 0 | | |
| 14 | RDGP | Development Groups | 2 | GroupCode | Development Group Code | nVarChar | 3 | 0 | | |
| 15 | RGRP | users groups | 1 | GroupCode | Group Code | Int | 11 | 0 | | |
| TOPInventory and Production |
| 16 | APLN | Price Lists | 6 | GroupCode | Group No. | Int | 6 | 0 | 1 | 1=Group 1, 2=Group 2, 3=Group 3, 4=Group 4 |
| 17 | OPLN | Price Lists | 6 | GroupCode | Group No. | Int | 6 | 0 | 1 | 1=Group 1, 2=Group 2, 3=Group 3, 4=Group 4 |
