Profile Questionnaire Line

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

Table Type: Company

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

Table Number: 5088

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Profile Questionnaire Code]
   ,[Line No_]
   ,[Type]
   ,[Description]
   ,[Multiple Answers]
   ,[Auto Contact Classification]
   ,[Customer Class_ Field]
   ,[Vendor Class_ Field]
   ,[Contact Class_ Field]
   ,[Starting Date Formula]
   ,[Ending Date Formula]
   ,[Classification Method]
   ,[Sorting Method]
   ,[From Value]
   ,[To Value]
   ,[Priority]
   ,[No_ of Decimals]
   ,[Min_ _ Questions Answered]
   ,[Wizard Step]
   ,[Interval Option]
   ,[Answer Option]
   ,[Answer Description]
   ,[Wizard From Value]
   ,[Wizard To Value]
   ,[Wizard From Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Profile Questionnaire Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Profile Questionnaire Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Profile Questionnaire Code Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Type Searchint
5Description Searchnvarchar(500)
6Multiple Answers Searchtinyint
7Auto Contact Classification Searchtinyint
8Customer Class_ Field Searchint
9Vendor Class_ Field Searchint
10Contact Class_ Field Searchint
11Starting Date Formula Searchvarchar(32)
12Ending Date Formula Searchvarchar(32)
13Classification Method Searchint
14Sorting Method Searchint
15From Value Searchdecimal(38,38)
16To Value Searchdecimal(38,38)
17Priority Searchint
18No_ of Decimals Searchint
19Min_ _ Questions Answered Searchdecimal(38,38)
20Wizard Step Searchint
21Interval Option Searchint
22Answer Option Searchint
23Answer Description Searchnvarchar(500)
24Wizard From Value Searchdecimal(38,38)
25Wizard To Value Searchdecimal(38,38)
26Wizard From Line No_ Searchint
27$systemId Searchuniqueidentifier
28$systemCreatedAt Searchdatetime
29$systemCreatedBy Searchuniqueidentifier
30$systemModifiedAt Searchdatetime
31$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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