Cost Budget Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost Budget Entry

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

Table Type: Company

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

Table Number: 1109

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Budget Name]
   ,[Cost Type No_]
   ,[Date]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Amount]
   ,[Description]
   ,[Document No_]
   ,[Source Code]
   ,[System-Created Entry]
   ,[Allocated]
   ,[Allocated with Journal No_]
   ,[Last Modified By User]
   ,[Last Date Modified]
   ,[Allocation Description]
   ,[Allocation ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Cost 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_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
      ON
         [Cost Budget Entry].[Budget Name] = [G_L Budget Name].[Budget Name]

Show/hide columns in Cost 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 [Cost Budget Entry].[Budget Name] ,[G_L Budget Name].[Budget Name] FROM [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry] LEFT JOIN [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name] ON [Cost Budget Entry].[Budget Name] = [G_L Budget Name].[Budget Name]
4	Cost Type No_	nvarchar(40)
5	Date	datetime
6	Cost Center Code	nvarchar(40)
7	Cost Object Code	nvarchar(40)
8	Amount	decimal(38,38)
9	Description	nvarchar(200)
10	Document No_	nvarchar(40)
11	Source Code	nvarchar(20)
12	System-Created Entry	tinyint
13	Allocated	tinyint
14	Allocated with Journal No_	int
15	Last Modified By User	nvarchar(100)
16	Last Date Modified	datetime
17	Allocation Description	nvarchar(160)
18	Allocation ID	nvarchar(20)
19	$systemId	uniqueidentifier
20	$systemCreatedAt	datetime
21	$systemCreatedBy	uniqueidentifier
22	$systemModifiedAt	datetime
23	$systemModifiedBy	uniqueidentifier