Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI010
Product: Enhanced Intrastat (2788)
Series: Company
Display Name: Intrastat Agents DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: EDCEI010
Technical Name: syIntrastatAgentsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 AGENTID 
Agent ID STR6 String 6 2 AGENTNAME Agent Name STR30 String 30 3 ADRCNTCT Address Contact STR60 String 60 4 ADDRESS1 Address 1 STR60 String 60 5 ADDRESS2 Address 2 STR60 String 60 6 ADDRESS3 Address 3 STR60 String 60 7 CITY City STR35 String 35 8 ZIPCODE Zip Code STR10 String 10 9 RGN Region STR6_VAT String 6 10 CCode Country Code STR6_VAT String 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 STR20 String 20 12 PHONE1 Phone 1 Phone_Number String 14 13 PHONE2 Phone 2 Phone_Number String 14 14 PHONE3 Phone 3 Phone_Number3 String 14 15 FAX Fax STR14_FAX String 14 16 TXRGNNUM Tax Registration Number STR25 String 25 17 NOTEINDX Note Index DLR14 Currency 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'].NOTEINDX18 DEX_ROW_ID int int 10