MRP Setup File (MPPS0130)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPPS0130

Product: Manufacturing (346)
Series:

Display Name: MRP Setup File
Physical Name: MPPS0130
Technical Name: MRP_Setup

Group Display Name: Manufacturing MRP
Group Technical Name: Manufacturing MRP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RUNNUMBER SearchMRP_Run_NumberLong IntegerINT99
2RUNSTARTDATE_I SearchRun Start DateDateDate_RJ0
3RUNENDDATE_I SearchRun End DateDateDate_RJ0
4CHANGEDATE_I SearchChange DateDateDT8
5USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['MRP Setup File'].USERID AS 'MRP Setup File-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       MPPS0130 AS ['MRP Setup File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['MRP Setup File'].USERID = ['Users Master'].USERID
6STTITNUM SearchStart Item NumberStringSTR30_Item_Number30
7ENITMNBR SearchEnd Item NumberStringSTR30_Item_Number30
8MRPCBDAYS_I SearchMRP_CB_DaysBooleanMRP_CB_Days0
9MRPCBMONTHS_I SearchMRP_CB_MonthsBooleanMRP_CB_Months0
10MRPCBUSER_I SearchMRP_CB_UserBooleanMRP_CB_User0
11MRPUSERSIZE_I SearchMRP_User_SizeIntegerINT44
12MRPCBWEEKS_I SearchMRP_CB_WeeksBooleanMRP_CB_Weeks0
13MRPRunDateI SearchMRP_Run_DateDateDT8
14MRPRUNLENGTH_I SearchMRP_Run_LengthIntegerINT33
15MRPRUNSPAN_I SearchMRP_Run_SpanIntegerMRP_Run_Span0
16MRPREGENTYPE_I SearchMRP_Regen_TypeIntegerMRP_Regen_Type0
17MRP_METHOD SearchMRP_MethodIntegerMRP_Method0
18PASTDUE SearchMRP_Past_Due_PeriodIntegerINT3_U03
19MRPEITHER_I SearchMRP_INT_Either_ItemsIntegerINT22
20MRPCBMOVEIN SearchMRP_CB_MoveinBooleanMRP_CB_Movin0
21MRPCBTIMEFENCE SearchMRP_CB_Time_FenceBooleanMRP_CB_Time_Fence0
22MOVEOUT SearchMoveOutBooleanCB0
23CANCELED SearchCancelledBooleanYN0
24MRPCBCALCINACTIVE_I SearchMRP_CB_CalcInactiveBooleanMRP_CB_CalcInactive0
25CALCPASTDUE SearchMRP_CB_Calc_Past_DueBooleanMRP_CB_Calc_Past_Due0
26MRP_CB_MO_Quote SearchMRP_CB_MO_QuoteBooleanMRP_CB_MO_Quote0
27MRP_CB_SO_Quote SearchMRP_CB_SO_QuoteBooleanMRP_CB_SO_Quote0
28MRPDDCONSTRAINT_I SearchMRP_DownDay_ConstraintIntegerDDL_MRP_DownDay_Constraint0
29MRPSOREQFIRM_I SearchMRP_SO_Request_FirmedBooleanMRP_SO_Request_Firmed0
30SCHEDULINGPREFEREN_I SearchScheduling PreferenceStringSTR2020
31STRTTIME SearchStart TimeTimeTM66
32ENDTIME SearchEnd TimeTimeTM66
33STRTDATE SearchStart DateDateDT8
34ENDDATE SearchEnd DateDateDT8

Leave a Reply

Your email address will not be published. Required fields are marked *