| 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 | WLS1 | Potential Processor of Tasks | 3 | LineID | Line ID | Int | 6 | 0 | | |
9 | WLS2 | Input data for tasks | 3 | LineID | Line ID | Int | 11 | 0 | | |
10 | WLS3 | Notes of Tasks | 3 | LineID | Line ID | Int | 11 | 0 | | |
11 | WLS4 | Task Output Data | 3 | LineID | Line ID | nVarChar | 6 | 0 | | |
12 | WLS5 | Task Field Mapping Information | 3 | LineID | Line ID | nVarChar | 6 | 0 | | |
TOPBanking |
13 | ABO1 | External Bank Operation Code - Rows - Log | 6 | LineId | Row | Int | 6 | 0 | | |
14 | ABT1 | Internal Bank Operation Codes - Accounts - Log | 2 | LineId | Row | Int | 6 | 0 | | |
15 | ACH1 | Checks for Payment - Rows - History | 2 | LineId | Row Number | Int | 11 | 0 | | |
16 | ARC1 | Incoming Payment - Checks - History | 2 | LineID | Row Number | Int | 11 | 0 | | |
17 | ARC3 | Credit Vouchers History | 2 | LineID | Row No. | Int | 11 | 0 | | |
18 | ARC4 | Incoming Payment - Account List - History | 2 | LineId | Row Number | Int | 11 | 0 | | |
19 | BOC1 | External Bank Operation Code - Rows | 6 | LineId | Row | Int | 6 | 0 | | |
20 | BOE1 | Bill of Exchange for Payment - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
21 | BTC1 | Internal Bank Operation Codes - Accounts | 2 | LineId | Row | Int | 6 | 0 | | |
22 | CHD1 | Checks for Payment Drafts - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
23 | CHO1 | Checks for Payment - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
24 | PDF1 | Payment Draft - Checks | 2 | LineID | Row Number | Int | 11 | 0 | | |
25 | PDF3 | Payment Draft - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
26 | PDF4 | Payment Draft - Account List | 2 | LineId | Row Number | Int | 11 | 0 | | |
27 | PEX1 | Payment Results Table - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
28 | RCC4 | Incoming Payment - Credit Vouchers | 2 | LineId | Row Number | Int | 11 | 0 | | |
29 | RCT1 | Incoming Payment - Checks | 2 | LineID | Row Number | Int | 11 | 0 | | |
30 | RCT3 | Incoming Pmt - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
31 | RCT4 | Incoming Payment - Account List | 2 | LineId | Row Number | Int | 11 | 0 | | |
32 | VPM1 | Outgoing Payments - Check Rows | 2 | LineID | Row Number | Int | 11 | 0 | | |
33 | VPM3 | Outgoing Payments - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
34 | VPM4 | Outgoing Payments - Accounts | 2 | LineId | Row Number | Int | 11 | 0 | | |
TOPBusiness Partners |
35 | AWD3 | WTax Codes Details for BP | 2 | LineId | Row Number | Int | 11 | 0 | | |
36 | AWD4 | WTax Codes Details for Item | 2 | LineId | Row Number | Int | 11 | 0 | | |
37 | AWD5 | WTax Codes Details for Freight | 2 | LineId | Row Number | Int | 11 | 0 | | |
38 | WTD3 | WTax Codes Details for BP | 2 | LineId | Row Number | Int | 11 | 0 | | |
39 | WTD4 | WTax Codes Details for Item | 2 | LineId | Row Number | Int | 11 | 0 | | |
40 | WTD5 | WTax Codes Details for Freight | 2 | LineId | Row Number | Int | 11 | 0 | | |
TOPFinance |
41 | CASE1 | Internal Recon. Upgrade 2007A | 2 | LineId | Inconsistent Amt Number | Int | 11 | 0 | 0 | |
42 | CDC1 | Cash Discount - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
43 | CFH1 | Cash Flow Statement Report - History - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
44 | RCR1 | Recurring Postings - Rows | 2 | LineId | Row Number | Int | 11 | 0 | 0 | |
45 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 2 | LineID | Line Identification | Int | 11 | 0 | | |
46 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 2 | LineID | Line Identification | Int | 11 | 0 | | |
TOPInventory and Production |
47 | ILM3 | Non-Inventory and Resource Components Log Msg | 2 | LineID | Line ID | Int | 11 | 0 | | |
48 | UILM3 | Non-Inventory and Resource Components Log Msg | 2 | LineID | Line ID | Int | 11 | 0 | | |
49 | UWKO1 | Production Instructions - Rows | 2 | LineID | Row Number | Int | 11 | 0 | 0 | |
50 | WKO1 | Production Instructions - Rows | 2 | LineID | Row Number | Int | 11 | 0 | 0 | |
51 | WTC1 | WTax Certificates - WT Groups in Certificates | 2 | LineId | Row Number | Int | 11 | 0 | | |
52 | WTC2 | WTax Certificates - Docs in WT Groups | 3 | LineId | Line Number | Int | 11 | 0 | | |
TOPMarketing Documents |
53 | GPA1 | Gross Profit Adjustment - Documents | 2 | LineId | Row No. | Int | 11 | 0 | | |
54 | GPA4 | Gross Profit Adjustment - JE Details Accounts | 2 | LineId | Row No. | Int | 11 | 0 | | |
55 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 2 | LineId | Row No. | Int | 11 | 0 | | |
56 | GPA6 | Product Cost Adjustment - Applied Material Revaluations | 2 | LineId | Row No. | Int | 11 | 0 | | |
57 | GPA8 | Product Cost Adjustment - MRV Document Lines | 2 | LineId | Row No. | Int | 11 | 0 | | |
58 | GPA9 | Applied Gross Profit Adjustments | 2 | LineId | Row No. | Int | 11 | 0 | | |
59 | TGPA | Gross Profit Adjustment - Log | 4 | LineID | Line ID | Int | 11 | 0 | | |
TOPMRP |
60 | FCT1 | Sales Forecast - Rows | 2 | LineID | Row Number | Int | 11 | 0 | | |
61 | MSN3 | MRP Pegging Information | 11 | LineID | Row Number | Int | 11 | 0 | | |
TOPReports |
62 | TRS1 | Tax Report Saving Object - Approved Documents | 3 | LineID | Internal Row Number | Int | 11 | 0 | | |
63 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 3 | LineID | Internal Row Number | Int | 11 | 0 | | |
TOPService |
64 | REQ1 | External System Call Request - Message List | 2 | LineId | Message Line ID | Int | 11 | 0 | | |
65 | REQ2 | External System Call Request - Argument List | 2 | LineId | Message Line ID | Int | 11 | 0 | 1 | |
66 | REQ3 | External System Call Request - Message Argument List | 2 | LineId | Message Line ID | Int | 11 | 0 | | |