Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | AFML | Tax Formula Master Table | 3 | Descr | Description | nVarChar | 100 | 0 | ||
2 | CUFD | User Fields - Description | 4 | Descr | Description | nVarChar | 30 | 0 | ||
3 | OBSI | Brazil String Indexer | 3 | Descr | Description | nVarChar | 254 | 0 | ||
4 | OCPT | Cockpit Main Table | 4 | Descr | Description | nVarChar | 100 | 0 | ||
5 | OFML | Tax Formula Master Table | 3 | Descr | Description | nVarChar | 100 | 0 | ||
6 | OLLF | Legal List Format | 3 | Descr | Electronic File Description | nVarChar | 250 | 0 | ||
7 | ONOA | Nature of Assessee | 3 | Descr | Description | nVarChar | 100 | 0 | ||
8 | OSEC | Sections | 3 | Descr | Description | nVarChar | 30 | 0 | ||
9 | OTCX | Tax Code Determination | 30 | Descr | Description | nVarChar | 250 | 0 | ||
10 | OTFC | Tax Type Combination | 3 | Descr | Description | nVarChar | 100 | 0 | ||
11 | OTPA | Tax Parameter Attributes | 3 | Descr | Description | nVarChar | 30 | 0 | ||
12 | OTPR | Tax Return Values | 3 | Descr | Description | nVarChar | 30 | 0 | ||
13 | OTPS | Tax Parameter | 3 | Descr | Description | nVarChar | 100 | 0 | ||
14 | OUTB | User Tables | 2 | Descr | Description | nVarChar | 30 | 0 | ||
15 | TCD1 | Key Fields for Determination | 7 | Descr | Description | nVarChar | 100 | 0 | ||
16 | UFD1 | User Fields - Values Definitions | 5 | Descr | Description | nVarChar | 254 | 0 | ||
Finance | ||||||||||
17 | BOX3 | Box Definition - Choice | 4 | Descr | Description | nVarChar | 250 | 0 | ||
18 | OFYM | Financial Year Master | 3 | Descr | Description | nVarChar | 30 | 0 | ||
Inventory and Production | ||||||||||
19 | OIPF | Landed Costs | 11 | Descr | Remarks | nVarChar | 250 | 0 | ||
MRP | ||||||||||
20 | OMSN | MRP Scenarios | 3 | Descr | Description | nVarChar | 100 | 0 | ||
Reports | ||||||||||
21 | OTRX | Transformation Documents | 3 | Descr | Description | nVarChar | 250 | 0 | ||
Service | ||||||||||
22 | OBFI | Brazil Fuel Indexer | 3 | Descr | Description | nVarChar | 254 | 0 | ||
23 | OBNI | Brazil Numeric Indexer | 3 | Descr | Description | nVarChar | 254 | 0 | ||
24 | OLNK | Help Links | 3 | Descr | Description | nVarChar | 100 | 0 |