Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_TAXT
Product: Financial Elementz (6391)
Series: Project
Display Name: ELZ_Tax_Translation
Physical Name: ELZ_TAXT
Technical Name: ELZ_Tax_TranslationSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TAXDTLID 
Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['ELZ_Tax_Translation'].TAXDTLID AS 'ELZ_Tax_Translation-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
ELZ_TAXT AS ['ELZ_Tax_Translation']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['ELZ_Tax_Translation'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID2 STTXDTID Start Tax Detail ID String STR15_LBAU 15