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 TypeSQL DB LengthKeyable Length
1MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString3230
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 DescriptionSTR100String102100
4MRPAMOUNT_I SearchMRP_AmountDLR_14_MRPCurrency1014
5DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
6DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
7MRPAMOUNT2_I SearchMRP_Amount2DLR_14_MRPCurrency1014
8VARSTDCOSTS1 SearchvarStandCosts1DLR17_QTY_RBS0_STRCurrency1017
9VARSTDCOSTS1_1 SearchvarStandCosts1[1]DLR17_QTY_RBS0_STRCurrency1017
10VARSTDCOSTS1_2 SearchvarStandCosts1[2]DLR17_QTY_RBS0_STRCurrency1017
11VARSTDCOSTS2 SearchvarStandCosts2DLR17_QTY_RBS0_STRCurrency1017
12VARSTDCOSTS1_3 SearchvarStandCosts1[3]DLR17_QTY_RBS0_STRCurrency1017
13VARSTDCOSTS1_4 SearchvarStandCosts1[4]DLR17_QTY_RBS0_STRCurrency1017
14VARSTDCOSTS1_5 SearchvarStandCosts1[5]DLR17_QTY_RBS0_STRCurrency1017
15VARSTDCOSTS1_6 SearchvarStandCosts1[6]DLR17_QTY_RBS0_STRCurrency1017
16VARSTDCOSTS1_7 SearchvarStandCosts1[7]DLR17_QTY_RBS0_STRCurrency1017
17VARSTDCOSTS1_8 SearchvarStandCosts1[8]DLR17_QTY_RBS0_STRCurrency1017
18VARSTDCOSTS1_9 SearchvarStandCosts1[9]DLR17_QTY_RBS0_STRCurrency1017
19VARSTDCOSTS1_10 SearchvarStandCosts1[10]DLR17_QTY_RBS0_STRCurrency1017
20VARSTDCOSTS1_11 SearchvarStandCosts1[11]DLR17_QTY_RBS0_STRCurrency1017
21VARSTDCOSTS1_12 SearchvarStandCosts1[12]DLR17_QTY_RBS0_STRCurrency1017
22VARSTDCOSTS1_13 SearchvarStandCosts1[13]DLR17_QTY_RBS0_STRCurrency1017
23VARSTDCOSTS2_1 SearchvarStandCosts2[1]DLR17_QTY_RBS0_STRCurrency1017
24VARSTDCOSTS2_2 SearchvarStandCosts2[2]DLR17_QTY_RBS0_STRCurrency1017
25VARSTDCOSTS2_3 SearchvarStandCosts2[3]DLR17_QTY_RBS0_STRCurrency1017
26VARSTDCOSTS2_4 SearchvarStandCosts2[4]DLR17_QTY_RBS0_STRCurrency1017
27VARSTDCOSTS2_5 SearchvarStandCosts2[5]DLR17_QTY_RBS0_STRCurrency1017
28VARSTDCOSTS2_6 SearchvarStandCosts2[6]DLR17_QTY_RBS0_STRCurrency1017
29VARSTDCOSTS2_7 SearchvarStandCosts2[7]DLR17_QTY_RBS0_STRCurrency1017
30VARSTDCOSTS2_8 SearchvarStandCosts2[8]DLR17_QTY_RBS0_STRCurrency1017
31VARSTDCOSTS2_9 SearchvarStandCosts2[9]DLR17_QTY_RBS0_STRCurrency1017
32VARSTDCOSTS2_10 SearchvarStandCosts2[10]DLR17_QTY_RBS0_STRCurrency1017
33VARSTDCOSTS2_11 SearchvarStandCosts2[11]DLR17_QTY_RBS0_STRCurrency1017
34VARSTDCOSTS2_12 SearchvarStandCosts2[12]DLR17_QTY_RBS0_STRCurrency1017
35VARSTDCOSTS2_13 SearchvarStandCosts2[13]DLR17_QTY_RBS0_STRCurrency1017
36DEX_ROW_ID Searchintint1010

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 *