Analysis Report Chart Line

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

Table Type: Company

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

Table Number: 771

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User ID]
   ,[Analysis Area]
   ,[Name]
   ,[Analysis Line Line No_]
   ,[Analysis Column Line No_]
   ,[Analysis Line Template Name]
   ,[Analysis Column Template Name]
   ,[Original Measure Name]
   ,[Measure Name]
   ,[Measure Value]
   ,[Chart Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis Report Chart Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis Report Chart Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(264)
3Analysis Area Primary Key Searchint
4Name Primary Key Searchnvarchar(60)
5Analysis Line Line No_ Primary Key Searchint
6Analysis Column Line No_ Primary Key Searchint
7Analysis Line Template Name Searchnvarchar(20)
8Analysis Column Template Name Searchnvarchar(20)
9Original Measure Name Searchnvarchar(222)
10Measure Name Searchnvarchar(222)
11Measure Value Searchnvarchar(60)
12Chart Type Searchint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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