Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT06
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Line
Physical Name: EDCVAT06
Technical Name: vatDaybookLineSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VATRPTID 
Vat Daybook Report ID String STR8_LBAU 8 2 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['VAT Daybook Line'].CCode AS 'VAT Daybook Line-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT06 AS ['VAT Daybook Line']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Line'].CCode = ['VAT Country Code MSTR'].CCode3 VATCOLCD Vat Column Code String STR3_LBAU 3 4 SERIES Series Integer DDL_Series 0 5 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 Line'].TAXDTLID AS 'VAT Daybook Line-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
EDCVAT06 AS ['VAT Daybook Line']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['VAT Daybook Line'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID6 TXDTLDSC Tax Detail Description String STR30 30 7 AMTTYP Amount Type Integer Amount Type 0 8 DocType Doc Type Integer Vat Doc Type 0