| 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 |