Analysis View

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[Account Source]
   ,[Last Entry No_]
   ,[Last Budget Entry No_]
   ,[Last Date Updated]
   ,[Update on Posting]
   ,[Blocked]
   ,[Account Filter]
   ,[Business Unit Filter]
   ,[Starting Date]
   ,[Date Compression]
   ,[Dimension 1 Code]
   ,[Dimension 2 Code]
   ,[Dimension 3 Code]
   ,[Dimension 4 Code]
   ,[Include Budgets]
   ,[Refresh When Unblocked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis View table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Name Searchnvarchar(100)
4Account Source Searchint
5Last Entry No_ Searchint
6Last Budget Entry No_ Searchint
7Last Date Updated Searchdatetime
8Update on Posting Searchtinyint
9Blocked Searchtinyint
10Account Filter Searchnvarchar(500)
11Business Unit Filter Searchnvarchar(500)
12Starting Date Searchdatetime
13Date Compression Searchint
14Dimension 1 Code Searchnvarchar(40)
15Dimension 2 Code Searchnvarchar(40)
16Dimension 3 Code Searchnvarchar(40)
17Dimension 4 Code Searchnvarchar(40)
18Include Budgets Searchtinyint
19Refresh When Unblocked Searchtinyint
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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