MOPEdit MO Status Header (MOP1070)

azurecurveProductsManufacturing (346)3rd PartyMOPEdit MO Status Header (MOP1070)

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

Product: Manufacturing (346)
Series:

Display Name: MOPEdit MO Status Header
Physical Name: MOP1070
Technical Name: MOP_EditMOStatus_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['MOPEdit MO Status Header'].USERID AS 'MOPEdit MO Status Header-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       MOP1070 AS ['MOPEdit MO Status Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['MOPEdit MO Status Header'].USERID = ['Users Master'].USERID
2MANUFACTUREORDERST_I SearchManufacture Order StatusIntegerDDL_WO_Status0
3MANORDERSTART_I SearchManufacture Order StartStringSTR30_UC30
4MANORDEREND_I SearchManufacture Order EndStringSTR30_UC30
5STTITNUM SearchStart Item NumberStringSTR30_Item_Number30
6ENITMNBR SearchEnd Item NumberStringSTR30_Item_Number30
7STRTDATE SearchStart DateDateDT8
8ENDDATE SearchEnd DateDateDT8
9STTLOCCD SearchStart Location CodeStringSTR10_Location_Code10
10ENLOCNCD SearchEnd Location CodeStringSTR10_Location_Code10
11STRTRTNGNM SearchStart Routing NameStringSTR30_Item_Number30
12ENDRTNGNM SearchEnd Routing NameStringSTR30_Item_Number30
13STARTBOMCAT SearchStart Bom CatIntegerDDL_BOM_Cat0
14ENDBOMCAT SearchEnd BOM CatIntegerDDL_BOM_Cat0
15STARTBOMNAME SearchStart Bom NameStringSTR15_LBU15
16ENDBOMNAME SearchEnd BOM NameStringSTR15_LBU15
17EXCLDMOSTATUS_1 SearchExclude MO Status[1]BooleanCB0
18EXCLDMOSTATUS SearchExclude MO StatusCBBoolean0
19EXCLDMOSTATUS_2 SearchExclude MO Status[2]BooleanCB0
20EXCLDMOSTATUS_3 SearchExclude MO Status[3]BooleanCB0
21EXCLDMOSTATUS_4 SearchExclude MO Status[4]BooleanCB0
22EXCLDMOSTATUS_5 SearchExclude MO Status[5]BooleanCB0
23EXCLDMOSTATUS_6 SearchExclude MO Status[6]BooleanCB0
24EXCLDMOSTATUS_7 SearchExclude MO Status[7]BooleanCB0
25PSTGDATE SearchPosting DateDateDT8
26COMPLETECLOSEDATE SearchComplete/Close DateDateDT8
27COMPCALCOPTION SearchComponent Calculation OptionIntegerDDL_Component_Calc_Option0
28SHOWMRPORDERS SearchShow MRP OrdersBooleanCB0
29STARTPLANNERID SearchStart Planner IDStringSTR15_User_ID15
30ENDPLANNERID SearchEnd Planner IDStringSTR15_User_ID15
azurecurveProductsManufacturing (346)3rd PartyMOPEdit MO Status Header (MOP1070)

Leave a Reply

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