Error Buffer

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

Table Type: Company

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

Table Number: 5890

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Error No_]
   ,[Error Text]
   ,[Source Table]
   ,[Source No_]
   ,[Source Ref_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Error Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Error Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Error No_ Primary Key Searchint
3Error Text Searchnvarchar(500)
4Source Table Searchint
5Source No_ Searchnvarchar(40)
6Source Ref_ No_ Searchint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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