Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI010
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Agents
Physical Name: EDCEI010
Technical Name: syIntrastatAgentsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 AGENTID 
Agent ID String STR6 6 2 AGENTNAME Agent Name String STR30 30 3 ADRCNTCT Address Contact String STR60 60 4 ADDRESS1 Address 1 String STR60 60 5 ADDRESS2 Address 2 String STR60 60 6 ADDRESS3 Address 3 String STR60 60 7 CITY City String STR35 35 8 ZIPCODE Zip Code String STR10 10 9 RGN Region String STR6_VAT 6 10 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['Intrastat Agents'].CCode AS 'Intrastat Agents-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCEI010 AS ['Intrastat Agents']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Intrastat Agents'].CCode = ['VAT Country Code MSTR'].CCode11 BRNCHIDENTF Branch Identifier String STR20 20 12 PHONE1 Phone 1 String Phone_Number 14 13 PHONE2 Phone 2 String Phone_Number 14 14 PHONE3 Phone 3 String Phone_Number3 14 15 FAX Fax String STR14_FAX 14 16 TXRGNNUM Tax Registration Number String STR25 25 17 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Intrastat Agents'].NOTEINDX AS 'Intrastat Agents-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EDCEI010 AS ['Intrastat Agents']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Intrastat Agents'].NOTEINDX = ['Record Notes Master'].NOTEINDX