CRM Integration Record

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

Table Type: Company

Table Name: CRM Integration Record
Database Table Name: CRONUS UK Ltd_$CRM Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5331

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 Integration Record can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$CRM Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[CRM ID]
   ,[Integration ID]
   ,[Last Synch_ Modified On]
   ,[Last Synch_ CRM Modified On]
   ,[Table ID]
   ,[Last Synch_ Result]
   ,[Last Synch_ CRM Result]
   ,[Last Synch_ Job ID]
   ,[Last Synch_ CRM Job ID]
   ,[Skipped]
   ,[Option Mapping Failure]
   ,[Statistics Uploaded]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$CRM Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in CRM Integration Record table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2CRM ID Primary Key Searchuniqueidentifier
3Integration ID Primary Key Searchuniqueidentifier
4Last Synch_ Modified On Searchdatetime
5Last Synch_ CRM Modified On Searchdatetime
6Table ID Searchint
7Last Synch_ Result Searchint
8Last Synch_ CRM Result Searchint
9Last Synch_ Job ID Searchuniqueidentifier
10Last Synch_ CRM Job ID Searchuniqueidentifier
11Skipped Searchtinyint
12Option Mapping Failure Searchtinyint
13Statistics Uploaded Searchtinyint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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