Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT30
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Declaration Header
Physical Name: EDCVAT30
Technical Name: vatDaybookDeclarationHDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 vatDbkDeclType 
vatDbkDeclType Integer vatDbkDDL_DeclType 0 2 vatDbkDeclNumber vatDbkDeclNumber String vatDbkSTR11_LBAU 11 3 vatDbkRespMesgID vatDbkRespMessageID String STR64 64 4 vatDbkDeclMsgVer vatDbkDeclMessageVersion String STR64 64 5 vatDbkDeclStatus vatDbkDeclStatus Integer vatDbkDDL_DeclStatus 0 6 vatDbkDeclYear vatDbkDeclYear Integer Year 4 7 VATNLRPTPERIOD vatDaybookRptPeriod Integer ReportingPeriod 0 8 vatDbkDeclPeriod vatDbkDeclPeriod Integer INT3 3 9 vatDbkDeclDtCreated vatDbkDeclDateCreated Date DT 8 10 vatDbkDeclTmCreated vatDbkDeclTimeCreated Time TM6 6 11 vatDbkDeclCreatedBy vatDbkDeclCreatedBy String User_ID 15 12 VATRPTID Vat Daybook Report ID String STR8_LBAU 8 13 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['VAT Daybook Declaration Header'].CCode AS 'VAT Daybook Declaration Header-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT30 AS ['VAT Daybook Declaration Header']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Declaration Header'].CCode = ['VAT Country Code MSTR'].CCode