Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT22
Product: VAT Daybook (3096)
Series:
Display Name: vatDaybookITCColumnCode
Physical Name: EDCVAT22
Technical Name: vatDaybookITCColumnCodeSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VATRPTID 
Vat Daybook Report ID String STR8_LBAU 8 2 VATCOLCD Vat Column Code String STR3_LBAU 3 3 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['vatDaybookITCColumnCode'].TAXDTLID AS 'vatDaybookITCColumnCode-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
EDCVAT22 AS ['vatDaybookITCColumnCode']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['vatDaybookITCColumnCode'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID4 vatDbkITCClaimRate vatDbkITCClaimRate Currency DLR5_%2 8