Error Message – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EError Message

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

Table Type: Company

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

Table Number: 700

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[Record ID]
   ,[Field Number]
   ,[Message Type]
   ,[Description]
   ,[Additional Information]
   ,[Support Url]
   ,[Table Number]
   ,[Context Record ID]
   ,[Context Field Number]
   ,[Context Table Number]
   ,[Register ID]
   ,[Created On]
   ,[Context]
   ,[Duplicate]
   ,[Error Call Stack]
   ,[Message]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

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

Show/hide columns in Error Message table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	Integer	4	ID	int
2	Record ID	Record ID	Normal	RecordID	448	Record ID	varbinary(448)
3	Field Number	Field Number	Normal	Integer	4	Field Number	int
4	Message Type	Message Type	Normal	Option	4	Message Type	int
	Available options are: “Error” “Warning” “Information”
5	Description	Description	Normal	Text	250	Description	nvarchar(500)
6	Additional Information	Additional Information	Normal	Text	250	Additional Information	nvarchar(500)
7	Support Url	Support Url	Normal	Text	250	Support Url	nvarchar(500)
8	Table Number	Table Number	Normal	Integer	4	Table Number	int
10	Context Record ID	Context Record ID	Normal	RecordID	448	Context Record ID	varbinary(448)
11	Field Name	Field Name	FlowField	Text	80
12	Table Name	Table Name	FlowField	Text	80
13	Context Field Number	Context Field Number	Normal	Integer	4	Context Field Number	int
14	Context Table Number	Context Table Number	Normal	Integer	4	Context Table Number	int
15	Context Field Name	Context Field Name	FlowField	Text	80
16	Register ID	Register ID	Normal	GUID	16	Register ID	uniqueidentifier
	Key to join to the Error Message Register table. Show/hide example query SELECT [Error Message].[Register ID] ,[Error Message Register].[ID] FROM [CRONUS UK Ltd_$Error Message$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Error Message] LEFT JOIN [CRONUS UK Ltd_$Error Message Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Error Message Register] ON [Error Message].[Register ID] = [Error Message Register].[ID]
17	Created On	Created On	Normal	DateTime	8	Created On	datetime
18	Context	Context	Normal	Boolean	4	Context	tinyint
20	Duplicate	Duplicate	Normal	Boolean	4	Duplicate	tinyint
21	Error Call Stack	Error Call Stack	Normal	BLOB	8	Error Call Stack	image
22	Message	Description	Normal	Text	2048	Message	nvarchar(4096)
23	Reg. Err. Msg. System ID	Reg. Err. Msg. System ID	Normal	GUID	16
7900	Title	Title	Normal	Text	2048
7901	Recommended Action Caption	Recommended action caption	Normal	Text	100
7902	Error Msg. Fix Implementation	Error fix implementation	Normal	Option	4
7903	Message Status	Status	Normal	Option	4
7904	Sub-Context Record ID	Sub-Context Record ID	Normal	RecordID	448
7905	Sub-Context Field Number	Sub-Context Field Number	Normal	Integer	4
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 [Error Message].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Error Message$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Error Message] LEFT JOIN [User] AS [User] ON [Error Message].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier