MOP Variances (MOP3000)

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

Product: Manufacturing (346)
Series:

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
2MANUFACTUREORDERST_I SearchManufacture Order StatusIntegerDDL_WO_Status0
3ENDQTY_I SearchEnd QTYCurrencyDLR_14_MRP14
4QTYRECVD SearchQTY ReceivedCurrencyDLR17_QTY_RBS0_UTR17
5ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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
6VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
7DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
8DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
9STDMATQTYRCD SearchVar_StdMatQtyRcdCurrencyDLR17_RBS0_STR$17
10STDMATFOQTYRCD SearchVar_StdMatFoQtyRcdCurrencyDLR17_RBS0_STR$17
11STDMATVOQTYRCD SearchVar_StdMatVoQtyRcdCurrencyDLR17_RBS0_STR$17
12STDLABQTYRCD SearchVar_StdLabQtyRcdCurrencyDLR17_RBS0_STR$17
13STDLABFOQTYRCD SearchVar_StdLabFoQtyRcdCurrencyDLR17_RBS0_STR$17
14STDLABVOQTYRCD SearchVar_StdLabVoQtyRcdCurrencyDLR17_RBS0_STR$17
15STDMACHQTYRCD SearchVar_StdMachQtyRcdCurrencyDLR17_RBS0_STR$17
16STDMACHFOQTYRCD SearchVar_StdMachFoQtyRcdCurrencyDLR17_RBS0_STR$17
17STDMACHVOQTYRCD SearchVar_StdMachVoQtyRcdCurrencyDLR17_RBS0_STR$17
18STDTOTALQTYRCD SearchVar_StdTotalQtyRcdCurrencyDLR17_RBS0_STR$17
19STDMATQTYEND SearchVar_StdMatQtyEndCurrencyDLR17_RBS0_STR$17
20STDMATFOQTYEND SearchVar_StdMatFoQtyEndCurrencyDLR17_RBS0_STR$17
21STDMATVOQTYEND SearchVar_StdMatVoQtyEndCurrencyDLR17_RBS0_STR$17
22STDLABQTYEND SearchVar_StdLabQtyEndCurrencyDLR17_RBS0_STR$17
23STDLABFOQTYEND SearchVar_StdLabFoQtyEndCurrencyDLR17_RBS0_STR$17
24STDLABVOQTYEND SearchVar_StdLabVoQtyEndCurrencyDLR17_RBS0_STR$17
25STDMACHQTYEND SearchVar_StdMachQtyEndCurrencyDLR17_RBS0_STR$17
26STDMACHFOQTYEND SearchVar_StdMachFoQtyEndCurrencyDLR17_RBS0_STR$17
27STDMACHVOQTYEND SearchVar_StdMachVoQtyEndCurrencyDLR17_RBS0_STR$17
28STDTOTALQTYEND SearchVar_StdTotalQtyEndCurrencyDLR17_RBS0_STR$17
29PRODMATQTYRCD SearchVar_ProdMatQtyRcdCurrencyDLR17_RBS0_STR$17
30PRODMATFOQTYRCD SearchVar_ProdMatFoQtyRcdCurrencyDLR17_RBS0_STR$17
31PRODMATVOQTYRCD SearchVar_ProdMatVoQtyRcdCurrencyDLR17_RBS0_STR$17
32PRODLABQTYRCD SearchVar_ProdLabQtyRcdCurrencyDLR17_RBS0_STR$17
33PRODLABFOQTYRCD SearchVar_ProdLabFoQtyRcdCurrencyDLR17_RBS0_STR$17
34PRODLABVOQTYRCD SearchVar_ProdLabVoQtyRcdCurrencyDLR17_RBS0_STR$17
35PRODMACHQTYRCD SearchVar_ProdMachQtyRcdCurrencyDLR17_RBS0_STR$17
36PRODMACHFOQTYRCD SearchVar_ProdMachFoQtyRcdCurrencyDLR17_RBS0_STR$17
37PRODMACHVOQTYRCD SearchVar_ProdMachVoQtyRcdCurrencyDLR17_RBS0_STR$17
38PRODTOTALQTYRCD SearchVar_ProdTotalQtyRcdCurrencyDLR17_RBS0_STR$17
39PRODMATQTYEND SearchVar_ProdMatQtyEndCurrencyDLR17_RBS0_STR$17
40PRODMATFOQTYEND SearchVar_ProdMatFoQtyEndCurrencyDLR17_RBS0_STR$17
41PRODMATVOQTYEND SearchVar_ProdMatVoQtyEndCurrencyDLR17_RBS0_STR$17
42PRODLABQTYEND SearchVar_ProdLabQtyEndCurrencyDLR17_RBS0_STR$17
43PRODLABFOQTYEND SearchVar_ProdLabFoQtyEndCurrencyDLR17_RBS0_STR$17
44PRODLABVOQTYEND SearchVar_ProdLabVoQtyEndCurrencyDLR17_RBS0_STR$17
45PRODMACHQTYEND SearchVar_ProdMachQtyEndCurrencyDLR17_RBS0_STR$17
46PRODMACHFOQTYEND SearchVar_ProdMachFoQtyEndCurrencyDLR17_RBS0_STR$17
47PRODMACHVOQTYEND SearchVar_ProdMachVoQtyEndCurrencyDLR17_RBS0_STR$17
48PRODTOTALQTYEND SearchVar_ProdTotalQtyEndCurrencyDLR17_RBS0_STR$17
49MATWIPIN SearchVar_MatQtyWipInCurrencyDLR17_RBS0_STR$17
50MATFOWIPIN SearchVar_MatFoQtyWipInCurrencyDLR17_RBS0_STR$17
51MATVOWIPIN SearchVar_MatVoQtyWipInCurrencyDLR17_RBS0_STR$17
52LABWIPIN SearchVar_LabQtyWipInCurrencyDLR17_RBS0_STR$17
53LABFOWIPIN SearchVar_LabFoQtyWipInCurrencyDLR17_RBS0_STR$17
54LABVOWIPIN SearchVar_LabVoQtyWipInCurrencyDLR17_RBS0_STR$17
55MACHWIPIN SearchVar_MachQtyWipInCurrencyDLR17_RBS0_STR$17
56MACHFOWIPIN SearchVar_MachFoQtyWipInCurrencyDLR17_RBS0_STR$17
57MACHVOWIPIN SearchVar_MachVoQtyWipInCurrencyDLR17_RBS0_STR$17
58TOTALWIPIN SearchVar_TotalQtyWipInCurrencyDLR17_RBS0_STR$17
59MATWIPCONSUMED SearchVar_MatQtyWipConsumedCurrencyDLR17_RBS0_STR$17
60MATFOWIPCONSUMED SearchVar_MatFoQtyWipConsumedCurrencyDLR17_RBS0_STR$17
61MATVOWIPCONSUMED SearchVar_MatVoQtyWipConsumedCurrencyDLR17_RBS0_STR$17
62LABWIPCONSUMED SearchVar_LabQtyWipConsumedCurrencyDLR17_RBS0_STR$17
63LABFOWIPCONSUMED SearchVar_LabFoQtyWipConsumedCurrencyDLR17_RBS0_STR$17
64LABVOWIPCONSUMED SearchVar_LabVoQtyWipConsumedCurrencyDLR17_RBS0_STR$17
65MACHWIPCONSUMED SearchVar_MachQtyWipConsumedCurrencyDLR17_RBS0_STR$17
66MACHFOWIPCONSUMED SearchVar_MachFoQtyWipConsumedCurrencyDLR17_RBS0_STR$17
67MACHVOWIPCONSUMED SearchVar_MachVoQtyWipConsumedCurrencyDLR17_RBS0_STR$17
68TOTALWIPCONSUMED SearchVar_TotalQtyWipConsumedCurrencyDLR17_RBS0_STR$17
69STDMATQTYRCDVAR SearchVar_StdMatQtyRcdVarCurrencyDLR17_RBS0_STR$17
70STDMATFOQTYRCDVAR SearchVar_StdMatFoQtyRcdVarCurrencyDLR17_RBS0_STR$17
71STDMATVOQTYRCDVAR SearchVar_StdMatVoQtyRcdVarCurrencyDLR17_RBS0_STR$17
72STDLABQTYRCDVAR SearchVar_StdLabQtyRcdVarCurrencyDLR17_RBS0_STR$17
73STDLABFOQTYRCDVAR SearchVar_StdLabFoQtyRcdVarCurrencyDLR17_RBS0_STR$17
74STDLABVOQTYRCDVAR SearchVar_StdLabVoQtyRcdVarCurrencyDLR17_RBS0_STR$17
75STDMACHQTYRCDVAR SearchVar_StdMachQtyRcdVarCurrencyDLR17_RBS0_STR$17
76STDMACHFOQTYRCDVAR SearchVar_StdMachFoQtyRcdVarCurrencyDLR17_RBS0_STR$17
77STDMACHVOQTYRCDVAR SearchVar_StdMachVoQtyRcdVarCurrencyDLR17_RBS0_STR$17
78STDTOTALQTYRCDVAR SearchVar_StdTotalQtyRcdVarCurrencyDLR17_RBS0_STR$17
79STDMATQTYENDVAR SearchVar_StdMatQtyEndVarCurrencyDLR17_RBS0_STR$17
80STDMATFOQTYENDVAR SearchVar_StdMatFoQtyEndVarCurrencyDLR17_RBS0_STR$17
81STDMATVOQTYENDVAR SearchVar_StdMatVoQtyEndVarCurrencyDLR17_RBS0_STR$17
82STDLABQTYENDVAR SearchVar_StdLabQtyEndVarCurrencyDLR17_RBS0_STR$17
83STDLABFOQTYENDVAR SearchVar_StdLabFoQtyEndVarCurrencyDLR17_RBS0_STR$17
84STDLABVOQTYENDVAR SearchVar_StdLabVoQtyEndVarCurrencyDLR17_RBS0_STR$17
85STDMACHQTYENDVAR SearchVar_StdMachQtyEndVarCurrencyDLR17_RBS0_STR$17
86STDMACHFOQTYENDVAR SearchVar_StdMachFoQtyEndVarCurrencyDLR17_RBS0_STR$17
87STDMACHVOQTYENDVAR SearchVar_StdMachVoQtyEndVarCurrencyDLR17_RBS0_STR$17
88STDTOTALQTYENDVAR SearchVar_StdTotalQtyEndVarCurrencyDLR17_RBS0_STR$17
89STDMATQTYRCDVARPCT SearchVar_StdMatQtyRcdVarPctCurrencyDLR5_%28
90STDMATFOQTYRCDVARPCT SearchVar_StdMatFoQtyRcdVarPctCurrencyDLR5_%28
91STDMATVOQTYRCDVARPCT SearchVar_StdMatVoQtyRcdVarPctCurrencyDLR5_%28
92STDLABQTYRCDVARPCT SearchVar_StdLabQtyRcdVarPctCurrencyDLR5_%28
93STDLABFOQTYRCDVARPCT SearchVar_StdLabFoQtyRcdVarPctCurrencyDLR5_%28
94STDLABVOQTYRCDVARPCT SearchVar_StdLabVoQtyRcdVarPctCurrencyDLR5_%28
95STDMACHQTYRCDVARPCT SearchVar_StdMachQtyRcdVarPctCurrencyDLR5_%28
96STDMACHFOQTYRCDVARPCT SearchVar_StdMachFoQtyRcdVarPctCurrencyDLR5_%28
97STDMACHVOQTYRCDVARPCT SearchVar_StdMachVoQtyRcdVarPctCurrencyDLR5_%28
98STDTOTALQTYRCDVARPCT SearchVar_StdTotalQtyRcdVarPctCurrencyDLR5_%28
99STDMATQTYENDVARPCT SearchVar_StdMatQtyEndVarPctCurrencyDLR5_%28
100STDMATFOQTYENDVARPCT SearchVar_StdMatFoQtyEndVarPctCurrencyDLR5_%28
101STDMATVOQTYENDVARPCT SearchVar_StdMatVoQtyEndVarPctCurrencyDLR5_%28
102STDLABQTYENDVARPCT SearchVar_StdLabQtyEndVarPctCurrencyDLR5_%28
103STDLABFOQTYENDVARPCT SearchVar_StdLabFoQtyEndVarPctCurrencyDLR5_%28
104STDLABVOQTYENDVARPCT SearchVar_StdLabVoQtyEndVarPctCurrencyDLR5_%28
105STDMACHQTYENDVARPCT SearchVar_StdMachQtyEndVarPctCurrencyDLR5_%28
106STDMACHFOQTYENDVARPCT SearchVar_StdMachFoQtyEndVarPctCurrencyDLR5_%28
107STDMACHVOQTYENDVARPCT SearchVar_StdMachVoQtyEndVarPctCurrencyDLR5_%28
108STDTOTALQTYENDVARPCT SearchVar_StdTotalQtyEndVarPctCurrencyDLR5_%28
109PRODMATQTYRCDVAR SearchVar_ProdMatQtyRcdVarCurrencyDLR17_RBS0_STR$17
110PRODMATFOQTYRCDVAR SearchVar_ProdMatFoQtyRcdVarCurrencyDLR17_RBS0_STR$17
111PRODMATVOQTYRCDVAR SearchVar_ProdMatVoQtyRcdVarCurrencyDLR17_RBS0_STR$17
112PRODLABQTYRCDVAR SearchVar_ProdLabQtyRcdVarCurrencyDLR17_RBS0_STR$17
113PRODLABFOQTYRCDVAR SearchVar_ProdLabFoQtyRcdVarCurrencyDLR17_RBS0_STR$17
114PRODLABVOQTYRCDVAR SearchVar_ProdLabVoQtyRcdVarCurrencyDLR17_RBS0_STR$17
115PRODMACHQTYRCDVAR SearchVar_ProdMachQtyRcdVarCurrencyDLR17_RBS0_STR$17
116PRODMACHFOQTYRCDVAR SearchVar_ProdMachFoQtyRcdVarCurrencyDLR17_RBS0_STR$17
117PRODMACHVOQTYRCDVAR SearchVar_ProdMachVoQtyRcdVarCurrencyDLR17_RBS0_STR$17
118PRODTOTALQTYRCDVAR SearchVar_ProdTotalQtyRcdVarCurrencyDLR17_RBS0_STR$17
119PRODMATQTYENDVAR SearchVar_ProdMatQtyEndVarCurrencyDLR17_RBS0_STR$17
120PRODMATFOQTYENDVAR SearchVar_ProdMatFoQtyEndVarCurrencyDLR17_RBS0_STR$17
121PRODMATVOQTYENDVAR SearchVar_ProdMatVoQtyEndVarCurrencyDLR17_RBS0_STR$17
122PRODLABQTYENDVAR SearchVar_ProdLabQtyEndVarCurrencyDLR17_RBS0_STR$17
123PRODLABFOQTYENDVAR SearchVar_ProdLabFoQtyEndVarCurrencyDLR17_RBS0_STR$17
124PRODLABVOQTYENDVAR SearchVar_ProdLabVoQtyEndVarCurrencyDLR17_RBS0_STR$17
125PRODMACHQTYENDVAR SearchVar_ProdMachQtyEndVarCurrencyDLR17_RBS0_STR$17
126PRODMACHFOQTYENDVAR SearchVar_ProdMachFoQtyEndVarCurrencyDLR17_RBS0_STR$17
127PRODMACHVOQTYENDVAR SearchVar_ProdMachVoQtyEndVarCurrencyDLR17_RBS0_STR$17
128PRODTOTALQTYENDVAR SearchVar_ProdTotalQtyEndVarCurrencyDLR17_RBS0_STR$17
129PRODMATQTYRCDVARPCT SearchVar_ProdMatQtyRcdVarPctCurrencyDLR5_%28
130PRODMATFOQTYRCDVARPCT SearchVar_ProdMatFoQtyRcdVarPctCurrencyDLR5_%28
131PRODMATVOQTYRCDVARPCT SearchVar_ProdMatVoQtyRcdVarPctCurrencyDLR5_%28
132PRODLABQTYRCDVARPCT SearchVar_ProdLabQtyRcdVarPctCurrencyDLR5_%28
133PRODLABFOQTYRCDVARPCT SearchVar_ProdLabFoQtyRcdVarPctCurrencyDLR5_%28
134PRODLABVOQTYRCDVARPCT SearchVar_ProdLabVoQtyRcdVarPctCurrencyDLR5_%28
135PRODMACHQTYRCDVARPCT SearchVar_ProdMachQtyRcdVarPctCurrencyDLR5_%28
136PRODMACHFOQTYRCDVARPCT SearchVar_ProdMachFoQtyRcdVarPctCurrencyDLR5_%28
137PRODMACHVOQTYRCDVARPCT SearchVar_ProdMachVoQtyRcdVarPctCurrencyDLR5_%28
138PRODTOTALQTYRCDVARPCT SearchVar_ProdTotalQtyRcdVarPctCurrencyDLR5_%28
139PRODMATQTYENDVARPCT SearchVar_ProdMatQtyEndVarPctCurrencyDLR5_%28
140PRODMATFOQTYENDVARPCT SearchVar_ProdMatFoQtyEndVarPctCurrencyDLR5_%28
141PRODMATVOQTYENDVARPCT SearchVar_ProdMatVoQtyEndVarPctCurrencyDLR5_%28
142PRODLABQTYENDVARPCT SearchVar_ProdLabQtyEndVarPctCurrencyDLR5_%28
143PRODLABFOQTYENDVARPCT SearchVar_ProdLabFoQtyEndVarPctCurrencyDLR5_%28
144PRODLABVOQTYENDVARPCT SearchVar_ProdLabVoQtyEndVarPctCurrencyDLR5_%28
145PRODMACHQTYENDVARPCT SearchVar_ProdMachQtyEndVarPctCurrencyDLR5_%28
146PRODMACHFOQTYENDVARPCT SearchVar_ProdMachFoQtyEndVarPctCurrencyDLR5_%28
147PRODMACHVOQTYENDVARPCT SearchVar_ProdMachVoQtyEndVarPctCurrencyDLR5_%28
148PRODTOTALQTYENDVARPCT SearchVar_ProdTotalQtyEndVarPctCurrencyDLR5_%28
149PRODTOTALQTYENDVARPCT2 SearchVar_ProdTotalQtyEndVarPct2CurrencyDLR5_%28
150MATVARPCT SearchVar_MatQtyVarPctCurrencyDLR5_%28
151MATFOVARPCT SearchVar_MatFoQtyVarPctCurrencyDLR5_%28
152MATVOVARPCT SearchVar_MatVoQtyVarPctCurrencyDLR5_%28
153LABVARPCT SearchVar_LabQtyVarPctCurrencyDLR5_%28
154LABFOVARPCT SearchVar_LabFoQtyVarPctCurrencyDLR5_%28
155LABVOVARPCT SearchVar_LabVoQtyVarPctCurrencyDLR5_%28
156MACHVARPCT SearchVar_MachQtyVarPctCurrencyDLR5_%28
157MACHFOVARPCT SearchVar_MachFoQtyVarPctCurrencyDLR5_%28
158MACHVOVARPCT SearchVar_MachVoQtyVarPctCurrencyDLR5_%28
159TOTALVARPCT SearchVar_TotalQtyVarPctCurrencyDLR5_%28

Leave a Reply

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