Analysis by Dim_ Parameters

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

Table Type: Company

Table Name: Analysis by Dim_ Parameters
Database Table Name: CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 361

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_ Parameters can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis by Dim_ Parameters table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Analysis View Code Primary Key Searchnvarchar(20)
3Line Dim Option Searchint
4Column Dim Option Searchint
5Date Filter Searchnvarchar(500)
6Account Filter Searchnvarchar(500)
7Bus_ Unit Filter Searchnvarchar(500)
8Cash Flow Forecast Filter Searchnvarchar(500)
9Budget Filter Searchnvarchar(500)
10Dimension 1 Filter Searchnvarchar(500)
11Dimension 2 Filter Searchnvarchar(500)
12Dimension 3 Filter Searchnvarchar(500)
13Dimension 4 Filter Searchnvarchar(500)
14Show Actual_Budgets Searchint
15Show Amount Field Searchint
16Closing Entries Searchint
17Rounding Factor Searchint
18Show In Add_ Currency Searchtinyint
19Show Column Name Searchtinyint
20Show Opposite Sign Searchtinyint
21Period Type Searchint
22Column Set Searchnvarchar(500)
23Amount Type Searchint
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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