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

Leave a Reply

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