MOP Variances (MOP3000)

azurecurve Products Manufacturing (346)3rd PartyMOP Variances (MOP3000)

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

Display Name: MOP Variances
Physical Name: MOP3000
Technical Name: MOP_Variances

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
2	MANUFACTUREORDERST_I	Manufacture Order Status	Integer	DDL_WO_Status	0
3	ENDQTY_I	End QTY	Currency	DLR_14_MRP	14
4	QTYRECVD	QTY Received	Currency	DLR17_QTY_RBS0_UTR	17
5	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['MOP Variances'].ITEMNMBR AS 'MOP Variances-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MOP3000 AS ['MOP Variances'] INNER JOIN IV00101 AS ['Item Master'] ON ['MOP Variances'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	VCTNMTHD	Valuation Method	Integer	DDL_Valuation_Method	0
7	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
8	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
9	STDMATQTYRCD	Var_StdMatQtyRcd	Currency	DLR17_RBS0_STR$	17
10	STDMATFOQTYRCD	Var_StdMatFoQtyRcd	Currency	DLR17_RBS0_STR$	17
11	STDMATVOQTYRCD	Var_StdMatVoQtyRcd	Currency	DLR17_RBS0_STR$	17
12	STDLABQTYRCD	Var_StdLabQtyRcd	Currency	DLR17_RBS0_STR$	17
13	STDLABFOQTYRCD	Var_StdLabFoQtyRcd	Currency	DLR17_RBS0_STR$	17
14	STDLABVOQTYRCD	Var_StdLabVoQtyRcd	Currency	DLR17_RBS0_STR$	17
15	STDMACHQTYRCD	Var_StdMachQtyRcd	Currency	DLR17_RBS0_STR$	17
16	STDMACHFOQTYRCD	Var_StdMachFoQtyRcd	Currency	DLR17_RBS0_STR$	17
17	STDMACHVOQTYRCD	Var_StdMachVoQtyRcd	Currency	DLR17_RBS0_STR$	17
18	STDTOTALQTYRCD	Var_StdTotalQtyRcd	Currency	DLR17_RBS0_STR$	17
19	STDMATQTYEND	Var_StdMatQtyEnd	Currency	DLR17_RBS0_STR$	17
20	STDMATFOQTYEND	Var_StdMatFoQtyEnd	Currency	DLR17_RBS0_STR$	17
21	STDMATVOQTYEND	Var_StdMatVoQtyEnd	Currency	DLR17_RBS0_STR$	17
22	STDLABQTYEND	Var_StdLabQtyEnd	Currency	DLR17_RBS0_STR$	17
23	STDLABFOQTYEND	Var_StdLabFoQtyEnd	Currency	DLR17_RBS0_STR$	17
24	STDLABVOQTYEND	Var_StdLabVoQtyEnd	Currency	DLR17_RBS0_STR$	17
25	STDMACHQTYEND	Var_StdMachQtyEnd	Currency	DLR17_RBS0_STR$	17
26	STDMACHFOQTYEND	Var_StdMachFoQtyEnd	Currency	DLR17_RBS0_STR$	17
27	STDMACHVOQTYEND	Var_StdMachVoQtyEnd	Currency	DLR17_RBS0_STR$	17
28	STDTOTALQTYEND	Var_StdTotalQtyEnd	Currency	DLR17_RBS0_STR$	17
29	PRODMATQTYRCD	Var_ProdMatQtyRcd	Currency	DLR17_RBS0_STR$	17
30	PRODMATFOQTYRCD	Var_ProdMatFoQtyRcd	Currency	DLR17_RBS0_STR$	17
31	PRODMATVOQTYRCD	Var_ProdMatVoQtyRcd	Currency	DLR17_RBS0_STR$	17
32	PRODLABQTYRCD	Var_ProdLabQtyRcd	Currency	DLR17_RBS0_STR$	17
33	PRODLABFOQTYRCD	Var_ProdLabFoQtyRcd	Currency	DLR17_RBS0_STR$	17
34	PRODLABVOQTYRCD	Var_ProdLabVoQtyRcd	Currency	DLR17_RBS0_STR$	17
35	PRODMACHQTYRCD	Var_ProdMachQtyRcd	Currency	DLR17_RBS0_STR$	17
36	PRODMACHFOQTYRCD	Var_ProdMachFoQtyRcd	Currency	DLR17_RBS0_STR$	17
37	PRODMACHVOQTYRCD	Var_ProdMachVoQtyRcd	Currency	DLR17_RBS0_STR$	17
38	PRODTOTALQTYRCD	Var_ProdTotalQtyRcd	Currency	DLR17_RBS0_STR$	17
39	PRODMATQTYEND	Var_ProdMatQtyEnd	Currency	DLR17_RBS0_STR$	17
40	PRODMATFOQTYEND	Var_ProdMatFoQtyEnd	Currency	DLR17_RBS0_STR$	17
41	PRODMATVOQTYEND	Var_ProdMatVoQtyEnd	Currency	DLR17_RBS0_STR$	17
42	PRODLABQTYEND	Var_ProdLabQtyEnd	Currency	DLR17_RBS0_STR$	17
43	PRODLABFOQTYEND	Var_ProdLabFoQtyEnd	Currency	DLR17_RBS0_STR$	17
44	PRODLABVOQTYEND	Var_ProdLabVoQtyEnd	Currency	DLR17_RBS0_STR$	17
45	PRODMACHQTYEND	Var_ProdMachQtyEnd	Currency	DLR17_RBS0_STR$	17
46	PRODMACHFOQTYEND	Var_ProdMachFoQtyEnd	Currency	DLR17_RBS0_STR$	17
47	PRODMACHVOQTYEND	Var_ProdMachVoQtyEnd	Currency	DLR17_RBS0_STR$	17
48	PRODTOTALQTYEND	Var_ProdTotalQtyEnd	Currency	DLR17_RBS0_STR$	17
49	MATWIPIN	Var_MatQtyWipIn	Currency	DLR17_RBS0_STR$	17
50	MATFOWIPIN	Var_MatFoQtyWipIn	Currency	DLR17_RBS0_STR$	17
51	MATVOWIPIN	Var_MatVoQtyWipIn	Currency	DLR17_RBS0_STR$	17
52	LABWIPIN	Var_LabQtyWipIn	Currency	DLR17_RBS0_STR$	17
53	LABFOWIPIN	Var_LabFoQtyWipIn	Currency	DLR17_RBS0_STR$	17
54	LABVOWIPIN	Var_LabVoQtyWipIn	Currency	DLR17_RBS0_STR$	17
55	MACHWIPIN	Var_MachQtyWipIn	Currency	DLR17_RBS0_STR$	17
56	MACHFOWIPIN	Var_MachFoQtyWipIn	Currency	DLR17_RBS0_STR$	17
57	MACHVOWIPIN	Var_MachVoQtyWipIn	Currency	DLR17_RBS0_STR$	17
58	TOTALWIPIN	Var_TotalQtyWipIn	Currency	DLR17_RBS0_STR$	17
59	MATWIPCONSUMED	Var_MatQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
60	MATFOWIPCONSUMED	Var_MatFoQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
61	MATVOWIPCONSUMED	Var_MatVoQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
62	LABWIPCONSUMED	Var_LabQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
63	LABFOWIPCONSUMED	Var_LabFoQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
64	LABVOWIPCONSUMED	Var_LabVoQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
65	MACHWIPCONSUMED	Var_MachQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
66	MACHFOWIPCONSUMED	Var_MachFoQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
67	MACHVOWIPCONSUMED	Var_MachVoQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
68	TOTALWIPCONSUMED	Var_TotalQtyWipConsumed	Currency	DLR17_RBS0_STR$	17
69	STDMATQTYRCDVAR	Var_StdMatQtyRcdVar	Currency	DLR17_RBS0_STR$	17
70	STDMATFOQTYRCDVAR	Var_StdMatFoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
71	STDMATVOQTYRCDVAR	Var_StdMatVoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
72	STDLABQTYRCDVAR	Var_StdLabQtyRcdVar	Currency	DLR17_RBS0_STR$	17
73	STDLABFOQTYRCDVAR	Var_StdLabFoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
74	STDLABVOQTYRCDVAR	Var_StdLabVoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
75	STDMACHQTYRCDVAR	Var_StdMachQtyRcdVar	Currency	DLR17_RBS0_STR$	17
76	STDMACHFOQTYRCDVAR	Var_StdMachFoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
77	STDMACHVOQTYRCDVAR	Var_StdMachVoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
78	STDTOTALQTYRCDVAR	Var_StdTotalQtyRcdVar	Currency	DLR17_RBS0_STR$	17
79	STDMATQTYENDVAR	Var_StdMatQtyEndVar	Currency	DLR17_RBS0_STR$	17
80	STDMATFOQTYENDVAR	Var_StdMatFoQtyEndVar	Currency	DLR17_RBS0_STR$	17
81	STDMATVOQTYENDVAR	Var_StdMatVoQtyEndVar	Currency	DLR17_RBS0_STR$	17
82	STDLABQTYENDVAR	Var_StdLabQtyEndVar	Currency	DLR17_RBS0_STR$	17
83	STDLABFOQTYENDVAR	Var_StdLabFoQtyEndVar	Currency	DLR17_RBS0_STR$	17
84	STDLABVOQTYENDVAR	Var_StdLabVoQtyEndVar	Currency	DLR17_RBS0_STR$	17
85	STDMACHQTYENDVAR	Var_StdMachQtyEndVar	Currency	DLR17_RBS0_STR$	17
86	STDMACHFOQTYENDVAR	Var_StdMachFoQtyEndVar	Currency	DLR17_RBS0_STR$	17
87	STDMACHVOQTYENDVAR	Var_StdMachVoQtyEndVar	Currency	DLR17_RBS0_STR$	17
88	STDTOTALQTYENDVAR	Var_StdTotalQtyEndVar	Currency	DLR17_RBS0_STR$	17
89	STDMATQTYRCDVARPCT	Var_StdMatQtyRcdVarPct	Currency	DLR5_%2	8
90	STDMATFOQTYRCDVARPCT	Var_StdMatFoQtyRcdVarPct	Currency	DLR5_%2	8
91	STDMATVOQTYRCDVARPCT	Var_StdMatVoQtyRcdVarPct	Currency	DLR5_%2	8
92	STDLABQTYRCDVARPCT	Var_StdLabQtyRcdVarPct	Currency	DLR5_%2	8
93	STDLABFOQTYRCDVARPCT	Var_StdLabFoQtyRcdVarPct	Currency	DLR5_%2	8
94	STDLABVOQTYRCDVARPCT	Var_StdLabVoQtyRcdVarPct	Currency	DLR5_%2	8
95	STDMACHQTYRCDVARPCT	Var_StdMachQtyRcdVarPct	Currency	DLR5_%2	8
96	STDMACHFOQTYRCDVARPCT	Var_StdMachFoQtyRcdVarPct	Currency	DLR5_%2	8
97	STDMACHVOQTYRCDVARPCT	Var_StdMachVoQtyRcdVarPct	Currency	DLR5_%2	8
98	STDTOTALQTYRCDVARPCT	Var_StdTotalQtyRcdVarPct	Currency	DLR5_%2	8
99	STDMATQTYENDVARPCT	Var_StdMatQtyEndVarPct	Currency	DLR5_%2	8
100	STDMATFOQTYENDVARPCT	Var_StdMatFoQtyEndVarPct	Currency	DLR5_%2	8
101	STDMATVOQTYENDVARPCT	Var_StdMatVoQtyEndVarPct	Currency	DLR5_%2	8
102	STDLABQTYENDVARPCT	Var_StdLabQtyEndVarPct	Currency	DLR5_%2	8
103	STDLABFOQTYENDVARPCT	Var_StdLabFoQtyEndVarPct	Currency	DLR5_%2	8
104	STDLABVOQTYENDVARPCT	Var_StdLabVoQtyEndVarPct	Currency	DLR5_%2	8
105	STDMACHQTYENDVARPCT	Var_StdMachQtyEndVarPct	Currency	DLR5_%2	8
106	STDMACHFOQTYENDVARPCT	Var_StdMachFoQtyEndVarPct	Currency	DLR5_%2	8
107	STDMACHVOQTYENDVARPCT	Var_StdMachVoQtyEndVarPct	Currency	DLR5_%2	8
108	STDTOTALQTYENDVARPCT	Var_StdTotalQtyEndVarPct	Currency	DLR5_%2	8
109	PRODMATQTYRCDVAR	Var_ProdMatQtyRcdVar	Currency	DLR17_RBS0_STR$	17
110	PRODMATFOQTYRCDVAR	Var_ProdMatFoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
111	PRODMATVOQTYRCDVAR	Var_ProdMatVoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
112	PRODLABQTYRCDVAR	Var_ProdLabQtyRcdVar	Currency	DLR17_RBS0_STR$	17
113	PRODLABFOQTYRCDVAR	Var_ProdLabFoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
114	PRODLABVOQTYRCDVAR	Var_ProdLabVoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
115	PRODMACHQTYRCDVAR	Var_ProdMachQtyRcdVar	Currency	DLR17_RBS0_STR$	17
116	PRODMACHFOQTYRCDVAR	Var_ProdMachFoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
117	PRODMACHVOQTYRCDVAR	Var_ProdMachVoQtyRcdVar	Currency	DLR17_RBS0_STR$	17
118	PRODTOTALQTYRCDVAR	Var_ProdTotalQtyRcdVar	Currency	DLR17_RBS0_STR$	17
119	PRODMATQTYENDVAR	Var_ProdMatQtyEndVar	Currency	DLR17_RBS0_STR$	17
120	PRODMATFOQTYENDVAR	Var_ProdMatFoQtyEndVar	Currency	DLR17_RBS0_STR$	17
121	PRODMATVOQTYENDVAR	Var_ProdMatVoQtyEndVar	Currency	DLR17_RBS0_STR$	17
122	PRODLABQTYENDVAR	Var_ProdLabQtyEndVar	Currency	DLR17_RBS0_STR$	17
123	PRODLABFOQTYENDVAR	Var_ProdLabFoQtyEndVar	Currency	DLR17_RBS0_STR$	17
124	PRODLABVOQTYENDVAR	Var_ProdLabVoQtyEndVar	Currency	DLR17_RBS0_STR$	17
125	PRODMACHQTYENDVAR	Var_ProdMachQtyEndVar	Currency	DLR17_RBS0_STR$	17
126	PRODMACHFOQTYENDVAR	Var_ProdMachFoQtyEndVar	Currency	DLR17_RBS0_STR$	17
127	PRODMACHVOQTYENDVAR	Var_ProdMachVoQtyEndVar	Currency	DLR17_RBS0_STR$	17
128	PRODTOTALQTYENDVAR	Var_ProdTotalQtyEndVar	Currency	DLR17_RBS0_STR$	17
129	PRODMATQTYRCDVARPCT	Var_ProdMatQtyRcdVarPct	Currency	DLR5_%2	8
130	PRODMATFOQTYRCDVARPCT	Var_ProdMatFoQtyRcdVarPct	Currency	DLR5_%2	8
131	PRODMATVOQTYRCDVARPCT	Var_ProdMatVoQtyRcdVarPct	Currency	DLR5_%2	8
132	PRODLABQTYRCDVARPCT	Var_ProdLabQtyRcdVarPct	Currency	DLR5_%2	8
133	PRODLABFOQTYRCDVARPCT	Var_ProdLabFoQtyRcdVarPct	Currency	DLR5_%2	8
134	PRODLABVOQTYRCDVARPCT	Var_ProdLabVoQtyRcdVarPct	Currency	DLR5_%2	8
135	PRODMACHQTYRCDVARPCT	Var_ProdMachQtyRcdVarPct	Currency	DLR5_%2	8
136	PRODMACHFOQTYRCDVARPCT	Var_ProdMachFoQtyRcdVarPct	Currency	DLR5_%2	8
137	PRODMACHVOQTYRCDVARPCT	Var_ProdMachVoQtyRcdVarPct	Currency	DLR5_%2	8
138	PRODTOTALQTYRCDVARPCT	Var_ProdTotalQtyRcdVarPct	Currency	DLR5_%2	8
139	PRODMATQTYENDVARPCT	Var_ProdMatQtyEndVarPct	Currency	DLR5_%2	8
140	PRODMATFOQTYENDVARPCT	Var_ProdMatFoQtyEndVarPct	Currency	DLR5_%2	8
141	PRODMATVOQTYENDVARPCT	Var_ProdMatVoQtyEndVarPct	Currency	DLR5_%2	8
142	PRODLABQTYENDVARPCT	Var_ProdLabQtyEndVarPct	Currency	DLR5_%2	8
143	PRODLABFOQTYENDVARPCT	Var_ProdLabFoQtyEndVarPct	Currency	DLR5_%2	8
144	PRODLABVOQTYENDVARPCT	Var_ProdLabVoQtyEndVarPct	Currency	DLR5_%2	8
145	PRODMACHQTYENDVARPCT	Var_ProdMachQtyEndVarPct	Currency	DLR5_%2	8
146	PRODMACHFOQTYENDVARPCT	Var_ProdMachFoQtyEndVarPct	Currency	DLR5_%2	8
147	PRODMACHVOQTYENDVARPCT	Var_ProdMachVoQtyEndVarPct	Currency	DLR5_%2	8
148	PRODTOTALQTYENDVARPCT	Var_ProdTotalQtyEndVarPct	Currency	DLR5_%2	8
149	PRODTOTALQTYENDVARPCT2	Var_ProdTotalQtyEndVarPct2	Currency	DLR5_%2	8
150	MATVARPCT	Var_MatQtyVarPct	Currency	DLR5_%2	8
151	MATFOVARPCT	Var_MatFoQtyVarPct	Currency	DLR5_%2	8
152	MATVOVARPCT	Var_MatVoQtyVarPct	Currency	DLR5_%2	8
153	LABVARPCT	Var_LabQtyVarPct	Currency	DLR5_%2	8
154	LABFOVARPCT	Var_LabFoQtyVarPct	Currency	DLR5_%2	8
155	LABVOVARPCT	Var_LabVoQtyVarPct	Currency	DLR5_%2	8
156	MACHVARPCT	Var_MachQtyVarPct	Currency	DLR5_%2	8
157	MACHFOVARPCT	Var_MachFoQtyVarPct	Currency	DLR5_%2	8
158	MACHVOVARPCT	Var_MachVoQtyVarPct	Currency	DLR5_%2	8
159	TOTALVARPCT	Var_TotalQtyVarPct	Currency	DLR5_%2	8

azurecurve Products Manufacturing (346)3rd PartyMOP Variances (MOP3000)

Click to show/hide

Leave a Reply Cancel reply