Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT05
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Header
Physical Name: EDCVAT05
Technical Name: vatDaybookHdrSeq 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 Header'].CCode AS 'VAT Daybook Header-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT05 AS ['VAT Daybook Header']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Header'].CCode = ['VAT Country Code MSTR'].CCode3 VATCOLCD Vat Column Code String STR3_LBAU 3 4 Vat_Description1 Vat Description1 String STR30 30 5 Vat_Description2 Vat Description2 String STR30 30 6 SERIES Series Integer DDL_Series 0