Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI002
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Setup
Physical Name: EDCEI002
Technical Name: syIntrastatSetpSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPADRSCODE 
CompAddrCode String STR15_Address_Code 15 2 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Intrastat Setup'].LOCNCODE AS 'Intrastat Setup-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EDCEI002 AS ['Intrastat Setup']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Intrastat Setup'].LOCNCODE = ['Site Setup'].LOCNCODE3 LOCATNNM Location Name String STR30 30 4 RGN Region String STR6_VAT 6 5 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['Intrastat Setup'].CCode AS 'Intrastat Setup-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCEI002 AS ['Intrastat Setup']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Intrastat Setup'].CCode = ['VAT Country Code MSTR'].CCode6 TXRGNNUM Tax Registration Number String STR25 25 7 BRNCHNMBR Branch Number String STR20 20 8 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Intrastat Setup'].CURNCYID AS 'Intrastat Setup-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
EDCEI002 AS ['Intrastat Setup']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Intrastat Setup'].CURNCYID = ['Currency Setup'].CURNCYID9 ISAGENT IsAgent Boolean CB_IsAgent 0 10 AGENTID Agent ID String STR6 6 11 OCCDECL OccasionalDeclarant Boolean OccasionalDeclarant 0 12 UPDINTRA UpdateIntrastat Integer GB 0 13 TRANSNATURE Transaction Nature String STR6_VAT 6 14 ARVLSTD ArrivalsStd Currency DLR19_$S2 19 15 DEPARTSTD DispatchesStd Currency DLR19_$S2 19 16 ARVLEXT ArrivalsExt Currency DLR19_$S2 19 17 DEPARTEXT DispatchesExt Currency DLR19_$S2 19 18 DCLRSUBMSN DeclarationSubmission Integer GB 0 19 SUBMSNDAY SubmissionDay Integer INT2 2 20 DISPSINGLE DispatchesSingle Currency DLR19_$S2 19 21 ARRSINGLE ArrivalsSingle Currency DLR19_$S2 19 22 ALLOWINTNONIV AllowIntrastatNONIV Boolean AllowIntrastatNONIV 0 23 SINGLEDECL SingleDeclarant Boolean SingleDeclarant 0 24 SUMMNOTEDIT Summary Not Editable Boolean Boolean 0 25 DECLNUM Declarant Number Integer INT2_U0 2 26 BASETHRSLDON BaseThresholdOn Integer DDL_Allocate_By 0 27 NETMSCALC Net Mass Calculation Integer INT1 1