Interaction 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
   [timestamp]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Interaction Template Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Interaction Template Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Sales Invoices Searchnvarchar(20)
4Sales Cr_ Memo Searchnvarchar(20)
5Sales Ord_ Cnfrmn_ Searchnvarchar(20)
6Sales Quotes Searchnvarchar(20)
7Purch Invoices Searchnvarchar(20)
8Purch Cr Memos Searchnvarchar(20)
9Purch_ Orders Searchnvarchar(20)
10Purch_ Quotes Searchnvarchar(20)
11E-Mails Searchnvarchar(20)
12Cover Sheets Searchnvarchar(20)
13Outg_ Calls Searchnvarchar(20)
14Sales Blnkt_ Ord Searchnvarchar(20)
15Serv Ord Post Searchnvarchar(20)
16Sales Shpt_ Note Searchnvarchar(20)
17Sales Statement Searchnvarchar(20)
18Sales Rmdr_ Searchnvarchar(20)
19Serv Ord Create Searchnvarchar(20)
20Purch Blnkt Ord Searchnvarchar(20)
21Purch_ Rcpt_ Searchnvarchar(20)
22Sales Return Order Searchnvarchar(20)
23Sales Return Receipt Searchnvarchar(20)
24Sales Finance Charge Memo Searchnvarchar(20)
25Purch_ Return Shipment Searchnvarchar(20)
26Purch_ Return Ord_ Cnfrmn_ Searchnvarchar(20)
27Service Contract Searchnvarchar(20)
28Service Contract Quote Searchnvarchar(20)
29Service Quote Searchnvarchar(20)
30Meeting Invitation Searchnvarchar(20)
31E-Mail Draft Searchnvarchar(20)
32$systemId Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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