| 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 | |
| RUNNUMBER | MRP_Run_Number |
Long Integer | 4 | View | |
| RELEASEDATE_I | Release Date |
Date | 4 | View | |
| LLC | LLC |
Long Integer | 4 | View | |
| QTYTORDR | QTY To Order |
Currency | 10 | View | |
| QUANTITY | QTY |
Currency | 10 | View | |
| BASEUOFM | Base U Of M |
String | 10 | View | |
| PRIMVNDR | Primary Vendor |
String | 16 | View | |
| REPLENISHMENTMETHOD | Replenishment Method 1 – Make |
Integer | 2 | View | |
| TRANSFERRED | Transferred |
Boolean | 2 | View | |
| ISCRPSCHDLD | IsCRPScheduled |
Boolean | 2 | View |