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_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 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'].USERID2 MANUFACTUREORDERST_I Manufacture Order Status Integer DDL_WO_Status 0 3 MANORDERSTART_I Manufacture Order Start String STR30_UC 30 4 MANORDEREND_I Manufacture Order End String STR30_UC 30 5 STTITNUM Start Item Number String STR30_Item_Number 30 6 ENITMNBR End Item Number String STR30_Item_Number 30 7 STRTDATE Start Date Date DT 8 8 ENDDATE End Date Date DT 8 9 STTLOCCD Start Location Code String STR10_Location_Code 10 10 ENLOCNCD End Location Code String STR10_Location_Code 10 11 STRTRTNGNM Start Routing Name String STR30_Item_Number 30 12 ENDRTNGNM End Routing Name String STR30_Item_Number 30 13 STARTBOMCAT Start Bom Cat Integer DDL_BOM_Cat 0 14 ENDBOMCAT End BOM Cat Integer DDL_BOM_Cat 0 15 STARTBOMNAME Start Bom Name String STR15_LBU 15 16 ENDBOMNAME End BOM Name String STR15_LBU 15 17 EXCLDMOSTATUS Exclude MO Status CB Boolean 0 18 EXCLDMOSTATUS_1 Exclude MO Status[1] Boolean CB 0 19 EXCLDMOSTATUS_2 Exclude MO Status[2] Boolean CB 0 20 EXCLDMOSTATUS_3 Exclude MO Status[3] Boolean CB 0 21 EXCLDMOSTATUS_4 Exclude MO Status[4] Boolean CB 0 22 EXCLDMOSTATUS_5 Exclude MO Status[5] Boolean CB 0 23 EXCLDMOSTATUS_6 Exclude MO Status[6] Boolean CB 0 24 EXCLDMOSTATUS_7 Exclude MO Status[7] Boolean CB 0 25 PSTGDATE Posting Date Date DT 8 26 COMPLETECLOSEDATE Complete/Close Date Date DT 8 27 COMPCALCOPTION Component Calculation Option Integer DDL_Component_Calc_Option 0 28 SHOWMRPORDERS Show MRP Orders Boolean CB 0 29 STARTPLANNERID Start Planner ID String STR15_User_ID 15 30 ENDPLANNERID End Planner ID String STR15_User_ID 15