Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOPV1100
Product: Manufacturing (346)
Series:
Display Name: Manufacturing Order List View
Physical Name: MOPV1100
Technical Name: MFGMOListSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MANUFACTUREORDER_I Manufacture Order String STR30_UC 30 2 Language_ID Language ID Integer INT5 4 3 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Manufacturing Order List View'].ITEMNMBR AS 'Manufacturing Order List View-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOPV1100 AS ['Manufacturing Order List View']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Manufacturing Order List View'].ITEMNMBR = ['Item Master'].ITEMNMBR
4 BOMCAT_I BOM Cat Integer DDL_BOM_Cat 0 5 BOMCATSTR BOM Cat String String STR12 12 6 MANUFACTUREORDERST_I Manufacture Order Status Integer DDL_WO_Status 0 7 MOSTATUSSTR MO Status String String STR20 20 8 STRTDATE Start Date Date DT 8 9 ENDQTY_I End QTY Currency DLR_14_MRP 14 10 ROUTINGNAME_I RoutingName String STR30_Item_Number 30 11 JOBNUMBER_I Job Num String STR30 30 12 POSTTOSITE_I Post To Site String STR10_Location_Code 10 13 ENDDATE End Date Date DT 8 14 STARTQTY_I Start QTY Currency DLR_14_MRP 14 15 MANUFACTUREORDPRI_I Manufacture Order Priority Integer DDL_MOP_Priority 0 16 MOPRIORITYSTR MO Priority String String STR10 10