Hybrid Replication Detail – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables HHybrid Replication Detail

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

Table Type: System

Table Name: Hybrid Replication Detail
Database Table Name:

Table Number: 4002

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 Hybrid Replication Detail 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 [Hybrid Replication Detail]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Hybrid Replication Detail].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Hybrid Replication Detail].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Hybrid Replication Detail].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Hybrid Replication Detail table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Run ID	Run ID	Normal	Text	50
2	Table Name	Table Name	Normal	Text	250
3	Company Name	Company Name	Normal	Text	250
	Key to join to the Company table. Show/hide example query SELECT [Hybrid Replication Detail].[] ,[Company].[Name] FROM [] AS [Hybrid Replication Detail] LEFT JOIN [Company] AS [Company] ON [Hybrid Replication Detail].[] = [Company].[Name]
4	Start Time	Start Time	Normal	DateTime	8
5	End Time	End Time	Normal	DateTime	8
8	Status	Status	Normal	Option	4
10	Errors	Errors	Normal	BLOB	8
11	Error Code	Error Code	Normal	Text	10
12	Error Message	Error Message	Normal	Text	2048
14	Records Copied	Records Copied	Normal	Integer	4
15	Total Records	Total Records	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 [Hybrid Replication Detail].[] ,[User].[User Security ID] FROM [] AS [Hybrid Replication Detail] LEFT JOIN [User] AS [User] ON [Hybrid Replication Detail].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16