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: 3rd Party

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 OrderSTR30_UCString30
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
4MRPAMOUNT_I SearchMRP_AmountDLR_14_MRPCurrency14
5DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
6DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
7MRPAMOUNT2_I SearchMRP_Amount2DLR_14_MRPCurrency14
8VARSTDCOSTS1 SearchvarStandCosts1DLR17_QTY_RBS0_STRCurrency17
9VARSTDCOSTS1_1 SearchvarStandCosts1[1]DLR17_QTY_RBS0_STRCurrency17
10VARSTDCOSTS1_2 SearchvarStandCosts1[2]DLR17_QTY_RBS0_STRCurrency17
11VARSTDCOSTS2 SearchvarStandCosts2DLR17_QTY_RBS0_STRCurrency17
12VARSTDCOSTS1_3 SearchvarStandCosts1[3]DLR17_QTY_RBS0_STRCurrency17
13VARSTDCOSTS1_4 SearchvarStandCosts1[4]DLR17_QTY_RBS0_STRCurrency17
14VARSTDCOSTS1_5 SearchvarStandCosts1[5]DLR17_QTY_RBS0_STRCurrency17
15VARSTDCOSTS1_6 SearchvarStandCosts1[6]DLR17_QTY_RBS0_STRCurrency17
16VARSTDCOSTS1_7 SearchvarStandCosts1[7]DLR17_QTY_RBS0_STRCurrency17
17VARSTDCOSTS1_8 SearchvarStandCosts1[8]DLR17_QTY_RBS0_STRCurrency17
18VARSTDCOSTS1_9 SearchvarStandCosts1[9]DLR17_QTY_RBS0_STRCurrency17
19VARSTDCOSTS1_10 SearchvarStandCosts1[10]DLR17_QTY_RBS0_STRCurrency17
20VARSTDCOSTS1_11 SearchvarStandCosts1[11]DLR17_QTY_RBS0_STRCurrency17
21VARSTDCOSTS1_12 SearchvarStandCosts1[12]DLR17_QTY_RBS0_STRCurrency17
22VARSTDCOSTS1_13 SearchvarStandCosts1[13]DLR17_QTY_RBS0_STRCurrency17
23VARSTDCOSTS2_1 SearchvarStandCosts2[1]DLR17_QTY_RBS0_STRCurrency17
24VARSTDCOSTS2_2 SearchvarStandCosts2[2]DLR17_QTY_RBS0_STRCurrency17
25VARSTDCOSTS2_3 SearchvarStandCosts2[3]DLR17_QTY_RBS0_STRCurrency17
26VARSTDCOSTS2_4 SearchvarStandCosts2[4]DLR17_QTY_RBS0_STRCurrency17
27VARSTDCOSTS2_5 SearchvarStandCosts2[5]DLR17_QTY_RBS0_STRCurrency17
28VARSTDCOSTS2_6 SearchvarStandCosts2[6]DLR17_QTY_RBS0_STRCurrency17
29VARSTDCOSTS2_7 SearchvarStandCosts2[7]DLR17_QTY_RBS0_STRCurrency17
30VARSTDCOSTS2_8 SearchvarStandCosts2[8]DLR17_QTY_RBS0_STRCurrency17
31VARSTDCOSTS2_9 SearchvarStandCosts2[9]DLR17_QTY_RBS0_STRCurrency17
32VARSTDCOSTS2_10 SearchvarStandCosts2[10]DLR17_QTY_RBS0_STRCurrency17
33VARSTDCOSTS2_11 SearchvarStandCosts2[11]DLR17_QTY_RBS0_STRCurrency17
34VARSTDCOSTS2_12 SearchvarStandCosts2[12]DLR17_QTY_RBS0_STRCurrency17
35VARSTDCOSTS2_13 SearchvarStandCosts2[13]DLR17_QTY_RBS0_STRCurrency17
36DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyMOP_MO_Variance_Material_Hist_STD (MOP1012)

Leave a Reply

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