| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ASTC | Sales Tax Codes | 2 | Name | Name | nVarChar | 100 | 0 | | |
2 | CDPM | Dynamic Permission | 2 | Name | Name | nVarChar | 64 | 0 | | |
3 | CFN1 | Default Common Functions | 5 | Name | Name | nVarChar | 100 | 0 | | |
4 | CSPI | Solution Packager Information | 2 | Name | Parameter Name | nVarChar | 50 | 0 | | |
5 | GFL2 | Grid Filter Name | 5 | Name | Name | nVarChar | 100 | 0 | | |
6 | MAP2 | Mapping Input and Output Relation | 5 | Name | Parameter Name | nVarChar | 20 | 0 | | |
7 | OADF | Address Formats | 2 | Name | Name | nVarChar | 50 | 0 | | |
8 | OALT | Alerts Template | 2 | Name | Name | nVarChar | 50 | 0 | | |
9 | OCDT | Credit Card Payment | 2 | Name | Credit Card Payment Name | nVarChar | 30 | 0 | | |
10 | OCMN | Customized Menu | 2 | Name | Menu Item Name | nVarChar | 100 | 0 | | |
11 | OCNT | Counties | 5 | Name | County Name | nVarChar | 100 | 0 | | |
12 | OCPT | Cockpit Main Table | 3 | Name | Name | nVarChar | 20 | 0 | | |
13 | OCRY | Countries | 2 | Name | Name | nVarChar | 100 | 0 | | |
14 | OCST | States | 3 | Name | Name | nVarChar | 100 | 0 | | |
15 | ODMW | Data Migration | 2 | Name | Package Name | nVarChar | 20 | 0 | | |
16 | OENC | Encryption Types | 1 | Name | Name | nVarChar | 100 | 0 | | |
17 | OFRM | File Format | 2 | Name | File Format Name | nVarChar | 100 | 0 | | |
18 | OGSP | Goods Shipment | 2 | Name | Name | nVarChar | 50 | 0 | | |
19 | OIND | Triangular Deal | 2 | Name | Name | nVarChar | 50 | 0 | | |
20 | OLLF | Legal List Format | 2 | Name | Electronic File Name | nVarChar | 100 | 0 | | |
21 | OLNG | User Language Table | 3 | Name | Language Full Name | nVarChar | 30 | 0 | | |
22 | OMAO | Mobile Add-On Setting | 2 | Name | Add-On Name | nVarChar | 200 | 0 | | |
23 | OMLS | Distribution List | 2 | Name | Name | nVarChar | 30 | 0 | | |
24 | OMPS | Map Services | 2 | Name | Name | nVarChar | 20 | 0 | | |
25 | OPRO | Property Object | 5 | Name | Property Name | nVarChar | 50 | 0 | | |
26 | OPVL | Lender - Pelecard | 2 | Name | Name | nVarChar | 50 | 0 | | |
27 | ORIT | Dunning Interest Rate | 2 | Name | Interest Name | nVarChar | 50 | 0 | | |
28 | OSSP | Service Supply | 2 | Name | Name | nVarChar | 50 | 0 | | |
29 | OSTA | Sales Tax Authorities | 2 | Name | Name | nVarChar | 100 | 0 | | |
30 | OSTC | Sales Tax Codes | 2 | Name | Name | nVarChar | 100 | 0 | | |
31 | OSTT | Sales Tax Authorities Type | 2 | Name | Name | nVarChar | 40 | 0 | | |
32 | OUDG | User Defaults | 2 | Name | Name | nVarChar | 20 | 0 | | |
33 | OUDO | User-Defined Object | 2 | Name | Name | nVarChar | 100 | 0 | | |
34 | OUPT | User Autorization Tree | 2 | Name | Name | nVarChar | 64 | 0 | | |
35 | OWDT | Widget Table | 2 | Name | Widget Name | nVarChar | 20 | 0 | | |
36 | OWST | Confirmation Level | 2 | Name | Name | nVarChar | 20 | 0 | | |
37 | OWTM | Approval Templates | 2 | Name | Name | nVarChar | 20 | 0 | | |
38 | SPRG | Application Start | 3 | Name | Application Name | nVarChar | 128 | 0 | | |
TOPBanking |
39 | OBCA | Bank Charges Allocation Codes | 2 | Name | Description | nVarChar | 50 | 0 | | |
40 | OPFT | Portfolio Definitions | 2 | Name | Name | nVarChar | 50 | 0 | | |
41 | OPYD | Payment Run | 2 | Name | Payment Run Name | nVarChar | 50 | 0 | | |
42 | OUBR | Branches | 2 | Name | Name | nVarChar | 20 | 0 | | |
43 | OUDP | Departments | 2 | Name | Name | nVarChar | 20 | 0 | | |
TOPBusiness Partners |
44 | ACPN | Campaign | 2 | Name | Campaign Name | nVarChar | 100 | 0 | | |
45 | ACPR | Contact Persons - History | 3 | Name | Contact Person Name | nVarChar | 50 | 0 | | |
46 | OCLA | Activity Status | 2 | name | Status Name | nVarChar | 30 | 0 | | |
47 | OCLO | Meetings Location | 2 | Name | Name | nVarChar | 50 | 0 | | |
48 | OCLS | Activity Subjects | 2 | Name | Name | nVarChar | 20 | 0 | | |
49 | OCLT | Activity Types | 2 | Name | Name | nVarChar | 20 | 0 | | |
50 | OCPN | Campaign | 2 | Name | Campaign Name | nVarChar | 100 | 0 | | |
51 | OCPR | Contact Persons | 3 | Name | Contact Person Name | nVarChar | 50 | 0 | | |
52 | OPRT | Partners | 2 | Name | Name | nVarChar | 15 | 0 | | |
TOPFinance |
53 | AFPR | Posting Period-Log | 3 | Name | Period Name | nVarChar | 20 | 0 | | |
54 | AVTG | Tax Definition | 2 | Name | Name | nVarChar | 50 | 0 | | |
55 | OACG | Account Category | 2 | Name | Name | nVarChar | 40 | 0 | | |
56 | OACR | Accrual Type | 2 | Name | Accrual Type Name | nVarChar | 30 | 0 | | |
57 | OASC | Account Segmentation Categories | 3 | Name | Name | nVarChar | 100 | 0 | | |
58 | OASG | Account Segmentation | 2 | Name | Name | nVarChar | 100 | 0 | | |
59 | OBGS | Budget Scenario | 2 | Name | Name | nVarChar | 100 | 0 | | |
60 | OFPR | Posting Period | 3 | Name | Period Name | nVarChar | 20 | 0 | | |
61 | OFRC | Financial Report Categories | 3 | Name | Name | nVarChar | 254 | 0 | | |
62 | OFRT | Financial Report Templates | 2 | Name | Name | nVarChar | 100 | 0 | | |
63 | OIDC | Indicator | 2 | Name | Indicator Name | nVarChar | 50 | 0 | | |
64 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 6 | Name | Rule Name | nVarChar | 100 | 0 | | |
65 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 6 | Name | Rule Name | nVarChar | 100 | 0 | | |
66 | OSHR | Shareholder's Rights and Interests Report History | 2 | Name | Report Name | nVarChar | 40 | 0 | | |
67 | OSVT | Define Summary VAT Report Type | 2 | Name | Summary VAT Report Type | nVarChar | 254 | 0 | | |
68 | OVTG | Tax Definition | 2 | Name | Name | nVarChar | 50 | 0 | | |
TOPHuman Resources |
69 | OHED | Education Types | 2 | name | Name | nVarChar | 20 | 0 | | |
70 | OHPS | Employee Position | 2 | name | Position Name | nVarChar | 20 | 0 | | |
71 | OHST | Employee Status | 2 | name | Name | nVarChar | 20 | 0 | | |
72 | OHTM | Employee Teams | 2 | name | Team Name | nVarChar | 20 | 0 | | |
73 | OHTR | Termination Reason | 2 | name | Name | nVarChar | 20 | 0 | | |
74 | OHTY | Employee Types | 2 | name | Name | nVarChar | 20 | 0 | | |
TOPInventory and Production |
75 | APKL | Pick List - History | 2 | Name | Name | nVarChar | 155 | 0 | | |
76 | OCYC | Cycle | 2 | Name | Cycle Name | nVarChar | 20 | 0 | | |
77 | OPKL | Pick List | 2 | Name | Name | nVarChar | 155 | 0 | | |
TOPMRP |
78 | OFCT | Sales Forecast | 3 | Name | Forecast Name | nVarChar | 100 | 0 | | |
TOPReports |
79 | OQWZ | Query Wizard | 2 | Name | Query Name | nVarChar | 50 | 0 | | |
80 | RTYP | Document Type List | 2 | NAME | Type Name | nVarChar | 250 | 0 | | |
81 | SRA3 | Scheduled Report Recipients | 5 | Name | Name | nVarChar | 155 | 0 | | |
82 | XROBJ | XLR Company Report Objects | 2 | Name | Name | nVarChar | 50 | 0 | | |
TOPSales Opportunities |
83 | OCMT | Competitors | 2 | Name | Name | nVarChar | 15 | 0 | | |
84 | OOPR | Sales Opportunity | 36 | Name | Opportunity Name | nVarChar | 100 | 0 | | |
TOPService |
85 | MDC1 | Master Data Cleanup - Log | 5 | Name | Name | nVarChar | 100 | 0 | | |
86 | OMDC | Master Data Cleanup | 2 | Name | Master Data Cleanup Name | nVarChar | 100 | 0 | | |
87 | OSCO | Service Call Origins | 2 | Name | Name | nVarChar | 20 | 0 | | |
88 | OSCP | Service Call Problem Types | 2 | Name | Name | nVarChar | 20 | 0 | | |
89 | OSCS | Service Call Statuses | 2 | Name | Name | nVarChar | 20 | 0 | | |
90 | OSCT | Service Call Types | 2 | Name | Name | nVarChar | 20 | 0 | | |
91 | OSST | Service Call Solution Statuses | 2 | Name | Name | nVarChar | 20 | 0 | | |