Data Migration Error – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DData Migration Error

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

Table Type: Company

Table Name: Data Migration Error
Database Table Name: CRONUS UK Ltd_$Data Migration Error$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1797

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 Data Migration Error can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Data Migration Error$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[Migration Type]
   ,[Destination Table ID]
   ,[Source Staging Table Record ID]
   ,[Error Message]
   ,[Scheduled For Retry]
   ,[Error Dismissed]
   ,[Exception Message]
   ,[Exception Call Stack]
   ,[Last Record Under Processing]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Data Migration Error$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Migration Error$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Error]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Migration Error].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Migration Error].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Migration Error table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Id	Id	Normal	Integer	4	Id	int
2	Migration Type	Migration Type	Normal	Text	250	Migration Type	nvarchar(500)
3	Destination Table ID	Destination Table ID	Normal	Integer	4	Destination Table ID	int
4	Source Staging Table Record ID	Source Staging Table Record ID	Normal	RecordID	448	Source Staging Table Record ID	varbinary(448)
5	Error Message	Error Message	Normal	Text	250	Error Message	nvarchar(500)
6	Scheduled For Retry	Scheduled For Retry	Normal	Boolean	4	Scheduled For Retry	tinyint
9	Error Dismissed	Error Dismissed	Normal	Boolean	4	Error Dismissed	tinyint
10	Exception Message	Exception Message	Normal	BLOB	8	Exception Message	image
11	Exception Call Stack	Exception Call Stack	Normal	BLOB	8	Exception Call Stack	image
12	Last Record Under Processing	Last record under processing	Normal	Text	2048	Last Record Under Processing	nvarchar(4096)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Data Migration Error].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Data Migration Error$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Error] LEFT JOIN [User] AS [User] ON [Data Migration Error].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Data Migration Error].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Data Migration Error$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Error] LEFT JOIN [User] AS [User] ON [Data Migration Error].[$systemModifiedBy] = [User].[User Security ID]