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
   [User ID]
   ,[Name]
   ,[Analysis Area]
   ,[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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis Report Chart Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis Report Chart Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis Report Chart Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis Report Chart Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Analysis Report Chart Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1User ID SearchUser IDNormalText132User IDnvarchar(264)
2Name Primary Key SearchNameNormalText30Namenvarchar(60)
10Analysis Area Primary Key SearchAnalysis AreaNormalOption4Analysis Areaint
Available options are:
  • “Sales”
  • “Purchase”
  • “Inventory”
20Analysis Report Name Primary Key SearchAnalysis Report NameNormalCode10Analysis Report Namenvarchar(20)
21Analysis Line Template Name SearchAnalysis Line Template NameNormalCode10Analysis Line Template Namenvarchar(20)
22Analysis Column Template Name SearchAnalysis Column Template NameNormalCode10Analysis Column Template Namenvarchar(20)
30Base X-Axis on SearchBase X-Axis onNormalOption4Base X-Axis onint
Available options are:
  • “Period”
  • “Line”
  • “Column”
31Start Date SearchStart DateNormalDate4Start Datedatetime
32End Date SearchEnd DateNormalDate4End Datedatetime
41Period Length SearchPeriod LengthNormalOption4Period Lengthint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
42No. of Periods SearchNo. of PeriodsNormalInteger4No_ of Periodsint
50Last Viewed SearchLast ViewedNormalBoolean4Last Viewedtinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Analysis Report Chart Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Analysis Report Chart Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis Report Chart Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Analysis Report Chart Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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