| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F00189 | WF - Tax Reconciliation | 8 | TG | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 2 | F0018R | Tax Reconciliation Repository | 5 | ED | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 3 | F0911 | Account Ledger | 5 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 4 | F03B117 | Revenue Recognition GL Info | 5 | RL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 5 | F03B119 | Revenue Recognition GL Info Audit | 5 | RN | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP05T: Time Entry |
| 6 | F063951 | Payroll Journal (Compressed) File | 21 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP07: Payroll |
| 7 | F05290 | WF - Payroll Journal (Detail) | 21 | JR | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP09: General Accounting |
| 8 | F0911P | Purge - Account Ledger | 5 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 9 | F0911R | WF - Account Ledger Reconciliation | 5 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 10 | F0911Z1 | Journal Entry Transactions - Batch File | 22 | VN | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 11 | F0911Z4 | F0911 Interoperability Table | 27 | SZ | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 12 | F0912 | Cost Allocations/Flex Budgeting | 33 | RJ | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 13 | F0912A | Index Computation Entry File | 29 | RI | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 14 | F097021W | Account Ledger to Account Master Work Table | 7 | TA | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 15 | F09UI015 | Indexed Computations Multi-Tiered Entries | 5 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 16 | F09UI017 | Cash Forecast Detail | 6 | FW | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 17 | F52G11 | Burdening Detail Ledger | 5 | BD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 18 | F52G11WF | Temporary Burdened Detail Ledger Workfile | 5 | BW | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP12: Fixed Assets |
| 19 | F12911ER | Post G/L to FA Exceptions Work File | 3 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP15: Real Estate Management |
| 20 | F1532B | Expense Participation Audit File | 4 | NT | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP38: Agreement Management |
| 21 | F38111 | Agreements Transaction Ledger | 17 | DZ | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP39: Advanced Stock Valuation |
| 22 | F3910 | G/L Adjustment Table | 16 | SC | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP40: Inventory/OP Base |
| 23 | F40UI801 | Generic Error Table | 14 | ZB | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP41: Inventory Management |
| 24 | F4111 | Item Ledger File | 25 | IL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 25 | F41291Z | Landed Cost Cache Table | 31 | IG | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP41B: Bulk Stock Management |
| 26 | F41511 | Bulk Product Transaction File | 4 | PA | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 27 | F41512 | Gain/Loss Transactions File | 7 | PT | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP42: Sales Management |
| 28 | F42800G1 | Sales Update G Batch Detail Workfile | 3 | DG | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP43: Procurement |
| 29 | F43121 | Purchase Order Receiver File | 60 | PR | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 30 | F43121Z | Receiver workfile | 12 | PW | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 31 | F43121Z1 | Receipts Unedited Transaction Table | 77 | SZ | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 32 | F4314Z | Voucher Match Selection File | 160 | PN | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP43A: Purchase Order Receipt/Routing |
| 33 | F43126 | Purchase Order Receiver Multiple Account | 26 | P4 | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 34 | F43127 | Purchase Order Receiver Non-Billable | 18 | PR | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP47: Electronic Commerce |
| 35 | F47122 | EDI Product Activity Data Detail - Inbound | 53 | MJ | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 36 | F47127 | EDI Product Activity Data Detail - Outbound | 53 | MJ | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP48S: Service Billing |
| 37 | F4812 | Billing Detail Workfile | 5 | WD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 38 | F4812H | Billing Workfile History | 5 | WD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 39 | F4812HS | Billing Workfile History Purged Save | 5 | WD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 40 | F48S910 | Billing Detail Journal Workfile | 15 | W2 | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 41 | F48S911 | Summarized Journal Workfile | 13 | W3 | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 42 | F48S912 | G/L Link | 10 | W6 | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 43 | F48SUI01 | Billing Detail Print Workfile | 5 | WD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP49: Transportation Management |
| 44 | F49631 | Load In-transit Ledger | 4 | TO | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 45 | F4981 | Freight Audit History | 45 | FH | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP51: Job Costing |
| 46 | F51911 | Draw Reporting Master | 4 | GK | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 47 | F51911EX | Draw Explanation Table | 5 | GK | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP70: Multi-National Products |
| 48 | F700911 | GL Invoice Number | 5 | GA | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 49 | F704200 | Final VAT AP - COMM - 70 | 16 | FV | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP74P: Poland |
| 50 | F74P9100 | Cash Desk Transaction - POL - 74P | 8 | CD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP74R: Russia |
| 51 | F74R0018 | Russian Tax File - 74R | 72 | TD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 52 | F74R0100 | Petty Cash Transactions - RUS - 00 - 74R | 9 | PC | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP75C: China |
| 53 | F75C015 | Cash Flow Data - China | 5 | CF | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 54 | F75C202 | Asset Disposal Amounts - CHINA | 8 | DA | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 55 | F75C911A | Account Ledger Processing Info- China - 09 | 6 | AL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 56 | F75C912 | Transaction-wise Subsidiary Info - China - 09 | 6 | TS | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP75I: India |
| 57 | F75I310W | Voucher Entry Record | 6 | RE | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP75T: Taiwan |
| 58 | F75T005 | GUI/VAT Transaction Detail - 75T | 39 | TD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 59 | F75T0059 | GUI/VAT Transaction Detail History - 75T | 39 | TD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 60 | F75T005T | GUI/VAT Transaction Detail Temp - 75T | 39 | TD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 61 | F75T005Z | GUI/VAT Transaction Detail - Work - 75T | 46 | ZD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP76A: Argentina |
| 62 | F76A41 | CERG G/L - Lot Detail - ARG - 09 - 76A | 7 | LD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP76B: Brazil |
| 63 | F76B911 | IN86-Work Table for Journal Entries - 09 | 15 | BD | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP76C: Colombia |
| 64 | F76C574 | DIAN File Type 2 (C) - COL - 04 | 2 | R2 | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 65 | F76C575 | Work File Magnetic Media - COL - 04 | 15 | Q1 | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 66 | F76C576 | DIAN Flat File - COL - 04 | 1 | PL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 67 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 6 | DF | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 68 | F76CT1 | Tributary Information - COL - 76C | 14 | TI | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP76H: Chile |
| 69 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 26 | AL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP76M: Mexico |
| 70 | F76M0314 | Receipt Detail Tag File - Mexico | 7 | MA | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 71 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 11 | RT | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| 72 | F76M990 | GL VAT on Gain/loss MEX - 76M | 4 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
| TOP89: Conversion Programs |
| 73 | F0911T | Needed for upgrade for XE and below | 6 | GL | JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 |
