| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 112 | GL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F03B117 | Revenue Recognition GL Info | 51 | RL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 3 | F03B119 | Revenue Recognition GL Info Audit | 49 | RN | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP05: Time Accounting and HRM Base |
| 4 | F0618 | Employee Transaction History | 108 | YT | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP05T: Time Entry |
| 5 | F06116 | Employee Transaction Detail File | 159 | YT | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 6 | F06116Z1 | Employee Transactions - Batch File | 171 | VL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 7 | F06116Z2 | ESS Timecard History | 171 | VM | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 8 | F063951 | Payroll Journal (Compressed) File | 68 | GL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP07: Payroll |
| 9 | F05290 | WF - Payroll Journal (Detail) | 70 | JR | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 10 | F0716701 | Employee Assignment T/E Template Information | 13 | EA | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 11 | F0716709 | Employee Assignment T/E Template Info History | 13 | EA | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP09: General Accounting |
| 12 | F0911P | Purge - Account Ledger | 112 | GL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 13 | F0911R | WF - Account Ledger Reconciliation | 67 | GL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 14 | F0911Z1 | Journal Entry Transactions - Batch File | 163 | VN | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 15 | F0911Z4 | F0911 Interoperability Table | 143 | SZ | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP16: Profit Management (EPS) |
| 16 | F1602 | Cost Analyzer Balances | 15 | CB | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 17 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 37 | CZ | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 18 | F1610 | Cost Calculation Definitions | 37 | CD | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 19 | F1611 | Cost Calculation Transactions | 24 | CT | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 20 | F1630 | Driver Definitions | 20 | CD | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 21 | F1632 | Driver Balances | 15 | CB | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 22 | F1632Z1 | External Driver Balances-Interoperability Table | 37 | CY | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 23 | F16421 | Rate Master Detail File | 10 | RD | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP18: Timecard Automation |
| 24 | F186602 | Labor Rules Tag File | 165 | TF | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP31: Shop Floor Control |
| 25 | F31UI802 | Accumulate Amounts by Account | 24 | WG | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 26 | F31UI803 | Work File for Summarizing Journal Entries | 23 | SG | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 27 | F42800G1 | Sales Update G Batch Detail Workfile | 112 | DG | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 28 | F4311T | Purchase Order Detail Tag File | 18 | PD | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 29 | F4311Z | Purchase Order Generator File | 215 | PW | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 30 | F43121T | Purchase Order Receiver Tag File | 25 | PR | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 31 | F43121Z | Receiver workfile | 133 | PW | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 32 | F43121Z1 | Receipts Unedited Transaction Table | 144 | SZ | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 33 | F43147 | Freight Distribution Workfile | 50 | FD | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 34 | F4314Z | Voucher Match Selection File | 97 | PN | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 35 | F4575 | Ship and Debit History | 50 | AH | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 36 | F4575TMP | Ship and Debit History - Temp Table | 50 | AH | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 37 | F4576 | Ship and Debit Claims | 78 | AC | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 38 | F4576TMP | Ship and Debit Claims- Temp Table | 78 | AC | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 39 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 75 | Z1 | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP48S: Service Billing |
| 40 | F48S0618 | Payroll Reclassification Workfile | 108 | YT | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP74U: United Kingdom Localizations |
| 41 | F74U424A | SPC Subcontractor Accrual Data - UK - 43 | 25 | PL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 42 | F74U424W | SPC Subcontractor Accrual Workfile - UK - 43 | 20 | WF | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP76H: Chile |
| 43 | F76H6001 | Actual Cost Process Header - CHI - 41 - 76H | 9 | PH | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 44 | F76H6002 | Indirect Costs Selection EPS F1602 - CHI - 41 - 76H | 18 | I1 | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 45 | F76H6003 | Indirect Costs Selection EPS F1642 - CHI - 41 - 76H | 19 | I2 | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP83: Management Reporting - FASTR |
| 46 | F83UI001 | Balance Audit Work File - (Financial Reporting) | 26 | R1 | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 47 | F0911T | Needed for upgrade for XE and below | 24 | GL | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
| 48 | F0911Z1T | Needed for upgrade for XE and below | 21 | VN | ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 |
