Analysis 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
   [timestamp]
   ,[User ID]
   ,[Page ID]
   ,[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_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis by Dim_ User Param_ table

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

Leave a Reply

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