Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT18
Product: VAT Daybook (3096)
Series:
Display Name: VAT Daybook Summary BELGIUM
Physical Name: EDCVAT18
Technical Name: vatDaybookSummaryBELGIUMSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VATRPTID 
Vat Daybook Report ID String STR8_LBAU 8 2 RptTemplateID Rpt Template ID String STR6_VAT 6 3 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['VAT Daybook Summary BELGIUM'].CCode AS 'VAT Daybook Summary BELGIUM-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCVAT18 AS ['VAT Daybook Summary BELGIUM']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT Daybook Summary BELGIUM'].CCode = ['VAT Country Code MSTR'].CCode4 YEAR1 Year Integer Year 4 5 PERIODID Period ID Integer INT3 3 6 vatColCodeAmtSalesArray vatColCodeAmtSalesArray DLR17_RBSO_UTR$ Currency 17 7 vatColCodeAmtSalesArray_1 vatColCodeAmtSalesArray[1] Currency DLR17_RBSO_UTR$ 17 8 vatColCodeAmtPurArray vatColCodeAmtPurArray DLR17_RBSO_UTR$ Currency 17 9 vatColCodeAmtSalesArray_2 vatColCodeAmtSalesArray[2] Currency DLR17_RBSO_UTR$ 17 10 vatColCodeAmtSalesArray_3 vatColCodeAmtSalesArray[3] Currency DLR17_RBSO_UTR$ 17 11 vatColCodeAmtSalesArray_4 vatColCodeAmtSalesArray[4] Currency DLR17_RBSO_UTR$ 17 12 vatColCodeAmtSalesArray_5 vatColCodeAmtSalesArray[5] Currency DLR17_RBSO_UTR$ 17 13 vatColCodeAmtSalesArray_6 vatColCodeAmtSalesArray[6] Currency DLR17_RBSO_UTR$ 17 14 vatColCodeAmtSalesArray_7 vatColCodeAmtSalesArray[7] Currency DLR17_RBSO_UTR$ 17 15 vatColCodeAmtSalesArray_8 vatColCodeAmtSalesArray[8] Currency DLR17_RBSO_UTR$ 17 16 vatColCodeAmtSalesArray_9 vatColCodeAmtSalesArray[9] Currency DLR17_RBSO_UTR$ 17 17 vatColCodeAmtSalesArray_10 vatColCodeAmtSalesArray[10] Currency DLR17_RBSO_UTR$ 17 18 vatColCodeAmtSalesArray_11 vatColCodeAmtSalesArray[11] Currency DLR17_RBSO_UTR$ 17 19 vatColCodeAmtSalesArray_12 vatColCodeAmtSalesArray[12] Currency DLR17_RBSO_UTR$ 17 20 vatColCodeAmtSalesArray_13 vatColCodeAmtSalesArray[13] Currency DLR17_RBSO_UTR$ 17 21 vatColCodeAmtSalesArray_14 vatColCodeAmtSalesArray[14] Currency DLR17_RBSO_UTR$ 17 22 vatColCodeAmtSalesArray_15 vatColCodeAmtSalesArray[15] Currency DLR17_RBSO_UTR$ 17 23 vatColCodeAmtSalesArray_16 vatColCodeAmtSalesArray[16] Currency DLR17_RBSO_UTR$ 17 24 vatColCodeAmtSalesArray_17 vatColCodeAmtSalesArray[17] Currency DLR17_RBSO_UTR$ 17 25 vatColCodeAmtSalesArray_18 vatColCodeAmtSalesArray[18] Currency DLR17_RBSO_UTR$ 17 26 vatColCodeAmtSalesArray_19 vatColCodeAmtSalesArray[19] Currency DLR17_RBSO_UTR$ 17 27 vatColCodeAmtSalesArray_20 vatColCodeAmtSalesArray[20] Currency DLR17_RBSO_UTR$ 17 28 vatColCodeAmtSalesArray_21 vatColCodeAmtSalesArray[21] Currency DLR17_RBSO_UTR$ 17 29 vatColCodeAmtSalesArray_22 vatColCodeAmtSalesArray[22] Currency DLR17_RBSO_UTR$ 17 30 vatColCodeAmtSalesArray_23 vatColCodeAmtSalesArray[23] Currency DLR17_RBSO_UTR$ 17 31 vatColCodeAmtSalesArray_24 vatColCodeAmtSalesArray[24] Currency DLR17_RBSO_UTR$ 17 32 vatColCodeAmtSalesArray_25 vatColCodeAmtSalesArray[25] Currency DLR17_RBSO_UTR$ 17 33 vatColCodeAmtSalesArray_26 vatColCodeAmtSalesArray[26] Currency DLR17_RBSO_UTR$ 17 34 vatColCodeAmtSalesArray_27 vatColCodeAmtSalesArray[27] Currency DLR17_RBSO_UTR$ 17 35 vatColCodeAmtSalesArray_28 vatColCodeAmtSalesArray[28] Currency DLR17_RBSO_UTR$ 17 36 vatColCodeAmtSalesArray_29 vatColCodeAmtSalesArray[29] Currency DLR17_RBSO_UTR$ 17 37 vatColCodeAmtSalesArray_30 vatColCodeAmtSalesArray[30] Currency DLR17_RBSO_UTR$ 17 38 vatColCodeAmtPurArray_1 vatColCodeAmtPurArray[1] Currency DLR17_RBSO_UTR$ 17 39 vatColCodeAmtPurArray_2 vatColCodeAmtPurArray[2] Currency DLR17_RBSO_UTR$ 17 40 vatColCodeAmtPurArray_3 vatColCodeAmtPurArray[3] Currency DLR17_RBSO_UTR$ 17 41 vatColCodeAmtPurArray_4 vatColCodeAmtPurArray[4] Currency DLR17_RBSO_UTR$ 17 42 vatColCodeAmtPurArray_5 vatColCodeAmtPurArray[5] Currency DLR17_RBSO_UTR$ 17 43 vatColCodeAmtPurArray_6 vatColCodeAmtPurArray[6] Currency DLR17_RBSO_UTR$ 17 44 vatColCodeAmtPurArray_7 vatColCodeAmtPurArray[7] Currency DLR17_RBSO_UTR$ 17 45 vatColCodeAmtPurArray_8 vatColCodeAmtPurArray[8] Currency DLR17_RBSO_UTR$ 17 46 vatColCodeAmtPurArray_9 vatColCodeAmtPurArray[9] Currency DLR17_RBSO_UTR$ 17 47 vatColCodeAmtPurArray_10 vatColCodeAmtPurArray[10] Currency DLR17_RBSO_UTR$ 17 48 vatColCodeAmtPurArray_11 vatColCodeAmtPurArray[11] Currency DLR17_RBSO_UTR$ 17 49 vatColCodeAmtPurArray_12 vatColCodeAmtPurArray[12] Currency DLR17_RBSO_UTR$ 17 50 vatColCodeAmtPurArray_13 vatColCodeAmtPurArray[13] Currency DLR17_RBSO_UTR$ 17 51 vatColCodeAmtPurArray_14 vatColCodeAmtPurArray[14] Currency DLR17_RBSO_UTR$ 17 52 vatColCodeAmtPurArray_15 vatColCodeAmtPurArray[15] Currency DLR17_RBSO_UTR$ 17 53 vatColCodeAmtPurArray_16 vatColCodeAmtPurArray[16] Currency DLR17_RBSO_UTR$ 17 54 vatColCodeAmtPurArray_17 vatColCodeAmtPurArray[17] Currency DLR17_RBSO_UTR$ 17 55 vatColCodeAmtPurArray_18 vatColCodeAmtPurArray[18] Currency DLR17_RBSO_UTR$ 17 56 vatColCodeAmtPurArray_19 vatColCodeAmtPurArray[19] Currency DLR17_RBSO_UTR$ 17 57 vatColCodeAmtPurArray_20 vatColCodeAmtPurArray[20] Currency DLR17_RBSO_UTR$ 17 58 vatColCodeAmtPurArray_21 vatColCodeAmtPurArray[21] Currency DLR17_RBSO_UTR$ 17 59 vatColCodeAmtPurArray_22 vatColCodeAmtPurArray[22] Currency DLR17_RBSO_UTR$ 17 60 vatColCodeAmtPurArray_23 vatColCodeAmtPurArray[23] Currency DLR17_RBSO_UTR$ 17 61 vatColCodeAmtPurArray_24 vatColCodeAmtPurArray[24] Currency DLR17_RBSO_UTR$ 17 62 vatColCodeAmtPurArray_25 vatColCodeAmtPurArray[25] Currency DLR17_RBSO_UTR$ 17 63 vatColCodeAmtPurArray_26 vatColCodeAmtPurArray[26] Currency DLR17_RBSO_UTR$ 17 64 vatColCodeAmtPurArray_27 vatColCodeAmtPurArray[27] Currency DLR17_RBSO_UTR$ 17 65 vatColCodeAmtPurArray_28 vatColCodeAmtPurArray[28] Currency DLR17_RBSO_UTR$ 17 66 vatColCodeAmtPurArray_29 vatColCodeAmtPurArray[29] Currency DLR17_RBSO_UTR$ 17 67 vatColCodeAmtPurArray_30 vatColCodeAmtPurArray[30] Currency DLR17_RBSO_UTR$ 17