| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 4 | FA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 2 | F1201P | Asset Master Purge Table | 4 | FA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 17 | FA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 4 | F1212 | Parent History | 2 | FY | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 5 | F1212P | Parent History Purge Table | 2 | FY | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP13: Plant/Equipment Management |
| 6 | F1207 | Maintenance Schedule File | 38 | FW | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 7 | F12071 | Equipment PM Schedule (Model) | 62 | FZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 8 | F1207P | Maintenance Schedule Purge Table | 38 | FW | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 9 | F1308 | Equipment Routes Table | 2 | F0 | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 10 | F1308P | Equipment Routes Purge Table | 2 | F0 | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP13E: Equipment Cost Analysis |
| 11 | F1381 | Equipment Analysis Filters | 10 | EF | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 12 | F1382 | Equipment Analysis Listing | 5 | EL | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 13 | F1383 | Equipment Analysis Costs | 5 | EC | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP17: Customer Service Management |
| 14 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 125 | WS | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP31: Shop Floor Control |
| 15 | F4801S | Purge - Work Order Master file | 116 | WA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 16 | F4801Z1 | Outbound Work Order Header | 125 | SY | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 17 | F40051 | Return Material Authorization | 42 | RD | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 18 | F4211Z1 | Sales Order Detail Unedited Transaction File | 253 | SZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 19 | F4211 | Sales Order Detail File | 245 | SD | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 20 | F42119 | Sales Order History File | 245 | SD | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 21 | F42199 | S.O. Detail Ledger File | 245 | SL | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 22 | F42UI11 | SO Detail Cache File (MBF) | 176 | ZD | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 23 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 1 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 24 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 1 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 25 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 1 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 26 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 1 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 27 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 1 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP42B: Sales Order Entry |
| 28 | F4011ZT | Batch Receiver File - Order Details Tag | 54 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 29 | F47012T | EDI Purchase Order Detail Tag - Inbound | 54 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 30 | F47092T | EDI Request for Quote Detail Tag - Inbound | 54 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 31 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 54 | UZ | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP48: Work Order Processing |
| 32 | F4801 | Work Order Master File | 116 | WA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| 33 | F48UI001 | X4801 Master Business Function Workfile | 119 | WA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 34 | F76B8200 | IN86-Work Table for Fixed Assets - 12 | 3 | FA | AAID | Parent Number | Numeric | Generic Edit | 8 | 0 |
