Contact Profile Answer

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

Table Type: Company

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

Table Number: 5089

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 Profile Answer can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Contact No_]
   ,[Contact Company No_]
   ,[Profile Questionnaire Code]
   ,[Line No_]
   ,[Profile Questionnaire Priority]
   ,[Answer Priority]
   ,[Last Date Updated]
   ,[Questions Answered (_)]
   ,[Profile Questionnaire Value]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Contact Profile Answer$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 Profile Answer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Profile Answer]
LEFT JOIN
   [CRONUS UK Ltd_$Profile Questionnaire Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Header]
      ON
         [Contact Profile Answer].[Profile Questionnaire Code] = [Profile Questionnaire Header].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Contact Profile Answer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Contact Profile Answer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Contact Profile Answer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Contact No. Primary Key SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Contact Profile Answer].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Contact Profile Answer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Profile Answer]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Contact Profile Answer].[Contact No_] = [Contact].[No_]
2Contact Company No. SearchContact Company No.NormalCode20Contact Company No_nvarchar(40)
3Profile Questionnaire Code Primary Key SearchProfile Questionnaire CodeNormalCode20Profile Questionnaire Codenvarchar(40)
Key to join to the Profile Questionnaire Header table.

Show/hide example query

SELECT
       [Contact Profile Answer].[Profile Questionnaire Code]
       ,[Profile Questionnaire Header].[Code]
FROM
       [CRONUS UK Ltd_$Contact Profile Answer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Profile Answer]
LEFT JOIN
       [CRONUS UK Ltd_$Profile Questionnaire Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Header]
              ON
                     [Contact Profile Answer].[Profile Questionnaire Code] = [Profile Questionnaire Header].[Code]
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Answer SearchAnswerFlowFieldText250
6Contact Company Name SearchContact Company NameFlowFieldText100
7Contact Name SearchContact NameFlowFieldText100
8Profile Questionnaire Priority SearchProfile Questionnaire PriorityNormalOption4Profile Questionnaire Priorityint
Available options are:
  • “Very Low”
  • “Low”
  • “Normal”
  • “High”
  • “Very High”
9Answer Priority SearchAnswer PriorityNormalOption4Answer Priorityint
Available options are:
  • “Very Low (Hidden)”
  • “Low”
  • “Normal”
  • “High”
  • “Very High”
10Last Date Updated SearchLast Date UpdatedNormalDate4Last Date Updateddatetime
11Questions Answered (%) SearchQuestions Answered (%)NormalDecimal12Questions Answered (_)decimal(38,38)
5088Profile Questionnaire Value SearchProfile Questionnaire ValueNormalText250Profile Questionnaire Valuenvarchar(500)
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 Profile Answer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Contact Profile Answer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Profile Answer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Contact Profile Answer].[$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 Profile Answer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Contact Profile Answer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Profile Answer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Contact Profile Answer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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