Email Item

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

Table Type: Company

Table Name: Email Item
Database Table Name: CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 9500

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [ID]
   ,[From Name]
   ,[From Address]
   ,[Send to]
   ,[Send CC]
   ,[Send BCC]
   ,[Subject]
   ,[Body]
   ,[Attachment File Path]
   ,[Attachment Name]
   ,[Plaintext Formatted]
   ,[Body File Path]
   ,[Message Type]
   ,[Send as HTML]
   ,[Attachment File Path 2]
   ,[Attachment Name 2]
   ,[Attachment File Path 3]
   ,[Attachment Name 3]
   ,[Attachment File Path 4]
   ,[Attachment Name 4]
   ,[Attachment File Path 5]
   ,[Attachment Name 5]
   ,[Attachment File Path 6]
   ,[Attachment Name 6]
   ,[Attachment File Path 7]
   ,[Attachment Name 7]
   ,[Source Table]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Email Item]
LEFT JOIN
   [User] AS [User]
      ON
         [Email Item].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Email Item].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Email Item table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalGUID16IDuniqueidentifier
2From Name SearchFrom NameNormalText100From Namenvarchar(200)
3From Address SearchFrom AddressNormalText250From Addressnvarchar(500)
4Send to SearchSend toNormalText250Send tonvarchar(500)
5Send CC SearchSend CCNormalText250Send CCnvarchar(500)
6Send BCC SearchSend BCCNormalText250Send BCCnvarchar(500)
7Subject SearchSubjectNormalText250Subjectnvarchar(500)
8Body SearchBodyNormalBLOB8Bodyimage
9Attachment File Path SearchAttachment File PathNormalText250Attachment File Pathnvarchar(500)
10Attachment Name SearchAttachment NameNormalText250Attachment Namenvarchar(500)
11Plaintext Formatted SearchPlaintext FormattedNormalBoolean4Plaintext Formattedtinyint
12Body File Path SearchBody File PathNormalText250Body File Pathnvarchar(500)
13Message Type SearchMessage TypeNormalOption4Message Typeint
Available options are:
  • “Custom Message”
  • “From Email Body Template”
14Send as HTML SearchSend as HTMLNormalBoolean4Send as HTMLtinyint
21Attachment File Path 2 SearchAttachment File Path 2NormalText250Attachment File Path 2nvarchar(500)
22Attachment Name 2 SearchAttachment Name 2NormalText50Attachment Name 2nvarchar(100)
23Attachment File Path 3 SearchAttachment File Path 3NormalText250Attachment File Path 3nvarchar(500)
24Attachment Name 3 SearchAttachment Name 3NormalText50Attachment Name 3nvarchar(100)
25Attachment File Path 4 SearchAttachment File Path 4NormalText250Attachment File Path 4nvarchar(500)
26Attachment Name 4 SearchAttachment Name 4NormalText50Attachment Name 4nvarchar(100)
27Attachment File Path 5 SearchAttachment File Path 5NormalText250Attachment File Path 5nvarchar(500)
28Attachment Name 5 SearchAttachment Name 5NormalText50Attachment Name 5nvarchar(100)
29Attachment File Path 6 SearchAttachment File Path 6NormalText250Attachment File Path 6nvarchar(500)
30Attachment Name 6 SearchAttachment Name 6NormalText50Attachment Name 6nvarchar(100)
31Attachment File Path 7 SearchAttachment File Path 7NormalText250Attachment File Path 7nvarchar(500)
32Attachment Name 7 SearchAttachment Name 7NormalText50Attachment Name 7nvarchar(100)
33Source Table SearchEmail Source TableNormalInteger4Source Tableint
34Source System Id SearchThe system id of the source recordNormalGUID16
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Email Item].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Email Item]
LEFT JOIN
       [User] AS [User]
              ON
                     [Email Item].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Email Item].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Email Item]
LEFT JOIN
       [User] AS [User]
              ON
                     [Email Item].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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