Analysis by Dim. User Param.

Dynamics 365 BC Table ReferenceTablesCompany TablesAAnalysis 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Analysis View Code SearchAnalysis View CodeNormalCode10Analysis View Codenvarchar(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]
3Line Dim Option SearchLine Dim OptionNormalOption4Line Dim Optionint
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”
4Column Dim Option SearchColumn Dim OptionNormalOption4Column Dim Optionint
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”
5Date Filter SearchDate FilterNormalText250Date Filternvarchar(500)
6Account Filter SearchAccount FilterNormalText250Account Filternvarchar(500)
7Bus. Unit Filter SearchBusiness Unit FilterNormalText250Bus_ Unit Filternvarchar(500)
8Cash Flow Forecast Filter SearchCash Flow Forecast FilterNormalText250Cash Flow Forecast Filternvarchar(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_]
9Budget Filter SearchBudget FilterNormalText250Budget Filternvarchar(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]
10Dimension 1 Filter SearchDimension 1 FilterNormalText250Dimension 1 Filternvarchar(500)
11Dimension 2 Filter SearchDimension 2 FilterNormalText250Dimension 2 Filternvarchar(500)
12Dimension 3 Filter SearchDimension 3 FilterNormalText250Dimension 3 Filternvarchar(500)
13Dimension 4 Filter SearchDimension 4 FilterNormalText250Dimension 4 Filternvarchar(500)
20Show Actual/Budgets SearchShowNormalOption4Show Actual_Budgetsint
21Show Amount Field SearchShow Amount FieldNormalOption4Show Amount Fieldint
Available options are:
  • “Amount”
  • “Debit Amount”
  • “Credit Amount”
22Closing Entries SearchClosing EntriesNormalOption4Closing Entriesint
Available options are:
  • “Include”
  • “Exclude”
23Rounding Factor SearchRounding FactorNormalOption4Rounding Factorint
Available options are:
  • “None”
  • “1”
  • “1000”
  • “1000000”
24Show In Add. Currency SearchShow Amounts in Add. Reporting CurrencyNormalBoolean4Show In Add_ Currencytinyint
25Show Column Name SearchShow Column NameNormalBoolean4Show Column Nametinyint
26Show Opposite Sign SearchShow Opposite SignNormalBoolean4Show Opposite Signtinyint
30Period Type SearchView byNormalOption4Period Typeint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Accounting Period”
31Column Set SearchColumn SetNormalText250Column Setnvarchar(500)
33Amount Type SearchView asNormalOption4Amount Typeint
Available options are:
  • “Net Change”
  • “Balance at Date”
1000User ID SearchUser IDNormalCode50User IDnvarchar(100)
1001Page ID Primary Key SearchPage IDNormalInteger4Page IDint
2000000000$systemId Primary Key SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesAAnalysis by Dim. User Param.

Leave a Reply

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