Interaction 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: 0

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
   [timestamp]
   ,[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 columns in Interaction Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Interaction Group Code Searchnvarchar(20)
4Description Searchnvarchar(200)
5Unit Cost (LCY) Searchdecimal(38,38)
6Unit Duration (Min_) Searchdecimal(38,38)
7Information Flow Searchint
8Initiated By Searchint
9Campaign No_ Searchnvarchar(40)
10Campaign Target Searchtinyint
11Campaign Response Searchtinyint
12Correspondence Type (Default) Searchint
13Language Code (Default) Searchnvarchar(20)
14Wizard Action Searchint
15Ignore Contact Corres_ Type Searchtinyint
16Word Template Code Searchnvarchar(60)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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