MOP_MO_Variance_Material_Hist (MOP1004)

azurecurveProductsManufacturing (346)3rd PartyMOP_MO_Variance_Material_Hist (MOP1004)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1004

Product: Manufacturing (346)
Series: 3rd Party

Display Name: MOP_MO_Variance_Material_Hist
Physical Name: MOP1004
Technical Name: MOP_MO_Variance_Material_Hist

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'].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'].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
8ORIGQTYALLOW SearchOriginal QTY AllowedDLR_14_MRPCurrency14
9QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency17
10QTY_ISSUED_I SearchQTY IssuedDLR17_QTY_RBS0_UTRCurrency17
11QTYCONSUMED SearchQTY ConsumedDLR17_QTY_RBS0_UTRCurrency17
12VARPRODMOCOSTS SearchvarProdMOCostsDLR17_QTY_RBS0_STRCurrency17
13VARPRODMOCOSTS_1 SearchvarProdMOCosts[1]DLR17_QTY_RBS0_STRCurrency17
14VARPRODRECDCOSTS SearchvarProdRecdCostsDLR17_QTY_RBS0_STRCurrency17
15VARPRODMOCOSTS_2 SearchvarProdMOCosts[2]DLR17_QTY_RBS0_STRCurrency17
16VARPRODMOCOSTS_3 SearchvarProdMOCosts[3]DLR17_QTY_RBS0_STRCurrency17
17VARCOSTSCLLCTD SearchvarCostCollectedDLR17_QTY_RBS0_STRCurrency17
18VARCOSTSUSED SearchvarCostsUsedDLR17_QTY_RBS0_STRCurrency17
19VARPRODMOCOSTS_4 SearchvarProdMOCosts[4]DLR17_QTY_RBS0_STRCurrency17
20VARSTDCOSTS1 SearchvarStandCosts1DLR17_QTY_RBS0_STRCurrency17
21VARPRODMOCOSTS_5 SearchvarProdMOCosts[5]DLR17_QTY_RBS0_STRCurrency17
22VARPRODMOCOSTS_6 SearchvarProdMOCosts[6]DLR17_QTY_RBS0_STRCurrency17
23VARSTDCOSTS2 SearchvarStandCosts2DLR17_QTY_RBS0_STRCurrency17
24VARPRODMOCOSTS_7 SearchvarProdMOCosts[7]DLR17_QTY_RBS0_STRCurrency17
25VARPRODMOCOSTS_8 SearchvarProdMOCosts[8]DLR17_QTY_RBS0_STRCurrency17
26VARPRODMOCOSTS_9 SearchvarProdMOCosts[9]DLR17_QTY_RBS0_STRCurrency17
27VARPRODMOCOSTS_10 SearchvarProdMOCosts[10]DLR17_QTY_RBS0_STRCurrency17
28VARPRODMOCOSTS_11 SearchvarProdMOCosts[11]DLR17_QTY_RBS0_STRCurrency17
29VARPRODMOCOSTS_12 SearchvarProdMOCosts[12]DLR17_QTY_RBS0_STRCurrency17
30VARPRODMOCOSTS_13 SearchvarProdMOCosts[13]DLR17_QTY_RBS0_STRCurrency17
31VARPRODRECDCOSTS_1 SearchvarProdRecdCosts[1]DLR17_QTY_RBS0_STRCurrency17
32VARPRODRECDCOSTS_2 SearchvarProdRecdCosts[2]DLR17_QTY_RBS0_STRCurrency17
33VARPRODRECDCOSTS_3 SearchvarProdRecdCosts[3]DLR17_QTY_RBS0_STRCurrency17
34VARPRODRECDCOSTS_4 SearchvarProdRecdCosts[4]DLR17_QTY_RBS0_STRCurrency17
35VARPRODRECDCOSTS_5 SearchvarProdRecdCosts[5]DLR17_QTY_RBS0_STRCurrency17
36VARPRODRECDCOSTS_6 SearchvarProdRecdCosts[6]DLR17_QTY_RBS0_STRCurrency17
37VARPRODRECDCOSTS_7 SearchvarProdRecdCosts[7]DLR17_QTY_RBS0_STRCurrency17
38VARPRODRECDCOSTS_8 SearchvarProdRecdCosts[8]DLR17_QTY_RBS0_STRCurrency17
39VARPRODRECDCOSTS_9 SearchvarProdRecdCosts[9]DLR17_QTY_RBS0_STRCurrency17
40VARPRODRECDCOSTS_10 SearchvarProdRecdCosts[10]DLR17_QTY_RBS0_STRCurrency17
41VARPRODRECDCOSTS_11 SearchvarProdRecdCosts[11]DLR17_QTY_RBS0_STRCurrency17
42VARPRODRECDCOSTS_12 SearchvarProdRecdCosts[12]DLR17_QTY_RBS0_STRCurrency17
43VARPRODRECDCOSTS_13 SearchvarProdRecdCosts[13]DLR17_QTY_RBS0_STRCurrency17
44VARCOSTSCLLCTD_1 SearchvarCostCollected[1]DLR17_QTY_RBS0_STRCurrency17
45VARCOSTSCLLCTD_2 SearchvarCostCollected[2]DLR17_QTY_RBS0_STRCurrency17
46VARCOSTSCLLCTD_3 SearchvarCostCollected[3]DLR17_QTY_RBS0_STRCurrency17
47VARCOSTSCLLCTD_4 SearchvarCostCollected[4]DLR17_QTY_RBS0_STRCurrency17
48VARCOSTSCLLCTD_5 SearchvarCostCollected[5]DLR17_QTY_RBS0_STRCurrency17
49VARCOSTSCLLCTD_6 SearchvarCostCollected[6]DLR17_QTY_RBS0_STRCurrency17
50VARCOSTSCLLCTD_7 SearchvarCostCollected[7]DLR17_QTY_RBS0_STRCurrency17
51VARCOSTSCLLCTD_8 SearchvarCostCollected[8]DLR17_QTY_RBS0_STRCurrency17
52VARCOSTSCLLCTD_9 SearchvarCostCollected[9]DLR17_QTY_RBS0_STRCurrency17
53VARCOSTSCLLCTD_10 SearchvarCostCollected[10]DLR17_QTY_RBS0_STRCurrency17
54VARCOSTSCLLCTD_11 SearchvarCostCollected[11]DLR17_QTY_RBS0_STRCurrency17
55VARCOSTSCLLCTD_12 SearchvarCostCollected[12]DLR17_QTY_RBS0_STRCurrency17
56VARCOSTSCLLCTD_13 SearchvarCostCollected[13]DLR17_QTY_RBS0_STRCurrency17
57VARCOSTSUSED_1 SearchvarCostsUsed[1]DLR17_QTY_RBS0_STRCurrency17
58VARCOSTSUSED_2 SearchvarCostsUsed[2]DLR17_QTY_RBS0_STRCurrency17
59VARCOSTSUSED_3 SearchvarCostsUsed[3]DLR17_QTY_RBS0_STRCurrency17
60VARCOSTSUSED_4 SearchvarCostsUsed[4]DLR17_QTY_RBS0_STRCurrency17
61VARCOSTSUSED_5 SearchvarCostsUsed[5]DLR17_QTY_RBS0_STRCurrency17
62VARCOSTSUSED_6 SearchvarCostsUsed[6]DLR17_QTY_RBS0_STRCurrency17
63VARCOSTSUSED_7 SearchvarCostsUsed[7]DLR17_QTY_RBS0_STRCurrency17
64VARCOSTSUSED_8 SearchvarCostsUsed[8]DLR17_QTY_RBS0_STRCurrency17
65VARCOSTSUSED_9 SearchvarCostsUsed[9]DLR17_QTY_RBS0_STRCurrency17
66VARCOSTSUSED_10 SearchvarCostsUsed[10]DLR17_QTY_RBS0_STRCurrency17
67VARCOSTSUSED_11 SearchvarCostsUsed[11]DLR17_QTY_RBS0_STRCurrency17
68VARCOSTSUSED_12 SearchvarCostsUsed[12]DLR17_QTY_RBS0_STRCurrency17
69VARCOSTSUSED_13 SearchvarCostsUsed[13]DLR17_QTY_RBS0_STRCurrency17
70VARSTDCOSTS1_1 SearchvarStandCosts1[1]DLR17_QTY_RBS0_STRCurrency17
71VARSTDCOSTS1_2 SearchvarStandCosts1[2]DLR17_QTY_RBS0_STRCurrency17
72VARSTDCOSTS1_3 SearchvarStandCosts1[3]DLR17_QTY_RBS0_STRCurrency17
73VARSTDCOSTS1_4 SearchvarStandCosts1[4]DLR17_QTY_RBS0_STRCurrency17
74VARSTDCOSTS1_5 SearchvarStandCosts1[5]DLR17_QTY_RBS0_STRCurrency17
75VARSTDCOSTS1_6 SearchvarStandCosts1[6]DLR17_QTY_RBS0_STRCurrency17
76VARSTDCOSTS1_7 SearchvarStandCosts1[7]DLR17_QTY_RBS0_STRCurrency17
77VARSTDCOSTS1_8 SearchvarStandCosts1[8]DLR17_QTY_RBS0_STRCurrency17
78VARSTDCOSTS1_9 SearchvarStandCosts1[9]DLR17_QTY_RBS0_STRCurrency17
79VARSTDCOSTS1_10 SearchvarStandCosts1[10]DLR17_QTY_RBS0_STRCurrency17
80VARSTDCOSTS1_11 SearchvarStandCosts1[11]DLR17_QTY_RBS0_STRCurrency17
81VARSTDCOSTS1_12 SearchvarStandCosts1[12]DLR17_QTY_RBS0_STRCurrency17
82VARSTDCOSTS1_13 SearchvarStandCosts1[13]DLR17_QTY_RBS0_STRCurrency17
83VARSTDCOSTS2_1 SearchvarStandCosts2[1]DLR17_QTY_RBS0_STRCurrency17
84VARSTDCOSTS2_2 SearchvarStandCosts2[2]DLR17_QTY_RBS0_STRCurrency17
85VARSTDCOSTS2_3 SearchvarStandCosts2[3]DLR17_QTY_RBS0_STRCurrency17
86VARSTDCOSTS2_4 SearchvarStandCosts2[4]DLR17_QTY_RBS0_STRCurrency17
87VARSTDCOSTS2_5 SearchvarStandCosts2[5]DLR17_QTY_RBS0_STRCurrency17
88VARSTDCOSTS2_6 SearchvarStandCosts2[6]DLR17_QTY_RBS0_STRCurrency17
89VARSTDCOSTS2_7 SearchvarStandCosts2[7]DLR17_QTY_RBS0_STRCurrency17
90VARSTDCOSTS2_8 SearchvarStandCosts2[8]DLR17_QTY_RBS0_STRCurrency17
91VARSTDCOSTS2_9 SearchvarStandCosts2[9]DLR17_QTY_RBS0_STRCurrency17
92VARSTDCOSTS2_10 SearchvarStandCosts2[10]DLR17_QTY_RBS0_STRCurrency17
93VARSTDCOSTS2_11 SearchvarStandCosts2[11]DLR17_QTY_RBS0_STRCurrency17
94VARSTDCOSTS2_12 SearchvarStandCosts2[12]DLR17_QTY_RBS0_STRCurrency17
95VARSTDCOSTS2_13 SearchvarStandCosts2[13]DLR17_QTY_RBS0_STRCurrency17
96DEX_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 (MOP1004)

Leave a Reply

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