Analysis by Dim. User Param. – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAnalysis by Dim. User Param.

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

Table Type: Company

Table Name: Analysis by Dim. User Param.
Database Table Name: CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 727

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 Analysis by Dim. User Param. can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Analysis View Code]
   ,[Line Dim Option]
   ,[Column Dim Option]
   ,[Date Filter]
   ,[Account Filter]
   ,[Bus_ Unit Filter]
   ,[Cash Flow Forecast Filter]
   ,[Budget Filter]
   ,[Dimension 1 Filter]
   ,[Dimension 2 Filter]
   ,[Dimension 3 Filter]
   ,[Dimension 4 Filter]
   ,[Show Actual_Budgets]
   ,[Show Amount Field]
   ,[Closing Entries]
   ,[Rounding Factor]
   ,[Show In Add_ Currency]
   ,[Show Column Name]
   ,[Show Opposite Sign]
   ,[Period Type]
   ,[Column Set]
   ,[Amount Type]
   ,[User ID]
   ,[Page ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. User Param.]
LEFT JOIN
   [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
      ON
         [Analysis by Dim. User Param.].[Analysis View Code] = [Analysis View].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
      ON
         [Analysis by Dim. User Param.].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
      ON
         [Analysis by Dim. User Param.].[Budget Filter] = [G/L Budget Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis by Dim. User Param.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis by Dim. User Param.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Analysis by Dim. User Param. table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Analysis View Code	Analysis View Code	Normal	Code	10	Analysis View Code	nvarchar(20)
	Key to join to the Analysis View table. Show/hide example query SELECT [Analysis by Dim. User Param.].[Analysis View Code] ,[Analysis View].[Code] FROM [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. User Param.] LEFT JOIN [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View] ON [Analysis by Dim. User Param.].[Analysis View Code] = [Analysis View].[Code]
3	Line Dim Option	Line Dim Option	Normal	Option	4	Line Dim Option	int
	Available options are: “G/L Account” “Period” “Business Unit” “Dimension 1” “Dimension 2” “Dimension 3” “Dimension 4” “Cash Flow Account” “Cash Flow Forecast” “Undefined” “Statistical Account”
4	Column Dim Option	Column Dim Option	Normal	Option	4	Column Dim Option	int
	Available options are: “G/L Account” “Period” “Business Unit” “Dimension 1” “Dimension 2” “Dimension 3” “Dimension 4” “Cash Flow Account” “Cash Flow Forecast” “Undefined” “Statistical Account”
5	Date Filter	Date Filter	Normal	Text	250	Date Filter	nvarchar(500)
6	Account Filter	Account Filter	Normal	Text	250	Account Filter	nvarchar(500)
7	Bus. Unit Filter	Business Unit Filter	Normal	Text	250	Bus_ Unit Filter	nvarchar(500)
8	Cash Flow Forecast Filter	Cash Flow Forecast Filter	Normal	Text	250	Cash Flow Forecast Filter	nvarchar(500)
	Key to join to the Cash Flow Forecast table. Show/hide example query SELECT [Analysis by Dim. User Param.].[Cash Flow Forecast Filter] ,[Cash Flow Forecast].[No_] FROM [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. User Param.] LEFT JOIN [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast] ON [Analysis by Dim. User Param.].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
9	Budget Filter	Budget Filter	Normal	Text	250	Budget Filter	nvarchar(500)
	Key to join to the G/L Budget Name table. Show/hide example query SELECT [Analysis by Dim. User Param.].[Budget Filter] ,[G/L Budget Name].[Name] FROM [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. User Param.] LEFT JOIN [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name] ON [Analysis by Dim. User Param.].[Budget Filter] = [G/L Budget Name].[Name]
10	Dimension 1 Filter	Dimension 1 Filter	Normal	Text	250	Dimension 1 Filter	nvarchar(500)
11	Dimension 2 Filter	Dimension 2 Filter	Normal	Text	250	Dimension 2 Filter	nvarchar(500)
12	Dimension 3 Filter	Dimension 3 Filter	Normal	Text	250	Dimension 3 Filter	nvarchar(500)
13	Dimension 4 Filter	Dimension 4 Filter	Normal	Text	250	Dimension 4 Filter	nvarchar(500)
20	Show Actual/Budgets	Show	Normal	Option	4	Show Actual_Budgets	int
21	Show Amount Field	Show Amount Field	Normal	Option	4	Show Amount Field	int
	Available options are: “Amount” “Debit Amount” “Credit Amount”
22	Closing Entries	Closing Entries	Normal	Option	4	Closing Entries	int
	Available options are: “Include” “Exclude”
23	Rounding Factor	Rounding Factor	Normal	Option	4	Rounding Factor	int
	Available options are: “None” “1” “1000” “1000000”
24	Show In Add. Currency	Show Amounts in Add. Reporting Currency	Normal	Boolean	4	Show In Add_ Currency	tinyint
25	Show Column Name	Show Column Name	Normal	Boolean	4	Show Column Name	tinyint
26	Show Opposite Sign	Show Opposite Sign	Normal	Boolean	4	Show Opposite Sign	tinyint
30	Period Type	View by	Normal	Option	4	Period Type	int
	Available options are: “Day” “Week” “Month” “Quarter” “Year” “Accounting Period”
31	Column Set	Column Set	Normal	Text	250	Column Set	nvarchar(500)
33	Amount Type	View as	Normal	Option	4	Amount Type	int
	Available options are: “Net Change” “Balance at Date”
1000	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
1001	Page ID	Page ID	Normal	Integer	4	Page ID	int
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 [Analysis by Dim. User Param.].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. User Param.] LEFT JOIN [User] AS [User] ON [Analysis by Dim. User Param.].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables AAnalysis by Dim. User Param.

Leave a Reply Cancel reply