Contact

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5050

Table Type: Company

Table Name: Contact
Database Table Name: CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5050

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Contact can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Phone No_]
   ,[Telex No_]
   ,[Territory Code]
   ,[Currency Code]
   ,[Language Code]
   ,[Registration Number]
   ,[Salesperson Code]
   ,[Country_Region Code]
   ,[Format Region]
   ,[Last Date Modified]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[VAT Registration No_]
   ,[Picture]
   ,[Post Code]
   ,[County]
   ,[E-Mail]
   ,[Home Page]
   ,[No_ Series]
   ,[Image]
   ,[Privacy Blocked]
   ,[Minor]
   ,[Parental Consent Received]
   ,[Coupled to CRM]
   ,[Type]
   ,[Company No_]
   ,[Company Name]
   ,[Lookup Contact No_]
   ,[First Name]
   ,[Middle Name]
   ,[Surname]
   ,[Job Title]
   ,[Initials]
   ,[Extension No_]
   ,[Mobile Phone No_]
   ,[Pager]
   ,[Organizational Level Code]
   ,[Exclude from Segment]
   ,[External ID]
   ,[Business Relation]
   ,[Contact Business Relation]
   ,[Correspondence Type]
   ,[Salutation Code]
   ,[Search E-Mail]
   ,[Last Time Modified]
   ,[E-Mail 2]
   ,[Xrm Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Contact].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Contact].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Contact].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Contact].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Contact].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Contact].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Contact].[Company Name] = [Company].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Organizational Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Organizational Level]
      ON
         [Contact].[Organizational Level Code] = [Organizational Level].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Contact].[Salesperson Filter] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
      ON
         [Contact].[Campaign Filter] = [Campaign].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [Contact].[Sales Cycle Filter] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
      ON
         [Contact].[Team Filter] = [Team].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Close Opportunity Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Close Opportunity Code]
      ON
         [Contact].[Close Opportunity Filter] = [Close Opportunity Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salutation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salutation]
      ON
         [Contact].[Salutation Code] = [Salutation].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Responsibility$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Responsibility]
      ON
         [Contact].[Job Responsibility Filter] = [Job Responsibility].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Contact].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Contact].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Contact table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Name SearchNameNormalText100Namenvarchar(200)
3Search Name SearchSearch NameNormalCode100Search Namenvarchar(200)
4Name 2 SearchName 2NormalText50Name 2nvarchar(100)
5Address SearchAddressNormalText100Addressnvarchar(200)
6Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
7City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Contact].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Contact].[City] = [Post Code].[City]
9Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
10Telex No. SearchTelex No.NormalText20Telex No_nvarchar(40)
15Territory Code SearchTerritory CodeNormalCode10Territory Codenvarchar(20)
Key to join to the Territory table.

Show/hide example query

SELECT
       [Contact].[Territory Code]
       ,[Territory].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
              ON
                     [Contact].[Territory Code] = [Territory].[Code]
22Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Contact].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Contact].[Currency Code] = [Currency].[Code]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Contact].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Contact].[Language Code] = [Language].[Code]
25Registration Number SearchRegistration No.NormalText50Registration Numbernvarchar(100)
29Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Contact].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Contact].[Salesperson Code] = [Salesperson/Purchaser].[Code]
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Contact].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Contact].[Country_Region Code] = [Country/Region].[Code]
38Comment SearchCommentFlowFieldBoolean4
48Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
54Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
84Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
85Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
86VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
89Picture SearchPictureNormalBLOB8Pictureimage
91Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Contact].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Contact].[Post Code] = [Post Code].[Code]
92County SearchStateNormalText30Countynvarchar(60)
102E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
103Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Contact].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Contact].[No_ Series] = [No. Series].[Code]
140Image SearchImageNormalMedia16Imageuniqueidentifier
150Privacy Blocked SearchPrivacy BlockedNormalBoolean4Privacy Blockedtinyint
151Minor SearchMinorNormalBoolean4Minortinyint
152Parental Consent Received SearchParental Consent ReceivedNormalBoolean4Parental Consent Receivedtinyint
720Coupled to CRM SearchCoupled to DataverseNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to DataverseFlowFieldBoolean4
5050Type SearchTypeNormalOption4Typeint
Available options are:
  • “Company”
  • “Person”
5051Company No. SearchCompany No.NormalCode20Company No_nvarchar(40)
5052Company Name SearchCompany NameNormalText100Company Namenvarchar(200)
Key to join to the Company table.

Show/hide example query

SELECT
       [Contact].[Company Name]
       ,[Company].[Name]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [Company] AS [Company]
              ON
                     [Contact].[Company Name] = [Company].[Name]
