Tenant Report Layout

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

Table Type: System

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

Table Number: 2000000232

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Tenant Report Layout]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Report ID]
   ,[Name]
   ,[App ID]
   ,[Caption]
   ,[CaptionML]
   ,[Company Name]
   ,[Layout]
   ,[Layout Format]
   ,[Custom Type]
   ,[MIME Type]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Report Layout]

Show/hide columns in Tenant Report Layout table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Report ID Primary Key Searchint
3Name Primary Key Searchnvarchar(500)
4App ID Primary Key Searchuniqueidentifier
5Caption Searchnvarchar(500)
6CaptionML Searchnvarchar(500)
7Company Name Searchnvarchar(60)
8Layout Searchuniqueidentifier
9Layout Format Searchint
10Custom Type Searchuniqueidentifier
11MIME Type Searchnvarchar(510)
12Description Searchnvarchar(500)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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