| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP17: Customer Service Management |
| 1 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 62 | WP | MTST | Material Status Code W.O. | String | UDC | 2 | 0 |
| TOP31: Shop Floor Control |
| 2 | F3111 | Work Order Parts List | 49 | WM | MTST | Material Status Code W.O. | String | UDC | 2 | 0 |
| 3 | F3111S | Purge - Shop Floor Parts List | 49 | WM | MTST | Material Status Code W.O. | String | UDC | 2 | 0 |
| 4 | F3111Z1 | Outbound Work Order Parts List | 62 | SZ | MTST | Material Status Code W.O. | String | UDC | 2 | 0 |
| TOP43: Procurement |
| 5 | F4311Z | Purchase Order Generator File | 204 | PW | MTST | Material Status Code W.O. | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 31 / MS (Material Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | |
| 2 | 03 | Print Pick List | | Y |
| 3 | 04 | Pick List Printed | | Y |
| 4 | 06 | No Warehse/Mfg Pick Interface | | N |
| 5 | 07 | In Warehouse | | N |
| 6 | 08 | Out of Warehouse | | N |
| 7 | 09 | Qty Remaining or Cancelled | | N |
| 8 | 10 | Partial Issue | | |
| 9 | 11 | Material on Order | | N |
| 10 | 20 | Material Issue | | |
| 11 | 99 | Material Issue Complete | | |
