| 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 | | |
TOPBanking |
2 | ABO1 | External Bank Operation Code - Rows - Log | 6 | LineId | Row | Int | 6 | 0 | | |
3 | ABT1 | Internal Bank Operation Codes - Accounts - Log | 2 | LineId | Row | Int | 6 | 0 | | |
4 | ACH1 | Checks for Payment - Rows - History | 2 | LineId | Row Number | Int | 11 | 0 | | |
5 | ARC1 | Incoming Payment - Checks - History | 2 | LineID | Row Number | Int | 11 | 0 | | |
6 | ARC3 | Credit Vouchers History | 2 | LineID | Row No. | Int | 11 | 0 | | |
7 | ARC4 | Incoming Payment - Account List - History | 2 | LineId | Row Number | Int | 11 | 0 | | |
8 | BOC1 | External Bank Operation Code - Rows | 6 | LineId | Row | Int | 6 | 0 | | |
9 | BOE1 | Bill of Exchange for Payment - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
10 | BTC1 | Internal Bank Operation Codes - Accounts | 2 | LineId | Row | Int | 6 | 0 | | |
11 | CHD1 | Checks for Payment Drafts - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
12 | CHO1 | Checks for Payment - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
13 | PDF1 | Payment Draft - Checks | 2 | LineID | Row Number | Int | 11 | 0 | | |
14 | PDF3 | Payment Draft - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
15 | PDF4 | Payment Draft - Account List | 2 | LineId | Row Number | Int | 11 | 0 | | |
16 | PEX1 | Payment Results Table - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
17 | RCC4 | Incoming Payment - Credit Vouchers | 2 | LineId | Row Number | Int | 11 | 0 | | |
18 | RCT1 | Incoming Payment - Checks | 2 | LineID | Row Number | Int | 11 | 0 | | |
19 | RCT3 | Incoming Pmt - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
20 | RCT4 | Incoming Payment - Account List | 2 | LineId | Row Number | Int | 11 | 0 | | |
21 | VPM1 | Outgoing Payments - Check Rows | 2 | LineID | Row Number | Int | 11 | 0 | | |
22 | VPM3 | Outgoing Payments - Credit Vouchers | 2 | LineID | Row No. | Int | 11 | 0 | | |
23 | VPM4 | Outgoing Payments - Accounts | 2 | LineId | Row Number | Int | 11 | 0 | | |
TOPFinance |
24 | CASE1 | Internal Recon. Upgrade 2007A | 2 | LineId | Inconsistent Amt Number | Int | 11 | 0 | 0 | |
25 | CDC1 | Cash Discount - Rows | 2 | LineId | Row No. | Int | 11 | 0 | | |
26 | CFH1 | Cash Flow Statement Report - History - Rows | 2 | LineId | Row Number | Int | 11 | 0 | | |
27 | RCR1 | Recurring Postings - Rows | 2 | LineId | Row Number | Int | 11 | 0 | 0 | |
28 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 2 | LineID | Line Identification | Int | 11 | 0 | | |
29 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 2 | LineID | Line Identification | Int | 11 | 0 | | |
TOPInventory and Production |
30 | UWKO1 | Production Instructions - Rows | 2 | LineID | Row Number | Int | 11 | 0 | 0 | |
31 | WKO1 | Production Instructions - Rows | 2 | LineID | Row Number | Int | 11 | 0 | 0 | |
TOPMRP |
32 | FCT1 | Sales Forecast - Rows | 2 | LineID | Row Number | Int | 11 | 0 | | |
33 | MSN3 | MRP Pegging Information | 11 | LineID | Row Number | Int | 11 | 0 | | |
TOPReports |
34 | TRS1 | Tax Report Saving Object - Approved Documents | 3 | LineID | Internal Row Number | Int | 11 | 0 | | |
35 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 3 | LineID | Internal Row Number | Int | 11 | 0 | | |
TOPService |
36 | REQ1 | External System Call Request - Message List | 2 | LineId | Message Line ID | Int | 11 | 0 | | |
37 | REQ2 | External System Call Request - Argument List | 2 | LineId | Message Line ID | Int | 11 | 0 | 1 | |
38 | REQ3 | External System Call Request - Message Argument List | 2 | LineId | Message Line ID | Int | 11 | 0 | | |