Profile Questionnaire Line

Dynamics 365 BC Table ReferenceTablesCompany TablesPProfile 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

   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Profile Questionnaire Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Line]
LEFT JOIN
   [CRONUS UK Ltd_$Profile Questionnaire Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Header]
      ON
         [Profile Questionnaire Line].[Profile Questionnaire Code] = [Profile Questionnaire Header].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Profile Questionnaire Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Profile Questionnaire Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Profile Questionnaire Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Profile Questionnaire Code Primary Key SearchProfile Questionnaire CodeNormalCode20Profile Questionnaire Codenvarchar(40)
Key to join to the Profile Questionnaire Header table.

Show/hide example query

SELECT
       [Profile Questionnaire Line].[Profile Questionnaire Code]
       ,[Profile Questionnaire Header].[Code]
FROM
       [CRONUS UK Ltd_$Profile Questionnaire Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Line]
LEFT JOIN
       [CRONUS UK Ltd_$Profile Questionnaire Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Header]
              ON
                     [Profile Questionnaire Line].[Profile Questionnaire Code] = [Profile Questionnaire Header].[Code]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Type SearchTypeNormalOption4Typeint
Available options are:
  • “Question”
  • “Answer”
4Description SearchDescriptionNormalText250Descriptionnvarchar(500)
5Multiple Answers SearchMultiple AnswersNormalBoolean4Multiple Answerstinyint
6Auto Contact Classification SearchAuto Contact ClassificationNormalBoolean4Auto Contact Classificationtinyint
7Customer Class. Field SearchCustomer Class. FieldNormalOption4Customer Class_ Fieldint
Available options are:
  • ” “
  • “Sales (LCY)”
  • “Profit (LCY)”
  • “Sales Frequency (Invoices/Year)”
  • “Avg. Invoice Amount (LCY)”
  • “Discount (%)”
  • “Avg. Overdue (Day)”
8Vendor Class. Field SearchVendor Class. FieldNormalOption4Vendor Class_ Fieldint
Available options are:
  • ” “
  • “Purchase (LCY)”
  • “Purchase Frequency (Invoices/Year)”
  • “Avg. Ticket Size (LCY)”
  • “Discount (%)”
  • “Avg. Overdue (Day)”
9Contact Class. Field SearchContact Class. FieldNormalOption4Contact Class_ Fieldint
Available options are:
  • ” “
  • “Interaction Quantity”
  • “Interaction Frequency (No./Year)”
  • “Avg. Interaction Cost (LCY)”
  • “Avg. Interaction Duration (Min.)”
  • “Opportunity Won (%)”
  • “Rating”
10Starting Date Formula SearchStarting Date FormulaNormalDateFormula32Starting Date Formulavarchar(32)
11Ending Date Formula SearchEnding Date FormulaNormalDateFormula32Ending Date Formulavarchar(32)
12Classification Method SearchClassification MethodNormalOption4Classification Methodint
Available options are:
  • ” “
  • “Defined Value”
  • “Percentage of Value”
  • “Percentage of Contacts”
13Sorting Method SearchSorting MethodNormalOption4Sorting Methodint
Available options are:
  • ” “
  • “Descending”
  • “Ascending”
14From Value SearchFrom ValueNormalDecimal12From Valuedecimal(38,38)
15To Value SearchTo ValueNormalDecimal12To Valuedecimal(38,38)
16No. of Contacts SearchNo. of ContactsFlowFieldInteger4
17Priority SearchPriorityNormalOption4Priorityint
Available options are:
  • “Very Low (Hidden)”
  • “Low”
  • “Normal”
  • “High”
  • “Very High”
18No. of Decimals SearchNo. of DecimalsNormalInteger4No_ of Decimalsint
19Min. % Questions Answered SearchMin. % Questions AnsweredNormalDecimal12Min_ _ Questions Answereddecimal(38,38)
9501Wizard Step SearchWizard StepNormalOption4Wizard Stepint
Available options are:
  • ” “
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
9502Interval Option SearchInterval OptionNormalOption4Interval Optionint
Available options are:
  • “Minimum”
  • “Maximum”
  • “Interval”
9503Answer Option SearchAnswer OptionNormalOption4Answer Optionint
Available options are:
  • “HighLow”
  • “ABC”
  • “Custom”
9504Answer Description SearchAnswer DescriptionNormalText250Answer Descriptionnvarchar(500)
9505Wizard From Value SearchWizard From ValueNormalDecimal12Wizard From Valuedecimal(38,38)
9506Wizard To Value SearchWizard To ValueNormalDecimal12Wizard To Valuedecimal(38,38)
9707Wizard From Line No. SearchWizard From Line No.NormalInteger4Wizard From Line No_int
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
       [Profile Questionnaire Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Profile Questionnaire Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Profile Questionnaire Line].[$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
       [Profile Questionnaire Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Profile Questionnaire Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Profile Questionnaire Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Profile Questionnaire Line].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesPProfile Questionnaire Line

Leave a Reply

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