| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ALR3 | Dynamic message data cells | 3 | Line | Number of Column in Message | Int | 11 | 0 | | |
2 | ATC1 | Attachments - Rows | 2 | Line | Row Number | Int | 11 | 0 | | |
TOPBanking |
3 | ARC6 | Incoming Payments - WTax Rows - History | 16 | Line | Internal Number | Int | 11 | 0 | | |
4 | PDF6 | Payment Drafts - Withholding Tax - Rows | 16 | Line | Internal Number | Int | 11 | 0 | | |
5 | RCT6 | Incoming Payments - WTax Rows | 16 | Line | Internal Number | Int | 11 | 0 | | |
6 | VPM6 | Outgoing Payments - WTax Rows | 16 | Line | Internal Number | Int | 11 | 0 | | |
TOPFinance |
7 | ISW3 | Declaration Rows | 2 | Line | Declaration Line | Int | 11 | 0 | | |
TOPHuman Resources |
8 | AHE1 | Absence Information | 2 | line | Absence Information Row | Int | 6 | 0 | | |
9 | AHE2 | Education | 2 | line | Education: Information Row | Int | 6 | 0 | | |
10 | AHE3 | Employee Reviews | 2 | line | Employee Review Row | Int | 6 | 0 | | |
11 | AHE4 | Previous Employment | 2 | line | Previous Employment Row | Int | 6 | 0 | | |
12 | AHE6 | Employee Roles | 2 | line | Employee Role Row | Int | 6 | 0 | | |
13 | AHE7 | Savings Payments | 2 | line | Row | Int | 6 | 0 | | |
14 | HEM1 | Absence Information | 2 | line | Absence Information Row | Int | 6 | 0 | | |
15 | HEM2 | Education | 2 | line | Education Information Row | Int | 6 | 0 | | |
16 | HEM3 | Employee Reviews | 2 | line | Employee Review Row | Int | 6 | 0 | | |
17 | HEM4 | Previous Employment | 2 | line | Previous Employment Row | Int | 6 | 0 | | |
18 | HEM6 | Employee Roles | 2 | line | Employee Role Row | Int | 6 | 0 | | |
19 | HEM7 | Savings Payments | 2 | line | Row | Int | 6 | 0 | | |
20 | HTM1 | Team Members | 2 | line | Row | Int | 6 | 0 | | |
TOPReports |
21 | EML1 | E-mail Log - Rows | 2 | Line | Row Number | Int | 11 | 0 | | |
TOPSales Opportunities |
22 | OPR1 | Opportunity - Rows | 2 | Line | Row No. | Int | 6 | 0 | | |
23 | OPR2 | Opportunity - Partners | 2 | Line | Row No. | Int | 6 | 0 | | |
24 | OPR3 | Opportunity - Competitors | 2 | Line | Row No. | Int | 6 | 0 | | |
25 | OPR4 | Opportunity - Interests | 2 | Line | Row No. | Int | 6 | 0 | | |
26 | OPR5 | Opportunity - Reasons | 2 | Line | Row No. | Int | 6 | 0 | | |
TOPService |
27 | ACT1 | Service Contract - Items | 2 | Line | Row | Int | 11 | 0 | | |
28 | ASC1 | Service Call Solutions - History | 2 | line | Row Number - History | Int | 6 | 0 | -1 | |
29 | ASC2 | Service Call Inventory Expenses - History | 2 | Line | Row - History | Int | 6 | 0 | -1 | |
30 | ASC3 | Service Call Travel/Labor Expenses - History | 2 | Line | Row | Int | 6 | 0 | -1 | |
31 | ASC4 | Service Call Travel/Labor Expenses - History | 2 | Line | Row | Int | 6 | 0 | -1 | |
32 | ASC5 | Service Call Activities - History | 2 | Line | Row No. | Int | 6 | 0 | -1 | |
33 | ASC6 | Service Call Scheduling - History | 2 | Line | Row | Int | 6 | 0 | | |
34 | CTR1 | Service Contract - Items | 2 | Line | Row | Int | 11 | 0 | | |
35 | SCL1 | Service Call Solutions - Rows | 2 | line | Row No. | Int | 6 | 0 | -1 | |
36 | SCL2 | Service Call Inventory Expenses | 2 | Line | Row | Int | 6 | 0 | -1 | |
37 | SCL3 | Service Call Travel/Labor Expenses | 2 | Line | Row | Int | 6 | 0 | -1 | |
38 | SCL4 | Expense Documents | 2 | Line | Row | Int | 6 | 0 | -1 | |
39 | SCL5 | Service Call Activities | 2 | Line | Row | Int | 6 | 0 | -1 | |
40 | SCL6 | Service Call Scheduling | 2 | Line | Row | Int | 6 | 0 | | |