G/L Budget Entry

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

Table Type: Company

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

Table Number: 96

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Budget Name]
   ,[G_L Account No_]
   ,[Date]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Amount]
   ,[Description]
   ,[Business Unit Code]
   ,[User ID]
   ,[Budget Dimension 1 Code]
   ,[Budget Dimension 2 Code]
   ,[Budget Dimension 3 Code]
   ,[Budget Dimension 4 Code]
   ,[Last Date Modified]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L 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_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
      ON
         [G/L Budget Entry].[Budget Name] = [G/L Budget Name].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [G/L Budget Entry].[Business Unit Code] = [Business Unit].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Entry].[Budget Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Entry].[Budget Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Entry].[Budget Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Entry].[Budget Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [G/L Budget Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Budget Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Budget Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Budget Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Budget Name SearchBudget NameNormalCode10Budget Namenvarchar(20)
Key to join to the G/L Budget Name table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Budget Name]
       ,[G/L Budget Name].[Name]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
              ON
                     [G/L Budget Entry].[Budget Name] = [G/L Budget Name].[Name]
3G/L Account No. SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [G/L Budget Entry].[G_L Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [G/L Budget Entry].[G_L Account No_] = [G/L Account].[No_]
4Date SearchDateNormalDate4Datedatetime
5Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Entry].[Global Dimension 1 Code] = [Dimension].[Code]
6Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Entry].[Global Dimension 2 Code] = [Dimension].[Code]
7Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
9Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10Business Unit Code SearchBusiness Unit CodeNormalCode20Business Unit Codenvarchar(40)
Key to join to the Business Unit table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Business Unit Code]
       ,[Business Unit].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
              ON
                     [G/L Budget Entry].[Business Unit Code] = [Business Unit].[Code]
11User ID SearchUser IDNormalCode50User IDnvarchar(100)
12Budget Dimension 1 Code SearchBudget Dimension 1 CodeNormalCode20Budget Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Budget Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Entry].[Budget Dimension 1 Code] = [Dimension].[Code]
13Budget Dimension 2 Code SearchBudget Dimension 2 CodeNormalCode20Budget Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Budget Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Entry].[Budget Dimension 2 Code] = [Dimension].[Code]
14Budget Dimension 3 Code SearchBudget Dimension 3 CodeNormalCode20Budget Dimension 3 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Budget Dimension 3 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Entry].[Budget Dimension 3 Code] = [Dimension].[Code]
15Budget Dimension 4 Code SearchBudget Dimension 4 CodeNormalCode20Budget Dimension 4 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Budget Dimension 4 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Entry].[Budget Dimension 4 Code] = [Dimension].[Code]
16Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [G/L Budget Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [G/L Budget Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
       [G/L Budget Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Budget Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [G/L Budget Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Budget Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from G/L Budget Entry table

Leave a Reply

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