| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 63 | GL | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 100 | RP | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 98 | RP | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
4 | F03B11P | Customer Ledger Purge File | 98 | RP | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
5 | F03B11Z1 | Batch Invoices | 114 | VJ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
6 | F03B11Z2 | F03B11 Interoperability Table | 111 | SY | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
7 | F03B13 | Receipts Header | 38 | RY | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
8 | F03B13P | Receipts Header Purge File | 38 | RY | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
9 | F03B13Z2 | F03B13 Interoperability Table | 51 | SY | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
10 | F03B14 | Receipts Detail | 79 | RZ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
11 | F03B14P | Receipts Detail Purge File | 79 | RZ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
12 | F03B14Z2 | F03B14 Interoperability Table | 92 | SZ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
13 | F03B575 | Auto Debit Invoice Select and Build | 107 | RD | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
14 | F03B672 | Draft Remittance | 37 | RD | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
15 | F09UI011 | Receipt Prepost Work File | 39 | GL | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP04: Accounts Payable |
16 | F0414 | Accounts Payable Matching Document Detail | 20 | RN | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
17 | F0414A | WF - As Of Accounts Payable Payment Detail | 20 | RN | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
18 | F0414P | Purge - Accounts Payable Matching Document Detail | 20 | RN | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
19 | F0414Z1 | F0414 Interoperability Table | 33 | SZ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP09: General Accounting |
20 | F0911P | Purge - Account Ledger | 63 | GL | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
21 | F0911Z1 | Journal Entry Transactions - Batch File | 80 | VN | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
22 | F0911Z4 | F0911 Interoperability Table | 85 | SZ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
23 | F09UI015 | Indexed Computations Multi-Tiered Entries | 63 | GL | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP42: Sales Management |
24 | F42800G1 | Sales Update G Batch Detail Workfile | 65 | DG | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP47: Electronic Commerce |
25 | F47057 | EDI Payment Order Remittance Advice - Outbound | 89 | D3 | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
26 | F47057W | EDI Payment Order Remittance Advice - Work | 89 | D3 | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
TOP76C: Colombia |
27 | F76C034A | A/R Check Detail file As Of - COL - 03B | 77 | RZ | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
28 | F76C575 | Work File Magnetic Media - COL - 04 | 28 | Q1 | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |
29 | F76CT1 | Tributary Information - COL - 76C | 27 | TI | ALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 |