Generic Chart Y-Axis

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

Table Type: Company

Table Name: Generic Chart Y-Axis
Database Table Name: CRONUS UK Ltd_$Generic Chart Y-Axis$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 9182

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 Generic Chart Y-Axis can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Generic Chart Y-Axis$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Line No_]
   ,[Y-Axis Measure Field ID]
   ,[Y-Axis Measure Field Name]
   ,[Measure Operator]
   ,[Y-Axis Measure Field Caption]
   ,[Show Title]
   ,[Aggregation]
   ,[Chart Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Generic Chart Y-Axis$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Generic Chart Y-Axis table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Y-Axis Measure Field ID Searchint
5Y-Axis Measure Field Name Searchnvarchar(100)
6Measure Operator Searchint
7Y-Axis Measure Field Caption Searchnvarchar(500)
8Show Title Searchtinyint
9Aggregation Searchint
10Chart Type Searchint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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