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
   [timestamp]
   ,[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 columns in G_L Budget Name table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Name Primary Key Searchnvarchar(20)
3Description Searchnvarchar(160)
4Blocked Searchtinyint
5Budget Dimension 1 Code Searchnvarchar(40)
6Budget Dimension 2 Code Searchnvarchar(40)
7Budget Dimension 3 Code Searchnvarchar(40)
8Budget Dimension 4 Code Searchnvarchar(40)
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to G_L Budget Name table

Leave a Reply

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