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_VariancesSeq 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