Report Settings Override

Table Type: System

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

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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Object ID	int
3	Company Name	nvarchar(60)
4	Timeout	int
5	MaxRows	int
6	MaxDocuments	int
7	$systemId	uniqueidentifier
8	$systemCreatedAt	datetime
9	$systemCreatedBy	uniqueidentifier
10	$systemModifiedAt	datetime
11	$systemModifiedBy	uniqueidentifier