Email Logging Setup

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

Table Type: Company

Table Name: Email Logging Setup
Database Table Name: CRONUS UK Ltd_$Email Logging Setup$114e4e19-182b-42e2-b5a9-91d8b8ee8ce1

Table Number: 1680

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Email Logging Setup$114e4e19-182b-42e2-b5a9-91d8b8ee8ce1]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Email Address]
   ,[Email Batch Size]
   ,[Enabled]
   ,[Client Id]
   ,[Client Secret Key]
   ,[Redirect URL]
   ,[Consent Given]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Email Logging Setup$114e4e19-182b-42e2-b5a9-91d8b8ee8ce1]

Show/hide columns in Email Logging Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Email Address Searchnvarchar(500)
4Email Batch Size Searchint
5Enabled Searchtinyint
6Client Id Searchnvarchar(500)
7Client Secret Key Searchuniqueidentifier
8Redirect URL Searchnvarchar(4096)
9Consent Given Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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