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
   [timestamp]
   ,[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]
   ,[Source System Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Email Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Email Item table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3From Name Searchnvarchar(200)
4From Address Searchnvarchar(500)
5Send to Searchnvarchar(500)
6Send CC Searchnvarchar(500)
7Send BCC Searchnvarchar(500)
8Subject Searchnvarchar(500)
9Body Searchimage
10Attachment File Path Searchnvarchar(500)
11Attachment Name Searchnvarchar(500)
12Plaintext Formatted Searchtinyint
13Body File Path Searchnvarchar(500)
14Message Type Searchint
15Send as HTML Searchtinyint
16Attachment File Path 2 Searchnvarchar(500)
17Attachment Name 2 Searchnvarchar(100)
18Attachment File Path 3 Searchnvarchar(500)
19Attachment Name 3 Searchnvarchar(100)
20Attachment File Path 4 Searchnvarchar(500)
21Attachment Name 4 Searchnvarchar(100)
22Attachment File Path 5 Searchnvarchar(500)
23Attachment Name 5 Searchnvarchar(100)
24Attachment File Path 6 Searchnvarchar(500)
25Attachment Name 6 Searchnvarchar(100)
26Attachment File Path 7 Searchnvarchar(500)
27Attachment Name 7 Searchnvarchar(100)
28Source Table Searchint
29Source System Id Searchuniqueidentifier
30$systemId Searchuniqueidentifier
31$systemCreatedAt Searchdatetime
32$systemCreatedBy Searchuniqueidentifier
33$systemModifiedAt Searchdatetime
34$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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