Integration Synch_ Job

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

Table Type: Company

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

Table Number: 5338

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Start Date_Time]
   ,[Finish Date_Time]
   ,[Message]
   ,[Integration Table Mapping Name]
   ,[Inserted]
   ,[Modified]
   ,[Deleted]
   ,[Unchanged]
   ,[Skipped]
   ,[Failed]
   ,[Synch_ Direction]
   ,[Job Queue Log Entry No_]
   ,[Type]
   ,[Uncoupled]
   ,[Coupled]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Integration Synch_ Job$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Integration Synch_ Job table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Start Date_Time Searchdatetime
4Finish Date_Time Searchdatetime
5Message Searchnvarchar(500)
6Integration Table Mapping Name Searchnvarchar(40)
7Inserted Searchint
8Modified Searchint
9Deleted Searchint
10Unchanged Searchint
11Skipped Searchint
12Failed Searchint
13Synch_ Direction Searchint
14Job Queue Log Entry No_ Searchint
15Type Searchint
16Uncoupled Searchint
17Coupled Searchint
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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