Budget Buffer

Dynamics 365 BC Table ReferenceTablesCompany TablesBBudget Buffer

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

Table Type: Company

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

Table Number: 371

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [G_L Account No_]
   ,[Dimension Value Code 1]
   ,[Dimension Value Code 2]
   ,[Dimension Value Code 3]
   ,[Dimension Value Code 4]
   ,[Dimension Value Code 5]
   ,[Dimension Value Code 6]
   ,[Dimension Value Code 7]
   ,[Dimension Value Code 8]
   ,[Date]
   ,[Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Budget Buffer]
LEFT JOIN
   [User] AS [User]
      ON
         [Budget Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Budget Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Budget Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1G/L Account No. SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
2Dimension Value Code 1 Primary Key SearchDimension Value Code 1NormalCode20Dimension Value Code 1nvarchar(40)
3Dimension Value Code 2 Primary Key SearchDimension Value Code 2NormalCode20Dimension Value Code 2nvarchar(40)
4Dimension Value Code 3 Primary Key SearchDimension Value Code 3NormalCode20Dimension Value Code 3nvarchar(40)
5Dimension Value Code 4 Primary Key SearchDimension Value Code 4NormalCode20Dimension Value Code 4nvarchar(40)
6Dimension Value Code 5 Primary Key SearchDimension Value Code 5NormalCode20Dimension Value Code 5nvarchar(40)
7Dimension Value Code 6 Primary Key SearchDimension Value Code 6NormalCode20Dimension Value Code 6nvarchar(40)
8Dimension Value Code 7 Primary Key SearchDimension Value Code 7NormalCode20Dimension Value Code 7nvarchar(40)
9Dimension Value Code 8 Primary Key SearchDimension Value Code 8NormalCode20Dimension Value Code 8nvarchar(40)
10Date Primary Key SearchDateNormalDate4Datedatetime
11Amount Primary Key SearchAmountNormalDecimal12Amountdecimal(38,38)
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
	       [Budget Buffer].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Budget Buffer]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Budget Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesBBudget Buffer

Leave a Reply

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