| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AAD1 | Administration Extension-Log | 15 | Code | Code | Int | 11 | 0 | 1 | |
2 | AADM | Administration - Log | 270 | Code | Code | Int | 11 | 0 | 1 | |
3 | ACFP | CFOP for Nota Fiscal | 2 | Code | CFOP Code | nVarChar | 6 | 0 | | |
4 | ADM1 | Administration Extension | 15 | Code | Code | Int | 11 | 0 | 1 | |
5 | ADM2 | Administration Electronic Report | 1 | Code | Code | Int | 11 | 0 | | |
6 | AFML | Tax Formula Master Table | 2 | Code | Code | nVarChar | 20 | 0 | | |
7 | ALR1 | Queue of messages to be sent | 1 | Code | Internal Number | Int | 11 | 0 | | |
8 | ALR2 | Dynamic message data row | 1 | Code | Internal Number | Int | 11 | 0 | | |
9 | ALR3 | Dynamic message data cells | 1 | Code | Internal Number | Int | 11 | 0 | | |
10 | ALT1 | Alerts - Users | 1 | Code | Internal Number | Int | 11 | 0 | | |
11 | ASTC | Sales Tax Codes | 1 | Code | Code | nVarChar | 8 | 0 | | |
12 | ATSC | CST Code for Nota Fiscal | 2 | CODE | CST Code Incoming | nVarChar | 20 | 0 | | |
13 | CSTN | Workstation ID | 1 | Code | Code | Int | 11 | 0 | | |
14 | MAP1 | Input and Output of Mapping | 2 | Code | Code | Int | 11 | 0 | | |
15 | MLS1 | Distribution Lists - Recipients | 1 | Code | Code | Int | 11 | 0 | | |
16 | OADF | Address Formats | 1 | Code | Code | Int | 6 | 0 | | |
17 | OADM | Administration | 270 | Code | Code | Int | 11 | 0 | 1 | |
18 | OALR | Alerts | 1 | Code | Internal Number | Int | 11 | 0 | | |
19 | OALT | Alerts Template | 1 | Code | Internal Number | Int | 11 | 0 | | |
20 | OBDC | B1i DI Configuration | 1 | Code | Code | Int | 11 | 0 | | |
21 | OBSI | Brazil String Indexer | 2 | Code | Code | nVarChar | 2 | 0 | | |
22 | OCDT | Credit Card Payment | 1 | Code | Credit Card Payment Code | nVarChar | 8 | 0 | | |
23 | OCFP | CFOP for Nota Fiscal | 2 | Code | CFOP Code | nVarChar | 6 | 0 | | |
24 | OCNT | Counties | 2 | Code | County Code | nVarChar | 7 | 0 | | |
25 | OCPT | Cockpit Main Table | 2 | Code | Cockpit Code | Int | 6 | 0 | | |
26 | OCRY | Countries | 1 | Code | Code | nVarChar | 3 | 0 | | |
27 | OCSN | Certificate Series | 2 | Code | Code | nVarChar | 4 | 0 | | |
28 | OCST | States | 1 | Code | Code | nVarChar | 3 | 0 | | |
29 | ODMW | Data Migration | 1 | Code | Package Code | Int | 11 | 0 | | |
30 | OFML | Tax Formula Master Table | 2 | Code | Code | nVarChar | 20 | 0 | | |
31 | OGSP | Goods Shipment | 1 | Code | Code | VarChar | 1 | 0 | | |
32 | OIND | Triangular Deal | 1 | Code | Code | VarChar | 1 | 0 | | |
33 | OJPE | Local Era Calendar | 1 | Code | Local Era Code | VarChar | 1 | 0 | | |
34 | OLNG | User Language Table | 1 | Code | Code | Int | 11 | 0 | | |
35 | OMAO | Mobile Add-On Setting | 1 | Code | Add-On Code | nVarChar | 20 | 0 | | |
36 | OMLS | Distribution List | 1 | Code | Code | Int | 11 | 0 | | |
37 | ONFT | Nota Fiscal Tax Category (Brazil) | 2 | Code | Tax Category | nVarChar | 20 | 0 | | |
38 | ONOA | Nature of Assessee | 2 | Code | Code | nVarChar | 4 | 0 | | |
39 | OPRO | Property Object | 3 | Code | Input/Output Code | Int | 11 | 0 | | |
40 | OPVL | Lender - Pelecard | 1 | Code | Internal Number | Int | 11 | 0 | | |
41 | ORIT | Dunning Interest Rate | 1 | Code | Interest Code | nVarChar | 20 | 0 | | |
42 | OSEC | Sections | 2 | Code | Code | nVarChar | 4 | 0 | | |
43 | OSSP | Service Supply | 1 | Code | Code | VarChar | 1 | 0 | | |
44 | OSTA | Sales Tax Authorities | 1 | Code | Code | nVarChar | 8 | 0 | | |
45 | OSTC | Sales Tax Codes | 1 | Code | Code | nVarChar | 8 | 0 | | |
46 | OTFC | Tax Type Combination | 2 | Code | Code | nVarChar | 20 | 0 | | |
47 | OTPA | Tax Parameter Attributes | 2 | Code | Attribute Code | nVarChar | 8 | 0 | | |
48 | OTPR | Tax Return Values | 2 | Code | Return Value Code | nVarChar | 7 | 0 | | |
49 | OTPS | Tax Parameter | 2 | Code | Code | nVarChar | 5 | 0 | | |
50 | OTSC | CST Code for Nota Fiscal | 2 | CODE | CST Code Incoming | nVarChar | 20 | 0 | | |
51 | OUDG | User Defaults | 1 | Code | Code | nVarChar | 8 | 0 | | |
52 | OUDO | User-Defined Object | 1 | Code | Code | nVarChar | 20 | 0 | | |
53 | RIT1 | Interest Rates | 1 | Code | Object Code | nVarChar | 20 | 0 | | |
54 | UDG1 | User Defaults - Documents | 1 | Code | Code | nVarChar | 8 | 0 | | |
55 | UDG2 | User Defaults - Credit Cards | 1 | Code | Code | nVarChar | 8 | 0 | | |
56 | UDO1 | User-Defined Objects - Child | 1 | Code | Code | nVarChar | 20 | 0 | | |
57 | UDO2 | User-Defined Objects - Find Columns | 1 | Code | Code | nVarChar | 20 | 0 | | |
58 | UDO3 | User-Defined Objects - Found Columns | 1 | Code | Code | nVarChar | 20 | 0 | | |
59 | UDO4 | User-Defined Objects - Child Table Columns | 1 | Code | Code | nVarChar | 20 | 0 | | |
TOPBanking |
60 | ACH1 | Checks for Payment - Rows - History | 8 | Code | Tax Definition | nVarChar | 8 | 0 | | |
61 | BOE1 | Bill of Exchange for Payment - Rows | 8 | Code | Tax Definition | nVarChar | 8 | 0 | | |
62 | CHD1 | Checks for Payment Drafts - Rows | 8 | Code | Tax Definition | nVarChar | 8 | 0 | | |
63 | CHO1 | Checks for Payment - Rows | 8 | Code | Tax Definition | nVarChar | 8 | 0 | | |
64 | OBCA | Bank Charges Allocation Codes | 1 | Code | Code | nVarChar | 3 | 0 | | |
65 | OPFT | Portfolio Definitions | 1 | Code | Code | nVarChar | 8 | 0 | | |
66 | OPYD | Payment Run | 1 | Code | Payment Run Code | nVarChar | 20 | 0 | | |
67 | OUBR | Branches | 1 | Code | Code | Int | 6 | 0 | | |
68 | OUDP | Departments | 1 | Code | Code | Int | 6 | 0 | | |
TOPBusiness Partners |
69 | OCLO | Meetings Location | 1 | Code | Code | Int | 6 | 0 | | |
70 | OCLS | Activity Subjects | 1 | Code | Code | Int | 6 | 0 | | |
71 | OCLT | Activity Types | 1 | Code | Code | Int | 6 | 0 | | |
TOPFinance |
72 | AFPR | Posting Period-Log | 2 | Code | Period Code | nVarChar | 20 | 0 | | |
73 | AVT1 | Tax Definition | 1 | Code | Group Code | nVarChar | 8 | 0 | | |
74 | AVTG | Tax Definition | 1 | Code | Code | nVarChar | 8 | 0 | | |
75 | AWH2 | WTax Definition - Rows2 | 2 | Code | Tax Code | nVarChar | 8 | 0 | | |
76 | OACR | Accrual Type | 1 | Code | Accrual Type Code | nVarChar | 8 | 0 | | |
77 | OASC | Account Segmentation Categories | 2 | Code | Code | nVarChar | 20 | 0 | | |
78 | OCDC | Cash Discount | 1 | Code | Code | nVarChar | 20 | 0 | | |
79 | OCFL | Cash Flow Additional Trans. | 1 | Code | Code | Int | 11 | 0 | | |
80 | OCIG | CIG Codes | 2 | Code | Contract Code Identification | nVarChar | 10 | 0 | | |
81 | OCUP | CUP Codes | 2 | Code | Unique Code of Project | nVarChar | 15 | 0 | | |
82 | OFPR | Posting Period | 2 | Code | Period Code | nVarChar | 20 | 0 | | |
83 | OFYM | Financial Year Master | 2 | Code | Code | nVarChar | 6 | 0 | | |
84 | OIDC | Indicator | 1 | Code | Indicator Code | nVarChar | 2 | 0 | | |
85 | OVTG | Tax Definition | 1 | Code | Code | nVarChar | 8 | 0 | | |
86 | VTG1 | Tax Definition | 1 | Code | Group Code | nVarChar | 8 | 0 | | |
87 | WHT2 | Withholding Tax Definition - Rows2 | 2 | Code | Tax Code | nVarChar | 8 | 0 | | |
TOPInventory and Production |
88 | AITT | Product Tree - History | 1 | Code | Parent Item | nVarChar | 20 | 0 | | |
89 | ATT1 | Bill of Materials - Component Items - History | 3 | Code | Child Item | nVarChar | 20 | 0 | | |
90 | ITT1 | Bill of Materials - Component Items | 3 | Code | Component Item | nVarChar | 20 | 0 | | |
91 | OCYC | Cycle | 1 | Code | Cycle Code | Int | 6 | 0 | | |
92 | OITT | Product Tree | 1 | Code | Parent Item | nVarChar | 20 | 0 | | |
93 | OLCT | Location | 1 | Code | Location Code | Int | 11 | 0 | | |
94 | TMP1 | Bill of Materials - Component Items | 3 | Code | Component Item | nVarChar | 20 | 0 | | |
TOPMarketing Documents |
95 | ORCP | Recurring Transaction Template | 2 | Code | Template Code | nVarChar | 8 | 0 | | |
TOPMRP |
96 | OFCT | Sales Forecast | 2 | Code | Forecast Code | nVarChar | 16 | 0 | | |
TOPReports |
97 | FLT1 | 856 Report - Selection Criteria | 2 | Code | Code | nVarChar | 50 | 0 | | |
98 | OQWZ | Query Wizard | 1 | Code | Query Code | nVarChar | 8 | 0 | | |
99 | OTRX | Transformation Documents | 2 | Code | Code | nVarChar | 20 | 0 | | |
100 | QWZ1 | Query Tables | 1 | Code | Query Code | nVarChar | 8 | 0 | | |
101 | QWZ2 | Query Result Fields | 1 | Code | Query Code | nVarChar | 8 | 0 | | |
102 | QWZ3 | Query Condition Fields | 1 | Code | Query Code | nVarChar | 8 | 0 | | |
103 | RTYP | Document Type List | 1 | CODE | Report Type | nVarChar | 4 | 0 | | |
TOPService |
104 | OBFI | Brazil Fuel Indexer | 1 | Code | Fuel Code | nVarChar | 10 | 0 | | |
105 | OBNI | Brazil Numeric Indexer | 2 | Code | Code | Int | 11 | 0 | | |