Cost Budget Register

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

Table Type: Company

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

Table Number: 1111

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Source]
   ,[Description]
   ,[From Budget Entry No_]
   ,[To Budget Entry No_]
   ,[From Cost Budget Entry No_]
   ,[To Cost Budget Entry No_]
   ,[No_ of Entries]
   ,[Amount]
   ,[Processed Date]
   ,[Posting Date]
   ,[Closed]
   ,[Level]
   ,[User ID]
   ,[Journal Batch Name]
   ,[Cost Budget Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cost Budget Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cost Budget Register table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Source Searchint
4Description Searchnvarchar(200)
5From Budget Entry No_ Searchint
6To Budget Entry No_ Searchint
7From Cost Budget Entry No_ Searchint
8To Cost Budget Entry No_ Searchint
9No_ of Entries Searchint
10Amount Searchdecimal(38,38)
11Processed Date Searchdatetime
12Posting Date Searchdatetime
13Closed Searchtinyint
14Level Searchint
15User ID Searchnvarchar(100)
16Journal Batch Name Searchnvarchar(20)
17Cost Budget Name Searchnvarchar(20)
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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