Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EIRS1000
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Requirement Setup
Physical Name: EIRS1000
Technical Name: EI_Requirement_SetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPADRSCODE 
CompAddrCode String STR15_Address_Code 15 2 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['Intrastat Requirement Setup'].CCode AS 'Intrastat Requirement Setup-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EIRS1000 AS ['Intrastat Requirement Setup']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Intrastat Requirement Setup'].CCode = ['VAT Country Code MSTR'].CCode3 ISREQD_1 ISRequired[1] Boolean Boolean 0 4 ISREQD ISRequired Boolean Boolean 0 5 ISREQD_2 ISRequired[2] Boolean Boolean 0 6 ISREQD_3 ISRequired[3] Boolean Boolean 0 7 ISREQD_4 ISRequired[4] Boolean Boolean 0 8 ISREQD_5 ISRequired[5] Boolean Boolean 0 9 ISREQD_6 ISRequired[6] Boolean Boolean 0 10 ISREQD_7 ISRequired[7] Boolean Boolean 0 11 ISREQD_8 ISRequired[8] Boolean Boolean 0 12 ISREQD_9 ISRequired[9] Boolean Boolean 0 13 ISREQD_10 ISRequired[10] Boolean Boolean 0 14 ISREQD_11 ISRequired[11] Boolean Boolean 0 15 ISREQD_12 ISRequired[12] Boolean Boolean 0 16 ISREQD_13 ISRequired[13] Boolean Boolean 0 17 ISREQD_14 ISRequired[14] Boolean Boolean 0 18 ISREQD_15 ISRequired[15] Boolean Boolean 0 19 ISREQD_16 ISRequired[16] Boolean Boolean 0 20 ISREQD_17 ISRequired[17] Boolean Boolean 0 21 ISREQD_18 ISRequired[18] Boolean Boolean 0