Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
ORDERNUMBER | Order Number |
String | 32 | View | |
ORD | Ord |
Long Integer | 4 | View | |
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 | |
QTYORDER | QTY Ordered |
Currency | 10 | View | |
QTYSHPPD | QTY Shipped |
Currency | 10 | View | |
STSDESCR | Status Description |
String | 32 | View | |
Status | Status |
Integer | 2 | View | |
CONTENDDTE | Contract End Date |
Date | 4 | View | |
VENDORID | Vendor ID |
String | 16 | 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 |