Manufacture Order Master (WO010032)

azurecurveProductsManufacturing (346)3rd PartyManufacture Order Master (WO010032)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Manufacture Order Master
Physical Name: WO010032
Technical Name: MOP_Order_MSTR

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
3MANUFACTUREORDERST_I SearchManufacture Order StatusDDL_WO_StatusInteger20
4ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Manufacture Order Master'].ITEMNMBR AS 'Manufacture Order Master-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       WO010032 AS ['Manufacture Order Master']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Manufacture Order Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
5ARCHIVED_MO_I SearchArchived MOCBBoolean20
6BOMCAT_I SearchBOM CatDDL_BOM_CatInteger20
7BOMNAME_I SearchBOM NameSTR15_LBUString1615
8ROUTINGNAME_I SearchRoutingNameSTR30_Item_NumberString3230
9ENDQTY_I SearchEnd QTYDLR_14_MRPCurrency1014
10STARTQTY_I SearchStart QTYDLR_14_MRPCurrency1014
11STRTDATE SearchStart DateDTDate48
12STARTTIME_I SearchStart Time_ICTM6Time46
13ENDDATE SearchEnd DateDTDate48
14DRAWFROMSITE_I SearchDraw From SiteSTR10_Location_CodeString1210
15CHANGEDATE_I SearchChange DateDTDate48
16USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Manufacture Order Master'].USERID AS 'Manufacture Order Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WO010032 AS ['Manufacture Order Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Manufacture Order Master'].USERID = ['Users Master'].USERID
17SCHEDULEMETHOD_I SearchSchedule MethodDDL_Schedule_MethodInteger20
18PROJEMPLOYEEHRSSUM_I SearchProjected Employee Hours SumhrCurrency1010
19PROJMACHINEHRSSUM_I SearchProjected Machine Hours SumhrCurrency1010
20MATPROJCOSTI SearchMat Proj CostDLR17_RBS0_UTR$Currency1017
21MATPROJCOSTI_1 SearchMat Proj Cost[1]DLR17_RBS0_UTR$Currency1017
22MATPROJCOSTI_2 SearchMat Proj Cost[2]DLR17_RBS0_UTR$Currency1017
23MATFIXOHDPROJCOSTI SearchMat Fix Ohd Proj CostDLR17_RBS0_UTR$Currency1017
24MATFIXOHDPROJCOSTI_1 SearchMat Fix Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency1017
25MATVAROHDPROJCOST SearchMat Var Ohd Proj CostDLR17_RBS0_UTR$Currency1017
26MATFIXOHDPROJCOSTI_2 SearchMat Fix Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency1017
27LABPROJCOSTI SearchLab Proj CostDLR17_RBS0_UTR$Currency1017
28LABFIXOHDPROJCOSTI SearchLab Fix Ohd Proj CostDLR17_RBS0_UTR$Currency1017
29MATVAROHDPROJCOST_1 SearchMat Var Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency1017
30LABVAROHDPROJCOSTI SearchLab Var Ohd Proj CostDLR17_RBS0_UTR$Currency1017
31MATVAROHDPROJCOST_2 SearchMat Var Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency1017
32LABPROJCOSTI_1 SearchLab Proj Cost[1]DLR17_RBS0_UTR$Currency1017
33MACHPROJCOSTI SearchMach Proj CostDLR17_RBS0_UTR$Currency1017
34MACHFIXOHDPROJCOSTI SearchMach Fix Ohd Proj CostDLR17_RBS0_UTR$Currency1017
35LABPROJCOSTI_2 SearchLab Proj Cost[2]DLR17_RBS0_UTR$Currency1017
36LABFIXOHDPROJCOSTI_1 SearchLab Fix Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency1017
37MACHVAROHDPROJCOSTI SearchMach Var Ohd Proj CostDLR17_RBS0_UTR$Currency1017
38POSTTOSITE_I SearchPost To SiteSTR10_Location_CodeString1210
39LABFIXOHDPROJCOSTI_2 SearchLab Fix Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency1017
40LABVAROHDPROJCOSTI_1 SearchLab Var Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency1017
41LOTNUMBR SearchLot NumberSTR20_LBAUString2220
42SCHEDULINGPREFEREN_I SearchScheduling PreferenceSTR20String2220
43LABVAROHDPROJCOSTI_2 SearchLab Var Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency1017
44PLANNAME_I SearchPlan NameSTR15String1615
45MACHPROJCOSTI_1 SearchMach Proj Cost[1]DLR17_RBS0_UTR$Currency1017
46ACTUALDEMAND_I SearchActual DemandDLR_14_MRPCurrency1014
47MACHPROJCOSTI_2 SearchMach Proj Cost[2]DLR17_RBS0_UTR$Currency1017
48MANUFACTUREORDPRI_I SearchManufacture Order PriorityDDL_MOP_PriorityInteger20
49MACHFIXOHDPROJCOSTI_1 SearchMach Fix Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency1017
50Partial_Purge_Date SearchPartial Purge DateDT6Date46
51MACHFIXOHDPROJCOSTI_2 SearchMach Fix Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency1017
52NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Manufacture Order Master'].NOTEINDX AS 'Manufacture Order Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WO010032 AS ['Manufacture Order Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Manufacture Order Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
53MACHVAROHDPROJCOSTI_1 SearchMach Var Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency1017
54MACHVAROHDPROJCOSTI_2 SearchMach Var Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency1017
55OUTSOURCED_I SearchOutsourcedDDL_YesNoInteger20
56COMPCALCOPTION SearchComponent Calculation OptionDDL_Component_Calc_OptionInteger20
57COMPLETECLOSEDATE SearchComplete/Close DateDTDate48
58PSTGDATE SearchPosting DateDTDate48
59PLNNDSPPLID SearchPlanned Supply IDINTInteger20
60PICKNUMBER SearchPick NumberSTR17_LBAU_Pick_NumberString1817
61QUICK_MO_I SearchQuick MOBooleanBoolean20
62ROUTING_REVISION_LEVEL SearchRouting Revision LevelSTR50String5250
63BOM_REVISION_LEVEL SearchBOM Revision LevelSTR50String5250
64DEX_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 PartyManufacture Order Master (WO010032)

Leave a Reply

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