MPPS0130 - MRP Setup File | Prospr - Dynamics GP Table Reference

MPPS0130 - MRP Setup File

Query Builder

Select * from MPPS0130

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RUNNUMBER	MRP_Run_Number	Long Integer	4	View
RUNSTARTDATE_I	Run Start Date	Date	4	View
RUNENDDATE_I	Run End Date	Date	4	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
STTITNUM	Start Item Number	String	32	View
ENITMNBR	End Item Number	String	32	View
MRPCBDAYS_I	MRP_CB_Days	Boolean	2	View
MRPCBMONTHS_I	MRP_CB_Months	Boolean	2	View
MRPCBUSER_I	MRP_CB_User	Boolean	2	View
MRPUSERSIZE_I	MRP_User_Size	Integer	2	View
MRPCBWEEKS_I	MRP_CB_Weeks	Boolean	2	View
MRPRunDateI	MRP_Run_Date	Date	4	View
MRPRUNLENGTH_I	MRP_Run_Length	Integer	2	View
MRPRUNSPAN_I	MRP_Run_Span	Integer	2	View
MRPREGENTYPE_I	MRP_Regen_Type	Integer	2	View
MRP_METHOD	MRP_Method	Integer	2	View
PASTDUE	MRP_Past_Due_Period	Integer	2	View
MRPEITHER_I	MRP_INT_Either_Items	Integer	2	View
MRPCBMOVEIN	MRP_CB_Movein	Boolean	2	View
MRPCBTIMEFENCE	MRP_CB_Time_Fence	Boolean	2	View
MOVEOUT	MoveOut	Boolean	2	View
CANCELED	Cancelled	Boolean	2	View
MRPCBCALCINACTIVE_I	MRP_CB_CalcInactive	Boolean	2	View
CALCPASTDUE	MRP_CB_Calc_Past_Due	Boolean	2	View
MRP_CB_MO_Quote	MRP_CB_MO_Quote	Boolean	2	View
MRP_CB_SO_Quote	MRP_CB_SO_Quote	Boolean	2	View
MRPDDCONSTRAINT_I	MRP_DownDay_Constraint	Integer	2	View
MRPSOREQFIRM_I	MRP_SO_Request_Firmed	Boolean	2	View
SCHEDULINGPREFEREN_I	Scheduling Preference	String	22	View
STRTTIME	Start Time	Time	4	View
ENDTIME	End Time	Time	4	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View