| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP13: Plant/Equipment Management |
| 1 | F13411 | PM Projections | 16 | RX | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 2 | F13907 | Associated Service Types | 7 | FC | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 3 | F13907P | Associated Service Types Purge Table | 7 | FC | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 4 | F1393 | Maintenance Rules | 7 | GO | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOP17: Customer Service Management |
| 5 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 38 | WS | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOP31: Shop Floor Control |
| 6 | F3115 | Net Change Transaction table | 5 | NC | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 7 | F31UI006 | Line Scheduling Workbench - Work File | 33 | LS | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOP34A: Advanced Planning & Scheduling |
| 8 | F34A10 | APS Integration Constants | 34 | N0 | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOP41F: Apparel Management |
| 9 | FCW65 | Work Order Header for Style Items | 20 | OF | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOP48: Work Order Processing |
| 10 | F4801 | Work Order Master File | 19 | WA | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 11 | F4801S | Purge - Work Order Master file | 19 | WA | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 12 | F4801Z1 | Outbound Work Order Header | 38 | SY | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 13 | F4826 | W.O. Status Action Table | 3 | GE | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 14 | F4827 | Work Order Approval Routing | 4 | W5 | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 15 | F48710 | Work Order Mass Update Template Table | 9 | WT | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 16 | F48UI001 | X4801 Master Business Function Workfile | 22 | WA | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOP76H: Chile |
| 17 | F76H6001 | Actual Cost Process Header - CHI - 41 - 76H | 15 | PH | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOPH96: Deployment |
| 18 | F96400 | Sar grouping file for ESUs | 3 | SG | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| TOPH99: Product Version Control |
| 19 | F9900003 | Software Update Object Verification Work Table | 10 | SU | SRST | Status Code W.O. | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / SS (work order status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | | | |
| 2 | 05 | Order Created | | Y |
| 3 | 10 | Released (Firm) Not Started | | N |
| 4 | 15 | Sales Order WO Not Processed | | N |
| 5 | 25 | PL and Rtg Reviewed | | Y |
| 6 | 3P | Pristine Update | | N |
| 7 | 41 | Firm Planned Order (FPO) | | N |
| 8 | 45 | Material Issued | | N |
| 9 | 80 | Completion Reported | | Y |
| 10 | 81 | CRP Display Orders | | N |
| 11 | 82 | Lot Trace/Track Example order. | | N |
| 12 | 83 | Mfg. Acctg Example | | N |
| 13 | 84 | 4 Days from Final Accting | | Y |
| 14 | 86 | 3 Days from Final Accting | | Y |
| 15 | 88 | 2 Days from Final Accting | | Y |
| 16 | 90 | Complete - Partial | | N |
| 17 | 91 | Complete - Cancelled | | N |
| 18 | 92 | Complete - Partial Split | | N |
| 19 | 95 | Manufacturing Complete | | N |
| 20 | 98 | J.E.'s Variances - Proofed | | N |
| 21 | 99 | Order Complete | | N |
| 22 | A | Approved ECO | | N |
| 23 | AI | Additional data required (ECO) | | N |
| 24 | D | Disapproved ECO | | N |
| 25 | E1 | ECO Entered | | N |
| 26 | E2 | Preliminary Workup | | N |
| 27 | E3 | Approval Pending | | N |
| 28 | E4 | ECO Approved | | N |
| 29 | E5 | ECO Implemented | | N |
| 30 | EM | Emergency Order | | N |
| 31 | IA | Inactive Work Order | | N |
| 32 | M | Maintenance Work Request | | N |
| 33 | M* | MWO Waiting Manager Approval | | N |
| 34 | MA | MWO Approved | | N |
| 35 | MB | MWO Material Issued | | N |
| 36 | MC | W/O In Planning | | N |
| 37 | MD | W/O Plant Shutdown | | N |
| 38 | ME | W/O Waiting for Parts | | N |
| 39 | MF | W/O Parts Staged and Ready | | N |
| 40 | MG | W/O Ready to Schedule | | N |
| 41 | MH | W/O Issued & Released | | N |
| 42 | MI | W/O Outside Services | | N |
| 43 | MJ | W/O Completed | | N |
| 44 | MK | W/O Closed | | N |
| 45 | ML | Standing W/O`s | | N |
| 46 | MM | W/O Cancelled | | N |
| 47 | MP | MWO Planning Only | | N |
| 48 | MR | MWO Requested/Not Approved | | N |
| 49 | NB | Non-Billable Work Order | | N |
| 50 | NE | ECO Entered | | N |
| 51 | P | Planned (MRP) Order | | N |
| 52 | YY | OP Configured Work Order | N | Y |
| 53 | ZZ | New Rate For Processing | | Y |
