Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT03
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Calendar Line
Physical Name: EDCVAT03
Technical Name: vatDaybookCalLineSeq 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 Line'].CCode AS 'VAT Daybook Calendar Line-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT03 AS ['VAT Daybook Calendar Line']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Calendar Line'].CCode = ['VAT Country Code MSTR'].CCode2 YEAR1 Year Integer Year 4 3 PERIODID Period ID Integer INT3 3 4 PERNAME Period Name String STR20 20 5 PERIODDT Period Date Date DT_Date 6 6 RETNUM Return Number String STR16_LBAU 16 7 Date_To_Use Date_To_Use Integer DDL 0 8 RptTemplateID Rpt Template ID String STR6_VAT 6 9 DUEDATE Due Date Date DT 8