Integration Synch_ Job Errors

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

Table Type: Company

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

Table Number: 5339

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Integration Synch_ Job ID]
   ,[Source Record ID]
   ,[Destination Record ID]
   ,[Message]
   ,[Date_Time]
   ,[Exception Detail]
   ,[Error Message]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Integration Synch_ Job Errors$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Integration Synch_ Job Errors table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Integration Synch_ Job ID Searchuniqueidentifier
4Source Record ID Searchvarbinary(448)
5Destination Record ID Searchvarbinary(448)
6Message Searchnvarchar(500)
7Date_Time Searchdatetime
8Exception Detail Searchimage
9Error Message Searchnvarchar(4096)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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