Email Outbox

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

Table Type: Company

Table Name: Email Outbox
Database Table Name: CRONUS UK Ltd_$Email Outbox$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 8888

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Email Outbox$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Id]
   ,[Message Id]
   ,[Account Id]
   ,[Connector]
   ,[User Security Id]
   ,[Description]
   ,[Status]
   ,[Task Scheduler Id]
   ,[Date Queued]
   ,[Date Failed]
   ,[Send From]
   ,[Error Message]
   ,[Date Sending]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Email Outbox$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Email Outbox table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Id Primary Key Searchbigint
3Message Id Searchuniqueidentifier
4Account Id Searchuniqueidentifier
5Connector Searchint
6User Security Id Searchuniqueidentifier
7Description Searchnvarchar(4096)
8Status Searchint
9Task Scheduler Id Searchuniqueidentifier
10Date Queued Searchdatetime
11Date Failed Searchdatetime
12Send From Searchnvarchar(500)
13Error Message Searchnvarchar(4096)
14Date Sending Searchdatetime
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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