Report Inbox

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

Table Type: Company

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

Table Number: 477

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[User ID]
   ,[Report Output]
   ,[Created Date-Time]
   ,[Job Queue Log Entry ID]
   ,[Output Type]
   ,[Description]
   ,[Report ID]
   ,[Read]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Report Inbox$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Report Inbox table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3User ID Searchnvarchar(130)
4Report Output Searchimage
5Created Date-Time Searchdatetime
6Job Queue Log Entry ID Searchuniqueidentifier
7Output Type Searchint
8Description Searchnvarchar(500)
9Report ID Searchint
10Read Searchtinyint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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