| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 15 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP03: Accounts Receivable |
| 2 | F0311 | Accounts Receivable Ledger | 46 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 3 | F0312 | A/R Batch Cash Application | 26 | RU | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 4 | F03B11 | Customer Ledger | 47 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 5 | F03B117 | Revenue Recognition GL Info | 54 | RL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 6 | F03B119 | Revenue Recognition GL Info Audit | 52 | RN | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 7 | F03B11P | Customer Ledger Purge File | 47 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 8 | F03B11Z1 | Batch Invoices | 64 | VJ | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 9 | F03B11Z2 | F03B11 Interoperability Table | 60 | SY | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 10 | F03B13 | Receipts Header | 35 | RY | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 11 | F03B13P | Receipts Header Purge File | 35 | RY | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 12 | F03B13Z1 | Electronic Receipts Input | 33 | RU | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 13 | F03B13Z2 | F03B13 Interoperability Table | 48 | SY | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 14 | F03B571 | Auto Debit Batch Control | 16 | RC | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 15 | F03B575 | Auto Debit Invoice Select and Build | 56 | RD | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 16 | F03B672 | Draft Remittance | 34 | RD | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 17 | F09UI011 | Receipt Prepost Work File | 10 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP04: Accounts Payable |
| 18 | F0411 | Accounts Payable Ledger | 46 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 19 | F0411A | WF - 'As Of' Accounts Payable Ledger | 46 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 20 | F0411P | Purge - Accounts Payable Ledger | 46 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 21 | F0411Z1 | Voucher Transactions - Batch Upload | 64 | VL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 22 | F0411Z3 | F0411 Interoperability Table | 69 | SZ | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 23 | F0413 | Accounts Payable - Matching Document | 14 | RM | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 24 | F0413A | WF - 'As Of' Accounts Payable Payment Register | 14 | RM | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 25 | F0413P | Purge - Accounts Payable Matching Documents | 14 | RM | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 26 | F0413Z1 | F0413 Interoperability Table | 29 | SY | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 27 | F09UI005 | Tax Offsets User Index | 30 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP05: Time Accounting and HRM Base |
| 28 | F06106 | Employee Pay Instructions | 13 | YM | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 29 | F0618 | Employee Transaction History | 6 | YT | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP05T: Time Entry |
| 30 | F06116 | Employee Transaction Detail File | 6 | YT | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 31 | F06116Z1 | Employee Transactions - Batch File | 23 | VL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 32 | F06116Z2 | ESS Timecard History | 23 | VM | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 33 | F06278 | Retro Timecard Detail File | 9 | YT | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 34 | F063951 | Payroll Journal (Compressed) File | 9 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 35 | F069136 | Tip Disbursement | 15 | JE | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP07: Payroll |
| 36 | F05290 | WF - Payroll Journal (Detail) | 9 | JR | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 37 | F07UI200 | Timecard History Work File | 9 | TH | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP08AD: ADP Integration |
| 38 | F051371 | ADP Employee DBA Instructions | 18 | AD | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP09: General Accounting |
| 39 | F0911P | Purge - Account Ledger | 15 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 40 | F0911R | WF - Account Ledger Reconciliation | 15 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 41 | F0911Z1 | Journal Entry Transactions - Batch File | 32 | VN | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 42 | F0911Z4 | F0911 Interoperability Table | 37 | SZ | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 43 | F0912 | Cost Allocations/Flex Budgeting | 19 | RJ | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 44 | F0912A | Index Computation Entry File | 15 | RI | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 45 | F0912B | Variable Allocation File | 14 | R# | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 46 | F0916 | Bank Statement Header | 3 | GH | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 47 | F0917 | Bank Statement Detail | 3 | GD | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 48 | F09UI015 | Indexed Computations Multi-Tiered Entries | 15 | GL | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP11: Multi Currency |
| 49 | F1114 | Company Conversions Parameter File | 18 | C2 | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP18: Timecard Automation |
| 50 | F186602 | Labor Rules Tag File | 20 | TF | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 51 | F42800G1 | Sales Update G Batch Detail Workfile | 16 | DG | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 52 | F47057 | EDI Payment Order Remittance Advice - Outbound | 95 | D3 | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 53 | F47057W | EDI Payment Order Remittance Advice - Work | 95 | D3 | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 54 | F47113 | EDI Lockbox/Payment Detail - Batch | 22 | Z3 | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP48S: Service Billing |
| 55 | F48S0618 | Payroll Reclassification Workfile | 6 | YT | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 56 | F48S910 | Billing Detail Journal Workfile | 22 | W2 | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| 57 | F48S911 | Summarized Journal Workfile | 20 | W3 | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP74: EMEA Localization |
| 58 | F74900 | Foreign Receivables and Payables - EMEA | 54 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP76A: Argentina |
| 59 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 10 | WF | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
| TOP76C: Colombia |
| 60 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 46 | RP | AM | Account Mode - G/L | Character | UDC | 1 | 0 |
