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:
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 | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Run ID   | Run ID | Normal | Text | 50 | ||
| 2 | Subscription ID | Subscription ID | Normal | Text | 150 | ||
| 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 | ||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 |