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