Error 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
   [timestamp]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Error Message$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Error Message table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchint
3Record ID Searchvarbinary(448)
4Field Number Searchint
5Message Type Searchint
6Description Searchnvarchar(500)
7Additional Information Searchnvarchar(500)
8Support Url Searchnvarchar(500)
9Table Number Searchint
10Context Record ID Searchvarbinary(448)
11Context Field Number Searchint
12Context Table Number Searchint
13Register ID Searchuniqueidentifier
14Created On Searchdatetime
15Context Searchtinyint
16Duplicate Searchtinyint
17Error Call Stack Searchimage
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 *