Analysis View Budget Entry

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

Table Type: Company

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

Table Number: 366

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Analysis View Code]
   ,[Budget Name]
   ,[G_L Account No_]
   ,[Dimension 1 Value Code]
   ,[Dimension 2 Value Code]
   ,[Dimension 3 Value Code]
   ,[Dimension 4 Value Code]
   ,[Business Unit Code]
   ,[Posting Date]
   ,[Entry No_]
   ,[Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis View Budget 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_$Analysis View Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis View Budget Entry]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
      ON
         [Analysis View Budget Entry].[Budget Name] = [G_L Budget Name].[Budget Name]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
      ON
         [Analysis View Budget Entry].[G_L Account No_] = [G_L Account].[No_]

Show/hide columns in Analysis View Budget Entry table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Analysis View Budget Entry].[G_L Account No_]
       ,[G_L Account].[No_]
FROM
       [CRONUS UK Ltd_$Analysis View Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis View Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
              ON
                     [Analysis View Budget Entry].[G_L Account No_] = [G_L Account].[No_]
5Dimension 1 Value Code Primary Key Searchnvarchar(40)
6Dimension 2 Value Code Primary Key Searchnvarchar(40)
7Dimension 3 Value Code Primary Key Searchnvarchar(40)
8Dimension 4 Value Code Primary Key Searchnvarchar(40)
9Business Unit Code Primary Key Searchnvarchar(40)
10Posting Date Primary Key Searchdatetime
11Entry No_ Primary Key Searchint
12Amount Searchdecimal(38,38)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Analysis View Budget Entry table

Leave a Reply

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