Cost 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
   [Entry No_]
   ,[Budget Name]
   ,[Cost Type No_]
   ,[Date]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Amount]
   ,[Description]
   ,[Document No_]
   ,[Source Code]
   ,[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].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Budget Entry].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Budget Entry].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Cost Budget Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Budget Entry].[Last Modified By User] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
      ON
         [Cost Budget Entry].[Allocation ID] = [Cost Allocation Source].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Budget Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Budget Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Budget Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Budget Name Primary Key SearchBudget NameNormalCode10Budget Namenvarchar(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].[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].[Name]
3Cost Type No. SearchCost Type No.NormalCode20Cost Type No_nvarchar(40)
Key to join to the Cost Type table.

Show/hide example query

SELECT
	       [Cost Budget Entry].[Cost Type No_]
	       ,[Cost Type].[No_]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
	              ON
	                     [Cost Budget Entry].[Cost Type No_] = [Cost Type].[No_]
4Date SearchDateNormalDate4Datedatetime
5Cost Center Code SearchCost Center CodeNormalCode20Cost Center Codenvarchar(40)
Key to join to the Cost Center table.

Show/hide example query

SELECT
	       [Cost Budget Entry].[Cost Center Code]
	       ,[Cost Center].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
	              ON
	                     [Cost Budget Entry].[Cost Center Code] = [Cost Center].[Code]
6Cost Object Code SearchCost Object CodeNormalCode20Cost Object Codenvarchar(40)
Key to join to the Cost Object table.

Show/hide example query

SELECT
	       [Cost Budget Entry].[Cost Object Code]
	       ,[Cost Object].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
	              ON
	                     [Cost Budget Entry].[Cost Object Code] = [Cost Object].[Code]
7Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
9Description SearchDescriptionNormalText100Descriptionnvarchar(200)
20Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
30Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Cost Budget Entry].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Cost Budget Entry].[Source Code] = [Source Code].[Code]
31System-Created Entry SearchSystem-Created EntryNormalBoolean4
32Allocated SearchAllocatedNormalBoolean4Allocatedtinyint
33Allocated with Journal No. SearchAllocated with Journal No.NormalInteger4Allocated with Journal No_int
40Last Modified By User SearchLast Modified By UserNormalCode50Last Modified By Usernvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
	       [Cost Budget Entry].[Last Modified By User]
	       ,[User].[User Name]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Cost Budget Entry].[Last Modified By User] = [User].[User Name]
42Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
50Allocation Description SearchAllocation DescriptionNormalText80Allocation Descriptionnvarchar(160)
51Allocation ID SearchAllocation IDNormalCode10Allocation IDnvarchar(20)
Key to join to the Cost Allocation Source table.

Show/hide example query

SELECT
	       [Cost Budget Entry].[Allocation ID]
	       ,[Cost Allocation Source].[ID]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
	              ON
	                     [Cost Budget Entry].[Allocation ID] = [Cost Allocation Source].[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
	       [Cost Budget Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Cost Budget Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Cost Budget Entry table

Leave a Reply

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