External Event Subscription – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables EExternal Event Subscription

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

Table Type: System

Table Name: External Event Subscription
Database Table Name: External Event Subscription

Table Number: 2000000240

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 External Event Subscription can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [External Event Subscription]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[App Id]
   ,[Event Name]
   ,[Company Name]
   ,[User Id]
   ,[Notification Url]
   ,[Last Modified Date Time]
   ,[Client State]
   ,[Subscription Type]
   ,[Event Version]
   ,[Subscription State]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [External Event Subscription]

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

SELECT
   *
FROM
   [External Event Subscription] AS [External Event Subscription]
LEFT JOIN
   [Company] AS [Company]
      ON
         [External Event Subscription].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [External Event Subscription].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [External Event Subscription].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in External Event Subscription table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	GUID	16	ID	uniqueidentifier
2	App Id	App Id	Normal	GUID	16	App Id	uniqueidentifier
3	Event Name	Event Name	Normal	Text	80	Event Name	nvarchar(160)
4	Company Name	Company Name	Normal	Text	30	Company Name	nvarchar(60)
	Key to join to the Company table. Show/hide example query SELECT [External Event Subscription].[Company Name] ,[Company].[Name] FROM [External Event Subscription] AS [External Event Subscription] LEFT JOIN [Company] AS [Company] ON [External Event Subscription].[Company Name] = [Company].[Name]
5	User Id	User Id	Normal	GUID	16	User Id	uniqueidentifier
6	Notification Url	Notification Url	Normal	Text	2048	Notification Url	nvarchar(4096)
7	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
8	Client State	Client State	Normal	Text	2048	Client State	nvarchar(4096)
9	Subscription Type	Subscription Type	Normal	Option	4	Subscription Type	int
	Available options are: “Dataverse” “Webhook”
10	Event Version	Event Version	Normal	Text	43	Event Version	nvarchar(86)
11	Subscription State	Subscription State	Normal	Option	4	Subscription State	int
	Available options are: “Active” “Disabled”
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 [External Event Subscription].[$systemCreatedBy] ,[User].[User Security ID] FROM [External Event Subscription] AS [External Event Subscription] LEFT JOIN [User] AS [User] ON [External Event Subscription].[$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 [External Event Subscription].[$systemModifiedBy] ,[User].[User Security ID] FROM [External Event Subscription] AS [External Event Subscription] LEFT JOIN [User] AS [User] ON [External Event Subscription].[$systemModifiedBy] = [User].[User Security ID]