Intrastat Agents (EDCEI010)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI010

Product: Enhanced Intrastat (2788)
Series: Company

Display Name: Intrastat Agents
Physical Name: EDCEI010
Technical Name: syIntrastatAgents

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1AGENTID SearchAgent IDSTR6String86
2AGENTNAME SearchAgent NameSTR30String3230
3ADRCNTCT SearchAddress ContactSTR60String6260
4ADDRESS1 SearchAddress 1STR60String6260
5ADDRESS2 SearchAddress 2STR60String6260
6ADDRESS3 SearchAddress 3STR60String6260
7CITY SearchCitySTR35String3635
8ZIPCODE SearchZip CodeSTR10String1210
9RGN SearchRegionSTR6_VATString86
10CCode SearchCountry CodeSTR6_VATString86
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'].CCode
11BRNCHIDENTF SearchBranch IdentifierSTR20String2220
12PHONE1 SearchPhone 1Phone_NumberString2214
13PHONE2 SearchPhone 2Phone_NumberString2214
14PHONE3 SearchPhone 3Phone_Number3String2214
15FAX SearchFaxSTR14_FAXString2214
16TXRGNNUM SearchTax Registration NumberSTR25String2625
17NOTEINDX SearchNote IndexDLR14Currency1014
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
18DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *