| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 13: Plant/Equipment Management | ||||||||||
| 1 | F13411 | PM Projections | 22 | RX | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 17: Customer Service Management | ||||||||||
| 2 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 60 | WS | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 41F: Apparel Management | ||||||||||
| 3 | FCW65 | Work Order Header for Style Items | 42 | OF | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 48: Work Order Processing | ||||||||||
| 4 | F4801 | Work Order Master File | 41 | WA | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 5 | F4801S | Purge - Work Order Master file | 41 | WA | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 6 | F4801Z1 | Outbound Work Order Header | 60 | SY | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 7 | F48710 | Work Order Mass Update Template Table | 53 | WT | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
| 8 | F48UI001 | X4801 Master Business Function Workfile | 44 | WA | WR05 | Categories - Work Order 05 | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 00 / W5 (Work Order Category Code 5) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | . | |||
| 2 | 01 | Motors (M) | N | |
| 3 | 03 | Gear Reducers & Gear Box | N | |
| 4 | 04 | Agitators | N | |
| 5 | 05 | Hoists & Cranes | N | |
| 6 | 06 | Conveyors | N | |
| 7 | 07 | Scales | N | |
| 8 | 08 | Fans & Blowers | N | |
| 9 | 11 | Compressors | N | |
| 10 | 12 | Pumps (P) | N | |
| 11 | 13 | Heating and Ventilation | N | |
| 12 | 15 | Boilers | N | |
| 13 | 16 | Heat Exchangers | N | |
| 14 | 17 | Pressure Vessels | N | |
| 15 | 18 | Tanks & Vats | N | |
| 16 | 19 | Press | N | |
| 17 | 20 | Instrumentation | N | |
| 18 | 25 | Refiners, Grinders, Digesters | N | |
| 19 | 27 | Valves (V) | N | |
| 20 | 28 | Mobil Equipment | N | |
| 21 | 29 | MISC. Equipment | N | |
| 22 | 2A | Industrial Fan Motors | N | |
| 23 | 2B | Industrial Fans | N | |
| 24 | 2T | Milling Machine Table | N | |
| 25 | 3 | CONSTRUCTION EQUIPMENT | N | |
| 26 | 3A | CONCRETE EQUIPMENT | N | |
| 27 | 3AA | AIR COMPRESSORS | N | |
| 28 | 3AB | PAVEMENT BREAKERS | N | |
| 29 | 3AD | DIGGERS | N | |
| 30 | 3AE | DRILLS, HAND | N | |
| 31 | 3AR | ROCK DRILL TOOLS | N | |
| 32 | 3C | COMPACTION EQUIPMENT | N | |
| 33 | 3CO | CONCRETE EQUIPMENT & ACCESS | N | |
| 34 | 3CR | CRANES & SHOVELS | N | |
| 35 | 3H | HOIST & TOWER EQUIPMENT | N | |
| 36 | 3P | PILE DRIVING EQUIPMENT | N | |
| 37 | 3PU | PUMPING EQUIPMENT | N | |
| 38 | 3S | TOOLS, PORTABLE ELECTRIC | N | |
| 39 | 3T | TRACTORS & EARTHMOVING EQUIP. | N | |
| 40 | 3TC | TRACK-TYPE TRACTORS | N | |
| 41 | 3TE | EXCAVATORS | N | |
| 42 | 3TK | SKIDDERS | N | |
| 43 | 3TM | MOTOR GRADERS | N | |
| 44 | 3TP | PIPE LAYERS | N | |
| 45 | 3TS | SCRAPERS | N | |
| 46 | 3TT | TRUCKS, OFF-HIGHWAY | N | |
| 47 | 3TW | WHEEL TRACTORS | N | |
| 48 | 3TX | WHEEL LOADERS | N | |
| 49 | 3TY | TRACK-TPE LOADERS | N | |
| 50 | 3Z | GENERAL EQUIPMENT | N | |
| 51 | 40 | CARS & SMALL TRUCKS | N | |
| 52 | 50 | OTHER | N |