| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 34X: In-Memory Planning Advisor | ||||||||||
| 1 | F34X101W | Item Summary Work Table | 9 | IS | MPST | Planning Code | Character | UDC | 1 | 0 |
| 41: Inventory Management | ||||||||||
| 2 | F4101 | Item Master | 91 | IM | MPST | Planning Code | Character | UDC | 1 | 0 |
| 3 | F4101M | Item Manufacturing Data | 13 | IM | MPST | Planning Code | Character | UDC | 1 | 0 |
| 4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 106 | SZ | MPST | Planning Code | Character | UDC | 1 | 0 |
| 5 | F4102 | Item Branch File | 79 | IB | MPST | Planning Code | Character | UDC | 1 | 0 |
| 6 | F41UI001 | Inventory Transactions Detail File | 98 | IT | MPST | Planning Code | Character | UDC | 1 | 0 |
| 41F: Apparel Management | ||||||||||
| 7 | FCW10 | Item Branch Work File | 55 | WB | MPST | Planning Code | Character | UDC | 1 | 0 |
| 8 | FCW57 | Work File Additional System Information (F4101) | 5 | WF | MPST | Planning Code | Character | UDC | 1 | 0 |
| F30L: DFM Line Design | ||||||||||
| 9 | FF30L501 | DFM Item Definition Master | 50 | IB | MPST | Planning Code | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC H41 / MP (Planning Code) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 0 | Not Planned by MPS, MRP or DRP | N | |
| 2 | 1 | Planned by MPS or DRP | N | |
| 3 | 2 | Planned by MRP | N | |
| 4 | 3 | Planned by MRP with forecast | N | |
| 5 | 4 | Planned by MPS, Parent in Bill | N | |
| 6 | 5 | Planned by MPS, Component Bill | N |