G/L Budget Name

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

Table Type: Company

Table Name: G/L Budget Name
Database Table Name: CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 95

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Name]
   ,[Description]
   ,[Blocked]
   ,[Budget Dimension 1 Code]
   ,[Budget Dimension 2 Code]
   ,[Budget Dimension 3 Code]
   ,[Budget Dimension 4 Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Name].[Budget Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Name].[Budget Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Name].[Budget Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [G/L Budget Name].[Budget Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Budget Name].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Budget Name].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Budget Name table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Name Primary Key SearchNameNormalCode10Namenvarchar(20)
2Description SearchDescriptionNormalText80Descriptionnvarchar(160)
3Blocked SearchBlockedNormalBoolean4Blockedtinyint
4Budget Dimension 1 Code SearchBudget Dimension 1 CodeNormalCode20Budget Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Name].[Budget Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Name].[Budget Dimension 1 Code] = [Dimension].[Code]
5Budget Dimension 2 Code SearchBudget Dimension 2 CodeNormalCode20Budget Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Name].[Budget Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Name].[Budget Dimension 2 Code] = [Dimension].[Code]
6Budget Dimension 3 Code SearchBudget Dimension 3 CodeNormalCode20Budget Dimension 3 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Name].[Budget Dimension 3 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Name].[Budget Dimension 3 Code] = [Dimension].[Code]
7Budget Dimension 4 Code SearchBudget Dimension 4 CodeNormalCode20Budget Dimension 4 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [G/L Budget Name].[Budget Dimension 4 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [G/L Budget Name].[Budget Dimension 4 Code] = [Dimension].[Code]
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 Budget Name].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Budget Name].[$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 Budget Name].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Budget Name].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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