Analysis Report Chart Setup

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

Table Type: Company

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

Table Number: 770

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 Report Chart Setup can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User ID]
   ,[Analysis Area]
   ,[Name]
   ,[Analysis Report Name]
   ,[Analysis Line Template Name]
   ,[Analysis Column Template Name]
   ,[Base X-Axis on]
   ,[Start Date]
   ,[End Date]
   ,[Period Length]
   ,[No_ of Periods]
   ,[Last Viewed]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis Report Chart Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis Report Chart Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(264)
3Analysis Area Primary Key Searchint
4Name Primary Key Searchnvarchar(60)
5Analysis Report Name Searchnvarchar(20)
6Analysis Line Template Name Searchnvarchar(20)
7Analysis Column Template Name Searchnvarchar(20)
8Base X-Axis on Searchint
9Start Date Searchdatetime
10End Date Searchdatetime
11Period Length Searchint
12No_ of Periods Searchint
13Last Viewed Searchtinyint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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