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 TypeLength
1AGENTID SearchAgent IDSTR6String6
2AGENTNAME SearchAgent NameSTR30String30
3ADRCNTCT SearchAddress ContactSTR60String60
4ADDRESS1 SearchAddress 1STR60String60
5ADDRESS2 SearchAddress 2STR60String60
6ADDRESS3 SearchAddress 3STR60String60
7CITY SearchCitySTR35String35
8ZIPCODE SearchZip CodeSTR10String10
9RGN SearchRegionSTR6_VATString6
10CCode SearchCountry CodeSTR6_VATString6
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 IdentifierSTR20String20
12PHONE1 SearchPhone 1Phone_NumberString14
13PHONE2 SearchPhone 2Phone_NumberString14
14PHONE3 SearchPhone 3Phone_Number3String14
15FAX SearchFaxSTR14_FAXString14
16TXRGNNUM SearchTax Registration NumberSTR25String25
17NOTEINDX SearchNote IndexDLR14Currency14
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 Searchintint10

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 *