Analysis Line

Dynamics 365 BC Table ReferenceTablesCompany TablesAAnalysis 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

   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Analysis Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Analysis Line].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Analysis Line].[Group Dimension Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Analysis Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Analysis Area SearchAnalysis AreaNormalOption4Analysis Areaint
Available options are:
  • “Sales”
  • “Purchase”
  • “Inventory”
2Analysis Line Template Name Primary Key SearchAnalysis Line Template NameNormalCode10Analysis Line Template Namenvarchar(20)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Row Ref. No. Primary Key SearchRow Ref. No.NormalCode20Row Ref_ No_nvarchar(40)
5Description SearchDescriptionNormalText100Descriptionnvarchar(200)
6Type SearchTypeNormalOption4Typeint
Available options are:
  • “Item”
  • “Item Group”
  • “Customer”
  • “Customer Group”
  • “Vendor”
  • “Sales/Purchase Person”
  • “Formula”
7Range SearchRangeNormalText250Rangenvarchar(500)
8New Page SearchNew PageNormalBoolean4New Pagetinyint
9Show SearchShowNormalOption4Showint
Available options are:
  • “Yes”
  • “No”
  • “If Any Column Not Zero”
10Bold SearchBoldNormalBoolean4Boldtinyint
11Italic SearchItalicNormalBoolean4Italictinyint
12Underline SearchUnderlineNormalBoolean4Underlinetinyint
13Show Opposite Sign SearchShow Opposite SignNormalBoolean4Show Opposite Signtinyint
14Source Type Filter SearchSource Type FilterFlowFilterOption4
15Date Filter SearchDate FilterFlowFilterDate4
16Item Budget Filter SearchItem Budget FilterFlowFilterCode10
17Location Filter SearchLocation FilterFlowFilterCode10
Key to join to the Location table.

Show/hide example query

SELECT
	       [Analysis Line].[]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Analysis Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Analysis Line].[] = [Location].[Code]
18Dimension 1 Filter SearchDimension 1 FilterFlowFilterCode20
19Dimension 2 Filter SearchDimension 2 FilterFlowFilterCode20
20Dimension 3 Filter SearchDimension 3 FilterFlowFilterCode20
21Dimension 1 Totaling SearchDimension 1 TotalingNormalText80Dimension 1 Totalingnvarchar(160)
22Dimension 2 Totaling SearchDimension 2 TotalingNormalText80Dimension 2 Totalingnvarchar(160)
23Dimension 3 Totaling SearchDimension 3 TotalingNormalText80Dimension 3 Totalingnvarchar(160)
24Source No. Filter SearchSource No. FilterFlowFilterCode20
25Group Dimension Code SearchGroup Dimension CodeNormalCode20Group Dimension Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Analysis Line].[Group Dimension Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Analysis Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Analysis Line].[Group Dimension Code] = [Dimension].[Code]
26Indentation SearchIndentationNormalInteger4Indentationint
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 Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Analysis Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Analysis Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesAAnalysis Line

Leave a Reply

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