Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1071
Product: Manufacturing (346)
Series:
Display Name: MOP Edit MO Status Line
Physical Name: MOP1071
Technical Name: MOP_EditMOStatus_LineSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Process_Index Process Index Long Integer long 8 2 CB_I CB Boolean CB 0 3 MANUFACTUREORDER_I Manufacture Order String STR30_UC 30 4 MANUFACTUREORDERST_I Manufacture Order Status Integer DDL_WO_Status 0 5 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['MOP Edit MO Status Line'].ITEMNMBR AS 'MOP Edit MO Status Line-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOP1071 AS ['MOP Edit MO Status Line']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MOP Edit MO Status Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
6 STRTDATE Start Date Date DT 8 7 ENDQTY_I End QTY Currency DLR_14_MRP 14 8 DSCRIPTN Description String STR30 30 9 ITEMDESC Item Description String STR100 100 10 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 11 BASEUOFM Base U Of M String U_Of_M 8 12 DUEDATE Due Date Date DT 8 13 POSTTOSITE_I Post To Site String STR10_Location_Code 10 14 ROUTINGNAME_I RoutingName String STR30_Item_Number 30 15 BOMCAT_I BOM Cat Integer DDL_BOM_Cat 0 16 BOMNAME_I BOM Name String STR15_LBU 15 17 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 18 MFGNOTEINDEX_I MFG Note Index Currency DLR14 14 19 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['MOP Edit MO Status Line'].NOTEINDX AS 'MOP Edit MO Status Line-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
MOP1071 AS ['MOP Edit MO Status Line']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['MOP Edit MO Status Line'].NOTEINDX = ['Record Notes Master'].NOTEINDX
20 MOISLOCKED MOIsLocked Boolean CB 0 21 QTYUNEQUAL QtyUnequal Boolean CB 0 22 HASSHORTAGE HasShortage Boolean CB 0 23 MOPMSGRESULT_1 MOP_MessageResult[1] Integer DDL_MOP_MessageMatrix 0 24 MOPMSGRESULT MOP_MessageResult DDL_MOP_MessageMatrix Integer 0 25 MOPMSGRESULT_2 MOP_MessageResult[2] Integer DDL_MOP_MessageMatrix 0 26 MOPMSGRESULT_3 MOP_MessageResult[3] Integer DDL_MOP_MessageMatrix 0 27 MOPMSGRESULT_4 MOP_MessageResult[4] Integer DDL_MOP_MessageMatrix 0 28 RUNNUMBER MRP_Run_Number Long Integer INT9 9 29 PLANNERID Planner ID String STR15_User_ID 15