| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| ORDERNUMBER | Order Number |
String | 32 | 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 | |
| QUANTITY | QTY |
Currency | 10 | View | |
| Status | Status |
Integer | 2 | View | |
| STSDESCR | Status Description |
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 |