| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP13: Plant/Equipment Management |
1 | F13411 | PM Projections | 19 | RX | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
TOP17: Customer Service Management |
2 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 57 | WS | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
TOP31: Shop Floor Control |
3 | F31091 | Schedule Quantity Detail | 14 | IQ | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
4 | F31091S | Schedule Quantity Detail Purge | 14 | IQ | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
5 | F4801S | Purge - Work Order Master file | 38 | WA | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
6 | F4801Z1 | Outbound Work Order Header | 57 | SY | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
TOP48: Work Order Processing |
7 | F48001 | Work Order Default Coding File | 2 | WE | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
8 | F4801 | Work Order Master File | 38 | WA | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
9 | F48UI001 | X4801 Master Business Function Workfile | 41 | WA | WR02 | Categories - Work Order 02 | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / W2 (Work Order Category Code 2) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | |
2 | 100 | Machine Shop | | |
3 | 101 | Drill Press | | |
4 | 102 | Milling Machine | | |
5 | 103 | Molding Machine | | |
6 | 200 | Fab-Assembly Department | | |
7 | 201 | CNC Machine | | |
8 | 202 | Molding Machines | | |
9 | 203 | Blister Pack Machine | | |
10 | 204 | Final Assembly | | |
11 | 300 | Final Assembly Department | | |
12 | 320 | Material Handling | | |
13 | 330 | Sub Assembly | | |
14 | 340 | Quality Assurance | | |
15 | 400 | AS 400 | | N |
16 | F1 | Improper Start-Up or Operation | | |
17 | F2 | Improper Installation/Repair | | |
18 | F3 | Inadequate Preventive Maint | | |
19 | F4 | Material or Corrosion Problem | | |
20 | F5 | Lubrication or Cooling Problem | | |
21 | F6 | Out of Balance or Alignment | | |
22 | F7 | Duty or Plugged Up | | |
23 | F8 | Normal Wear | | |
24 | F9 | Design of Equipment | | |
25 | PNT | Paint Shop | | |