MPPS0230 - pref_mrp_sys | Prospr - Dynamics GP Table Reference

MPPS0230 - pref_mrp_sys

Query Builder

Select * from MPPS0230

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMPANYID	Company ID	Integer	2	View
MRPCBCALCINACTIVE_I	MRP_CB_CalcInactive	Boolean	2	View
MRPCBINACTIVE_I	MRP_CB_Inactive	Boolean	2	View
MRPDEFAULTBUCKET_I	MRP_Default_Bucket	Integer	2	View
MRPLABELS_I_1	MRP_Labels[1]	String	22	View
MRPLABELS_I_2	MRP_Labels[2]	String	22	View
MRPLABELS_I_3	MRP_Labels[3]	String	22	View
MRPLABELS_I_4	MRP_Labels[4]	String	22	View
MRPLABELS_I_5	MRP_Labels[5]	String	22	View
MRPLABELS_I_6	MRP_Labels[6]	String	22	View
MRPLABELS_I_7	MRP_Labels[7]	String	22	View
MRPLABELS_I_8	MRP_Labels[8]	String	22	View
MRPLABELS_I_9	MRP_Labels[9]	String	22	View
MRPLABELS_I_10	MRP_Labels[10]	String	22	View
MRPLABELS_I_11	MRP_Labels[11]	String	22	View
MRPLABELS_I_12	MRP_Labels[12]	String	22	View
MRPLABELS_I_13	MRP_Labels[13]	String	22	View
MRPLABELS_I_14	MRP_Labels[14]	String	22	View
MRPLABELS_I_15	MRP_Labels[15]	String	22	View
MRPLABELS_I_16	MRP_Labels[16]	String	22	View
MRPLABELS_I_17	MRP_Labels[17]	String	22	View
MRPLABELS_I_18	MRP_Labels[18]	String	22	View
MRPLABELS_I_19	MRP_Labels[19]	String	22	View
MRPLABELS_I_20	MRP_Labels[20]	String	22	View
MRPLABELS_I_21	MRP_Labels[21]	String	22	View
MRPLABELS_I_22	MRP_Labels[22]	String	22	View
MRPLABELS_I_23	MRP_Labels[23]	String	22	View
MRPLABELS_I_24	MRP_Labels[24]	String	22	View
MRPLABELS_I_25	MRP_Labels[25]	String	22	View
MRPLABELS_I_26	MRP_Labels[26]	String	22	View
MRPUSERNAME_I	MRP_User_Name	String	22	View
MRPUSERSIZE_I	MRP_User_Size	Integer	2	View
MRPVIEWQTYS_I_1	MRP_View_QTYS[1]	Integer	2	View
MRPVIEWQTYS_I_2	MRP_View_QTYS[2]	Integer	2	View
MRPVIEWQTYS_I_3	MRP_View_QTYS[3]	Integer	2	View
MRPVIEWQTYS_I_4	MRP_View_QTYS[4]	Integer	2	View
MRPVIEWQTYS_I_5	MRP_View_QTYS[5]	Integer	2	View
MRPVIEWQTYS_I_6	MRP_View_QTYS[6]	Integer	2	View
SCHEDULINGPREFEREN_I	Scheduling Preference	String	22	View
CALCPASTDUE	MRP_CB_Calc_Past_Due	Boolean	2	View
PASTDUE	MRP_Past_Due_Period	Integer	2	View
MRPEITHER_I	MRP_INT_Either_Items	Integer	2	View
MRPSOREQFIRM_I	MRP_SO_Request_Firmed	Boolean	2	View
MRP_CB_SO_Quote	MRP_CB_SO_Quote	Boolean	2	View
MRP_CB_MO_Quote	MRP_CB_MO_Quote	Boolean	2	View
MRP_METHOD	MRP_Method	Integer	2	View
BOM_VALIDATE_FLAG	BOM_Validate_Flag	Boolean	2	View
MRPCBMOVEIN	MRP_CB_Movein	Boolean	2	View
MRPCBTIMEFENCE	MRP_CB_Time_Fence	Boolean	2	View
MRPDDCONSTRAINT_I	MRP_DownDay_Constraint	Integer	2	View
MOVEOUT	MoveOut	Boolean	2	View
CANCELED	Cancelled	Boolean	2	View
ISMRP	IsMRP	Boolean	2	View
MRPALLOWNETCHNG	MRPAllowNetChange	Boolean	2	View
PROCESSSECURITY	Process Security	String	32	View
MRP_CB_MOP_SOP_Link	MRP_CB_MOP_SOP_Link	Boolean	2	View

MPPS0230 - pref_mrp_sys

Query Builder

Customer Service

Information

My Account

Contact Us