Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/VAT00400
Product: VAT Daybook (3096)
Series:
Display Name: Vat Daybook Reports Electronic Submission
Physical Name: VAT00400
Technical Name: vatDaybookReportTaxReturnSeq 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 Reports Electronic Submission'].CCode AS 'Vat Daybook Reports Electronic Submission-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
VAT00400 AS ['Vat Daybook Reports Electronic Submission']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Vat Daybook Reports Electronic Submission'].CCode = ['VAT Country Code MSTR'].CCode3 Submission_Number Submission_Number String Submission_Number 17 4 Total_Sales_Tax Total Sales Tax Currency DLR19_RBSO_UTR$ 19 5 EU_Purchases_Tax EU Purchases Tax Currency DLR19_RBSO_UTR$ 19 6 Total_Tax Total Tax Currency DLR19_RBSO_UTR$ 19 7 Total_Purchases_Tax Total Purchases Tax Currency DLR19_RBSO_UTR$ 19 8 Total_Tax_Due Total Tax Due Currency DLR19_RBSO_UTR$ 19 9 Total_Sales Total Sales Currency DLR19_RBSO_UTR$ 19 10 TOTPURCH Total Purchases Currency DLR19_RBS0_UTR$ 19 11 Total_EU_Sales Total EU Sales Currency DLR19_RBSO_UTR$ 19 12 Total_EU_Purchases Total EU Purchases Currency DLR19_RBSO_UTR$ 19 13 YEAR1 Year Integer Year 4 14 VAT_Period VatReturnPeriod Integer VatReturnPeriod 0 15 VATReturn_FileName VATReturn_FileName String STR255 255 16 STRTNGDT Starting Date Date DT 8 17 ENDINGDT Ending Date Date DT 8 18 DUEDATE Due Date Date DT 8 19 DATERECD Date Received Date DATE 6 20 PeriodKey Period Key String STR4 4 21 ObligationStatus Obligation Status String STR1 1