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 SQL DB Length Keyable Length 1 AGENTID 
Agent ID STR6 String 8 6 2 AGENTNAME Agent Name STR30 String 32 30 3 ADRCNTCT Address Contact STR60 String 62 60 4 ADDRESS1 Address 1 STR60 String 62 60 5 ADDRESS2 Address 2 STR60 String 62 60 6 ADDRESS3 Address 3 STR60 String 62 60 7 CITY City STR35 String 36 35 8 ZIPCODE Zip Code STR10 String 12 10 9 RGN Region STR6_VAT String 8 6 10 CCode Country Code STR6_VAT String 8 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 22 20 12 PHONE1 Phone 1 Phone_Number String 22 14 13 PHONE2 Phone 2 Phone_Number String 22 14 14 PHONE3 Phone 3 Phone_Number3 String 22 14 15 FAX Fax STR14_FAX String 22 14 16 TXRGNNUM Tax Registration Number STR25 String 26 25 17 NOTEINDX Note Index DLR14 Currency 10 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 10