Error Message Register

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

Table Type: Company

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

Table Number: 701

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Created On]
   ,[User ID]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Error Message Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Error Message Register table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Created On Searchdatetime
4User ID Searchnvarchar(100)
5Description Searchnvarchar(500)
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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