pref_mrp_sys (MPPS0230)

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

Product: Manufacturing (346)
Series:

Display Name: pref_mrp_sys
Physical Name: MPPS0230
Technical Name: pref_mrp_sys

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['pref_mrp_sys'].CMPANYID AS 'pref_mrp_sys-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       MPPS0230 AS ['pref_mrp_sys']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['pref_mrp_sys'].CMPANYID = ['Company Master'].CMPANYID
2MRPCBCALCINACTIVE_I SearchMRP_CB_CalcInactiveBooleanMRP_CB_CalcInactive0
3MRPCBINACTIVE_I SearchMRP_CB_InactiveBooleanMRP_CB_Inactive0
4MRPDEFAULTBUCKET_I SearchMRP_Default_BucketIntegerMRP_Default_Bucket0
5MRPLABELS_I SearchMRP_LabelsSTR20String20
6MRPLABELS_I_1 SearchMRP_Labels[1]StringSTR2020
7MRPLABELS_I_2 SearchMRP_Labels[2]StringSTR2020
8MRPLABELS_I_3 SearchMRP_Labels[3]StringSTR2020
9MRPVIEWQTYS_I SearchMRP_View_QTYSINT2Integer2
10MRPLABELS_I_4 SearchMRP_Labels[4]StringSTR2020
11MRPLABELS_I_5 SearchMRP_Labels[5]StringSTR2020
12MRPLABELS_I_6 SearchMRP_Labels[6]StringSTR2020
13MRPLABELS_I_7 SearchMRP_Labels[7]StringSTR2020
14MRPLABELS_I_8 SearchMRP_Labels[8]StringSTR2020
15MRPLABELS_I_9 SearchMRP_Labels[9]StringSTR2020
16MRPLABELS_I_10 SearchMRP_Labels[10]StringSTR2020
17MRPLABELS_I_11 SearchMRP_Labels[11]StringSTR2020
18MRPLABELS_I_12 SearchMRP_Labels[12]StringSTR2020
19MRPLABELS_I_13 SearchMRP_Labels[13]StringSTR2020
20MRPLABELS_I_14 SearchMRP_Labels[14]StringSTR2020
21MRPLABELS_I_15 SearchMRP_Labels[15]StringSTR2020
22MRPLABELS_I_16 SearchMRP_Labels[16]StringSTR2020
23MRPLABELS_I_17 SearchMRP_Labels[17]StringSTR2020
24MRPLABELS_I_18 SearchMRP_Labels[18]StringSTR2020
25MRPLABELS_I_19 SearchMRP_Labels[19]StringSTR2020
26MRPLABELS_I_20 SearchMRP_Labels[20]StringSTR2020
27MRPLABELS_I_21 SearchMRP_Labels[21]StringSTR2020
28MRPLABELS_I_22 SearchMRP_Labels[22]StringSTR2020
29MRPLABELS_I_23 SearchMRP_Labels[23]StringSTR2020
30MRPLABELS_I_24 SearchMRP_Labels[24]StringSTR2020
31MRPLABELS_I_25 SearchMRP_Labels[25]StringSTR2020
32MRPLABELS_I_26 SearchMRP_Labels[26]StringSTR2020
33MRPUSERNAME_I SearchMRP_User_NameStringSTR2020
34MRPUSERSIZE_I SearchMRP_User_SizeIntegerINT44
35MRPVIEWQTYS_I_1 SearchMRP_View_QTYS[1]IntegerINT22
36MRPVIEWQTYS_I_2 SearchMRP_View_QTYS[2]IntegerINT22
37MRPVIEWQTYS_I_3 SearchMRP_View_QTYS[3]IntegerINT22
38MRPVIEWQTYS_I_4 SearchMRP_View_QTYS[4]IntegerINT22
39MRPVIEWQTYS_I_5 SearchMRP_View_QTYS[5]IntegerINT22
40MRPVIEWQTYS_I_6 SearchMRP_View_QTYS[6]IntegerINT22
41SCHEDULINGPREFEREN_I SearchScheduling PreferenceStringSTR2020
42CALCPASTDUE SearchMRP_CB_Calc_Past_DueBooleanMRP_CB_Calc_Past_Due0
43PASTDUE SearchMRP_Past_Due_PeriodIntegerINT3_U03
44MRPEITHER_I SearchMRP_INT_Either_ItemsIntegerINT22
45MRPSOREQFIRM_I SearchMRP_SO_Request_FirmedBooleanMRP_SO_Request_Firmed0
46MRP_CB_SO_Quote SearchMRP_CB_SO_QuoteBooleanMRP_CB_SO_Quote0
47MRP_CB_MO_Quote SearchMRP_CB_MO_QuoteBooleanMRP_CB_MO_Quote0
48MRP_METHOD SearchMRP_MethodIntegerMRP_Method0
49BOM_VALIDATE_FLAG SearchBOM_Validate_FlagBooleanBoolean0
50MRPCBMOVEIN SearchMRP_CB_MoveinBooleanMRP_CB_Movin0
51MRPCBTIMEFENCE SearchMRP_CB_Time_FenceBooleanMRP_CB_Time_Fence0
52MRPDDCONSTRAINT_I SearchMRP_DownDay_ConstraintIntegerDDL_MRP_DownDay_Constraint0
53MOVEOUT SearchMoveOutBooleanCB0
54CANCELED SearchCancelledBooleanYN0
55ISMRP SearchIsMRPBooleanCB0
56MRPALLOWNETCHNG SearchMRPAllowNetChangeBooleanCB0
57PROCESSSECURITY SearchProcess SecurityStringSTR30_LBAU30
58MRP_CB_MOP_SOP_Link SearchMRP_CB_MOP_SOP_LinkBooleanMRP_CB_MOP_SOP_Link0

Leave a Reply

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