MRP0300 - mrpExceptionsEPS | Prospr - Dynamics GP Table Reference

MRP0300 - mrpExceptionsEPS

Select * from MRP0300

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 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	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