| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ACFP | CFOP for Nota Fiscal | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | ACRC | Credit Cards | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 3 | ASTT | Sales Tax Authorities Type | 8 | Locked | Locked | VarChar | 1 | 0 | N | |
| 4 | ATSC | CST Code for Nota Fiscal | 4 | Locked | Locked | VarChar | 1 | 0 | N | |
| 5 | AUSR | Archive Users - History | 33 | Locked | User Confirmation | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | NFN1 | Not a Fiscal Sequence | 11 | Locked | Locked | VarChar | 1 | 0 | N | |
| 7 | NNM1 | Documents Numbering - Series | 11 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 8 | OCFP | CFOP for Nota Fiscal | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 9 | OCRC | Credit Cards | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 10 | OCRN | Currency Codes | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 11 | OCRP | Payment Methods | 9 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 12 | ODCR | Checking Rule | 16 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 13 | OIDX | CPI Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 14 | OLNG | User Language Table | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 15 | ONFT | Nota Fiscal Tax Category (Brazil) | 3 | Locked | Locked | VarChar | 1 | 0 | N | |
| 16 | OSTT | Sales Tax Authorities Type | 8 | Locked | Locked | VarChar | 1 | 0 | N | |
| 17 | OTNC | Transaction Category | 3 | Locked | Locked | VarChar | 1 | 0 | N | |
| 18 | OTNN | 1099 Forms | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 19 | OTPA | Tax Parameter Attributes | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Yes |
| 20 | OTPR | Tax Return Values | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Yes |
| 21 | OTSC | CST Code for Nota Fiscal | 4 | Locked | Locked | VarChar | 1 | 0 | N | |
| 22 | OUSG | Usage of Nota Fiscal | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 23 | OUSR | Users | 33 | Locked | User Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 24 | TNN1 | 1099 Boxes | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| TOPBanking |
| 25 | ODSC | Bank Codes | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| TOPBusiness Partners |
| 26 | OCLA | Activity Status | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 27 | OCLO | Meetings Location | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 28 | OCOG | Commission Groups | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 29 | OCRG | Card Groups | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 30 | OEGP | E-Mail Group | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 31 | OSLP | Sales Employee | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 32 | OVTP | Vendor Type | 4 | Locked | Locked | VarChar | 1 | 0 | N | |
| TOPFinance |
| 33 | AMDR | Manual Distribution Rule | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 34 | APRJ | Project Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 35 | AVTG | Tax Definition | 7 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 36 | OACG | Account Category | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 37 | OACR | Accrual Type | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 38 | OBGS | Budget Scenario | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 39 | OFAA | Asset Attributes | 9 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 40 | OJET | JE Document Type | 2 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 41 | OMDR | Manual Distribution Rule | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 42 | OPRJ | Project Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 43 | OTRC | Journal Entry Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 44 | OVTG | Tax Definition | 7 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPGeneral |
| 45 | ARSB | Resource Groups - History | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 46 | ARSC1 | Resources - Warehouses - Log | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 47 | OFNS | Folio Numbering - Series | 11 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 48 | ORSB | Resource Groups | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 49 | RSC1 | Resources - Warehouses | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPHuman Resources |
| 50 | OHED | Education Types | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 51 | OHTY | Employee Types | 4 | locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 52 | OIDT | Employee ID Type | 2 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPInventory and Production |
| 53 | AITB | Item Groups - History | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 54 | AITW | Items - Warehouse - History | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 55 | AUGP | UoM Group | 11 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 56 | AUOM | UoM Master Data | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 57 | AWHS | Warehouses - History | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 58 | IPF1 | Landed Costs - Rows | 38 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 59 | IPF2 | Landed Costs - Costs | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 60 | OARG | Customs Groups | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 61 | OITB | Item Groups | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 62 | OITW | Items - Warehouse | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 63 | OLGT | Length Units | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 64 | ORCN | Retail Chains | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 65 | OUGP | UoM Group | 11 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 66 | OUOM | UoM Master Data | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 67 | OWGT | Weight Units | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 68 | OWHS | Warehouses | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 69 | SITW | Items - Warehouse | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 70 | UITW | Items - Warehouse | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPSales Opportunities |
| 71 | AOCR | Distribution Rule | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 72 | APRC | Cost Center | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 73 | OOCR | Distribution Rule | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 74 | OPRC | Cost Center | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPService |
| 75 | OAGP | Agent Name | 4 | Locked | Locked | VarChar | 1 | 0 | | |
| 76 | OSCO | Service Call Origins | 4 | Locked | Locked | VarChar | 1 | 0 | | |
| 77 | OSCS | Service Call Statuses | 4 | Locked | Locked | VarChar | 1 | 0 | | |
