Report Selections

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

Table Type: Company

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

Table Number: 77

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Usage]
   ,[Sequence]
   ,[Report ID]
   ,[Custom Report Layout Code]
   ,[Use for Email Attachment]
   ,[Use for Email Body]
   ,[Email Body Layout Code]
   ,[Email Body Layout Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Report Selections$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Report Selections table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Usage Primary Key Searchint
3Sequence Primary Key Searchnvarchar(20)
4Report ID Searchint
5Custom Report Layout Code Searchnvarchar(40)
6Use for Email Attachment Searchtinyint
7Use for Email Body Searchtinyint
8Email Body Layout Code Searchnvarchar(40)
9Email Body Layout Type Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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