Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
ITEMNMBR | Item Number |
String | 32 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
RELEASEDATE_I | Release Date |
Date | 4 | View | |
ORDERNUMBER | Order Number |
String | 32 | View | |
MRPTYPE | MRP_Type |
Integer | 2 | View | |
Status | Status |
Integer | 2 | View | |
STSDESCR | Status Description |
String | 32 | View | |
MADEBYMOOPEN | MadeByMoOpen |
Currency | 10 | View | |
MADEBYMORELEASED | MadeByMoReleased |
Currency | 10 | View | |
MOVEIN | MoveIn |
Boolean | 2 | View | |
MOVEOUT | MoveOut |
Boolean | 2 | View | |
ORGNLDUEDT | Original Due Date |
Date | 4 | View | |
ORGNLRLSDT | Original Release Date |
Date | 4 | View | |
CANCELED | Cancelled |
Boolean | 2 | View | |
HASMRPEXCEPTION_1 | HasMRPException[1] |
Boolean | 2 | View | |
HASMRPEXCEPTION_2 | HasMRPException[2] |
Boolean | 2 | View | |
HASMRPEXCEPTION_3 | HasMRPException[3] |
Boolean | 2 | View | |
HASMRPEXCEPTION_4 | HasMRPException[4] |
Boolean | 2 | View | |
HASMRPEXCEPTION_5 | HasMRPException[5] |
Boolean | 2 | View | |
HASMRPEXCEPTION_6 | HasMRPException[6] |
Boolean | 2 | View | |
HASMRPEXCEPTION_7 | HasMRPException[7] |
Boolean | 2 | View | |
HASMRPEXCEPTION_8 | HasMRPException[8] |
Boolean | 2 | View | |
HASMRPEXCEPTION_9 | HasMRPException[9] |
Boolean | 2 | View | |
HASMRPEXCEPTION_10 | HasMRPException[10] |
Boolean | 2 | View | |
HASMRPEXCEPTION_11 | HasMRPException[11] |
Boolean | 2 | View | |
HASMRPEXCEPTION_12 | HasMRPException[12] |
Boolean | 2 | View | |
HASMRPEXCEPTION_13 | HasMRPException[13] |
Boolean | 2 | View | |
HASMRPEXCEPTION_14 | HasMRPException[14] |
Boolean | 2 | View | |
HASMRPEXCEPTION_15 | HasMRPException[15] |
Boolean | 2 | View | |
HASMRPEXCEPTION_16 | HasMRPException[16] |
Boolean | 2 | View | |
HASMRPEXCEPTION_17 | HasMRPException[17] |
Boolean | 2 | View | |
HASMRPEXCEPTION_18 | HasMRPException[18] |
Boolean | 2 | View | |
HASMRPEXCEPTION_19 | HasMRPException[19] |
Boolean | 2 | View | |
HASMRPEXCEPTION_20 | HasMRPException[20] |
Boolean | 2 | View |