Service Email Queue – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SService Email Queue

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

Table Type: Company

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

Table Number: 5935

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 Service Email Queue can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Service Email Queue$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[To Address]
   ,[Copy-to Address]
   ,[Subject Line]
   ,[Body Line]
   ,[Attachment Filename]
   ,[Sending Date]
   ,[Sending Time]
   ,[Status]
   ,[Document Type]
   ,[Document No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Email Queue$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Email Queue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Email Queue]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Service Email Queue].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Service Email Queue].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Service Email Queue].[Document Type] = [Sales Header].[Document Type]
      AND
         [Service Email Queue].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Email Queue].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Email Queue].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Email Queue table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	To Address	To Address	Normal	Text	80	To Address	nvarchar(160)
3	Copy-to Address	Copy-to Address	Normal	Text	80	Copy-to Address	nvarchar(160)
4	Subject Line	Subject Line	Normal	Text	250	Subject Line	nvarchar(500)
5	Body Line	Body Line	Normal	Text	250	Body Line	nvarchar(500)
6	Attachment Filename	Attachment Filename	Normal	Text	80	Attachment Filename	nvarchar(160)
7	Sending Date	Sending Date	Normal	Date	4	Sending Date	datetime
8	Sending Time	Sending Time	Normal	Time	4	Sending Time	datetime
9	Status	Status	Normal	Option	4	Status	int
	Available options are: ” “ “Processed” “Error”
10	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Service Order”
11	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
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 [Service Email Queue].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Service Email Queue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Email Queue] LEFT JOIN [User] AS [User] ON [Service Email Queue].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier