| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 13: 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 |
| 17: Customer Service Management | ||||||||||
| 5 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 38 | WS | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 31: 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 |
| 8 | F4801S | Purge - Work Order Master file | 19 | WA | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 9 | F4801Z1 | Outbound Work Order Header | 38 | SY | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 34: Requirements Planning | ||||||||||
| 10 | F34A10 | Numetrix Integration Constants | 34 | N0 | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 48: Work Order Processing | ||||||||||
| 11 | F4801 | Work Order Master File | 19 | WA | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 12 | F4826 | W.O. Status Action Table | 3 | GE | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 13 | F4827 | Work Order Approval Routing | 4 | W5 | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 14 | F48UI001 | X4801 Master Business Function Workfile | 22 | WA | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| 76H: Chile | ||||||||||
| 15 | F76H6001 | Actual Cost Process Header - CHI - 41 - 76H | 15 | PH | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| H96: Deployment | ||||||||||
| 16 | F96400 | Sar grouping file for ESUs | 3 | SG | SRST | Status Code W.O. | String | UDC | 2 | 0 |
| H99: Product Version Control | ||||||||||
| 17 | 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.
UDC 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 |