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: 0

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
   [timestamp]
   ,[No_]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Phone No_]
   ,[Telex No_]
   ,[Territory Code]
   ,[Currency Code]
   ,[Language Code]
   ,[Salesperson Code]
   ,[Country_Region Code]
   ,[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_$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].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Contact].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Contact table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Search Name Searchnvarchar(200)
5Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Phone No_ Searchnvarchar(60)
10Telex No_ Searchnvarchar(40)
11Territory Code Searchnvarchar(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]
12Currency Code Searchnvarchar(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]
13Language Code Searchnvarchar(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]
14Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Contact].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
15Country_Region Code Searchnvarchar(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]
16Last Date Modified Searchdatetime
17Fax No_ Searchnvarchar(60)
18Telex Answer Back Searchnvarchar(40)
19VAT Registration No_ Searchnvarchar(40)
20Picture Searchimage
21Post Code Searchnvarchar(40)
22County Searchnvarchar(60)
23E-Mail Searchnvarchar(160)
24Home Page Searchnvarchar(160)
25No_ Series Searchnvarchar(40)
26Image Searchuniqueidentifier
27Privacy Blocked Searchtinyint
28Minor Searchtinyint
29Parental Consent Received Searchtinyint
30Coupled to CRM Searchtinyint
31Type Searchint
32Company No_ Searchnvarchar(40)
33Company Name Searchnvarchar(200)
34Lookup Contact No_ Searchnvarchar(40)
35First Name Searchnvarchar(60)
36Middle Name Searchnvarchar(60)
37Surname Searchnvarchar(60)
38Job Title Searchnvarchar(60)
39Initials Searchnvarchar(60)
40Extension No_ Searchnvarchar(60)
41Mobile Phone No_ Searchnvarchar(60)
42Pager Searchnvarchar(60)
43Organizational Level Code Searchnvarchar(20)
44Exclude from Segment Searchtinyint
45External ID Searchnvarchar(40)
46Business Relation Searchnvarchar(100)
47Contact Business Relation Searchint
48Correspondence Type Searchint
49Salutation Code Searchnvarchar(20)
50Search E-Mail Searchnvarchar(160)
51Last Time Modified Searchdatetime
52E-Mail 2 Searchnvarchar(160)
53Xrm Id Searchuniqueidentifier
54$systemId Searchuniqueidentifier
55$systemCreatedAt Searchdatetime
56$systemCreatedBy Searchuniqueidentifier
57$systemModifiedAt Searchdatetime
58$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Contact table

Leave a Reply

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