Email Scenario Attachments

Dynamics 365 BC Table ReferenceTablesCompany TablesEEmail Scenario Attachments

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

Table Type: Company

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

Table Number: 8911

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[Scenario]
   ,[Attachment Name]
   ,[Email Attachment]
   ,[AttachmentDefaultStatus]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Email Scenario Attachments$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 Scenario Attachments$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Scenario Attachments]
LEFT JOIN
   [User] AS [User]
      ON
         [Email Scenario Attachments].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Email Scenario Attachments].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Email Scenario Attachments table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Id SearchIdNormalBigInteger8Idbigint
2Scenario Primary Key SearchScenarioNormalOption4Scenarioint
Available options are:
  • “Default”
  • “Invite External Accountant”
  • “Notification”
  • “Job Planning Line Calendar”
  • “Interaction Template”
  • “Sales Quote”
  • “Sales Order”
  • “Sales Invoice”
  • “Sales Credit Memo”
  • “Purchase Quote”
  • “Purchase Order”
  • “Reminder”
  • “Finance Charge”
  • “Service Quote”
  • “Service Order”
  • “Service Invoice”
  • “Service Credit Memo”
  • “Posted Vendor Remittance”
  • “Customer Statement”
  • “Vendor Remittance”
  • “Email Printer”
3Attachment Name SearchAttachment NameNormalText250Attachment Namenvarchar(500)
4Email Attachment SearchEmail AttachmentNormalMedia16Email Attachmentuniqueidentifier
5AttachmentDefaultStatus SearchAttachmentDefaultStatusNormalBoolean4AttachmentDefaultStatustinyint
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 Scenario Attachments].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Email Scenario Attachments$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Scenario Attachments]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Email Scenario Attachments].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesEEmail Scenario Attachments

Leave a Reply

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