ECM_DPOP_State_TEMP (ECDPSTMP)

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

Product: Manufacturing (346)
Series:

Display Name: ECM_DPOP_State_TEMP
Physical Name: ECDPSTMP
Technical Name: ECM_DPOP_State_TEMP

Group Display Name: Manufacturing ECM
Group Technical Name: Manufacturing ECM

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PONUMBER SearchPO NumberStringSTR17_POP_Number17
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['ECM_DPOP_State_TEMP'].ITEMNMBR AS 'ECM_DPOP_State_TEMP-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ECDPSTMP AS ['ECM_DPOP_State_TEMP']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['ECM_DPOP_State_TEMP'].ITEMNMBR = ['Item Master'].ITEMNMBR

Leave a Reply

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