Manufacturing Order List View (MOPV1100)

azurecurveProductsManufacturing (346)3rd PartyManufacturing Order List View (MOPV1100)

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: MFGMOList

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
2Language_ID SearchLanguage IDIntegerINT54
3ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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
4BOMCAT_I SearchBOM CatIntegerDDL_BOM_Cat0
5BOMCATSTR SearchBOM Cat StringStringSTR1212
6MANUFACTUREORDERST_I SearchManufacture Order StatusIntegerDDL_WO_Status0
7MOSTATUSSTR SearchMO Status StringStringSTR2020
8STRTDATE SearchStart DateDateDT8
9ENDQTY_I SearchEnd QTYCurrencyDLR_14_MRP14
10ROUTINGNAME_I SearchRoutingNameStringSTR30_Item_Number30
11JOBNUMBER_I SearchJob NumStringSTR3030
12POSTTOSITE_I SearchPost To SiteStringSTR10_Location_Code10
13ENDDATE SearchEnd DateDateDT8
14STARTQTY_I SearchStart QTYCurrencyDLR_14_MRP14
15MANUFACTUREORDPRI_I SearchManufacture Order PriorityIntegerDDL_MOP_Priority0
16MOPRIORITYSTR SearchMO Priority StringStringSTR1010
azurecurveProductsManufacturing (346)3rd PartyManufacturing Order List View (MOPV1100)

Leave a Reply

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