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