| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 34: Requirements Planning | ||||||||||
| 1 | F3411 | MPS/MRP/DRP Message File | 5 | MM | MSGT | Message Type | Character | UDC | 1 | 0 |
| 34X: In-Memory Planning Advisor | ||||||||||
| 2 | F34X001 | Planning Advisor Message Type Configuration | 3 | MC | MSGT | Message Type | Character | UDC | 1 | 0 |
| 3 | F34X100W | Message Summary Work Table | 4 | MS | MSGT | Message Type | Character | UDC | 1 | 0 |
| 41F: Apparel Management | ||||||||||
| 4 | FCW97 | Grouping Messages | 4 | GM | MSGT | Message Type | Character | UDC | 1 | 0 |
| 43: Procurement | ||||||||||
| 5 | F4311Z | Purchase Order Generator File | 203 | PW | MSGT | Message Type | 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 34 / MT (Message Type) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | A | Warning Messages | ||
| 2 | B | Order & Expedite | ||
| 3 | C | Cancel | ||
| 4 | D | Defer | ||
| 5 | E | Expedite | ||
| 6 | F | Frozen Order | ||
| 7 | G | Increase Order Quantity to | ||
| 8 | H | Decrease Rate Quantity to | ||
| 9 | I | Increase Rate Quantity to | ||
| 10 | L | Decrease Order Quantity to | ||
| 11 | M | Manual Reminder | ||
| 12 | N | Create Rate | ||
| 13 | O | Order | ||
| 14 | P | Firm Order | ||
| 15 | S | FPO Adjustment Suggestion | ||
| 16 | T | Past Due Order | ||
| 17 | W | Warning, Create Related PO | N |