| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP17: Customer Service Management |
| 1 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 98 | WS | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP31P: Engineer To Order |
| 2 | F31PUI01 | Scheduling Error Report | 11 | SE | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP34: Requirements Planning |
| 3 | F34A70 | Last Outbound Work Order Table | 6 | OW | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP34A: Advanced Planning & Scheduling |
| 4 | F34A60 | Last Outbound Purchase Order/Transfer Order | 9 | OB | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP34X: In-Memory Planning Advisor |
| 5 | F34X200W | Planning Details Supply/Demand Work Table | 44 | SD | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 6 | F4011Z | Batch Receiver File - Order Details | 205 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 7 | F4211Z1 | Sales Order Detail Unedited Transaction File | 184 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP41F: Apparel Management |
| 8 | FCW65 | Work Order Header for Style Items | 69 | OF | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 9 | F4211 | Sales Order Detail File | 171 | SD | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 10 | F42119 | Sales Order History File | 171 | SD | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 11 | F42199 | S.O. Detail Ledger File | 171 | SL | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 12 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 62 | ZD | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 13 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 82 | UZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 14 | F43080 | Approvals Fields Constants | 146 | PD | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 15 | F4311 | Purchase Order Detail File | 146 | PD | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 16 | F4311Z | Purchase Order Generator File | 150 | PW | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 17 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 159 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 18 | F43199 | P.O. Detail Ledger File - Flexible Version | 146 | OL | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 19 | F47012 | EDI Purchase Order Detail - Inbound | 206 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 20 | F47017 | EDI Purchase Order Detail - Outbound | 160 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 21 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 160 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 22 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 206 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 23 | F47047 | EDI Invoice Detail (Sales) - Outbound | 206 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 24 | F47072 | EDI Receiving Advice Detail - Inbound | 161 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 25 | F47077 | EDI Receiving Advice Detail - Outbound | 161 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 26 | F47092 | EDI Request for Quote Detail - Inbound | 206 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 27 | F47097 | EDI Request for Quote Detail - Outbound | 160 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 28 | F47102 | EDI Response to RFQ Detail - Inbound | 160 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 29 | F47107 | EDI Response to RFQ Detail - Outbound | 205 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 30 | F47132 | EDI Purchase Order Change Detail - Inbound | 207 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 31 | F47137 | EDI Purchase Order Change Detail - Outbound | 161 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 32 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 162 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 33 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 208 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 34 | F47157 | EDI Shipping Schedule Detail - Outbound | 169 | SZ | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP48: Work Order Processing |
| 35 | F4801 | Work Order Master File | 79 | WA | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 36 | F4801S | Purge - Work Order Master file | 79 | WA | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 37 | F4801Z1 | Outbound Work Order Header | 98 | SY | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 38 | F48710 | Work Order Mass Update Template Table | 101 | WT | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| 39 | F48UI001 | X4801 Master Business Function Workfile | 82 | WA | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 40 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 146 | OL | UNCD | Work Order Freeze Code | Character | UDC | 1 | 0 |