Item Analysis View Budg_ Entry

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

Table Type: Company

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

Table Number: 7156

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Analysis Area]
   ,[Analysis View Code]
   ,[Budget Name]
   ,[Item No_]
   ,[Source Type]
   ,[Source No_]
   ,[Dimension 1 Value Code]
   ,[Dimension 2 Value Code]
   ,[Dimension 3 Value Code]
   ,[Location Code]
   ,[Posting Date]
   ,[Entry No_]
   ,[Quantity]
   ,[Sales Amount]
   ,[Cost Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Analysis View Budg_ Entry$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 Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
      ON
         [Item Analysis View Budg_ Entry].[Budget Name] = [G_L Budget Name].[Budget Name]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Item Analysis View Budg_ Entry].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Analysis View Budg_ Entry].[Location Code] = [Location].[Code]

Show/hide columns in Item Analysis View Budg_ Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Analysis Area Primary Key Searchint
3Analysis View Code Primary Key Searchnvarchar(20)
4Budget Name Primary Key Searchnvarchar(20)
Key to join to the G_L Budget Name table.

Show/hide example query

SELECT
       [Item Analysis View Budg_ Entry].[Budget Name]
       ,[G_L Budget Name].[Budget Name]
FROM
       [CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
              ON
                     [Item Analysis View Budg_ Entry].[Budget Name] = [G_L Budget Name].[Budget Name]
5Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Item Analysis View Budg_ Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Analysis View Budg_ Entry].[Item No_] = [Item].[No_]
6Source Type Primary Key Searchint
7Source No_ Primary Key Searchnvarchar(40)
8Dimension 1 Value Code Primary Key Searchnvarchar(40)
9Dimension 2 Value Code Primary Key Searchnvarchar(40)
10Dimension 3 Value Code Primary Key Searchnvarchar(40)
11Location Code Primary Key Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Item Analysis View Budg_ Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Item Analysis View Budg_ Entry].[Location Code] = [Location].[Code]
12Posting Date Primary Key Searchdatetime
13Entry No_ Primary Key Searchint
14Quantity Searchdecimal(38,38)
15Sales Amount Searchdecimal(38,38)
16Cost Amount Searchdecimal(38,38)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Analysis View Budg_ Entry table

Leave a Reply

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