Cost Type

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

Table Type: Company

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

Table Number: 1103

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Name]
   ,[Search Name]
   ,[Type]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Combine Entries]
   ,[Blocked]
   ,[New Page]
   ,[Blank Line]
   ,[Indentation]
   ,[Comment]
   ,[Cost Classification]
   ,[Fixed Share]
   ,[Modified Date]
   ,[Modified By]
   ,[Totaling]
   ,[Budget at Date]
   ,[G_L Account Range]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cost Type table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Search Name Searchnvarchar(200)
5Type Searchint
6Cost Center Code Searchnvarchar(40)
7Cost Object Code Searchnvarchar(40)
8Combine Entries Searchint
9Blocked Searchtinyint
10New Page Searchtinyint
11Blank Line Searchtinyint
12Indentation Searchint
13Comment Searchnvarchar(100)
14Cost Classification Searchint
15Fixed Share Searchnvarchar(60)
16Modified Date Searchdatetime
17Modified By Searchnvarchar(100)
18Totaling Searchnvarchar(500)
19Budget at Date Searchdecimal(38,38)
20G_L Account Range Searchnvarchar(100)
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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