Item Analysis View

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Analysis View

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

Table Type: Company

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

Table Number: 7152

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 Item Analysis View can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Analysis Area]
   ,[Code]
   ,[Name]
   ,[Last Entry No_]
   ,[Last Budget Entry No_]
   ,[Last Date Updated]
   ,[Update on Posting]
   ,[Blocked]
   ,[Item Filter]
   ,[Location Filter]
   ,[Starting Date]
   ,[Date Compression]
   ,[Dimension 1 Code]
   ,[Dimension 2 Code]
   ,[Dimension 3 Code]
   ,[Include Budgets]
   ,[Refresh When Unblocked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
LEFT JOIN
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
      ON
         [Item Analysis View].[Item Filter] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Analysis View].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Analysis View].[Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Analysis View].[Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Analysis View].[Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Analysis View].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Analysis View].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Analysis View table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Analysis Area SearchAnalysis AreaNormalOption4Analysis Areaint
Available options are:
  • “Sales”
  • “Purchase”
  • “Inventory”
2Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
3Name Primary Key SearchNameNormalText50Namenvarchar(100)
4Last Entry No. SearchLast Entry No.NormalInteger4Last Entry No_int
5Last Budget Entry No. SearchLast Budget Entry No.NormalInteger4Last Budget Entry No_int
6Last Date Updated SearchLast Date UpdatedNormalDate4Last Date Updateddatetime
7Update on Posting SearchUpdate on PostingNormalBoolean4Update on Postingtinyint
8Blocked SearchBlockedNormalBoolean4Blockedtinyint
9Item Filter SearchItem FilterNormalCode250Item Filternvarchar(500)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Item Analysis View].[Item Filter]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Item Analysis View].[Item Filter] = [Item].[No_]
10Location Filter SearchLocation FilterNormalCode250Location Filternvarchar(500)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Item Analysis View].[Location Filter]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Item Analysis View].[Location Filter] = [Location].[Code]
11Starting Date SearchStarting DateNormalDate4Starting Datedatetime
12Date Compression SearchDate CompressionNormalOption4Date Compressionint
Available options are:
  • “None”
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Period”
13Dimension 1 Code SearchDimension 1 CodeNormalCode20Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Item Analysis View].[Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Item Analysis View].[Dimension 1 Code] = [Dimension].[Code]
14Dimension 2 Code SearchDimension 2 CodeNormalCode20Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Item Analysis View].[Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Item Analysis View].[Dimension 2 Code] = [Dimension].[Code]
15Dimension 3 Code SearchDimension 3 CodeNormalCode20Dimension 3 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Item Analysis View].[Dimension 3 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Item Analysis View].[Dimension 3 Code] = [Dimension].[Code]
17Include Budgets SearchInclude BudgetsNormalBoolean4Include Budgetstinyint
18Refresh When Unblocked SearchRefresh When UnblockedNormalBoolean4Refresh When Unblockedtinyint
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
	       [Item Analysis View].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Item Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Item Analysis View].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Analysis View

Leave a Reply

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