| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ALR1 | Queue of messages to be sent | 2 | LineId | Row Number | Int | 11 | 0 | | |
2 | AWL1 | Potential Processor of Tasks | 3 | LineID | Line ID | Int | 6 | 0 | | |
3 | AWL2 | Input data for tasks | 3 | LineID | Line ID | Int | 11 | 0 | | |
4 | AWL3 | Task Notes | 3 | LineID | Line ID | Int | 11 | 0 | | |
5 | AWL4 | Task Output Data | 3 | LineID | Line ID | nVarChar | 6 | 0 | | |
6 | AWL5 | Task Field Mapping Information | 3 | LineID | Line ID | nVarChar | 6 | 0 | | |
7 | MDC1 | Master Data Cleanup - Log | 2 | LineID | Line ID | Int | 11 | 0 | | |
8 | MPO1 | Value Mapping Data | 2 | LineId | Line Id | Int | 11 | 0 | | |
9 | RLS1 | Reference Links Sources Definition | 2 | LineID | Line Id | Int | 11 | 0 | | |
10 | WLS1 | Potential Processor of Tasks | 3 | LineID | Line ID | Int | 6 | 0 | | |
11 | WLS2 | Input data for tasks | 3 | LineID | Line ID | Int | 11 | 0 | | |
12 | WLS3 | Notes of Tasks | 3 | LineID | Line ID | Int | 11 | 0 | | |
13 | WLS4 | Task Output Data | 3 | LineID | Line ID | nVarChar | 6 | 0 | | |
14 | WLS5 | Task Field Mapping Information | 3 | LineID | Line ID | nVarChar | 6 | 0 | | |
TOPBanking |
15 | ABO1 | External Bank Operation Code - Rows - Log | 6 | LineId | Row | Int | 6 | 0 | | |
16 | ABT1 | Internal Bank Operation Codes - Accounts - Log | 2 | LineId | Row | Int | 6 | 0 | | |
17 | ACH1 | Checks for Payment - Rows - History | 2 | LineId | Row Number | Int | 11 | 0 | | |
18 | ARC1 | Incoming Payment - Checks - History | 2 | LineID | Row Number | Int | 11 | 0 | | |
19 | ARC3 | Credit Vouchers History | 2 | LineID | Row No. | Int | 11 | 0 | | |
20 | ARC4 | Incoming Payment - Account List - History | 2 | LineId | Row Number | Int | 11 | 0 | | |
21 | BOC1 | External Bank Operation Code - Rows | 6 | LineId | Row | Int | 6 | 0 | | |
22 | BOE1 | Bill of Exchange for Payment - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
23 | BTC1 | Internal Bank Operation Codes - Accounts | 2 | LineId | Row | Int | 6 | 0 | | |
24 | CHD1 | Checks for Payment Drafts - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
25 | CHO1 | Checks for Payment - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
26 | PDF1 | Payment Draft - Checks | 2 | LineID | Row Number | Int | 11 | 0 | | |
27 | PDF3 | Payment Draft - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
28 | PDF4 | Payment Draft - Account List | 2 | LineId | Row Number | Int | 11 | 0 | | |
29 | PEX1 | Payment Results Table - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
30 | RCC4 | Incoming Payment - Credit Vouchers | 2 | LineId | Row Number | Int | 11 | 0 | | |
31 | RCT1 | Incoming Payment - Checks | 2 | LineID | Row Number | Int | 11 | 0 | | |
32 | RCT3 | Incoming Pmt - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
33 | RCT4 | Incoming Payment - Account List | 2 | LineId | Row Number | Int | 11 | 0 | | |
34 | VPM1 | Outgoing Payments - Check Rows | 2 | LineID | Row Number | Int | 11 | 0 | | |
35 | VPM3 | Outgoing Payments - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
36 | VPM4 | Outgoing Payments - Accounts | 2 | LineId | Row Number | Int | 11 | 0 | | |
TOPBusiness Partners |
37 | AWD3 | WTax Codes Details for BP | 2 | LineId | Row Number | Int | 11 | 0 | | |
38 | AWD4 | WTax Codes Details for Item | 2 | LineId | Row Number | Int | 11 | 0 | | |
39 | AWD5 | WTax Codes Details for Freight | 2 | LineId | Row Number | Int | 11 | 0 | | |
40 | WTD3 | WTax Codes Details for BP | 2 | LineId | Row Number | Int | 11 | 0 | | |
41 | WTD4 | WTax Codes Details for Item | 2 | LineId | Row Number | Int | 11 | 0 | | |
42 | WTD5 | WTax Codes Details for Freight | 2 | LineId | Row Number | Int | 11 | 0 | | |
TOPFinance |
43 | CASE1 | Internal Recon. Upgrade 2007A | 2 | LineId | Inconsistent Amt Number | Int | 11 | 0 | 0 | |
44 | CDC1 | Cash Discount - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
45 | CFH1 | Cash Flow Statement Report - History - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
46 | RCR1 | Recurring Postings - Rows | 2 | LineId | Row Number | Int | 11 | 0 | 0 | |
47 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 2 | LineID | Line Identification | Int | 11 | 0 | | |
48 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 2 | LineID | Line Identification | Int | 11 | 0 | | |
TOPGeneral |
49 | APH1 | Project Management - Stages - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
50 | APH2 | Project Management - Stages - Open Issues - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
51 | APH3 | Project Management - Stages - Attachments - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
52 | APH4 | Project Management - Stages - Documents - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
53 | APH5 | Project Management - Stages - Resources - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
54 | APH6 | Project Management - Stages - Activities - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
55 | APH7 | Project Management - Workorders - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
56 | APH8 | Project Management - Summary - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
57 | APM1 | Project Management - Stages - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
58 | APM2 | Project Management - Stages - Open Issues - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
59 | APM3 | Project Management - Stages - Attachments - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
60 | APM4 | Project Management - Stages - Documents - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
61 | APM5 | Project Management - Stages - Resources - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
62 | APM6 | Project Management - Stages - Activities - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
63 | APM7 | Project Management - Workorders - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
64 | APM8 | Project Management - Summary - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
65 | ASH1 | Project Management Time Sheet - Rows - History | 2 | LineID | Row No. | Int | 11 | 0 | | |
66 | PHA1 | Project Management - Stages | 2 | LineID | Row No. | Int | 11 | 0 | | |
67 | PHA2 | Project Management - Stages - Open Issues | 2 | LineID | Row No. | Int | 11 | 0 | | |
68 | PHA3 | Project Management - Stages - Attachments | 2 | LineID | Row No. | Int | 11 | 0 | | |
69 | PHA4 | Project Management - Stages - Documents | 2 | LineID | Row No. | Int | 11 | 0 | | |
70 | PHA5 | Project Management - Stages - Resources | 2 | LineID | Row No. | Int | 11 | 0 | | |
71 | PHA6 | Project Management - Stages - Activities | 2 | LineID | Row No. | Int | 11 | 0 | | |
72 | PHA7 | Project Management - Workorders | 2 | LineID | Row No. | Int | 11 | 0 | | |
73 | PHA8 | Project Management - Summary | 2 | LineID | Row No. | Int | 11 | 0 | | |
74 | PMG1 | Project Management - Stages | 2 | LineID | Row No. | Int | 11 | 0 | | |
75 | PMG2 | Project Management - Stages - Open Issues | 2 | LineID | Row No. | Int | 11 | 0 | | |
76 | PMG3 | Project Management - Stages - Attachments | 2 | LineID | Row No. | Int | 11 | 0 | | |
77 | PMG4 | Project Management - Stages - Documents | 2 | LineID | Row No. | Int | 11 | 0 | | |
78 | PMG5 | Project Management - Stages - Resources | 2 | LineID | Row No. | Int | 11 | 0 | | |
79 | PMG6 | Project Management - Stages - Activities | 2 | LineID | Row No. | Int | 11 | 0 | | |
80 | PMG7 | Project Management - Workorders | 2 | LineID | Row No. | Int | 11 | 0 | | |
81 | PMG8 | Project Management - Summary | 2 | LineID | Row No. | Int | 11 | 0 | | |
82 | PMG9 | Project Management - Charged Document Lines Log - Used by Billing Wizard | 2 | LineID | Row No. | Int | 11 | 0 | | |
83 | TSH1 | Project Management Time Sheet - Rows | 2 | LineID | Row No. | Int | 11 | 0 | | |
TOPInventory and Production |
84 | ILM3 | Non-Inventory and Resource Components Log Msg | 2 | LineID | Line ID | Int | 11 | 0 | | |
85 | IVL2 | Inventory Components for Production | 3 | LineID | Line ID | Int | 11 | 0 | | |
86 | SIVL2 | Inventory Components for Production | 3 | LineID | Line ID | Int | 11 | 0 | | |
87 | UILM3 | Non-Inventory and Resource Components Log Msg | 2 | LineID | Line ID | Int | 11 | 0 | | |
88 | UIVL2 | Inventory Components for Production | 3 | LineID | Line ID | Int | 11 | 0 | | |
89 | UWKO1 | Production Instructions - Rows | 2 | LineID | Row Number | Int | 11 | 0 | 0 | |
90 | WKO1 | Production Instructions - Rows | 2 | LineID | Row Number | Int | 11 | 0 | 0 | |
91 | WTC1 | WTax Certificates - WT Groups in Certificates | 2 | LineId | Row Number | Int | 11 | 0 | | |
92 | WTC2 | WTax Certificates - Docs in WT Groups | 3 | LineId | Line Number | Int | 11 | 0 | | |
TOPMarketing Documents |
93 | GPA1 | Gross Profit Adjustment - Documents | 2 | LineId | Row No. | Int | 11 | 0 | | |
94 | GPA4 | Gross Profit Adjustment - JE Details Accounts | 2 | LineId | Row No. | Int | 11 | 0 | | |
95 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 2 | LineId | Row No. | Int | 11 | 0 | | |
96 | GPA6 | Product Cost Adjustment - Applied Material Revaluations | 2 | LineId | Row No. | Int | 11 | 0 | | |
97 | GPA8 | Product Cost Adjustment - MRV Document Lines | 2 | LineId | Row No. | Int | 11 | 0 | | |
98 | GPA9 | Applied Gross Profit Adjustments | 2 | LineId | Row No. | Int | 11 | 0 | | |
99 | TGPA | Gross Profit Adjustment - Log | 4 | LineID | Line ID | Int | 11 | 0 | | |
TOPMRP |
100 | FCT1 | Sales Forecast - Rows | 2 | LineID | Row Number | Int | 11 | 0 | | |
101 | MSN3 | MRP Pegging Information | 11 | LineID | Row Number | Int | 11 | 0 | | |
TOPReports |
102 | TRS1 | Tax Report Saving Object - Approved Documents | 3 | LineID | Internal Row Number | Int | 11 | 0 | | |
103 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 3 | LineID | Internal Row Number | Int | 11 | 0 | | |
TOPService |
104 | REQ1 | External System Call Request - Message List | 2 | LineId | Message Line ID | Int | 11 | 0 | | |
105 | REQ2 | External System Call Request - Argument List | 2 | LineId | Message Line ID | Int | 11 | 0 | 1 | |
106 | REQ3 | External System Call Request - Message Argument List | 2 | LineId | Message Line ID | Int | 11 | 0 | | |