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