Interaction Template Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInteraction Template Setup

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

Table Type: Company

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

Table Number: 5122

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Sales Invoices]
   ,[Sales Cr_ Memo]
   ,[Sales Ord_ Cnfrmn_]
   ,[Sales Quotes]
   ,[Purch Invoices]
   ,[Purch Cr Memos]
   ,[Purch_ Orders]
   ,[Purch_ Quotes]
   ,[E-Mails]
   ,[Cover Sheets]
   ,[Outg_ Calls]
   ,[Sales Blnkt_ Ord]
   ,[Serv Ord Post]
   ,[Sales Shpt_ Note]
   ,[Sales Statement]
   ,[Sales Rmdr_]
   ,[Serv Ord Create]
   ,[Purch Blnkt Ord]
   ,[Purch_ Rcpt_]
   ,[Sales Return Order]
   ,[Sales Return Receipt]
   ,[Sales Finance Charge Memo]
   ,[Purch_ Return Shipment]
   ,[Purch_ Return Ord_ Cnfrmn_]
   ,[Service Contract]
   ,[Service Contract Quote]
   ,[Service Quote]
   ,[Meeting Invitation]
   ,[E-Mail Draft]
   ,[Sales Draft Invoices]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Interaction Template Setup$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 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
      ON
         [Interaction Template Setup].[Meeting Invitation] = [Interaction Template].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Template Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Template Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Interaction Template Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Sales Invoices	Sales Invoices	Normal	Code	10	Sales Invoices	nvarchar(20)
3	Sales Cr. Memo	Sales Cr. Memo	Normal	Code	10	Sales Cr_ Memo	nvarchar(20)
4	Sales Ord. Cnfrmn.	Sales Ord. Cnfrmn.	Normal	Code	10	Sales Ord_ Cnfrmn_	nvarchar(20)
5	Sales Quotes	Sales Quotes	Normal	Code	10	Sales Quotes	nvarchar(20)
6	Purch Invoices	Purch Invoices	Normal	Code	10	Purch Invoices	nvarchar(20)
7	Purch Cr Memos	Purch Cr Memos	Normal	Code	10	Purch Cr Memos	nvarchar(20)
8	Purch. Orders	Purch. Orders	Normal	Code	10	Purch_ Orders	nvarchar(20)
9	Purch. Quotes	Purch. Quotes	Normal	Code	10	Purch_ Quotes	nvarchar(20)
10	E-Mails	Emails	Normal	Code	10	E-Mails	nvarchar(20)
11	Cover Sheets	Cover Sheets	Normal	Code	10	Cover Sheets	nvarchar(20)
12	Outg. Calls	Outg. Calls	Normal	Code	10	Outg_ Calls	nvarchar(20)
13	Sales Blnkt. Ord	Sales Blnkt. Ord	Normal	Code	10	Sales Blnkt_ Ord	nvarchar(20)
14	Serv Ord Post	Serv Ord Post	Normal	Code	10	Serv Ord Post	nvarchar(20)
15	Sales Shpt. Note	Sales Shpt. Note	Normal	Code	10	Sales Shpt_ Note	nvarchar(20)
16	Sales Statement	Sales Statement	Normal	Code	10	Sales Statement	nvarchar(20)
17	Sales Rmdr.	Sales Rmdr.	Normal	Code	10	Sales Rmdr_	nvarchar(20)
18	Serv Ord Create	Serv Ord Create	Normal	Code	10	Serv Ord Create	nvarchar(20)
19	Purch Blnkt Ord	Purch Blnkt Ord	Normal	Code	10	Purch Blnkt Ord	nvarchar(20)
20	Purch. Rcpt.	Purch. Rcpt.	Normal	Code	10	Purch_ Rcpt_	nvarchar(20)
21	Sales Return Order	Sales Return Order	Normal	Code	10	Sales Return Order	nvarchar(20)
22	Sales Return Receipt	Sales Return Receipt	Normal	Code	10	Sales Return Receipt	nvarchar(20)
23	Sales Finance Charge Memo	Sales Finance Charge Memo	Normal	Code	10	Sales Finance Charge Memo	nvarchar(20)
24	Purch. Return Shipment	Purch. Return Shipment	Normal	Code	10	Purch_ Return Shipment	nvarchar(20)
25	Purch. Return Ord. Cnfrmn.	Purch. Return Ord. Cnfrmn.	Normal	Code	10	Purch_ Return Ord_ Cnfrmn_	nvarchar(20)
27	Service Contract	Service Contract	Normal	Code	10	Service Contract	nvarchar(20)
28	Service Contract Quote	Service Contract Quote	Normal	Code	10	Service Contract Quote	nvarchar(20)
29	Service Quote	Service Quote	Normal	Code	10	Service Quote	nvarchar(20)
30	Meeting Invitation	Meeting Invitation	Normal	Code	10	Meeting Invitation	nvarchar(20)
	Key to join to the Interaction Template table. Show/hide example query SELECT [Interaction Template Setup].[Meeting Invitation] ,[Interaction Template].[Code] FROM [CRONUS UK Ltd_$Interaction Template Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template Setup] LEFT JOIN [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template] ON [Interaction Template Setup].[Meeting Invitation] = [Interaction Template].[Code]
35	E-Mail Draft	E-Mail Draft	Normal	Code	10	E-Mail Draft	nvarchar(20)
40	Sales Draft Invoices	Sales Draft Invoices	Normal	Code	10	Sales Draft Invoices	nvarchar(20)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Interaction Template Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Interaction Template Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template Setup] LEFT JOIN [User] AS [User] ON [Interaction Template Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier