Cost Budget Register – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost Budget Register

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

Table Type: Company

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

Table Number: 1111

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Source]
   ,[Description]
   ,[From Budget Entry No_]
   ,[To Budget Entry No_]
   ,[From Cost Budget Entry No_]
   ,[To Cost Budget Entry No_]
   ,[No_ of Entries]
   ,[Amount]
   ,[Processed Date]
   ,[Posting Date]
   ,[Closed]
   ,[Level]
   ,[User ID]
   ,[Journal Batch Name]
   ,[Cost Budget Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Cost Budget Register$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 Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Name]
      ON
         [Cost Budget Register].[Cost Budget Name] = [Cost Budget Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Budget Register].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Budget Register].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Budget Register table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Integer	4	No_	int
2	Source	Source	Normal	Option	4	Source	int
	Available options are: “Transfer from G/L Budget” “Cost Journal” “Allocation” “Manual”
3	Description	Description	Normal	Text	100	Description	nvarchar(200)
4	From Budget Entry No.	From Budget Entry No.	Normal	Integer	4	From Budget Entry No_	int
	Key to join to the G/L Budget Entry table. Show/hide example query SELECT [Cost Budget Register].[From Budget Entry No_] ,[G/L Budget Entry].[Entry No_] FROM [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register] LEFT JOIN [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry] ON [Cost Budget Register].[From Budget Entry No_] = [G/L Budget Entry].[Entry No_]
5	To Budget Entry No.	To Budget Entry No.	Normal	Integer	4	To Budget Entry No_	int
	Key to join to the G/L Budget Entry table. Show/hide example query SELECT [Cost Budget Register].[To Budget Entry No_] ,[G/L Budget Entry].[Entry No_] FROM [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register] LEFT JOIN [CRONUS UK Ltd_$G_L Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Entry] ON [Cost Budget Register].[To Budget Entry No_] = [G/L Budget Entry].[Entry No_]
6	From Cost Budget Entry No.	From Cost Budget Entry No.	Normal	Integer	4	From Cost Budget Entry No_	int
	Key to join to the Cost Budget Entry table. Show/hide example query SELECT [Cost Budget Register].[From Cost Budget Entry No_] ,[Cost Budget Entry].[Entry No_] FROM [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register] LEFT JOIN [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry] ON [Cost Budget Register].[From Cost Budget Entry No_] = [Cost Budget Entry].[Entry No_]
7	To Cost Budget Entry No.	To Cost Budget Entry No.	Normal	Integer	4	To Cost Budget Entry No_	int
	Key to join to the Cost Budget Entry table. Show/hide example query SELECT [Cost Budget Register].[To Cost Budget Entry No_] ,[Cost Budget Entry].[Entry No_] FROM [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register] LEFT JOIN [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry] ON [Cost Budget Register].[To Cost Budget Entry No_] = [Cost Budget Entry].[Entry No_]
8	No. of Entries	No. of Entries	Normal	Integer	4	No_ of Entries	int
15	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
20	Processed Date	Processed Date	Normal	Date	4	Processed Date	datetime
21	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
23	Closed	Closed	Normal	Boolean	4	Closed	tinyint
25	Level	Level	Normal	Integer	4	Level	int
31	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
32	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
33	Cost Budget Name	Cost Budget Name	Normal	Code	10	Cost Budget Name	nvarchar(20)
	Key to join to the Cost Budget Name table. Show/hide example query SELECT [Cost Budget Register].[Cost Budget Name] ,[Cost Budget Name].[Name] FROM [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register] LEFT JOIN [CRONUS UK Ltd_$Cost Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Name] ON [Cost Budget Register].[Cost Budget Name] = [Cost Budget Name].[Name]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Cost Budget Register].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Register] LEFT JOIN [User] AS [User] ON [Cost Budget Register].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables CCost Budget Register

Leave a Reply Cancel reply