Analysis Line

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

Table Type: Company

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

Table Number: 7114

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Analysis Area]
   ,[Analysis Line Template Name]
   ,[Line No_]
   ,[Row Ref_ No_]
   ,[Description]
   ,[Type]
   ,[Range]
   ,[New Page]
   ,[Show]
   ,[Bold]
   ,[Italic]
   ,[Underline]
   ,[Show Opposite Sign]
   ,[Dimension 1 Totaling]
   ,[Dimension 2 Totaling]
   ,[Dimension 3 Totaling]
   ,[Group Dimension Code]
   ,[Indentation]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Analysis Area Primary Key Searchint
3Analysis Line Template Name Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Row Ref_ No_ Searchnvarchar(40)
6Description Searchnvarchar(200)
7Type Searchint
8Range Searchnvarchar(500)
9New Page Searchtinyint
10Show Searchint
11Bold Searchtinyint
12Italic Searchtinyint
13Underline Searchtinyint
14Show Opposite Sign Searchtinyint
15Dimension 1 Totaling Searchnvarchar(160)
16Dimension 2 Totaling Searchnvarchar(160)
17Dimension 3 Totaling Searchnvarchar(160)
18Group Dimension Code Searchnvarchar(40)
19Indentation Searchint
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 *