ECM_DPOP_State_TEMP (ECDPSTMP)

azurecurve Products Manufacturing (346)3rd PartyECM_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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	String	STR17_POP_Number	17
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	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

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

PONUMBER

PO Number

String

STR17_POP_Number

ITEMNMBR

Item Number

String

STR30_Item_Number

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

azurecurve Products Manufacturing (346)3rd PartyECM_DPOP_State_TEMP (ECDPSTMP)

Click to show/hide

Leave a Reply Cancel reply