G/L Acc. Budget Buffer

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

Table Type: Company

Table Name: G/L Acc. Budget Buffer
Database Table Name:

Table Number: 374

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

Show/hide an example select of all columns

SELECT
   *
FROM
   []

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Income_Balance]
   ,[Account Category]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   []

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

SELECT
   *
FROM
   [] AS [G/L Acc. Budget Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
      ON
         [G/L Acc. Budget Buffer].[Budget Filter] = [G/L Budget Name].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [G/L Acc. Budget Buffer].[Business Unit Filter] = [Business Unit].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Acc. Budget Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Acc. Budget Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Acc. Budget Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
3Budget Filter SearchBudget FilterFlowFilterCode10
4G/L Account Filter SearchG/L Account FilterFlowFilterCode20
5Business Unit Filter SearchBusiness Unit FilterFlowFilterCode20
6Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
7Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
8Budget Dimension 1 Filter SearchBudget Dimension 1 FilterFlowFilterCode20
9Budget Dimension 2 Filter SearchBudget Dimension 2 FilterFlowFilterCode20
10Budget Dimension 3 Filter SearchBudget Dimension 3 FilterFlowFilterCode20
11Budget Dimension 4 Filter SearchBudget Dimension 4 FilterFlowFilterCode20
12Date Filter SearchDate FilterFlowFilterDate4
13Budgeted Amount SearchBudgeted AmountFlowFieldDecimal12
14Income/Balance SearchIncome/BalanceNormalOption4Income_Balanceint
Available options are:
  • ” “
  • “Income Statement”
  • “Balance Sheet”
15Account Category SearchAccount CategoryNormalOption4Account Categoryint
Available options are:
  • ” “
  • “Assets”
  • “Liabilities”
  • “Equity”
  • “Income”
  • “Cost of Goods Sold”
  • “Expense”
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
       [G/L Acc. Budget Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [] AS [G/L Acc. Budget Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Acc. Budget Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [G/L Acc. Budget Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [] AS [G/L Acc. Budget Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Acc. Budget Buffer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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