Cost Journal Batch

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

Table Type: Company

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

Table Number: 1102

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Journal Template Name]
   ,[Name]
   ,[Description]
   ,[Reason Code]
   ,[Bal_ Cost Type No_]
   ,[Bal_ Cost Center Code]
   ,[Bal_ Cost Object Code]
   ,[Delete after Posting]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cost Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cost Journal Batch table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Name Primary Key Searchnvarchar(20)
4Description Searchnvarchar(200)
5Reason Code Searchnvarchar(20)
6Bal_ Cost Type No_ Searchnvarchar(40)
7Bal_ Cost Center Code Searchnvarchar(40)
8Bal_ Cost Object Code Searchnvarchar(40)
9Delete after Posting Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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