Interaction Template

Dynamics 365 BC Table ReferenceTablesCompany TablesIInteraction Template

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

Table Type: Company

Table Name: Interaction Template
Database Table Name: CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5064

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 Interaction Template can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Interaction Group Code]
   ,[Description]
   ,[Unit Cost (LCY)]
   ,[Unit Duration (Min_)]
   ,[Information Flow]
   ,[Initiated By]
   ,[Campaign No_]
   ,[Campaign Target]
   ,[Campaign Response]
   ,[Correspondence Type (Default)]
   ,[Language Code (Default)]
   ,[Wizard Action]
   ,[Ignore Contact Corres_ Type]
   ,[Word Template Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group]
      ON
         [Interaction Template].[Interaction Group Code] = [Interaction Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Interaction Template].[Language Code (Default)] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
      ON
         [Interaction Template].[Word Template Code] = [Word Template].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Template].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Interaction Template table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Interaction Group Code SearchInteraction Group CodeNormalCode10Interaction Group Codenvarchar(20)
Key to join to the Interaction Group table.

Show/hide example query

SELECT
       [Interaction Template].[Interaction Group Code]
       ,[Interaction Group].[Code]
FROM
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
       [CRONUS UK Ltd_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group]
              ON
                     [Interaction Template].[Interaction Group Code] = [Interaction Group].[Code]
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
5Unit Duration (Min.) SearchUnit Duration (Min.)NormalDecimal12Unit Duration (Min_)decimal(38,38)
6Information Flow SearchInformation FlowNormalOption4Information Flowint
Available options are:
  • ” “
  • “Outbound”
  • “Inbound”
7Initiated By SearchInitiated ByNormalOption4Initiated Byint
Available options are:
  • ” “
  • “Us”
  • “Them”
8Attachment No. SearchAttachment No.FlowFieldInteger4
9Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [Interaction Template].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [Interaction Template].[Campaign No_] = [Campaign].[No_]
10Campaign Target SearchCampaign TargetNormalBoolean4Campaign Targettinyint
11Campaign Response SearchCampaign ResponseNormalBoolean4Campaign Responsetinyint
12Correspondence Type (Default) SearchCorrespondence Type (Default)NormalOption4Correspondence Type (Default)int
Available options are:
  • ” “
  • “Hard Copy”
  • “Email”
  • “Fax”
13Date Filter SearchDate FilterFlowFilterDate4
14No. of Interactions SearchNo. of InteractionsFlowFieldInteger4
15Cost (LCY) SearchCost ($)FlowFieldDecimal12
16Duration (Min.) SearchDuration (Min.)FlowFieldDecimal12
17Language Code (Default) SearchLanguage Code (Default)NormalCode10Language Code (Default)nvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Interaction Template].[Language Code (Default)]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Interaction Template].[Language Code (Default)] = [Language].[Code]
18Wizard Action SearchWizard ActionNormalOption4Wizard Actionint
Available options are:
  • ” “
  • “Open”
  • “Import”
  • “Merge”
19Ignore Contact Corres. Type SearchIgnore Contact Corres. TypeNormalBoolean4Ignore Contact Corres_ Typetinyint
20Word Template Code SearchWord Template CodeNormalCode30Word Template Codenvarchar(60)
Key to join to the Word Template table.

Show/hide example query

SELECT
       [Interaction Template].[Word Template Code]
       ,[Word Template].[Code]
FROM
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
       [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
              ON
                     [Interaction Template].[Word Template Code] = [Word Template].[Code]
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
       [Interaction Template].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
       [User] AS [User]
              ON
                     [Interaction Template].[$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
       [Interaction Template].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
LEFT JOIN
       [User] AS [User]
              ON
                     [Interaction Template].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesIInteraction Template

Leave a Reply

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