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 | |
ORDERNUMBER | Order Number |
String | 32 | View | |
MRPTYPE | MRP_Type |
Integer | 2 | View | |
MRPPARENTTYPE | MRP Parent Type |
Integer | 2 | View | |
SEQ_I | Seq |
Long Integer | 4 | View | |
Status | Status |
Integer | 2 | View | |
STSDESCR | Status Description |
String | 32 | View | |
QUANTITY | QTY |
Currency | 10 | View | |
ATYALLOC | QTY Allocated |
Currency | 10 | View | |
QTYCONSUMED | QTY Consumed |
Currency | 10 | View | |
PHNTMPRNT | Phantom Parent |
String | 32 | View | |
CALCMRP_I | Calc MRP |
Boolean | 2 | View | |
MRPEXCEPTIONSARRAY_1 | MRP_Exceptions_Array[1] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_2 | MRP_Exceptions_Array[2] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_3 | MRP_Exceptions_Array[3] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_4 | MRP_Exceptions_Array[4] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_5 | MRP_Exceptions_Array[5] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_6 | MRP_Exceptions_Array[6] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_7 | MRP_Exceptions_Array[7] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_8 | MRP_Exceptions_Array[8] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_9 | MRP_Exceptions_Array[9] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_10 | MRP_Exceptions_Array[10] |
Integer | 2 | View | |
BUYERID | Buyer ID |
String | 16 | View | |
PLANNERID | Planner ID |
String | 16 | View |