Email Message Attachment – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EEmail Message Attachment

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

Table Type: Company

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

Table Number: 8904

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Email Message Attachment$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[Email Message Id]
   ,[Attachment]
   ,[Attachment Name]
   ,[Content Type]
   ,[InLine]
   ,[Content Id]
   ,[Length]
   ,[Data]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Email Message Attachment$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Email Message Attachment$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message Attachment]
LEFT JOIN
   [CRONUS UK Ltd_$Email Message$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message]
      ON
         [Email Message Attachment].[Email Message Id] = [Email Message].[Id]
LEFT JOIN
   [User] AS [User]
      ON
         [Email Message Attachment].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Email Message Attachment].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Email Message Attachment table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Id	Id	Normal	BigInteger	8	Id	bigint
2	Email Message Id	Email Message Id	Normal	GUID	16	Email Message Id	uniqueidentifier
	Key to join to the Email Message table. Show/hide example query SELECT [Email Message Attachment].[Email Message Id] ,[Email Message].[Id] FROM [CRONUS UK Ltd_$Email Message Attachment$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message Attachment] LEFT JOIN [CRONUS UK Ltd_$Email Message$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message] ON [Email Message Attachment].[Email Message Id] = [Email Message].[Id]
3	Attachment	Attachment	Normal	BLOB	8	Attachment	image
4	Attachment Name	Attachment Name	Normal	Text	250	Attachment Name	nvarchar(500)
5	Content Type	Content Type	Normal	Text	250	Content Type	nvarchar(500)
6	InLine	InLine	Normal	Boolean	4	InLine	tinyint
7	Content Id	Content Id	Normal	Text	40	Content Id	nvarchar(80)
8	Length	Length	Normal	Integer	4	Length	int
9	Data	Data	Normal	Media	16	Data	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Email Message Attachment].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Email Message Attachment$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message Attachment] LEFT JOIN [User] AS [User] ON [Email Message Attachment].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Email Message Attachment].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Email Message Attachment$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message Attachment] LEFT JOIN [User] AS [User] ON [Email Message Attachment].[$systemModifiedBy] = [User].[User Security ID]