Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1012
Product: Manufacturing (346)
Series:
Display Name: MOP_MO_Variance_Material_Hist_STD
Physical Name: MOP1012
Technical Name: MOP_MO_Variance_Material_Hist_STDSeq 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_STD'].ITEMNMBR AS 'MOP_MO_Variance_Material_Hist_STD-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOP1012 AS ['MOP_MO_Variance_Material_Hist_STD']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MOP_MO_Variance_Material_Hist_STD'].ITEMNMBR = ['Item Master'].ITEMNMBR
3 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 VARSTDCOSTS1 varStandCosts1 DLR17_QTY_RBS0_STR Currency 17 9 VARSTDCOSTS1_1 varStandCosts1[1] Currency DLR17_QTY_RBS0_STR 17 10 VARSTDCOSTS2 varStandCosts2 DLR17_QTY_RBS0_STR Currency 17 11 VARSTDCOSTS1_2 varStandCosts1[2] Currency DLR17_QTY_RBS0_STR 17 12 VARSTDCOSTS1_3 varStandCosts1[3] Currency DLR17_QTY_RBS0_STR 17 13 VARSTDCOSTS1_4 varStandCosts1[4] Currency DLR17_QTY_RBS0_STR 17 14 VARSTDCOSTS1_5 varStandCosts1[5] Currency DLR17_QTY_RBS0_STR 17 15 VARSTDCOSTS1_6 varStandCosts1[6] Currency DLR17_QTY_RBS0_STR 17 16 VARSTDCOSTS1_7 varStandCosts1[7] Currency DLR17_QTY_RBS0_STR 17 17 VARSTDCOSTS1_8 varStandCosts1[8] Currency DLR17_QTY_RBS0_STR 17 18 VARSTDCOSTS1_9 varStandCosts1[9] Currency DLR17_QTY_RBS0_STR 17 19 VARSTDCOSTS1_10 varStandCosts1[10] Currency DLR17_QTY_RBS0_STR 17 20 VARSTDCOSTS1_11 varStandCosts1[11] Currency DLR17_QTY_RBS0_STR 17 21 VARSTDCOSTS1_12 varStandCosts1[12] Currency DLR17_QTY_RBS0_STR 17 22 VARSTDCOSTS1_13 varStandCosts1[13] Currency DLR17_QTY_RBS0_STR 17 23 VARSTDCOSTS2_1 varStandCosts2[1] Currency DLR17_QTY_RBS0_STR 17 24 VARSTDCOSTS2_2 varStandCosts2[2] Currency DLR17_QTY_RBS0_STR 17 25 VARSTDCOSTS2_3 varStandCosts2[3] Currency DLR17_QTY_RBS0_STR 17 26 VARSTDCOSTS2_4 varStandCosts2[4] Currency DLR17_QTY_RBS0_STR 17 27 VARSTDCOSTS2_5 varStandCosts2[5] Currency DLR17_QTY_RBS0_STR 17 28 VARSTDCOSTS2_6 varStandCosts2[6] Currency DLR17_QTY_RBS0_STR 17 29 VARSTDCOSTS2_7 varStandCosts2[7] Currency DLR17_QTY_RBS0_STR 17 30 VARSTDCOSTS2_8 varStandCosts2[8] Currency DLR17_QTY_RBS0_STR 17 31 VARSTDCOSTS2_9 varStandCosts2[9] Currency DLR17_QTY_RBS0_STR 17 32 VARSTDCOSTS2_10 varStandCosts2[10] Currency DLR17_QTY_RBS0_STR 17 33 VARSTDCOSTS2_11 varStandCosts2[11] Currency DLR17_QTY_RBS0_STR 17 34 VARSTDCOSTS2_12 varStandCosts2[12] Currency DLR17_QTY_RBS0_STR 17 35 VARSTDCOSTS2_13 varStandCosts2[13] Currency DLR17_QTY_RBS0_STR 17