Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
GUID | GUID |
String | 38 | View | |
RUNNUMBER | MRP_Run_Number |
Long Integer | 4 | View | |
ORDERNUMBER | Order Number |
String | 32 | View | |
MRPTYPE | MRP_Type |
Integer | 2 | View | |
ORD | Ord |
Long Integer | 4 | View | |
SOPTYPE | SOP Type 1 = Quote |
Integer | 2 | View | |
CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
RELEASEDATE_I | Release Date |
Date | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
MRP_EXCEPTION_STATUS | MRP_Exception_Status |
String | 22 | View | |
SUPPLYQTY | SupplyQuantity |
Currency | 10 | View | |
DEMANDQTY | DemandQuantity |
Currency | 10 | View | |
BUYERID | Buyer ID |
String | 16 | View | |
PLANNERID | Planner ID |
String | 16 | View | |
MRPEXCEPTIONS | MRP_Exceptions |
Integer | 2 | View | |
Status | Status |
Integer | 2 | View | |
QUANTITY | QTY |
Currency | 10 | View | |
REPORTGROUP | ReportGroup |
Long Integer | 4 | View | |
LOTNUMBR | Lot Number |
String | 22 | View | |
DUEDATE2 | DueDate2 |
Date | 4 | View |