Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT40
Product: VAT Daybook (3096)
Series:
Display Name: vatDaybook ReverseCharge TaxDetail Setup
Physical Name: EDCVAT40
Technical Name: vatDaybookRCTaxSetupSeq 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
['vatDaybook ReverseCharge TaxDetail Setup'].TAXDTLID AS 'vatDaybook ReverseCharge TaxDetail Setup-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
EDCVAT40 AS ['vatDaybook ReverseCharge TaxDetail Setup']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['vatDaybook ReverseCharge TaxDetail Setup'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID2 TXDTLTYP Tax Detail Type Integer DDL_Tax_Detail_Type 0 3 RCTAXDTLID RC Tax Detail ID String STR15_Tax_Detail_ID 15