Financial Report User Filters – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables FFinancial Report User Filters

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

Table Type: Company

Table Name: Financial Report User Filters
Database Table Name: CRONUS UK Ltd_$Financial Report User Filters$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 89

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 Financial Report User Filters can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Financial Report User Filters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [User ID]
   ,[Financial Report Name]
   ,[UseAmountsInAddCurrency]
   ,[PeriodType]
   ,[ShowLinesWithShowNo]
   ,[Dim1Filter]
   ,[Dim2Filter]
   ,[Dim3Filter]
   ,[Dim4Filter]
   ,[CostCenterFilter]
   ,[CostObjectFilter]
   ,[CashFlowFilter]
   ,[GLBudgetFilter]
   ,[CostBudgetFilter]
   ,[DateFilter]
   ,[Row Definition]
   ,[Column Definition]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Financial Report User Filters$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Financial Report User Filters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Financial Report User Filters]
LEFT JOIN
   [User] AS [User]
      ON
         [Financial Report User Filters].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Financial Report User Filters].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Financial Report User Filters table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
2	Financial Report Name	Financial Report Name	Normal	Code	10	Financial Report Name	nvarchar(20)
3	UseAmountsInAddCurrency	Use Amounts in Additional Currency	Normal	Boolean	4	UseAmountsInAddCurrency	tinyint
4	PeriodType	Period Type	Normal	Option	4	PeriodType	int
	Available options are: “Day” “Week” “Month” “Quarter” “Year” “Accounting Period”
5	ShowLinesWithShowNo	Show All Lines	Normal	Boolean	4	ShowLinesWithShowNo	tinyint
6	Dim1Filter	Dimension 1 Filter	Normal	Text	2048	Dim1Filter	nvarchar(4096)
7	Dim2Filter	Dimension 2 Filter	Normal	Text	2048	Dim2Filter	nvarchar(4096)
8	Dim3Filter	Dimension 3 Filter	Normal	Text	2048	Dim3Filter	nvarchar(4096)
9	Dim4Filter	Dimension 4 Filter	Normal	Text	2048	Dim4Filter	nvarchar(4096)
10	CostCenterFilter	Cost Center Filter	Normal	Text	2048	CostCenterFilter	nvarchar(4096)
11	CostObjectFilter	Cost Object Filter	Normal	Text	2048	CostObjectFilter	nvarchar(4096)
12	CashFlowFilter	Cash Flow Filter	Normal	Text	2048	CashFlowFilter	nvarchar(4096)
13	GLBudgetFilter	G/L Budget Filter	Normal	Text	2048	GLBudgetFilter	nvarchar(4096)
14	CostBudgetFilter	Cost Budget Filter	Normal	Text	2048	CostBudgetFilter	nvarchar(4096)
15	DateFilter	Date Filter	Normal	Text	2048	DateFilter	nvarchar(4096)
51	Row Definition	Row Definition	Normal	Code	10	Row Definition	nvarchar(20)
52	Column Definition	Column Definition	Normal	Code	10	Column Definition	nvarchar(20)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Financial Report User Filters].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Financial Report User Filters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Financial Report User Filters] LEFT JOIN [User] AS [User] ON [Financial Report User Filters].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Financial Report User Filters].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Financial Report User Filters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Financial Report User Filters] LEFT JOIN [User] AS [User] ON [Financial Report User Filters].[$systemModifiedBy] = [User].[User Security ID]