Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT02
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Calendar Header
Physical Name: EDCVAT02
Technical Name: vatDaybookCalHdrSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CCode 
Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['VAT Daybook Calendar Header'].CCode AS 'VAT Daybook Calendar Header-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT02 AS ['VAT Daybook Calendar Header']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Calendar Header'].CCode = ['VAT Country Code MSTR'].CCode2 YEAR1 Year Integer Year 4 3 Date_To_Use Date_To_Use Integer DDL 0 4 FSTFSCDY First Fiscal Day Date DT_Date 6 5 LSTFSCDY Last Fiscal Day Date DT_Date 6 6 NUMOFPER Number of Periods Integer INT2 2