pref_mrp_sys (MPPS0230)

azurecurve Products Manufacturing (346)3rd Partypref_mrp_sys (MPPS0230)

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

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

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CMPANYID	Company ID	Integer	INT5	4
	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
2	MRPCBCALCINACTIVE_I	MRP_CB_CalcInactive	Boolean	MRP_CB_CalcInactive	0
3	MRPCBINACTIVE_I	MRP_CB_Inactive	Boolean	MRP_CB_Inactive	0
4	MRPDEFAULTBUCKET_I	MRP_Default_Bucket	Integer	MRP_Default_Bucket	0
5	MRPLABELS_I_1	MRP_Labels[1]	String	STR20	20
6	MRPLABELS_I	MRP_Labels	STR20	String	20
7	MRPLABELS_I_2	MRP_Labels[2]	String	STR20	20
8	MRPLABELS_I_3	MRP_Labels[3]	String	STR20	20
9	MRPVIEWQTYS_I	MRP_View_QTYS	INT2	Integer	2
10	MRPLABELS_I_4	MRP_Labels[4]	String	STR20	20
11	MRPLABELS_I_5	MRP_Labels[5]	String	STR20	20
12	MRPLABELS_I_6	MRP_Labels[6]	String	STR20	20
13	MRPLABELS_I_7	MRP_Labels[7]	String	STR20	20
14	MRPLABELS_I_8	MRP_Labels[8]	String	STR20	20
15	MRPLABELS_I_9	MRP_Labels[9]	String	STR20	20
16	MRPLABELS_I_10	MRP_Labels[10]	String	STR20	20
17	MRPLABELS_I_11	MRP_Labels[11]	String	STR20	20
18	MRPLABELS_I_12	MRP_Labels[12]	String	STR20	20
19	MRPLABELS_I_13	MRP_Labels[13]	String	STR20	20
20	MRPLABELS_I_14	MRP_Labels[14]	String	STR20	20
21	MRPLABELS_I_15	MRP_Labels[15]	String	STR20	20
22	MRPLABELS_I_16	MRP_Labels[16]	String	STR20	20
23	MRPLABELS_I_17	MRP_Labels[17]	String	STR20	20
24	MRPLABELS_I_18	MRP_Labels[18]	String	STR20	20
25	MRPLABELS_I_19	MRP_Labels[19]	String	STR20	20
26	MRPLABELS_I_20	MRP_Labels[20]	String	STR20	20
27	MRPLABELS_I_21	MRP_Labels[21]	String	STR20	20
28	MRPLABELS_I_22	MRP_Labels[22]	String	STR20	20
29	MRPLABELS_I_23	MRP_Labels[23]	String	STR20	20
30	MRPLABELS_I_24	MRP_Labels[24]	String	STR20	20
31	MRPLABELS_I_25	MRP_Labels[25]	String	STR20	20
32	MRPLABELS_I_26	MRP_Labels[26]	String	STR20	20
33	MRPUSERNAME_I	MRP_User_Name	String	STR20	20
34	MRPUSERSIZE_I	MRP_User_Size	Integer	INT4	4
35	MRPVIEWQTYS_I_1	MRP_View_QTYS[1]	Integer	INT2	2
36	MRPVIEWQTYS_I_2	MRP_View_QTYS[2]	Integer	INT2	2
37	MRPVIEWQTYS_I_3	MRP_View_QTYS[3]	Integer	INT2	2
38	MRPVIEWQTYS_I_4	MRP_View_QTYS[4]	Integer	INT2	2
39	MRPVIEWQTYS_I_5	MRP_View_QTYS[5]	Integer	INT2	2
40	MRPVIEWQTYS_I_6	MRP_View_QTYS[6]	Integer	INT2	2
41	SCHEDULINGPREFEREN_I	Scheduling Preference	String	STR20	20
42	CALCPASTDUE	MRP_CB_Calc_Past_Due	Boolean	MRP_CB_Calc_Past_Due	0
43	PASTDUE	MRP_Past_Due_Period	Integer	INT3_U0	3
44	MRPEITHER_I	MRP_INT_Either_Items	Integer	INT2	2
45	MRPSOREQFIRM_I	MRP_SO_Request_Firmed	Boolean	MRP_SO_Request_Firmed	0
46	MRP_CB_SO_Quote	MRP_CB_SO_Quote	Boolean	MRP_CB_SO_Quote	0
47	MRP_CB_MO_Quote	MRP_CB_MO_Quote	Boolean	MRP_CB_MO_Quote	0
48	MRP_METHOD	MRP_Method	Integer	MRP_Method	0
49	BOM_VALIDATE_FLAG	BOM_Validate_Flag	Boolean	Boolean	0
50	MRPCBMOVEIN	MRP_CB_Movein	Boolean	MRP_CB_Movin	0
51	MRPCBTIMEFENCE	MRP_CB_Time_Fence	Boolean	MRP_CB_Time_Fence	0
52	MRPDDCONSTRAINT_I	MRP_DownDay_Constraint	Integer	DDL_MRP_DownDay_Constraint	0
53	MOVEOUT	MoveOut	Boolean	CB	0
54	CANCELED	Cancelled	Boolean	YN	0
55	ISMRP	IsMRP	Boolean	CB	0
56	MRPALLOWNETCHNG	MRPAllowNetChange	Boolean	CB	0
57	PROCESSSECURITY	Process Security	String	STR30_LBAU	30
58	MRP_CB_MOP_SOP_Link	MRP_CB_MOP_SOP_Link	Boolean	MRP_CB_MOP_SOP_Link	0

azurecurve Products Manufacturing (346)3rd Partypref_mrp_sys (MPPS0230)

Click to show/hide

Leave a Reply Cancel reply