| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | ACRC | Credit Cards | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | AUSR | Archive Users - History | 33 | Locked | User Confirmation | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 3 | NFN1 | Not a Fiscal Sequence | 11 | Locked | Locked | VarChar | 1 | 0 | N | |
| 4 | NNM1 | Documents Numbering - Series | 11 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 5 | OCFP | CFOP for Nota Fiscal | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | OCRC | Credit Cards | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 7 | OCRN | Currency Codes | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 8 | OCRP | Payment Methods | 9 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 9 | OIDX | CPI Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 10 | OLNG | User Language Table | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 11 | ONFT | Nota Fiscal Tax Category (Brazil) | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 12 | OSTT | Sales Tax Authorities Type | 8 | Locked | Locked | VarChar | 1 | 0 | N | |
| 13 | OTNC | Transaction Category | 3 | Locked | Locked | VarChar | 1 | 0 | N | |
| 14 | OTNN | 1099 Forms | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 15 | OTPA | Tax Parameter Attributes | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Yes |
| 16 | OTPR | Tax Return Values | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Yes |
| 17 | OTSC | CST Code for Nota Fiscal | 4 | Locked | Locked | VarChar | 1 | 0 | N | |
| 18 | OUSG | Usage of Nota Fiscal | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 19 | OUSR | Users | 33 | Locked | User Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 20 | TNN1 | 1099 Boxes | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| Banking | ||||||||||
| 21 | ODSC | Bank Codes | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| Business Partners | ||||||||||
| 22 | OCLA | Activity Status | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 23 | OCLO | Meetings Location | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 24 | OCOG | Commission Groups | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 25 | OCRG | Card Groups | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 26 | OSLP | Sales Employee | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 27 | OVTP | Vendor Type | 4 | Locked | Locked | VarChar | 1 | 0 | N | |
| Finance | ||||||||||
| 28 | AVTG | Tax Definition | 7 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 29 | OACG | Account Category | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 30 | OBGS | Budget Scenario | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 31 | OMDR | Manual Distribution Rule | 5 | Locked | Locked | VarChar | 1 | 0 | N | |
| 32 | OPRJ | Project Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 33 | OTRC | Journal Entry Codes | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 34 | OVTG | Tax Definition | 7 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| Human Resources | ||||||||||
| 35 | OHED | Education Types | 4 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 36 | OHTY | Employee Types | 4 | locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| Inventory and Production | ||||||||||
| 37 | AITB | Item Groups - History | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 38 | AITW | Items - Warehouse - History | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 39 | AWHS | Warehouses - History | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 40 | IPF1 | Landed Costs - Rows | 38 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 41 | IPF2 | Landed Costs - Costs | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 42 | OARG | Customs Groups | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 43 | OITB | Item Groups | 3 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 44 | OITW | Items - Warehouse | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 45 | OLGT | Length Units | 6 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 46 | ORCN | Retail Chains | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 47 | OWGT | Weight Units | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 48 | OWHS | Warehouses | 8 | Locked | Locked | VarChar | 1 | 0 | N | N=Changeable, Y=Locked |
| 49 | UITW | Items - Warehouse | 14 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| Sales Opportunities | ||||||||||
| 50 | OOCR | Loading Factors | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 51 | OPRC | Profit Center | 5 | Locked | Locked | VarChar | 1 | 0 | N | N=No, Y=Yes |
| Service | ||||||||||
| 52 | OAGP | Agent Name | 4 | Locked | Locked | VarChar | 1 | 0 | ||
| 53 | OSCO | Service Call Origins | 4 | Locked | Locked | VarChar | 1 | 0 | ||
| 54 | OSCS | Service Call Statuses | 4 | Locked | Locked | VarChar | 1 | 0 | ||