| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP13: Plant/Equipment Management |
| 1 | F13411 | PM Projections | 28 | RX | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP13R: Resource Assignments |
| 2 | F48310 | Resource Master | 9 | RM | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 3 | F48311 | Resource Assignments | 62 | RA | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 4 | F48311S | Purge - Resource Assignments | 62 | RA | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 5 | F48315 | Maintenance Schedule Metrics | 3 | WS | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 6 | F48316 | Maintenance Rescheduling Metrics | 8 | RS | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP15: Real Estate Management |
| 7 | F1501 | Tenant/Lease Master | 10 | NE | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 8 | F1501B | Lease Master Header | 10 | NE | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP17: Customer Service Management |
| 9 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 43 | WS | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP30: Product Data Management |
| 10 | F3003Z1 | Routing Transactions File | 86 | SZ | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP31: Shop Floor Control |
| 11 | F3112 | Work Order Routing | 106 | WL | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 12 | F3112S | Purge Shop Floor Control Routing Instructions | 106 | WL | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 13 | F3112Z1 | Outbound Work Order Routings | 120 | SZ | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP31P: Engineer To Order |
| 14 | F31P10 | Project Quote Header | 17 | PQ | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 15 | F3003 | Routing Master File | 72 | IR | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP41F: Apparel Management |
| 16 | FCW65 | Work Order Header for Style Items | 25 | OF | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP43: Procurement |
| 17 | F4340 | Purchase Rebate Master File | 12 | RD | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP48: Work Order Processing |
| 18 | F48001 | Work Order Default Coding File | 4 | WE | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 19 | F4801 | Work Order Master File | 24 | WA | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 20 | F4801S | Purge - Work Order Master file | 24 | WA | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 21 | F4801Z1 | Outbound Work Order Header | 43 | SY | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 22 | F48710 | Work Order Mass Update Template Table | 23 | WT | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| 23 | F48UI001 | X4801 Master Business Function Workfile | 27 | WA | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
| TOP87: PeopleSoft Internal |
| 24 | F1811 | Task Resource | 11 | TK | ANSA | Address Number - Manager | Numeric | Generic Edit | 8 | 0 |
