Tenant Report Layout Selection

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

Table Type: System

Table Name: Tenant Report Layout Selection
Database Table Name: Tenant Report Layout Selection

Table Number: 2000000233

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 Tenant Report Layout Selection can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Tenant Report Layout Selection]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Report ID]
   ,[Company Name]
   ,[User ID]
   ,[Layout Name]
   ,[App ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Report Layout Selection]

Show/hide columns in Tenant Report Layout Selection table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Report ID Primary Key Searchint
3Company Name Primary Key Searchnvarchar(60)
4User ID Primary Key Searchuniqueidentifier
5Layout Name Searchnvarchar(500)
6App ID Searchuniqueidentifier
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 *