MOP Historical Variance (WO010116)

azurecurveProductsManufacturing (346)3rd PartyMOP Historical Variance (WO010116)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: MOP Historical Variance
Physical Name: WO010116
Technical Name: MFG_MOP_History

Group Display Name: Manufacturing MOP
Group Technical Name: Manufacturing MOP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString3230
2DSCRIPTN SearchDescriptionSTR30String3230
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['MOP Historical Variance'].ITEMNMBR AS 'MOP Historical Variance-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       WO010116 AS ['MOP Historical Variance']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['MOP Historical Variance'].ITEMNMBR = ['Item Master'].ITEMNMBR
4BOMCAT_I SearchBOM CatDDL_BOM_CatInteger20
5BOMNAME_I SearchBOM NameSTR15_LBUString1615
6ITEMDESC SearchItem DescriptionSTR100String102100
7ROUTINGNAME_I SearchRoutingNameSTR30_Item_NumberString3230
8REVISIONLEVEL_I SearchRevision LevelSTR50String5250
9STARTQTY_I SearchStart QTYDLR_14_MRPCurrency1014
10ENDQTY_I SearchEnd QTYDLR_14_MRPCurrency1014
11PROJEMPLOYEEHRSSUM_I SearchProjected Employee Hours SumhrCurrency1010
12PROJMACHINEHRSSUM_I SearchProjected Machine Hours SumhrCurrency1010
13ACTUALEMPHOURSSUM_I SearchActual Employee Hours SumhrCurrency1010
14ACTUALMACHRSSUM_I SearchActual Machine Hours SumhrCurrency1010
15MATCOSTI_1 SearchMat Cost[1]DLR17_RBS0_UTR$Currency1017
16MATCOSTI SearchMat CostDLR17_RBS0_UTR$Currency1017
17MATFIXOHDCOSTI SearchMat Fix Ohd CostDLR17_RBS0_UTR$Currency1017
18MATCOSTI_2 SearchMat Cost[2]DLR17_RBS0_UTR$Currency1017
19MATCOSTI_3 SearchMat Cost[3]DLR17_RBS0_UTR$Currency1017
20MATVAROHDCOSTI SearchMat Var Ohd CostDLR17_RBS0_UTR$Currency1017
21LABCOSTI SearchLab CostDLR17_RBS0_UTR$Currency1017
22MATCOSTI_4 SearchMat Cost[4]DLR17_RBS0_UTR$Currency1017
23LABFIXOHDCOSTI SearchLab Fix Ohd CostDLR17_RBS0_UTR$Currency1017
24MATCOSTI_5 SearchMat Cost[5]DLR17_RBS0_UTR$Currency1017
25LABVAROHDCOSTI SearchLab Var Ohd CostDLR17_RBS0_UTR$Currency1017
26MATCOSTI_6 SearchMat Cost[6]DLR17_RBS0_UTR$Currency1017
27MACHCOSTI SearchMach CostDLR17_RBS0_UTR$Currency1017
28MATCOSTI_7 SearchMat Cost[7]DLR17_RBS0_UTR$Currency1017
29MACHFIXOHDCOSTI SearchMach Fix Ohd CostDLR17_RBS0_UTR$Currency1017
30MATCOSTI_8 SearchMat Cost[8]DLR17_RBS0_UTR$Currency1017
31MATFIXOHDCOSTI_1 SearchMat Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
32MACHVAROHDCOSTI SearchMach Var Ohd CostDLR17_RBS0_UTR$Currency1017
33MATFIXOHDCOSTI_2 SearchMat Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
34QAQCNEEDEDSTR3_I SearchQA/QC Needed STR3STR3String43
35QTYTOPOST_I SearchQTY To PostDLR17_QTY_RBS0_UTRCurrency1017
36MATFIXOHDCOSTI_3 SearchMat Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
37LOTNUMBR SearchLot NumberSTR20_LBAUString2220
38MATFIXOHDCOSTI_4 SearchMat Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
39MATFIXOHDCOSTI_5 SearchMat Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
40PLANNAME_I SearchPlan NameSTR15String1615
41ACTUALDEMAND_I SearchActual DemandDLR_14_MRPCurrency1014
42MATFIXOHDCOSTI_6 SearchMat Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
43MATFIXOHDCOSTI_7 SearchMat Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
44NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['MOP Historical Variance'].NOTEINDX AS 'MOP Historical Variance-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WO010116 AS ['MOP Historical Variance']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['MOP Historical Variance'].NOTEINDX = ['Record Notes Master'].NOTEINDX
45MRPAMOUNT_I SearchMRP_AmountDLR_14_MRPCurrency1014
46MATFIXOHDCOSTI_8 SearchMat Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
47MATVAROHDCOSTI_1 SearchMat Var Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
48DATE1 SearchDateDT6Date46
49MATVAROHDCOSTI_2 SearchMat Var Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
50TIME1 SearchTimeTM6Time46
51MATVAROHDCOSTI_3 SearchMat Var Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
52BASEUOFM SearchBase U Of MU_Of_MString108
53MATVAROHDCOSTI_4 SearchMat Var Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
54DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
55MATVAROHDCOSTI_5 SearchMat Var Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
56DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
57MATVAROHDCOSTI_6 SearchMat Var Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
58MATVAROHDCOSTI_7 SearchMat Var Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
59MATVAROHDCOSTI_8 SearchMat Var Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
60LABCOSTI_1 SearchLab Cost[1]DLR17_RBS0_UTR$Currency1017
61LABCOSTI_2 SearchLab Cost[2]DLR17_RBS0_UTR$Currency1017
62LABCOSTI_3 SearchLab Cost[3]DLR17_RBS0_UTR$Currency1017
63LABCOSTI_4 SearchLab Cost[4]DLR17_RBS0_UTR$Currency1017
64LABCOSTI_5 SearchLab Cost[5]DLR17_RBS0_UTR$Currency1017
65LABCOSTI_6 SearchLab Cost[6]DLR17_RBS0_UTR$Currency1017
66LABCOSTI_7 SearchLab Cost[7]DLR17_RBS0_UTR$Currency1017
67LABCOSTI_8 SearchLab Cost[8]DLR17_RBS0_UTR$Currency1017
68LABFIXOHDCOSTI_1 SearchLab Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
69LABFIXOHDCOSTI_2 SearchLab Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
70LABFIXOHDCOSTI_3 SearchLab Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
71LABFIXOHDCOSTI_4 SearchLab Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
72LABFIXOHDCOSTI_5 SearchLab Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
73LABFIXOHDCOSTI_6 SearchLab Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
74LABFIXOHDCOSTI_7 SearchLab Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
75LABFIXOHDCOSTI_8 SearchLab Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
76LABVAROHDCOSTI_1 SearchLab Var Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
77LABVAROHDCOSTI_2 SearchLab Var Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
78LABVAROHDCOSTI_3 SearchLab Var Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
79LABVAROHDCOSTI_4 SearchLab Var Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
80LABVAROHDCOSTI_5 SearchLab Var Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
81LABVAROHDCOSTI_6 SearchLab Var Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
82LABVAROHDCOSTI_7 SearchLab Var Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
83LABVAROHDCOSTI_8 SearchLab Var Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
84MACHCOSTI_1 SearchMach Cost[1]DLR17_RBS0_UTR$Currency1017
85MACHCOSTI_2 SearchMach Cost[2]DLR17_RBS0_UTR$Currency1017
86MACHCOSTI_3 SearchMach Cost[3]DLR17_RBS0_UTR$Currency1017
87MACHCOSTI_4 SearchMach Cost[4]DLR17_RBS0_UTR$Currency1017
88MACHCOSTI_5 SearchMach Cost[5]DLR17_RBS0_UTR$Currency1017
89MACHCOSTI_6 SearchMach Cost[6]DLR17_RBS0_UTR$Currency1017
90MACHCOSTI_7 SearchMach Cost[7]DLR17_RBS0_UTR$Currency1017
91MACHCOSTI_8 SearchMach Cost[8]DLR17_RBS0_UTR$Currency1017
92MACHFIXOHDCOSTI_1 SearchMach Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
93MACHFIXOHDCOSTI_2 SearchMach Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
94MACHFIXOHDCOSTI_3 SearchMach Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
95MACHFIXOHDCOSTI_4 SearchMach Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
96MACHFIXOHDCOSTI_5 SearchMach Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
97MACHFIXOHDCOSTI_6 SearchMach Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
98MACHFIXOHDCOSTI_7 SearchMach Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
99MACHFIXOHDCOSTI_8 SearchMach Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
100MACHVAROHDCOSTI_1 SearchMach Var Ohd Cost[1]DLR17_RBS0_UTR$Currency1017
101MACHVAROHDCOSTI_2 SearchMach Var Ohd Cost[2]DLR17_RBS0_UTR$Currency1017
102MACHVAROHDCOSTI_3 SearchMach Var Ohd Cost[3]DLR17_RBS0_UTR$Currency1017
103MACHVAROHDCOSTI_4 SearchMach Var Ohd Cost[4]DLR17_RBS0_UTR$Currency1017
104MACHVAROHDCOSTI_5 SearchMach Var Ohd Cost[5]DLR17_RBS0_UTR$Currency1017
105MACHVAROHDCOSTI_6 SearchMach Var Ohd Cost[6]DLR17_RBS0_UTR$Currency1017
106MACHVAROHDCOSTI_7 SearchMach Var Ohd Cost[7]DLR17_RBS0_UTR$Currency1017
107MACHVAROHDCOSTI_8 SearchMach Var Ohd Cost[8]DLR17_RBS0_UTR$Currency1017
108DEX_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 Historical Variance (WO010116)

Leave a Reply

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