Custom Report Layout – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables CCustom Report Layout

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

Table Type: System

Table Name: Custom Report Layout
Database Table Name:

Table Number: 9650

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

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Custom Report Layout]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Custom Report Layout].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Custom Report Layout].[Last Modified By User] = [User].[User Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Custom Report Layout].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Custom Report Layout].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Custom Report Layout table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Code	Code	Normal	Code	20
2	Report ID	Report ID	Normal	Integer	4
3	Report Name	Report Name	FlowField	Text	250
4	Company Name	Company Name	Normal	Text	30
	Key to join to the Company table. Show/hide example query SELECT [Custom Report Layout].[] ,[Company].[Name] FROM [] AS [Custom Report Layout] LEFT JOIN [Company] AS [Company] ON [Custom Report Layout].[] = [Company].[Name]
6	Type	Type	Normal	Option	4
7	Layout	Layout	Normal	BLOB	8
8	Last Modified	Last Modified	Normal	DateTime	8
9	Last Modified by User	Last Modified by User	Normal	Code	50
	Key to join to the User table. Show/hide example query SELECT [Custom Report Layout].[] ,[User].[User Name] FROM [] AS [Custom Report Layout] LEFT JOIN [User] AS [User] ON [Custom Report Layout].[] = [User].[User Name]
10	File Extension	File Extension	Normal	Text	30
11	Description	Description	Normal	Text	250
12	Custom XML Part	Custom XML Part	Normal	BLOB	8
13	App ID	App ID	Normal	GUID	16
14	Built-In	Built-In	Normal	Boolean	4
15	Layout Last Updated	Layout Last Modified	Normal	DateTime	8
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [Custom Report Layout].[] ,[User].[User Security ID] FROM [] AS [Custom Report Layout] LEFT JOIN [User] AS [User] ON [Custom Report Layout].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16