MRPW4020 - mrpPicklistWork | Prospr - Dynamics GP Table Reference

MRPW4020 - mrpPicklistWork

Query Builder

Select * from MRPW4020

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
DUEDATE	Due Date	Date	4	View
ORDERNUMBER	Order Number	String	32	View
MRPTYPE	MRP_Type	Integer	2	View
MRPPARENTTYPE	MRP Parent Type	Integer	2	View
SEQ_I	Seq	Long Integer	4	View
Status	Status	Integer	2	View
STSDESCR	Status Description	String	32	View
QUANTITY	QTY	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
QTYCONSUMED	QTY Consumed	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