MRP4020 - mrpPicklistLinesEPS | Prospr - Dynamics GP Table Reference

MRP4020 - mrpPicklistLinesEPS

Query Builder

Select * from MRP4020

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
PHNTMPRNT	Phantom Parent	String	32	View
Status	Status	Integer	2	View
STSDESCR	Status Description	String	32	View
ALLCBYMOOPEN	AllocatedByMoOpen	Currency	10	View
ALLOCBYMORELEASED	AllocatedByMoReleased	Currency	10	View
CNSMDBYMOOPEN	ConsumedByMoOpen	Currency	10	View
CNSMDBYMORELEASED	ConsumedByMoReleased	Currency	10	View
REQBYMOOPEN	RequiredByMoOpen	Currency	10	View
REQBYMORELEASED	RequiredByMoReleased	Currency	10	View
MOVEIN	MoveIn	Boolean	2	View
MOVEOUT	MoveOut	Boolean	2	View
ORGNLDUEDT	Original Due Date	Date	4	View
CANCELED	Cancelled	Boolean	2	View
HASMRPEXCEPTION_1	HasMRPException[1]	Boolean	2	View
HASMRPEXCEPTION_2	HasMRPException[2]	Boolean	2	View
HASMRPEXCEPTION_3	HasMRPException[3]	Boolean	2	View
HASMRPEXCEPTION_4	HasMRPException[4]	Boolean	2	View
HASMRPEXCEPTION_5	HasMRPException[5]	Boolean	2	View
HASMRPEXCEPTION_6	HasMRPException[6]	Boolean	2	View
HASMRPEXCEPTION_7	HasMRPException[7]	Boolean	2	View
HASMRPEXCEPTION_8	HasMRPException[8]	Boolean	2	View
HASMRPEXCEPTION_9	HasMRPException[9]	Boolean	2	View
HASMRPEXCEPTION_10	HasMRPException[10]	Boolean	2	View
HASMRPEXCEPTION_11	HasMRPException[11]	Boolean	2	View
HASMRPEXCEPTION_12	HasMRPException[12]	Boolean	2	View
HASMRPEXCEPTION_13	HasMRPException[13]	Boolean	2	View
HASMRPEXCEPTION_14	HasMRPException[14]	Boolean	2	View
HASMRPEXCEPTION_15	HasMRPException[15]	Boolean	2	View
HASMRPEXCEPTION_16	HasMRPException[16]	Boolean	2	View
HASMRPEXCEPTION_17	HasMRPException[17]	Boolean	2	View
HASMRPEXCEPTION_18	HasMRPException[18]	Boolean	2	View
HASMRPEXCEPTION_19	HasMRPException[19]	Boolean	2	View
HASMRPEXCEPTION_20	HasMRPException[20]	Boolean	2	View

MRP4020 - mrpPicklistLinesEPS

Query Builder

Customer Service

Information

My Account

Contact Us