5053Lookup Contact No. SearchLookup Contact No.NormalCode20Lookup Contact No_nvarchar(40)
5054First Name SearchFirst NameNormalText30First Namenvarchar(60)
5055Middle Name SearchMiddle NameNormalText30Middle Namenvarchar(60)
5056Surname SearchSurnameNormalText30Surnamenvarchar(60)
5058Job Title SearchJob TitleNormalText30Job Titlenvarchar(60)
5059Initials SearchInitialsNormalText30Initialsnvarchar(60)
5060Extension No. SearchExtension No.NormalText30Extension No_nvarchar(60)
5061Mobile Phone No. SearchMobile Phone No.NormalText30Mobile Phone No_nvarchar(60)
5062Pager SearchPagerNormalText30Pagernvarchar(60)
5063Organizational Level Code SearchOrganizational Level CodeNormalCode10Organizational Level Codenvarchar(20)
Key to join to the Organizational Level table.

Show/hide example query

SELECT
       [Contact].[Organizational Level Code]
       ,[Organizational Level].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Organizational Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Organizational Level]
              ON
                     [Contact].[Organizational Level Code] = [Organizational Level].[Code]
5064Exclude from Segment SearchExclude from SegmentNormalBoolean4Exclude from Segmenttinyint
5065Date Filter SearchDate FilterFlowFilterDate4
5066Next Task Date SearchNext Task DateFlowFieldDate4
5067Last Date Attempted SearchLast Date AttemptedFlowFieldDate4
5068Date of Last Interaction SearchDate of Last InteractionFlowFieldDate4
5069No. of Job Responsibilities SearchNo. of Job ResponsibilitiesFlowFieldInteger4
5070No. of Industry Groups SearchNo. of Industry GroupsFlowFieldInteger4
5071No. of Business Relations SearchNo. of Business RelationsFlowFieldInteger4
5072No. of Mailing Groups SearchNo. of Mailing GroupsFlowFieldInteger4
5073External ID SearchExternal IDNormalCode20External IDnvarchar(40)
5074No. of Interactions SearchNo. of InteractionsFlowFieldInteger4
5075Business Relation SearchBusiness RelationNormalText50Business Relationnvarchar(100)
5076Cost (LCY) SearchCost ($)FlowFieldDecimal12
5077Duration (Min.) SearchDuration (Min.)FlowFieldDecimal12
5078No. of Opportunities SearchNo. of OpportunitiesFlowFieldInteger4
5079Estimated Value (LCY) SearchEstimated Value ($)FlowFieldDecimal12
5080Calcd. Current Value (LCY) SearchCalcd. Current Value ($)FlowFieldDecimal12
5082Opportunity Entry Exists SearchOpportunity Entry ExistsFlowFieldBoolean4
5083Task Entry Exists SearchTask Entry ExistsFlowFieldBoolean4
5084Salesperson Filter SearchSalesperson FilterFlowFilterCode20
5085Campaign Filter SearchCampaign FilterFlowFilterCode20
5086Contact Business Relation SearchContact Business RelationNormalOption4Contact Business Relationint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Employee”
  • “None”
  • “Other”
  • “Multiple”
5087Action Taken Filter SearchAction Taken FilterFlowFilterOption4
5088Sales Cycle Filter SearchSales Cycle FilterFlowFilterCode10
5089Sales Cycle Stage Filter SearchSales Cycle Stage FilterFlowFilterInteger4
5090Probability % Filter SearchProbability % FilterFlowFilterDecimal12
5091Completed % Filter SearchCompleted % FilterFlowFilterDecimal12
5092Estimated Value Filter SearchEstimated Value FilterFlowFilterDecimal12
5093Calcd. Current Value Filter SearchCalcd. Current Value FilterFlowFilterDecimal12
5094Chances of Success % Filter SearchChances of Success % FilterFlowFilterDecimal12
5095Task Status Filter SearchTask Status FilterFlowFilterOption4
5096Task Closed Filter SearchTask Closed FilterFlowFilterBoolean4
5097Priority Filter SearchPriority FilterFlowFilterOption4
5098Team Filter SearchTeam FilterFlowFilterCode10
5099Close Opportunity Filter SearchClose Opportunity FilterFlowFilterCode10
5100Correspondence Type SearchCorrespondence TypeNormalOption4Correspondence Typeint
Available options are:
  • ” “
  • “Hard Copy”
  • “Email”
  • “Fax”
5101Salutation Code SearchSalutation CodeNormalCode10Salutation Codenvarchar(20)
Key to join to the Salutation table.

Show/hide example query

SELECT
       [Contact].[Salutation Code]
       ,[Salutation].[Code]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [CRONUS UK Ltd_$Salutation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salutation]
              ON
                     [Contact].[Salutation Code] = [Salutation].[Code]
5102Search E-Mail SearchSearch EmailNormalCode80Search E-Mailnvarchar(160)
5104Last Time Modified SearchLast Time ModifiedNormalTime4Last Time Modifieddatetime
5105E-Mail 2 SearchEmail 2NormalText80E-Mail 2nvarchar(160)
5106Job Responsibility Filter SearchJob Responsibility FilterFlowFilterCode10
8050Xrm Id SearchXrm IdNormalGUID16Xrm Iduniqueidentifier
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Contact].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [User] AS [User]
              ON
                     [Contact].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Contact].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
LEFT JOIN
       [User] AS [User]
              ON
                     [Contact].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Contact table

Leave a Reply

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