MOP_MO_Variance_Material_Hist_STD (MOP1012)

azurecurveProductsManufacturing (346)3rd PartyMOP_MO_Variance_Material_Hist_STD (MOP1012)

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_STD

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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
3ITEMDESC SearchItem DescriptionStringSTR100100
4MRPAMOUNT_I SearchMRP_AmountCurrencyDLR_14_MRP14
5DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
6DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
7MRPAMOUNT2_I SearchMRP_Amount2CurrencyDLR_14_MRP14
8VARSTDCOSTS1 SearchvarStandCosts1DLR17_QTY_RBS0_STRCurrency17
9VARSTDCOSTS1_1 SearchvarStandCosts1[1]CurrencyDLR17_QTY_RBS0_STR17
10VARSTDCOSTS2 SearchvarStandCosts2DLR17_QTY_RBS0_STRCurrency17
11VARSTDCOSTS1_2 SearchvarStandCosts1[2]CurrencyDLR17_QTY_RBS0_STR17
12VARSTDCOSTS1_3 SearchvarStandCosts1[3]CurrencyDLR17_QTY_RBS0_STR17
13VARSTDCOSTS1_4 SearchvarStandCosts1[4]CurrencyDLR17_QTY_RBS0_STR17
14VARSTDCOSTS1_5 SearchvarStandCosts1[5]CurrencyDLR17_QTY_RBS0_STR17
15VARSTDCOSTS1_6 SearchvarStandCosts1[6]CurrencyDLR17_QTY_RBS0_STR17
16VARSTDCOSTS1_7 SearchvarStandCosts1[7]CurrencyDLR17_QTY_RBS0_STR17
17VARSTDCOSTS1_8 SearchvarStandCosts1[8]CurrencyDLR17_QTY_RBS0_STR17
18VARSTDCOSTS1_9 SearchvarStandCosts1[9]CurrencyDLR17_QTY_RBS0_STR17
19VARSTDCOSTS1_10 SearchvarStandCosts1[10]CurrencyDLR17_QTY_RBS0_STR17
20VARSTDCOSTS1_11 SearchvarStandCosts1[11]CurrencyDLR17_QTY_RBS0_STR17
21VARSTDCOSTS1_12 SearchvarStandCosts1[12]CurrencyDLR17_QTY_RBS0_STR17
22VARSTDCOSTS1_13 SearchvarStandCosts1[13]CurrencyDLR17_QTY_RBS0_STR17
23VARSTDCOSTS2_1 SearchvarStandCosts2[1]CurrencyDLR17_QTY_RBS0_STR17
24VARSTDCOSTS2_2 SearchvarStandCosts2[2]CurrencyDLR17_QTY_RBS0_STR17
25VARSTDCOSTS2_3 SearchvarStandCosts2[3]CurrencyDLR17_QTY_RBS0_STR17
26VARSTDCOSTS2_4 SearchvarStandCosts2[4]CurrencyDLR17_QTY_RBS0_STR17
27VARSTDCOSTS2_5 SearchvarStandCosts2[5]CurrencyDLR17_QTY_RBS0_STR17
28VARSTDCOSTS2_6 SearchvarStandCosts2[6]CurrencyDLR17_QTY_RBS0_STR17
29VARSTDCOSTS2_7 SearchvarStandCosts2[7]CurrencyDLR17_QTY_RBS0_STR17
30VARSTDCOSTS2_8 SearchvarStandCosts2[8]CurrencyDLR17_QTY_RBS0_STR17
31VARSTDCOSTS2_9 SearchvarStandCosts2[9]CurrencyDLR17_QTY_RBS0_STR17
32VARSTDCOSTS2_10 SearchvarStandCosts2[10]CurrencyDLR17_QTY_RBS0_STR17
33VARSTDCOSTS2_11 SearchvarStandCosts2[11]CurrencyDLR17_QTY_RBS0_STR17
34VARSTDCOSTS2_12 SearchvarStandCosts2[12]CurrencyDLR17_QTY_RBS0_STR17
35VARSTDCOSTS2_13 SearchvarStandCosts2[13]CurrencyDLR17_QTY_RBS0_STR17
azurecurveProductsManufacturing (346)3rd PartyMOP_MO_Variance_Material_Hist_STD (MOP1012)

Leave a Reply

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