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