| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0018 | Taxes | 49 | TD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 2 | F0911 | Account Ledger | 7 | GL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP03: Accounts Receivable |
| 3 | F0311 | Accounts Receivable Ledger | 21 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 4 | F0312 | A/R Batch Cash Application | 1 | RU | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 5 | F03B11 | Customer Ledger | 20 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 6 | F03B112 | Invoice Revisions | 22 | RW | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 7 | F03B112P | Invoice Revisions Purge File | 22 | RW | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 8 | F03B11P | Customer Ledger Purge File | 20 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 9 | F03B11Z1 | Batch Invoices | 38 | VJ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 10 | F03B11Z2 | F03B11 Interoperability Table | 33 | SY | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 11 | F03B13 | Receipts Header | 8 | RY | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 12 | F03B13P | Receipts Header Purge File | 8 | RY | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 13 | F03B13Z2 | F03B13 Interoperability Table | 21 | SY | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 14 | F03B14 | Receipts Detail | 12 | RZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 15 | F03B14P | Receipts Detail Purge File | 12 | RZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 16 | F03B14Z2 | F03B14 Interoperability Table | 25 | SZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 17 | F03B465 | A/R Netting Workfile | 22 | RO | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 18 | F03B575 | Auto Debit Invoice Select and Build | 23 | RD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 19 | F03B672 | Draft Remittance | 11 | RD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP04: Accounts Payable |
| 20 | F0411 | Accounts Payable Ledger | 45 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 21 | F0411A | WF - As Of Accounts Payable Ledger | 45 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 22 | F0411P | Purge - Accounts Payable Ledger | 45 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 23 | F0411Z1 | Voucher Transactions - Batch Upload | 63 | VL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 24 | F0411Z3 | F0411 Interoperability Table | 68 | SZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 25 | F0414 | Accounts Payable Matching Document Detail | 19 | RN | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 26 | F0414A | WF - As Of Accounts Payable Payment Detail | 19 | RN | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 27 | F0414P | Purge - Accounts Payable Matching Document Detail | 19 | RN | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 28 | F0414Z1 | F0414 Interoperability Table | 32 | SZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 29 | F09UI006 | Tax (F0018) Replica | 49 | TD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP05T: Time Entry |
| 30 | F063951 | Payroll Journal (Compressed) File | 1 | GL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP07: Payroll |
| 31 | F05290 | WF - Payroll Journal (Detail) | 1 | JR | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP09: General Accounting |
| 32 | F0911P | Purge - Account Ledger | 7 | GL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 33 | F0911R | WF - Account Ledger Reconciliation | 7 | GL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 34 | F0911Z1 | Journal Entry Transactions - Batch File | 24 | VN | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 35 | F0911Z4 | F0911 Interoperability Table | 29 | SZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 36 | F0916 | Bank Statement Header | 1 | GH | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 37 | F0917 | Bank Statement Detail | 1 | GD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 38 | F09UI015 | Indexed Computations Multi-Tiered Entries | 7 | GL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 39 | F70UI001 | Work File for G/L by Cat. Code Localization | 12 | WA | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 40 | F740911 | Work File for G/L Report by Category Code Localization | 15 | WA | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP15: Property Management |
| 41 | F1511 | Tenant/Lease Billings Detail | 79 | NJ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 42 | F1511B | Lease Billings Master | 75 | NJ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP42: Sales Management |
| 43 | F42800G1 | Sales Update G Batch Detail Workfile | 27 | DG | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP44H: Homebuilder Management |
| 44 | F4451 | Lot Proceed Detail (World) | 14 | JF | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP51: Job Costing |
| 45 | F51901 | Cost Code Schedule | 13 | GP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP55: Reserved for Clients |
| 46 | F74TL004 | Trial Balance Temp File | 13 | TB | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 47 | F74T532 | Supplier Ledger Transaction File | 20 | SL | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 48 | F74T550 | General Ledger Work File - Turkish | 20 | DK | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP70: Multi-National Products - obsolete-do not reuse |
| 49 | F702018 | Taxes by Sales Order Line - COMM - 42 | 18 | TA | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP74: EMEA Localization |
| 50 | F740018D | Data extraction ESL - 74 | 24 | DE | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 51 | F740018W | Data extraction ESL - Workfile - 74 | 24 | DE | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 52 | F74093 | Worktable for Printing IVA Summary - Italy | 48 | HC | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 53 | F74412 | Customer / Supplier Balance Worktable (A/P and A/R) | 15 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 54 | F74900 | Foreign Receivables and Payables - EMEA | 27 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP74R: CIS |
| 55 | F74R0018 | Russian Tax File - 74R | 81 | TD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 56 | F74R0100 | Petty Cash Transactions - RUS - 00 - 74R | 20 | PC | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP74S: Spain |
| 57 | F74S55 | Expenses and Exchange Rate for Payments - Spain - 04 | 12 | Q5 | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP74Y: Italy - Reporting System Only |
| 58 | F743B14I | Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B | 4 | TI | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP75C: China - Reporting System Only |
| 59 | F75C015 | Cash Flow Data - China | 9 | CF | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP75I: India |
| 60 | F75I402 | Purchase Tax Form Details | 30 | PT | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 61 | F75I402T | Purchase Tax Form Details -Secondary | 29 | PT | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP76A: Argentina |
| 62 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 50 | WF | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 63 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 31 | WF | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 64 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 42 | WF | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| TOP76C: Colombia |
| 65 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 20 | RP | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 66 | F76C034A | A/R Check Detail file As Of - COL - 03B | 12 | RZ | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 67 | F76C9415 | Workfile for Dialy Book - COL - 09 | 14 | LD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 68 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 18 | DF | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 69 | F76CUI02 | Tax Detail - Work File - COL - 76C | 53 | TD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
| 70 | F76CUI04 | Tax Detail for Distribution - Work File - COL - 76C | 54 | TD | POST | G/L Posted Code | Character | Generic Edit | 1 | 0 |
