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
   [timestamp]
   ,[Contact No_]
   ,[Profile Questionnaire Code]
   ,[Line No_]
   ,[Contact Company 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 columns in Contact Profile Answer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Contact No_ Primary Key Searchnvarchar(40)
3Profile Questionnaire Code Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Contact Company No_ Searchnvarchar(40)
6Profile Questionnaire Priority Searchint
7Answer Priority Searchint
8Last Date Updated Searchdatetime
9Questions Answered (_) Searchdecimal(38,38)
10Profile Questionnaire Value Searchnvarchar(500)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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