CRM Synch. Conflict Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCRM Synch. Conflict Buffer

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

Table Type: Company

Table Name: CRM Synch. Conflict Buffer
Database Table Name: CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5374

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 CRM Synch. Conflict Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Integration ID]
   ,[CRM ID]
   ,[Table ID]
   ,[Table Name]
   ,[Record ID]
   ,[Description]
   ,[Modified On]
   ,[Int_ Table ID]
   ,[Int_ Record ID]
   ,[Int_ Description]
   ,[Int_ Modified On]
   ,[Error Message]
   ,[Failed On]
   ,[Deleted On]
   ,[Record Exists]
   ,[Int_ Record Exists]
   ,[CRM Option Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Synch. Conflict Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Record]
      ON
         [CRM Synch. Conflict Buffer].[Integration ID] = [Integration Record].[Integration ID]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [CRM Synch. Conflict Buffer].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CRM Synch. Conflict Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CRM Synch. Conflict Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in CRM Synch. Conflict Buffer 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	Integration ID	Integration ID	Normal	GUID	16	Integration ID	uniqueidentifier
	Key to join to the Integration Record table. Show/hide example query SELECT [CRM Synch. Conflict Buffer].[Integration ID] ,[Integration Record].[Integration ID] FROM [CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Synch. Conflict Buffer] LEFT JOIN [CRONUS UK Ltd_$Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Record] ON [CRM Synch. Conflict Buffer].[Integration ID] = [Integration Record].[Integration ID]
3	CRM ID	CRM ID	Normal	GUID	16	CRM ID	uniqueidentifier
4	Table ID	Table ID	Normal	Integer	4	Table ID	int
	Key to join to the Data Exch. Mapping table. Show/hide example query SELECT [CRM Synch. Conflict Buffer].[Table ID] ,[Data Exch. Mapping].[Table ID] FROM [CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Synch. Conflict Buffer] LEFT JOIN [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping] ON [CRM Synch. Conflict Buffer].[Table ID] = [Data Exch. Mapping].[Table ID]
5	Table Name	Table Name	Normal	Text	250	Table Name	nvarchar(500)
6	Record ID	Record ID	Normal	RecordID	448	Record ID	varbinary(448)
7	Description	Description	Normal	Text	250	Description	nvarchar(500)
8	Modified On	Modified On	Normal	DateTime	8	Modified On	datetime
9	Int. Table ID	Int. Table ID	Normal	Integer	4	Int_ Table ID	int
10	Int. Record ID	Int. Record ID	Normal	RecordID	448	Int_ Record ID	varbinary(448)
11	Int. Description	Int. Description	Normal	Text	250	Int_ Description	nvarchar(500)
12	Int. Modified On	Int. Modified On	Normal	DateTime	8	Int_ Modified On	datetime
13	Error Message	Error Message	Normal	Text	250	Error Message	nvarchar(500)
14	Failed On	Failed On	Normal	DateTime	8	Failed On	datetime
15	Deleted On	Deleted On	Normal	DateTime	8	Deleted On	datetime
16	Record Exists	Record Exists	Normal	Boolean	4	Record Exists	tinyint
17	Int. Record Exists	Int. Record Exists	Normal	Boolean	4	Int_ Record Exists	tinyint
18	CRM Option Id	CRM Option Id	Normal	Integer	4	CRM Option Id	int
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 [CRM Synch. Conflict Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$CRM Synch_ Conflict Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Synch. Conflict Buffer] LEFT JOIN [User] AS [User] ON [CRM Synch. Conflict Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier