| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP34: Requirements Planning |
| 1 | F3403 | Branch Relationships Master File | 4 | MP | PRPX | Master Planning Family | String | UDC | 3 | 0 |
| TOP35: Enterprise Facility Planning |
| 2 | F35UI001 | MPS/MRP Planning - Multiple Plant User Index | 8 | MA | PRPX | Master Planning Family | 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 41 / P4 (Master Planning Family) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Add master planning family P4c | | Y |
| 2 | 027 | Lot Trace/Track | | N |
| 3 | 200 | Bike | | N |
| 4 | 210 | Bike Frame | | N |
| 5 | 220 | Bike Pump | | N |
| 6 | 240 | Bike Accessory | | N |
| 7 | 270 | Snowboards | | N |
| 8 | 300 | Cyclometer | | N |
| 9 | 400 | Beverage | | N |
| 10 | 420 | Health Foods | | N |
| 11 | 500 | Lubricant | | N |
| 12 | 600 | Forklift | | N |
| 13 | 620 | Cabinets | | N |
| 14 | 625 | Valves | | N |
| 15 | 630 | Pipes | | N |
| 16 | 700 | Phone Equipment | | N |
| 17 | 8 | Maintenance Purchasing | | N |
| 18 | 800 | Fish Processing | | N |
| 19 | 801 | MP1 | | N |
| 20 | 850 | Wood Products | | N |
| 21 | 880 | Automotive | | N |
| 22 | 9 | General Merchandise | | N |
| 23 | 999 | Raw Material | | N |
| 24 | CC1 | CC1 | | N |
| 25 | CC2 | CC2 | | N |
| 26 | CC3 | CC3 | | N |
| 27 | CC4 | CC4 | | N |
| 28 | CHE | Chemical | | N |
| 29 | DR2 | DRP Planning Family 2 | | N |
| 30 | DRP | DRP Planning Family | | N |
| 31 | ELC | Electrical | | N |
| 32 | ETO | Engineer to Order Items | | N |
| 33 | FDB | Food and Beverage | | N |
| 34 | MP | Raw Material | | N |
| 35 | MP1 | Master Planning Family One | | Y |
| 36 | PRO | Promotional Items | | N |
| 37 | PT | Finished Good | | N |
| 38 | SE | Semi-finished Good | | N |
| 39 | SRS | Supplier Release Schedule | | N |
| 40 | SS1 | Summer Seasonal - Type 1 | | N |
| 41 | SS2 | Summer Seasonal - Type 2 | | N |
| 42 | TLS | Tools | | N |
| 43 | WS | Winter Seasonal | | N |
| 44 | XYZ | Generic Planning Family | | N |
