Replication Run Completed Arg – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RReplication Run Completed Arg

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

Table Type: Company

Table Name: Replication Run Completed Arg
Database Table Name:

Table Number: 40026

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 Replication Run Completed Arg can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [Replication Run Completed Arg]
LEFT JOIN
   [External Event Subscription] AS [External Event Subscription]
      ON
         [Replication Run Completed Arg].[Subscription Id] = [External Event Subscription].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Replication Run Completed Arg].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Replication Run Completed Arg].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Replication Run Completed Arg table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Run ID	Run ID	Normal	Text	50
2	Subscription ID	Subscription ID	Normal	Text	150
	Key to join to the External Event Subscription table. Show/hide example query SELECT [Replication Run Completed Arg].[] ,[External Event Subscription].[ID] FROM [] AS [Replication Run Completed Arg] LEFT JOIN [External Event Subscription] AS [External Event Subscription] ON [Replication Run Completed Arg].[] = [External Event Subscription].[ID]
3	Notification Text	Notification Text	Normal	BLOB	8
4	TaskId	Task ID	Normal	GUID	16
5	Session Id	Session ID	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [Replication Run Completed Arg].[] ,[User].[User Security ID] FROM [] AS [Replication Run Completed Arg] LEFT JOIN [User] AS [User] ON [Replication Run Completed Arg].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16