Notification Entry

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

Table Type: Company

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

Table Number: 1511

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Type]
   ,[Recipient User ID]
   ,[Triggered By Record]
   ,[Link Target Page]
   ,[Custom Link]
   ,[Error Message]
   ,[Created Date-Time]
   ,[Created By]
   ,[Error Message 2]
   ,[Error Message 3]
   ,[Error Message 4]
   ,[Sender User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Notification Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Notification Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchint
3Type Searchint
4Recipient User ID Searchnvarchar(100)
5Triggered By Record Searchvarbinary(448)
6Link Target Page Searchint
7Custom Link Searchnvarchar(500)
8Error Message Searchnvarchar(4096)
9Created Date-Time Searchdatetime
10Created By Searchnvarchar(100)
11Error Message 2 Searchnvarchar(500)
12Error Message 3 Searchnvarchar(500)
13Error Message 4 Searchnvarchar(500)
14Sender User ID Searchnvarchar(100)
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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