Report Layout Definition

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

Table Type: System

Table Name: Report Layout Definition
Database Table Name: Report Layout Definition

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Report Layout Definition]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Report ID]
   ,[Name]
   ,[Runtime Package ID]
   ,[Caption]
   ,[CaptionML]
   ,[Layout]
   ,[Layout Format]
   ,[Custom Type]
   ,[MIME Type]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Report Layout Definition]

Show/hide columns in Report Layout Definition table

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

Leave a Reply

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