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
   [timestamp]
   ,[Entry No_]
   ,[Budget Name]
   ,[Cost Type No_]
   ,[Date]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Amount]
   ,[Description]
   ,[Document No_]
   ,[Source Code]
   ,[System-Created Entry]
   ,[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].[Budget Name]

Show/hide columns in Cost Budget Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Budget Name Searchnvarchar(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].[Budget 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].[Budget Name]
4Cost Type No_ Searchnvarchar(40)
5Date Searchdatetime
6Cost Center Code Searchnvarchar(40)
7Cost Object Code Searchnvarchar(40)
8Amount Searchdecimal(38,38)
9Description Searchnvarchar(200)
10Document No_ Searchnvarchar(40)
11Source Code Searchnvarchar(20)
12System-Created Entry Searchtinyint
13Allocated Searchtinyint
14Allocated with Journal No_ Searchint
15Last Modified By User Searchnvarchar(100)
16Last Date Modified Searchdatetime
17Allocation Description Searchnvarchar(160)
18Allocation ID Searchnvarchar(20)
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Cost Budget Entry table

Leave a Reply

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