| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 52 | GL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP05T: Time Entry |
| 2 | F063951 | Payroll Journal (Compressed) File | 14 | GL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP07: Payroll |
| 3 | F05290 | WF - Payroll Journal (Detail) | 14 | JR | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP09: General Accounting |
| 4 | F0911P | Purge - Account Ledger | 52 | GL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 5 | F0911R | WF - Acct Ledger File for Reconciliation | 42 | GL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 6 | F0911Z1 | Journal Entry Transactions - Batch File | 69 | VN | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 7 | F0911Z4 | F0911 Interoperability Table | 74 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 8 | F0912 | Cost Allocations/Flex Budgeting | 26 | RJ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 9 | F0912A | Index Computation Entry File | 22 | RI | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 10 | F09UI015 | Indexed Computations Multi-Tiered Entries | 52 | GL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP12: Fixed Assets |
| 11 | F1201 | Asset Master File | 5 | FA | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 12 | F1201P | Asset Master Purge Table | 5 | FA | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 13 | F1201Z1 | Unedited Asset Master Transactions | 18 | FA | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 14 | F12911ER | Post G/L to FA Exceptions Work File | 11 | GL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP13: Plant/Equipment Management |
| 15 | F1207 | Maintenance Schedule File | 3 | FW | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 16 | F12071 | Equipment PM Schedule (Model) | 60 | FZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 17 | F1207P | Maintenance Schedule Purge Table | 3 | FW | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 18 | F12120Z1 | Unedited Meter Reading Transactions | 17 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 19 | F1306 | Meter Reading Estimates | 3 | F5 | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 20 | F1306P | Meter Reading Estimates Purge Table | 3 | F5 | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 21 | F1393 | Maintenance Rules | 14 | GO | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP13C: Condition-Base Maintenance |
| 22 | F1310 | Condition-Based Alerts | 4 | CA | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 23 | F1310Z1 | Unedited Condition-Based Alerts | 17 | CB | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP13E: Equipment Cost Analysis |
| 24 | F1382 | Equipment Analysis Listing | 7 | EL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 25 | F1383 | Equipment Analysis Costs | 12 | EC | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP17: Customer Service Management |
| 26 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 26 | WQ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP31: Shop Floor Control |
| 27 | F4801Z1 | Outbound Work Order Header | 160 | SY | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP40R: Demand Scheduling |
| 28 | F47UI002 | ASN Extract Packaging Work File | 46 | SP | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP41: Inventory Management |
| 29 | F4111 | Item Ledger File | 50 | IL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP42: Sales Management |
| 30 | F42800G1 | Sales Update G Batch Detail Workfile | 26 | DG | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP43: Procurement |
| 31 | F43080 | Approvals Fields Constants | 132 | PD | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 32 | F4311 | Purchase Order Detail File | 132 | PD | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 33 | F4311Z | Purchase Order Generator File | 136 | PW | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 34 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 145 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 35 | F43121 | Purchase Order Receiver File | 52 | PR | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 36 | F43121Z | Receiver workfile | 42 | PW | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 37 | F43121Z1 | Receipts Unedited Transaction Table | 69 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 38 | F4314Z | Voucher Match Selection File | 152 | PN | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 39 | F43199 | P.O. Detail Ledger File - Flexible Version | 132 | OL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP43Q: Strategic Sourcing |
| 40 | F43Q11 | Event Detail | 19 | ED | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP44H: Homebuilder Management |
| 41 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 39 | CG | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP46: Warehouse Management |
| 42 | F4620 | Carton Detail Information | 55 | CD | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP47: Electronic Commerce |
| 43 | F47017 | EDI Purchase Order Detail - Outbound | 146 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 44 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 146 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 45 | F47032 | EDI Shipping Notice Detail - Inbound | 103 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 46 | F470375 | EDI ASN Packaging Detail | 36 | AK | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 47 | F47072 | EDI Receiving Advice Detail - Inbound | 147 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 48 | F47077 | EDI Receiving Advice Detail - Outbound | 147 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 49 | F47097 | EDI Request for Quote Detail - Outbound | 146 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 50 | F47102 | EDI Response to RFQ Detail - Inbound | 146 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 51 | F47137 | EDI Purchase Order Change Detail - Outbound | 147 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 52 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 148 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 53 | F47157 | EDI Shipping Schedule Detail - Outbound | 155 | SZ | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP48: Work Order Processing |
| 54 | F4801ST | Purge - Work Order Master Tag File | 13 | WA | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| 55 | F4801T | Work Order Master Tag File | 13 | WA | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP48S: Service Billing |
| 56 | F48S910 | Billing Detail Journal File | 29 | W2 | ASID | Serial Number | String | Generic Edit | 25 | 0 |
| TOP89: Conversion Programs |
| 57 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 132 | OL | ASID | Serial Number | String | Generic Edit | 25 | 0 |
