Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1004
Product: Manufacturing (346)
Series:
Display Name: MOP_MO_Variance_Material_Hist
Physical Name: MOP1004
Technical Name: MOP_MO_Variance_Material_HistSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MANUFACTUREORDER_I 
Manufacture Order String STR30_UC 30 2 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['MOP_MO_Variance_Material_Hist'].ITEMNMBR AS 'MOP_MO_Variance_Material_Hist-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOP1004 AS ['MOP_MO_Variance_Material_Hist']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MOP_MO_Variance_Material_Hist'].ITEMNMBR = ['Item Master'].ITEMNMBR3 ITEMDESC Item Description String STR100 100 4 MRPAMOUNT_I MRP_Amount Currency DLR_14_MRP 14 5 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 6 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 7 MRPAMOUNT2_I MRP_Amount2 Currency DLR_14_MRP 14 8 ORIGQTYALLOW Original QTY Allowed Currency DLR_14_MRP 14 9 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 10 QTY_ISSUED_I QTY Issued Currency DLR17_QTY_RBS0_UTR 17 11 QTYCONSUMED QTY Consumed Currency DLR17_QTY_RBS0_UTR 17 12 VARPRODMOCOSTS_1 varProdMOCosts[1] Currency DLR17_QTY_RBS0_STR 17 13 VARPRODMOCOSTS varProdMOCosts DLR17_QTY_RBS0_STR Currency 17 14 VARPRODRECDCOSTS varProdRecdCosts DLR17_QTY_RBS0_STR Currency 17 15 VARPRODMOCOSTS_2 varProdMOCosts[2] Currency DLR17_QTY_RBS0_STR 17 16 VARPRODMOCOSTS_3 varProdMOCosts[3] Currency DLR17_QTY_RBS0_STR 17 17 VARCOSTSCLLCTD varCostCollected DLR17_QTY_RBS0_STR Currency 17 18 VARCOSTSUSED varCostsUsed DLR17_QTY_RBS0_STR Currency 17 19 VARPRODMOCOSTS_4 varProdMOCosts[4] Currency DLR17_QTY_RBS0_STR 17 20 VARSTDCOSTS1 varStandCosts1 DLR17_QTY_RBS0_STR Currency 17 21 VARPRODMOCOSTS_5 varProdMOCosts[5] Currency DLR17_QTY_RBS0_STR 17 22 VARPRODMOCOSTS_6 varProdMOCosts[6] Currency DLR17_QTY_RBS0_STR 17 23 VARSTDCOSTS2 varStandCosts2 DLR17_QTY_RBS0_STR Currency 17 24 VARPRODMOCOSTS_7 varProdMOCosts[7] Currency DLR17_QTY_RBS0_STR 17 25 VARPRODMOCOSTS_8 varProdMOCosts[8] Currency DLR17_QTY_RBS0_STR 17 26 VARPRODMOCOSTS_9 varProdMOCosts[9] Currency DLR17_QTY_RBS0_STR 17 27 VARPRODMOCOSTS_10 varProdMOCosts[10] Currency DLR17_QTY_RBS0_STR 17 28 VARPRODMOCOSTS_11 varProdMOCosts[11] Currency DLR17_QTY_RBS0_STR 17 29 VARPRODMOCOSTS_12 varProdMOCosts[12] Currency DLR17_QTY_RBS0_STR 17 30 VARPRODMOCOSTS_13 varProdMOCosts[13] Currency DLR17_QTY_RBS0_STR 17 31 VARPRODRECDCOSTS_1 varProdRecdCosts[1] Currency DLR17_QTY_RBS0_STR 17 32 VARPRODRECDCOSTS_2 varProdRecdCosts[2] Currency DLR17_QTY_RBS0_STR 17 33 VARPRODRECDCOSTS_3 varProdRecdCosts[3] Currency DLR17_QTY_RBS0_STR 17 34 VARPRODRECDCOSTS_4 varProdRecdCosts[4] Currency DLR17_QTY_RBS0_STR 17 35 VARPRODRECDCOSTS_5 varProdRecdCosts[5] Currency DLR17_QTY_RBS0_STR 17 36 VARPRODRECDCOSTS_6 varProdRecdCosts[6] Currency DLR17_QTY_RBS0_STR 17 37 VARPRODRECDCOSTS_7 varProdRecdCosts[7] Currency DLR17_QTY_RBS0_STR 17 38 VARPRODRECDCOSTS_8 varProdRecdCosts[8] Currency DLR17_QTY_RBS0_STR 17 39 VARPRODRECDCOSTS_9 varProdRecdCosts[9] Currency DLR17_QTY_RBS0_STR 17 40 VARPRODRECDCOSTS_10 varProdRecdCosts[10] Currency DLR17_QTY_RBS0_STR 17 41 VARPRODRECDCOSTS_11 varProdRecdCosts[11] Currency DLR17_QTY_RBS0_STR 17 42 VARPRODRECDCOSTS_12 varProdRecdCosts[12] Currency DLR17_QTY_RBS0_STR 17 43 VARPRODRECDCOSTS_13 varProdRecdCosts[13] Currency DLR17_QTY_RBS0_STR 17 44 VARCOSTSCLLCTD_1 varCostCollected[1] Currency DLR17_QTY_RBS0_STR 17 45 VARCOSTSCLLCTD_2 varCostCollected[2] Currency DLR17_QTY_RBS0_STR 17 46 VARCOSTSCLLCTD_3 varCostCollected[3] Currency DLR17_QTY_RBS0_STR 17 47 VARCOSTSCLLCTD_4 varCostCollected[4] Currency DLR17_QTY_RBS0_STR 17 48 VARCOSTSCLLCTD_5 varCostCollected[5] Currency DLR17_QTY_RBS0_STR 17 49 VARCOSTSCLLCTD_6 varCostCollected[6] Currency DLR17_QTY_RBS0_STR 17 50 VARCOSTSCLLCTD_7 varCostCollected[7] Currency DLR17_QTY_RBS0_STR 17 51 VARCOSTSCLLCTD_8 varCostCollected[8] Currency DLR17_QTY_RBS0_STR 17 52 VARCOSTSCLLCTD_9 varCostCollected[9] Currency DLR17_QTY_RBS0_STR 17 53 VARCOSTSCLLCTD_10 varCostCollected[10] Currency DLR17_QTY_RBS0_STR 17 54 VARCOSTSCLLCTD_11 varCostCollected[11] Currency DLR17_QTY_RBS0_STR 17 55 VARCOSTSCLLCTD_12 varCostCollected[12] Currency DLR17_QTY_RBS0_STR 17 56 VARCOSTSCLLCTD_13 varCostCollected[13] Currency DLR17_QTY_RBS0_STR 17 57 VARCOSTSUSED_1 varCostsUsed[1] Currency DLR17_QTY_RBS0_STR 17 58 VARCOSTSUSED_2 varCostsUsed[2] Currency DLR17_QTY_RBS0_STR 17 59 VARCOSTSUSED_3 varCostsUsed[3] Currency DLR17_QTY_RBS0_STR 17 60 VARCOSTSUSED_4 varCostsUsed[4] Currency DLR17_QTY_RBS0_STR 17 61 VARCOSTSUSED_5 varCostsUsed[5] Currency DLR17_QTY_RBS0_STR 17 62 VARCOSTSUSED_6 varCostsUsed[6] Currency DLR17_QTY_RBS0_STR 17 63 VARCOSTSUSED_7 varCostsUsed[7] Currency DLR17_QTY_RBS0_STR 17 64 VARCOSTSUSED_8 varCostsUsed[8] Currency DLR17_QTY_RBS0_STR 17 65 VARCOSTSUSED_9 varCostsUsed[9] Currency DLR17_QTY_RBS0_STR 17 66 VARCOSTSUSED_10 varCostsUsed[10] Currency DLR17_QTY_RBS0_STR 17 67 VARCOSTSUSED_11 varCostsUsed[11] Currency DLR17_QTY_RBS0_STR 17 68 VARCOSTSUSED_12 varCostsUsed[12] Currency DLR17_QTY_RBS0_STR 17 69 VARCOSTSUSED_13 varCostsUsed[13] Currency DLR17_QTY_RBS0_STR 17 70 VARSTDCOSTS1_1 varStandCosts1[1] Currency DLR17_QTY_RBS0_STR 17 71 VARSTDCOSTS1_2 varStandCosts1[2] Currency DLR17_QTY_RBS0_STR 17 72 VARSTDCOSTS1_3 varStandCosts1[3] Currency DLR17_QTY_RBS0_STR 17 73 VARSTDCOSTS1_4 varStandCosts1[4] Currency DLR17_QTY_RBS0_STR 17 74 VARSTDCOSTS1_5 varStandCosts1[5] Currency DLR17_QTY_RBS0_STR 17 75 VARSTDCOSTS1_6 varStandCosts1[6] Currency DLR17_QTY_RBS0_STR 17 76 VARSTDCOSTS1_7 varStandCosts1[7] Currency DLR17_QTY_RBS0_STR 17 77 VARSTDCOSTS1_8 varStandCosts1[8] Currency DLR17_QTY_RBS0_STR 17 78 VARSTDCOSTS1_9 varStandCosts1[9] Currency DLR17_QTY_RBS0_STR 17 79 VARSTDCOSTS1_10 varStandCosts1[10] Currency DLR17_QTY_RBS0_STR 17 80 VARSTDCOSTS1_11 varStandCosts1[11] Currency DLR17_QTY_RBS0_STR 17 81 VARSTDCOSTS1_12 varStandCosts1[12] Currency DLR17_QTY_RBS0_STR 17 82 VARSTDCOSTS1_13 varStandCosts1[13] Currency DLR17_QTY_RBS0_STR 17 83 VARSTDCOSTS2_1 varStandCosts2[1] Currency DLR17_QTY_RBS0_STR 17 84 VARSTDCOSTS2_2 varStandCosts2[2] Currency DLR17_QTY_RBS0_STR 17 85 VARSTDCOSTS2_3 varStandCosts2[3] Currency DLR17_QTY_RBS0_STR 17 86 VARSTDCOSTS2_4 varStandCosts2[4] Currency DLR17_QTY_RBS0_STR 17 87 VARSTDCOSTS2_5 varStandCosts2[5] Currency DLR17_QTY_RBS0_STR 17 88 VARSTDCOSTS2_6 varStandCosts2[6] Currency DLR17_QTY_RBS0_STR 17 89 VARSTDCOSTS2_7 varStandCosts2[7] Currency DLR17_QTY_RBS0_STR 17 90 VARSTDCOSTS2_8 varStandCosts2[8] Currency DLR17_QTY_RBS0_STR 17 91 VARSTDCOSTS2_9 varStandCosts2[9] Currency DLR17_QTY_RBS0_STR 17 92 VARSTDCOSTS2_10 varStandCosts2[10] Currency DLR17_QTY_RBS0_STR 17 93 VARSTDCOSTS2_11 varStandCosts2[11] Currency DLR17_QTY_RBS0_STR 17 94 VARSTDCOSTS2_12 varStandCosts2[12] Currency DLR17_QTY_RBS0_STR 17 95 VARSTDCOSTS2_13 varStandCosts2[13] Currency DLR17_QTY_RBS0_STR 17