Report Settings Override

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

Table Type: System

Table Name: Report Settings Override
Database Table Name: Report Settings Override

Table Number: 2000000228

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Report Settings Override]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Object ID]
   ,[Company Name]
   ,[Timeout]
   ,[MaxRows]
   ,[MaxDocuments]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Report Settings Override]

Show/hide columns in Report Settings Override table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Object ID Primary Key Searchint
3Company Name Primary Key Searchnvarchar(60)
4Timeout Searchint
5MaxRows Searchint
6MaxDocuments 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 *