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 TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString30
2DSCRIPTN SearchDescriptionSTR30String30
3MANUFACTUREORDERST_I SearchManufacture Order StatusDDL_WO_StatusInteger0
4ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 MOCBBoolean0
6BOMCAT_I SearchBOM CatDDL_BOM_CatInteger0
7BOMNAME_I SearchBOM NameSTR15_LBUString15
8ROUTINGNAME_I SearchRoutingNameSTR30_Item_NumberString30
9ENDQTY_I SearchEnd QTYDLR_14_MRPCurrency14
10STARTQTY_I SearchStart QTYDLR_14_MRPCurrency14
11STRTDATE SearchStart DateDTDate8
12STARTTIME_I SearchStart Time_ICTM6Time6
13ENDDATE SearchEnd DateDTDate8
14DRAWFROMSITE_I SearchDraw From SiteSTR10_Location_CodeString10
15CHANGEDATE_I SearchChange DateDTDate8
16USERID SearchUser IDSTR15_User_IDString15
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_MethodInteger0
18PROJEMPLOYEEHRSSUM_I SearchProjected Employee Hours SumhrCurrency10
19PROJMACHINEHRSSUM_I SearchProjected Machine Hours SumhrCurrency10
20MATPROJCOSTI SearchMat Proj CostDLR17_RBS0_UTR$Currency17
21MATPROJCOSTI_1 SearchMat Proj Cost[1]DLR17_RBS0_UTR$Currency17
22MATPROJCOSTI_2 SearchMat Proj Cost[2]DLR17_RBS0_UTR$Currency17
23MATFIXOHDPROJCOSTI SearchMat Fix Ohd Proj CostDLR17_RBS0_UTR$Currency17
24MATFIXOHDPROJCOSTI_1 SearchMat Fix Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency17
25MATVAROHDPROJCOST SearchMat Var Ohd Proj CostDLR17_RBS0_UTR$Currency17
26MATFIXOHDPROJCOSTI_2 SearchMat Fix Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency17
27LABPROJCOSTI SearchLab Proj CostDLR17_RBS0_UTR$Currency17
28LABFIXOHDPROJCOSTI SearchLab Fix Ohd Proj CostDLR17_RBS0_UTR$Currency17
29MATVAROHDPROJCOST_1 SearchMat Var Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency17
30LABVAROHDPROJCOSTI SearchLab Var Ohd Proj CostDLR17_RBS0_UTR$Currency17
31MATVAROHDPROJCOST_2 SearchMat Var Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency17
32LABPROJCOSTI_1 SearchLab Proj Cost[1]DLR17_RBS0_UTR$Currency17
33MACHPROJCOSTI SearchMach Proj CostDLR17_RBS0_UTR$Currency17
34MACHFIXOHDPROJCOSTI SearchMach Fix Ohd Proj CostDLR17_RBS0_UTR$Currency17
35LABPROJCOSTI_2 SearchLab Proj Cost[2]DLR17_RBS0_UTR$Currency17
36LABFIXOHDPROJCOSTI_1 SearchLab Fix Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency17
37MACHVAROHDPROJCOSTI SearchMach Var Ohd Proj CostDLR17_RBS0_UTR$Currency17
38POSTTOSITE_I SearchPost To SiteSTR10_Location_CodeString10
39LABFIXOHDPROJCOSTI_2 SearchLab Fix Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency17
40LABVAROHDPROJCOSTI_1 SearchLab Var Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency17
41LOTNUMBR SearchLot NumberSTR20_LBAUString20
42SCHEDULINGPREFEREN_I SearchScheduling PreferenceSTR20String20
43LABVAROHDPROJCOSTI_2 SearchLab Var Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency17
44PLANNAME_I SearchPlan NameSTR15String15
45MACHPROJCOSTI_1 SearchMach Proj Cost[1]DLR17_RBS0_UTR$Currency17
46ACTUALDEMAND_I SearchActual DemandDLR_14_MRPCurrency14
47MACHPROJCOSTI_2 SearchMach Proj Cost[2]DLR17_RBS0_UTR$Currency17
48MANUFACTUREORDPRI_I SearchManufacture Order PriorityDDL_MOP_PriorityInteger0
49MACHFIXOHDPROJCOSTI_1 SearchMach Fix Ohd Proj Cost[1]DLR17_RBS0_UTR$Currency17
50Partial_Purge_Date SearchPartial Purge DateDT6Date6
51MACHFIXOHDPROJCOSTI_2 SearchMach Fix Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency17
52NOTEINDX SearchNote IndexDLR14Currency14
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$Currency17
54MACHVAROHDPROJCOSTI_2 SearchMach Var Ohd Proj Cost[2]DLR17_RBS0_UTR$Currency17
55OUTSOURCED_I SearchOutsourcedDDL_YesNoInteger0
56COMPCALCOPTION SearchComponent Calculation OptionDDL_Component_Calc_OptionInteger0
57COMPLETECLOSEDATE SearchComplete/Close DateDTDate8
58PSTGDATE SearchPosting DateDTDate8
59PLNNDSPPLID SearchPlanned Supply IDINTInteger0
60PICKNUMBER SearchPick NumberSTR17_LBAU_Pick_NumberString17
61QUICK_MO_I SearchQuick MOBooleanBoolean0
62ROUTING_REVISION_LEVEL SearchRouting Revision LevelSTR50String50
63BOM_REVISION_LEVEL SearchBOM Revision LevelSTR50String50
64DEX_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 PartyManufacture Order Master (WO010032)

Leave a Reply

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