MRP Setup File (MPPS0130)

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

Product: Manufacturing (346)
Series: 3rd Party

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_NumberINT9Long Integer9
2RUNSTARTDATE_I SearchRun Start DateDate_RJDate0
3RUNENDDATE_I SearchRun End DateDate_RJDate0
4CHANGEDATE_I SearchChange DateDTDate8
5USERID SearchUser IDSTR15_User_IDString15
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 NumberSTR30_Item_NumberString30
7ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
8MRPCBDAYS_I SearchMRP_CB_DaysMRP_CB_DaysBoolean0
9MRPCBMONTHS_I SearchMRP_CB_MonthsMRP_CB_MonthsBoolean0
10MRPCBUSER_I SearchMRP_CB_UserMRP_CB_UserBoolean0
11MRPUSERSIZE_I SearchMRP_User_SizeINT4Integer4
12MRPCBWEEKS_I SearchMRP_CB_WeeksMRP_CB_WeeksBoolean0
13MRPRunDateI SearchMRP_Run_DateDTDate8
14MRPRUNLENGTH_I SearchMRP_Run_LengthINT3Integer3
15MRPRUNSPAN_I SearchMRP_Run_SpanMRP_Run_SpanInteger0
16MRPREGENTYPE_I SearchMRP_Regen_TypeMRP_Regen_TypeInteger0
17MRP_METHOD SearchMRP_MethodMRP_MethodInteger0
18PASTDUE SearchMRP_Past_Due_PeriodINT3_U0Integer3
19MRPEITHER_I SearchMRP_INT_Either_ItemsINT2Integer2
20MRPCBMOVEIN SearchMRP_CB_MoveinMRP_CB_MovinBoolean0
21MRPCBTIMEFENCE SearchMRP_CB_Time_FenceMRP_CB_Time_FenceBoolean0
22MOVEOUT SearchMoveOutCBBoolean0
23CANCELED SearchCancelledYNBoolean0
24MRPCBCALCINACTIVE_I SearchMRP_CB_CalcInactiveMRP_CB_CalcInactiveBoolean0
25CALCPASTDUE SearchMRP_CB_Calc_Past_DueMRP_CB_Calc_Past_DueBoolean0
26MRP_CB_MO_Quote SearchMRP_CB_MO_QuoteMRP_CB_MO_QuoteBoolean0
27MRP_CB_SO_Quote SearchMRP_CB_SO_QuoteMRP_CB_SO_QuoteBoolean0
28MRPDDCONSTRAINT_I SearchMRP_DownDay_ConstraintDDL_MRP_DownDay_ConstraintInteger0
29MRPSOREQFIRM_I SearchMRP_SO_Request_FirmedMRP_SO_Request_FirmedBoolean0
30SCHEDULINGPREFEREN_I SearchScheduling PreferenceSTR20String20
31STRTTIME SearchStart TimeTM6Time6
32ENDTIME SearchEnd TimeTM6Time6
33STRTDATE SearchStart DateDTDate8
34ENDDATE SearchEnd DateDTDate8
35DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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