Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT14
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Tax Options
Physical Name: EDCVAT14
Technical Name: vatDaybookTaxOptionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TXOPTIONSID 
Tax Options ID String STR20_LBAU 20 2 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['VAT Daybook Tax Options'].TAXDTLID AS 'VAT Daybook Tax Options-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
EDCVAT14 AS ['VAT Daybook Tax Options']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['VAT Daybook Tax Options'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID3 TXOPTIONSDESC Tax Options Description String STR30 30 4 VATTAXTYPE vatDaybookTaxType Integer vatDaybookTaxType 0