| 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 |
