| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AFML | Tax Formula Master Table | 3 | Descr | Description | nVarChar | 100 | 0 | | |
2 | APFS | Personal Fields Setup - History | 15 | Descr | Description | nVarChar | 254 | 0 | | |
3 | CUFD | User Fields - Description | 4 | Descr | Description | nVarChar | 80 | 0 | | |
4 | OBMI | Brazilian Multi-Indexer | 4 | Descr | Description | nVarChar | 254 | 0 | | |
5 | OBSI | Brazil String Indexer | 3 | Descr | Beverage Table | Text | 16 | 0 | | |
6 | ODCI | Intrastat Configuration | 4 | Descr | Description | nVarChar | 254 | 0 | | |
7 | OFML | Tax Formula Master Table | 3 | Descr | Description | nVarChar | 100 | 0 | | |
8 | OGPC | Government Payment Code | 3 | Descr | Description | nVarChar | 100 | 0 | | |
9 | OLLF | Legal List Format | 3 | Descr | Electronic File Description | nVarChar | 250 | 0 | | |
10 | ONOA | Nature of Assessee | 3 | Descr | Description | nVarChar | 100 | 0 | | |
11 | OPFS | Personal Fields Setup | 15 | Descr | Description | nVarChar | 254 | 0 | | |
12 | OSEC | Sections | 3 | Descr | Description | nVarChar | 30 | 0 | | |
13 | OTCX | Tax Code Determination | 30 | Descr | Description | nVarChar | 250 | 0 | | |
14 | OTFC | Tax Type Combination | 3 | Descr | Description | nVarChar | 100 | 0 | | |
15 | OTPA | Tax Parameter Attributes | 3 | Descr | Description | nVarChar | 30 | 0 | | |
16 | OTPR | Tax Return Values | 3 | Descr | Description | nVarChar | 30 | 0 | | |
17 | OTPS | Tax Parameter | 3 | Descr | Description | nVarChar | 100 | 0 | | |
18 | OUSG | Usage of Nota Fiscal | 14 | Descr | Usage Description | nVarChar | 100 | 0 | | |
19 | OUTB | User Tables | 2 | Descr | Description | nVarChar | 30 | 0 | | |
20 | TCD1 | Key Fields for Determination | 7 | Descr | Description | nVarChar | 100 | 0 | | |
21 | UFD1 | User Fields - Values Definitions | 5 | Descr | Description | nVarChar | 254 | 0 | | |
TOPFinance |
22 | AADT | Fixed Assets Account Determination - History | 2 | Descr | Description | nVarChar | 100 | 0 | | |
23 | ADPA | Fixed Asset Depreciation Areas - History | 2 | Descr | Description | nVarChar | 100 | 0 | | |
24 | ADTP | Fixed Assets Depreciation Types - History | 2 | Descr | Description | nVarChar | 100 | 0 | | |
25 | BOX3 | Box Definition - Choice | 4 | Descr | Description | nVarChar | 250 | 0 | | |
26 | OADG | Depreciation Groups | 2 | Descr | Description | nVarChar | 100 | 0 | | |
27 | OADT | Fixed Assets Account Determination | 2 | Descr | Description | nVarChar | 100 | 0 | | |
28 | OAGS | Asset Groups | 2 | Descr | Description | nVarChar | 100 | 0 | | |
29 | ODPA | Fixed Asset Depreciation Areas | 2 | Descr | Description | nVarChar | 100 | 0 | | |
30 | ODPP | Depreciation Type Pools | 2 | Descr | Description | nVarChar | 100 | 0 | | |
31 | ODTP | Fixed Assets Depreciation Types | 2 | Descr | Description | nVarChar | 100 | 0 | | |
32 | OFYM | Financial Year Master | 3 | Descr | Description | nVarChar | 30 | 0 | | |
33 | OTTR | Remark Text Templates | 2 | Descr | Template Description | nVarChar | 254 | 0 | | |
TOPGeneral |
34 | MFLD | MetaData Tables Fields | 5 | Descr | Description | nVarChar | 250 | 0 | | |
35 | MTBL | MetaData Tables | 4 | Descr | Description | nVarChar | 254 | 0 | | |
36 | MVAL | MetaData Tables Fields Vals | 5 | Descr | Description | nVarChar | 254 | 0 | | |
37 | OBFI | Brazil Fuel Indexer | 3 | Descr | Description | nVarChar | 254 | 0 | | |
38 | OBNI | Brazil Numeric Indexer | 3 | Descr | Beverage Brand | nVarChar | 254 | 0 | | |
39 | OCPT | Cockpit Main Table | 4 | Descr | Description | nVarChar | 100 | 0 | | |
40 | OLNK | Help Links | 3 | Descr | Description | nVarChar | 100 | 0 | | |
41 | ONCP | New Cockpit Table | 11 | Descr | Description | nVarChar | 100 | 0 | | |
42 | OSES | OSES | 2 | Descr | SEFAZ Country Description | nVarChar | 100 | 0 | | |
TOPInventory and Production |
43 | ABIN | Bin Location - History | 34 | Descr | Description | nVarChar | 50 | 0 | | |
44 | ABSL | Warehouse Sublevel - History | 4 | Descr | Description | nVarChar | 50 | 0 | | |
45 | OBIN | Bin Location | 34 | Descr | Description | nVarChar | 50 | 0 | | |
46 | OBSL | Warehouse Sublevel | 4 | Descr | Description | nVarChar | 50 | 0 | | |
47 | OIPF | Landed Costs | 11 | Descr | Remarks | nVarChar | 250 | 0 | | |
TOPMRP |
48 | OMSN | MRP Scenarios | 3 | Descr | Description | nVarChar | 100 | 0 | | |
TOPReports |
49 | AECM | Electronic Communication Types or Protocols | 2 | Descr | Description | nVarChar | 200 | 0 | | |
50 | GDP1 | General Data Protection Wizard - Personal Fields Setup | 9 | Descr | Description | nVarChar | 254 | 0 | | |
51 | OECM | Electronic Communication Types or Protocols | 2 | Descr | Description | nVarChar | 200 | 0 | | |
52 | OTRX | Transformation Documents | 3 | Descr | Description | nVarChar | 250 | 0 | | |