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