G_L Budget Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GG_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

   [timestamp]
   ,[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].[Budget Name]
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_]

Show/hide columns in G_L Budget Entry table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Budget Name	nvarchar(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].[Budget 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].[Budget Name]
4	G_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_]
5	Date	datetime
6	Global Dimension 1 Code	nvarchar(40)
7	Global Dimension 2 Code	nvarchar(40)
8	Amount	decimal(38,38)
9	Description	nvarchar(200)
10	Business Unit Code	nvarchar(40)
11	User ID	nvarchar(100)
12	Budget Dimension 1 Code	nvarchar(40)
13	Budget Dimension 2 Code	nvarchar(40)
14	Budget Dimension 3 Code	nvarchar(40)
15	Budget Dimension 4 Code	nvarchar(40)
16	Last Date Modified	datetime
17	Dimension Set ID	int
18	$systemId	uniqueidentifier
19	$systemCreatedAt	datetime
20	$systemCreatedBy	uniqueidentifier
21	$systemModifiedAt	datetime
22	$systemModifiedBy	uniqueidentifier