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 TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString30
2DSCRIPTN SearchDescriptionSTR30String30
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_CatInteger0
5BOMNAME_I SearchBOM NameSTR15_LBUString15
6ITEMDESC SearchItem DescriptionSTR100String100
7ROUTINGNAME_I SearchRoutingNameSTR30_Item_NumberString30
8REVISIONLEVEL_I SearchRevision LevelSTR50String50
9STARTQTY_I SearchStart QTYDLR_14_MRPCurrency14
10ENDQTY_I SearchEnd QTYDLR_14_MRPCurrency14
11PROJEMPLOYEEHRSSUM_I SearchProjected Employee Hours SumhrCurrency10
12PROJMACHINEHRSSUM_I SearchProjected Machine Hours SumhrCurrency10
13ACTUALEMPHOURSSUM_I SearchActual Employee Hours SumhrCurrency10
14ACTUALMACHRSSUM_I SearchActual Machine Hours SumhrCurrency10
15MATCOSTI_1 SearchMat Cost[1]DLR17_RBS0_UTR$Currency17
16MATCOSTI SearchMat CostDLR17_RBS0_UTR$Currency17
17MATFIXOHDCOSTI SearchMat Fix Ohd CostDLR17_RBS0_UTR$Currency17
18MATCOSTI_2 SearchMat Cost[2]DLR17_RBS0_UTR$Currency17
19MATCOSTI_3 SearchMat Cost[3]DLR17_RBS0_UTR$Currency17
20MATVAROHDCOSTI SearchMat Var Ohd CostDLR17_RBS0_UTR$Currency17
21LABCOSTI SearchLab CostDLR17_RBS0_UTR$Currency17
22MATCOSTI_4 SearchMat Cost[4]DLR17_RBS0_UTR$Currency17
23LABFIXOHDCOSTI SearchLab Fix Ohd CostDLR17_RBS0_UTR$Currency17
24MATCOSTI_5 SearchMat Cost[5]DLR17_RBS0_UTR$Currency17
25LABVAROHDCOSTI SearchLab Var Ohd CostDLR17_RBS0_UTR$Currency17
26MATCOSTI_6 SearchMat Cost[6]DLR17_RBS0_UTR$Currency17
27MACHCOSTI SearchMach CostDLR17_RBS0_UTR$Currency17
28MATCOSTI_7 SearchMat Cost[7]DLR17_RBS0_UTR$Currency17
29MACHFIXOHDCOSTI SearchMach Fix Ohd CostDLR17_RBS0_UTR$Currency17
30MATCOSTI_8 SearchMat Cost[8]DLR17_RBS0_UTR$Currency17
31MATFIXOHDCOSTI_1 SearchMat Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency17
32MACHVAROHDCOSTI SearchMach Var Ohd CostDLR17_RBS0_UTR$Currency17
33MATFIXOHDCOSTI_2 SearchMat Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency17
34QAQCNEEDEDSTR3_I SearchQA/QC Needed STR3STR3String3
35QTYTOPOST_I SearchQTY To PostDLR17_QTY_RBS0_UTRCurrency17
36MATFIXOHDCOSTI_3 SearchMat Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency17
37LOTNUMBR SearchLot NumberSTR20_LBAUString20
38MATFIXOHDCOSTI_4 SearchMat Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency17
39MATFIXOHDCOSTI_5 SearchMat Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency17
40PLANNAME_I SearchPlan NameSTR15String15
41ACTUALDEMAND_I SearchActual DemandDLR_14_MRPCurrency14
42MATFIXOHDCOSTI_6 SearchMat Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency17
43MATFIXOHDCOSTI_7 SearchMat Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency17
44NOTEINDX SearchNote IndexDLR14Currency14
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_MRPCurrency14
46MATFIXOHDCOSTI_8 SearchMat Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency17
47MATVAROHDCOSTI_1 SearchMat Var Ohd Cost[1]DLR17_RBS0_UTR$Currency17
48DATE1 SearchDateDT6Date6
49MATVAROHDCOSTI_2 SearchMat Var Ohd Cost[2]DLR17_RBS0_UTR$Currency17
50TIME1 SearchTimeTM6Time6
51MATVAROHDCOSTI_3 SearchMat Var Ohd Cost[3]DLR17_RBS0_UTR$Currency17
52BASEUOFM SearchBase U Of MU_Of_MString8
53MATVAROHDCOSTI_4 SearchMat Var Ohd Cost[4]DLR17_RBS0_UTR$Currency17
54DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
55MATVAROHDCOSTI_5 SearchMat Var Ohd Cost[5]DLR17_RBS0_UTR$Currency17
56DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
57MATVAROHDCOSTI_6 SearchMat Var Ohd Cost[6]DLR17_RBS0_UTR$Currency17
58MATVAROHDCOSTI_7 SearchMat Var Ohd Cost[7]DLR17_RBS0_UTR$Currency17
59MATVAROHDCOSTI_8 SearchMat Var Ohd Cost[8]DLR17_RBS0_UTR$Currency17
60LABCOSTI_1 SearchLab Cost[1]DLR17_RBS0_UTR$Currency17
61LABCOSTI_2 SearchLab Cost[2]DLR17_RBS0_UTR$Currency17
62LABCOSTI_3 SearchLab Cost[3]DLR17_RBS0_UTR$Currency17
63LABCOSTI_4 SearchLab Cost[4]DLR17_RBS0_UTR$Currency17
64LABCOSTI_5 SearchLab Cost[5]DLR17_RBS0_UTR$Currency17
65LABCOSTI_6 SearchLab Cost[6]DLR17_RBS0_UTR$Currency17
66LABCOSTI_7 SearchLab Cost[7]DLR17_RBS0_UTR$Currency17
67LABCOSTI_8 SearchLab Cost[8]DLR17_RBS0_UTR$Currency17
68LABFIXOHDCOSTI_1 SearchLab Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency17
69LABFIXOHDCOSTI_2 SearchLab Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency17
70LABFIXOHDCOSTI_3 SearchLab Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency17
71LABFIXOHDCOSTI_4 SearchLab Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency17
72LABFIXOHDCOSTI_5 SearchLab Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency17
73LABFIXOHDCOSTI_6 SearchLab Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency17
74LABFIXOHDCOSTI_7 SearchLab Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency17
75LABFIXOHDCOSTI_8 SearchLab Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency17
76LABVAROHDCOSTI_1 SearchLab Var Ohd Cost[1]DLR17_RBS0_UTR$Currency17
77LABVAROHDCOSTI_2 SearchLab Var Ohd Cost[2]DLR17_RBS0_UTR$Currency17
78LABVAROHDCOSTI_3 SearchLab Var Ohd Cost[3]DLR17_RBS0_UTR$Currency17
79LABVAROHDCOSTI_4 SearchLab Var Ohd Cost[4]DLR17_RBS0_UTR$Currency17
80LABVAROHDCOSTI_5 SearchLab Var Ohd Cost[5]DLR17_RBS0_UTR$Currency17
81LABVAROHDCOSTI_6 SearchLab Var Ohd Cost[6]DLR17_RBS0_UTR$Currency17
82LABVAROHDCOSTI_7 SearchLab Var Ohd Cost[7]DLR17_RBS0_UTR$Currency17
83LABVAROHDCOSTI_8 SearchLab Var Ohd Cost[8]DLR17_RBS0_UTR$Currency17
84MACHCOSTI_1 SearchMach Cost[1]DLR17_RBS0_UTR$Currency17
85MACHCOSTI_2 SearchMach Cost[2]DLR17_RBS0_UTR$Currency17
86MACHCOSTI_3 SearchMach Cost[3]DLR17_RBS0_UTR$Currency17
87MACHCOSTI_4 SearchMach Cost[4]DLR17_RBS0_UTR$Currency17
88MACHCOSTI_5 SearchMach Cost[5]DLR17_RBS0_UTR$Currency17
89MACHCOSTI_6 SearchMach Cost[6]DLR17_RBS0_UTR$Currency17
90MACHCOSTI_7 SearchMach Cost[7]DLR17_RBS0_UTR$Currency17
91MACHCOSTI_8 SearchMach Cost[8]DLR17_RBS0_UTR$Currency17
92MACHFIXOHDCOSTI_1 SearchMach Fix Ohd Cost[1]DLR17_RBS0_UTR$Currency17
93MACHFIXOHDCOSTI_2 SearchMach Fix Ohd Cost[2]DLR17_RBS0_UTR$Currency17
94MACHFIXOHDCOSTI_3 SearchMach Fix Ohd Cost[3]DLR17_RBS0_UTR$Currency17
95MACHFIXOHDCOSTI_4 SearchMach Fix Ohd Cost[4]DLR17_RBS0_UTR$Currency17
96MACHFIXOHDCOSTI_5 SearchMach Fix Ohd Cost[5]DLR17_RBS0_UTR$Currency17
97MACHFIXOHDCOSTI_6 SearchMach Fix Ohd Cost[6]DLR17_RBS0_UTR$Currency17
98MACHFIXOHDCOSTI_7 SearchMach Fix Ohd Cost[7]DLR17_RBS0_UTR$Currency17
99MACHFIXOHDCOSTI_8 SearchMach Fix Ohd Cost[8]DLR17_RBS0_UTR$Currency17
100MACHVAROHDCOSTI_1 SearchMach Var Ohd Cost[1]DLR17_RBS0_UTR$Currency17
101MACHVAROHDCOSTI_2 SearchMach Var Ohd Cost[2]DLR17_RBS0_UTR$Currency17
102MACHVAROHDCOSTI_3 SearchMach Var Ohd Cost[3]DLR17_RBS0_UTR$Currency17
103MACHVAROHDCOSTI_4 SearchMach Var Ohd Cost[4]DLR17_RBS0_UTR$Currency17
104MACHVAROHDCOSTI_5 SearchMach Var Ohd Cost[5]DLR17_RBS0_UTR$Currency17
105MACHVAROHDCOSTI_6 SearchMach Var Ohd Cost[6]DLR17_RBS0_UTR$Currency17
106MACHVAROHDCOSTI_7 SearchMach Var Ohd Cost[7]DLR17_RBS0_UTR$Currency17
107MACHVAROHDCOSTI_8 SearchMach Var Ohd Cost[8]DLR17_RBS0_UTR$Currency17
108DEX_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 Historical Variance (WO010116)

Leave a Reply

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