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

Show/hide an example select of all columns by name

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

Show/hide columns in Contact table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Name Primary Key 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

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

22Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

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

35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
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

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

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

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

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
Key to join to the Salesperson/Purchaser table.

Show/hide example query

5085Campaign Filter SearchCampaign FilterFlowFilterCode20
Key to join to the Campaign table.

Show/hide example query

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
Key to join to the Sales Cycle table.

Show/hide example query

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
Key to join to the Team table.

Show/hide example query

5099Close Opportunity Filter SearchClose Opportunity FilterFlowFilterCode10
Key to join to the Close Opportunity Code table.

Show/hide example query

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

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
Key to join to the Job Responsibility table.

Show/hide example query

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

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Contact table

Leave a Reply

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