CRM 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
   [timestamp]
   ,[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 columns in CRM Synch_ Conflict Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Integration ID Searchuniqueidentifier
4CRM ID Searchuniqueidentifier
5Table ID Searchint
6Table Name Searchnvarchar(500)
7Record ID Searchvarbinary(448)
8Description Searchnvarchar(500)
9Modified On Searchdatetime
10Int_ Table ID Searchint
11Int_ Record ID Searchvarbinary(448)
12Int_ Description Searchnvarchar(500)
13Int_ Modified On Searchdatetime
14Error Message Searchnvarchar(500)
15Failed On Searchdatetime
16Deleted On Searchdatetime
17Record Exists Searchtinyint
18Int_ Record Exists Searchtinyint
19CRM Option Id Searchint
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *