MRP6060 - mrpQuantitiesQuery | Prospr - Dynamics GP Table Reference

MRP6060 - mrpQuantitiesQuery

Query Builder

Select * from MRP6060

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
QUERYNAME	Query Name	String	52	View
MRPQTYNUM_I	MRP_Quantity_Number	Integer	2	View
STTITNUM	Start Item Number	String	32	View
ENITMNBR	End Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
STTITCLS	Start Item Class	String	12	View
ENITMCLS	End Item Class	String	12	View
STTLOCCD	Start Location Code	String	12	View
ENLOCNCD	End Location Code	String	12	View
STARTORDERNMBR	Start Order Number	String	32	View
ENDORDERNMBR	End Order Number	String	32	View
STARTBUYERID	Start Buyer ID	String	16	View
ENDBUYERID	End Buyer ID	String	16	View
STARTPLANNERID	Start Planner ID	String	16	View
ENDPLANNERID	End Planner ID	String	16	View
STARTRELEASEDATE	Start Release Date	Date	4	View
ENDRELEASEDATE	End Release Date	Date	4	View
STTDUEDT	Start Due Date	Date	4	View
ENDDUEDT	End Due Date	Date	4	View
MRPQUERYIV_1	MRPQueryIV[1]	Boolean	2	View
MRPQUERYIV_2	MRPQueryIV[2]	Boolean	2	View
MRPQUERYIV_3	MRPQueryIV[3]	Boolean	2	View
MRPQUERYIV_4	MRPQueryIV[4]	Boolean	2	View
MRPQUERYPO_1	MRPQueryPO[1]	Boolean	2	View
MRPQUERYPO_2	MRPQueryPO[2]	Boolean	2	View
MRPQUERYPO_3	MRPQueryPO[3]	Boolean	2	View
MRPQUERYPO_4	MRPQueryPO[4]	Boolean	2	View
MRPQUERYSO_1	MRPQuerySO[1]	Boolean	2	View
MRPQUERYSO_2	MRPQuerySO[2]	Boolean	2	View
MRPQUERYSO_3	MRPQuerySO[3]	Boolean	2	View
MRPQUERYSO_4	MRPQuerySO[4]	Boolean	2	View
MRPQUERYSO_5	MRPQuerySO[5]	Boolean	2	View
MRPQUERYSO_6	MRPQuerySO[6]	Boolean	2	View
MRPQUERYSO_7	MRPQuerySO[7]	Boolean	2	View
MRPQUERYMO_1	MRPQueryMO[1]	Boolean	2	View
MRPQUERYMO_2	MRPQueryMO[2]	Boolean	2	View
MRPQUERYMO_3	MRPQueryMO[3]	Boolean	2	View
MRPQUERYMO_4	MRPQueryMO[4]	Boolean	2	View
MRPQUERYMO_5	MRPQueryMO[5]	Boolean	2	View
MRPQUERYMO_6	MRPQueryMO[6]	Boolean	2	View
MRPQUERYPK_1	MRPQueryPK[1]	Boolean	2	View
MRPQUERYPK_2	MRPQueryPK[2]	Boolean	2	View
MRPQUERYPK_3	MRPQueryPK[3]	Boolean	2	View
MRPQUERYPK_4	MRPQueryPK[4]	Boolean	2	View
MRPQUERYPK_5	MRPQueryPK[5]	Boolean	2	View
MRPQUERYPK_6	MRPQueryPK[6]	Boolean	2	View
MRPQUERYSUGGESTIONS_1	MRPQuerySuggestions[1]	Boolean	2	View
MRPQUERYSUGGESTIONS_2	MRPQuerySuggestions[2]	Boolean	2	View
MRPQUERYSUGGESTIONS_3	MRPQuerySuggestions[3]	Boolean	2	View
MRPQUERYSUGGESTIONS_4	MRPQuerySuggestions[4]	Boolean	2	View
MRPQUERYEXCEPTIONS_1	MRPQueryExceptions[1]	Boolean	2	View
MRPQUERYEXCEPTIONS_2	MRPQueryExceptions[2]	Boolean	2	View
MRPQUERYEXCEPTIONS_3	MRPQueryExceptions[3]	Boolean	2	View
MRPQUERYEXCEPTIONS_4	MRPQueryExceptions[4]	Boolean	2	View
MRPQUERYEXCEPTIONS_5	MRPQueryExceptions[5]	Boolean	2	View
MRPQUERYEXCEPTIONS_6	MRPQueryExceptions[6]	Boolean	2	View
MRPQUERYEXCEPTIONS_7	MRPQueryExceptions[7]	Boolean	2	View
MRPQUERYEXCEPTIONS_8	MRPQueryExceptions[8]	Boolean	2	View
MRPQUERYEXCEPTIONS_9	MRPQueryExceptions[9]	Boolean	2	View
MRPQUERYDUEDATE	MRPQueryDueDate	Integer	2	View
MRPQUERYRLSDATE	MRPQueryReleaseDate	Integer	2	View

MRP6060 - mrpQuantitiesQuery

Query Builder

Customer Service

Information

My Account

Contact Us