Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT09
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Report Options
Physical Name: EDCVAT09
Technical Name: vatDaybookRptOptionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RPTGRNMS 
Report Group Names String STR20 20 2 VATRPTID Vat Daybook Report ID String STR8_LBAU 8 3 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['VAT Daybook Report Options'].CCode AS 'VAT Daybook Report Options-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT09 AS ['VAT Daybook Report Options']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Report Options'].CCode = ['VAT Country Code MSTR'].CCode4 Report_Description Report Description String STR30 30 5 Default_On_Vat_Viewer Default On Vat Viewer Boolean Default On VAT Viewer 0 6 Revision_Allowed Revision Allowed Boolean RevisionAllowed 0 7 RptTemplateID Rpt Template ID String STR6_VAT 6 8 RPRTTYPE Report Type Integer DDL_Report_Type 0 9 TRXTYPE Transaction Type Integer GB 0 10 STRTDATE Start Date Date DT 8 11 ENDDATE End Date Date DT 8