CRM Full Synch_ Review Line

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

Table Type: Company

Table Name: CRM Full Synch_ Review Line
Database Table Name: CRONUS UK Ltd_$CRM Full Synch_ Review Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5373

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 Full Synch_ Review Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$CRM Full Synch_ Review Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Name]
   ,[Dependency Filter]
   ,[Session ID]
   ,[To Int_ Table Job ID]
   ,[To Int_ Table Job Status]
   ,[From Int_ Table Job ID]
   ,[From Int_ Table Job Status]
   ,[Direction]
   ,[Job Queue Entry ID]
   ,[Job Queue Entry Status]
   ,[Initial Synch Recommendation]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$CRM Full Synch_ Review Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in CRM Full Synch_ Review Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Name Primary Key Searchnvarchar(40)
3Dependency Filter Searchnvarchar(500)
4Session ID Searchint
5To Int_ Table Job ID Searchuniqueidentifier
6To Int_ Table Job Status Searchint
7From Int_ Table Job ID Searchuniqueidentifier
8From Int_ Table Job Status Searchint
9Direction Searchint
10Job Queue Entry ID Searchuniqueidentifier
11Job Queue Entry Status Searchint
12Initial Synch Recommendation Searchint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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