Item Budget Entry

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

Table Type: Company

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

Table Number: 7134

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

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

Show/hide columns in Item Budget Entry table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Item Budget Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Budget Entry].[Item No_] = [Item].[No_]
7Source Type Searchint
8Source No_ Searchnvarchar(40)
9Description Searchnvarchar(200)
10Quantity Searchdecimal(38,38)
11Cost Amount Searchdecimal(38,38)
12Sales Amount Searchdecimal(38,38)
13User ID Searchnvarchar(100)
14Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Item Budget Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Item Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Item Budget Entry].[Location Code] = [Location].[Code]
15Global Dimension 1 Code Searchnvarchar(40)
16Global Dimension 2 Code Searchnvarchar(40)
17Budget Dimension 1 Code Searchnvarchar(40)
18Budget Dimension 2 Code Searchnvarchar(40)
19Budget Dimension 3 Code Searchnvarchar(40)
20Dimension Set ID Searchint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Budget Entry table

Leave a Reply

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