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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Integration Synch_ Job Errors$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Synch. Job Errors]
LEFT JOIN
   [User] AS [User]
      ON
         [Integration Synch. Job Errors].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Integration Synch. Job Errors].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Integration Synch. Job Errors table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalInteger4No_int
2Integration Synch. Job ID SearchIntegration Synch. Job IDNormalGUID16Integration Synch_ Job IDuniqueidentifier
Key to join to the Integration Synch. Job table.

Show/hide example query

SELECT
       [Integration Synch. Job Errors].[Integration Synch_ Job ID]
       ,[Integration Synch. Job].[ID]
FROM
       [CRONUS UK Ltd_$Integration Synch_ Job Errors$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Synch. Job Errors]
LEFT JOIN
       [CRONUS UK Ltd_$Integration Synch_ Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Synch. Job]
              ON
                     [Integration Synch. Job Errors].[Integration Synch_ Job ID] = [Integration Synch. Job].[ID]
3Source Record ID SearchSource Record IDNormalRecordID448Source Record IDvarbinary(448)
4Destination Record ID SearchDestination Record IDNormalRecordID448Destination Record IDvarbinary(448)
5Message SearchMessageNormalText250Messagenvarchar(500)
6Date/Time SearchDate/TimeNormalDateTime8Date_Timedatetime
7Exception Detail SearchException DetailNormalBLOB8Exception Detailimage
8Error Message SearchError MessageNormalText2048Error Messagenvarchar(4096)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Integration Synch. Job Errors].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Integration Synch_ Job Errors$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Synch. Job Errors]
LEFT JOIN
       [User] AS [User]
              ON
                     [Integration Synch. Job Errors].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Integration Synch. Job Errors].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Integration Synch_ Job Errors$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Synch. Job Errors]
LEFT JOIN
       [User] AS [User]
              ON
                     [Integration Synch. Job Errors].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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