Gen_ Jnl_ Dim_ Filter

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

Table Type: Company

Table Name: Gen_ Jnl_ Dim_ Filter
Database Table Name: CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 357

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 Gen_ Jnl_ Dim_ Filter can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[Journal Line No_]
   ,[Dimension Code]
   ,[Dimension Value Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Gen_ Jnl_ Dim_ Filter table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Journal Line No_ Primary Key Searchint
5Dimension Code Primary Key Searchnvarchar(40)
6Dimension Value Filter Searchnvarchar(500)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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