Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_PTE
Product: Financial Elementz (6391)
Series: Project
Display Name: ELZ_Payment_Term_EOM
Physical Name: ELZ_PTE
Technical Name: ELZ_Payment_Term_EOMSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PYMTRMID 
Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['ELZ_Payment_Term_EOM'].PYMTRMID AS 'ELZ_Payment_Term_EOM-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ELZ_PTE AS ['ELZ_Payment_Term_EOM']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['ELZ_Payment_Term_EOM'].PYMTRMID = ['Payment Terms Master'].PYMTRMID