| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 36 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F03B117 | Revenue Recognition GL Info | 66 | RL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 3 | F03B119 | Revenue Recognition GL Info Audit | 67 | RN | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 4 | F09UI011 | Receipt Prepost Work File | 27 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP04: Accounts Payable |
| 5 | F09UI005 | Tax Offsets User Index | 25 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP05: Time Accounting and HRM Base |
| 6 | F069027 | Table Code Unit-of-Measure Window | 2 | Y2 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 7 | F069116 | Payroll Transaction Constants | 2 | YC | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 8 | F069130 | Group Limits | 2 | YD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 9 | F06931 | Wage Attachment File | 2 | J3 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP05T: Time Entry |
| 10 | F059022 | Pay Calculation Table | 11 | PC | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 11 | F063951 | Payroll Journal (Compressed) File | 17 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP07: Payroll |
| 12 | F05290 | WF - Payroll Journal (Detail) | 17 | JR | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 13 | F069026 | Payroll Generic Tables | 12 | Y2 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 14 | F0729 | Employee DBA Override Instructions | 8 | Y9 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 15 | F07390 | Year-End Rollover Workfile | 9 | RO | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP08AD: ADP Integration |
| 16 | F051375 | ADP Payroll DBA Transaction Constants | 4 | AD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP08B: Benefits Administration |
| 17 | F08320 | Benefits Plan Master | 2 | BA | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 18 | F08380WF | Batch Enrollment Work File | 6 | BE | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP09: General Accounting |
| 19 | F0911P | Purge - Account Ledger | 36 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 20 | F0911R | WF - Account Ledger Reconciliation | 33 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 21 | F0911Z1 | Journal Entry Transactions - Batch File | 53 | VN | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 22 | F0911Z4 | F0911 Interoperability Table | 58 | SZ | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 23 | F0912 | Cost Allocations/Flex Budgeting | 29 | RJ | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 24 | F09123 | Advanced Variable Numerator | 6 | VN | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 25 | F0912A | Index Computation Entry File | 25 | RI | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 26 | F0912B | Variable Allocation File | 9 | R# | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 27 | F0917 | Bank Statement Detail | 48 | GD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 28 | F09505 | WF - Bank File of Cleared Checks. | 3 | GN | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 29 | F097021W | Account Ledger to Account Master Work Table | 13 | TA | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 30 | F09UI015 | Indexed Computations Multi-Tiered Entries | 36 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 31 | F52G11 | Burdening Detail Ledger | 26 | BD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 32 | F52G11WF | Temporary Burdened Detail Ledger Workfile | 26 | BW | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 33 | F70UI001 | Work File for G/L by Cat. Code Localization | 7 | WA | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 34 | F740911 | Work File for G/L Report by Category Code Localization | 10 | WA | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP11: Multi Currency |
| 35 | F1114 | Company Conversions Parameter File | 16 | C2 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP12: Fixed Assets |
| 36 | F12911ER | Post G/L to FA Exceptions Work File | 6 | GL | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP42: Sales Management |
| 37 | F42800G | Sales Update G Batch Workfile | 21 | SG | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 38 | F42800G1 | Sales Update G Batch Detail Workfile | 116 | DG | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP48S: Service Billing |
| 39 | F4812 | Billing Detail Workfile | 50 | WD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 40 | F4812H | Billing Workfile History | 50 | WD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 41 | F4812HS | Billing Workfile History Purged Save | 50 | WD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 42 | F48S910 | Billing Detail Journal Workfile | 25 | W2 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 43 | F48S911 | Summarized Journal Workfile | 35 | W3 | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 44 | F48SUI01 | Billing Detail Print Workfile | 50 | WD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP51: Job Costing |
| 45 | F51911EX | Draw Explanation Table | 6 | GK | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP52G: Proj & Gov Contract Accounting |
| 46 | F52G90 | Invoice Printing Work Table | 46 | WT | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP74Z: Czech Republic |
| 47 | F74Z0010 | Cash Desk Document Printed - CZE - 74Z | 13 | ZO | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP76A: Argentina |
| 48 | F76A42 | CERG G/L - Work File - ARG - 09 - 76A | 11 | TF | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP76B: Brazil |
| 49 | F76B10 | Account Ledger - IN68 - 09 | 17 | AR | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| 50 | F76B911 | IN86-Work Table for Journal Entries - 09 | 17 | BD | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
| TOP76C: Colombia |
| 51 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 17 | DF | EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 |
