MRP4050 - mrpDependentDemandEPS | Prospr - Dynamics GP Table Reference

MRP4050 - mrpDependentDemandEPS

Query Builder

Select * from MRP4050

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PARENTNUMBER_I	Parent Number	String	32	View
ORDERNUMBER	Order Number	String	32	View
MRPPARENTTYPE	MRP Parent Type	Integer	2	View
EXPLODE_QTY_I	Explode Quantity	Currency	10	View
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
DUEDATE	Due Date	Date	4	View
MRPTYPE	MRP_Type	Integer	2	View
GUID	GUID	String	38	View
Status	Status	Integer	2	View
STSDESCR	Status Description	String	32	View
QUANTITY	QTY	Currency	10	View
PHNTMPRNT	Phantom Parent	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
BOMCAT_I	BOM Cat	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
BOMTYPE_I	BOM Type	Integer	2	View
LEVEL_I	Level0	Long Integer	4	View