Gen_ Journal Template

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

Table Type: Company

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

Table Number: 80

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Name]
   ,[Description]
   ,[Test Report ID]
   ,[Page ID]
   ,[Posting Report ID]
   ,[Force Posting Report]
   ,[Type]
   ,[Source Code]
   ,[Reason Code]
   ,[Recurring]
   ,[Force Doc_ Balance]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[Copy VAT Setup to Jnl_ Lines]
   ,[Allow VAT Difference]
   ,[Cust_ Receipt Report ID]
   ,[Vendor Receipt Report ID]
   ,[Increment Batch Name]
   ,[Copy to Posted Jnl_ Lines]
   ,[Allow Posting Date From]
   ,[Allow Posting Date To]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Gen_ Journal Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Name Primary Key Searchnvarchar(20)
3Description Searchnvarchar(160)
4Test Report ID Searchint
5Page ID Searchint
6Posting Report ID Searchint
7Force Posting Report Searchtinyint
8Type Searchint
9Source Code Searchnvarchar(20)
10Reason Code Searchnvarchar(20)
11Recurring Searchtinyint
12Force Doc_ Balance Searchtinyint
13Bal_ Account Type Searchint
14Bal_ Account No_ Searchnvarchar(40)
15No_ Series Searchnvarchar(40)
16Posting No_ Series Searchnvarchar(40)
17Copy VAT Setup to Jnl_ Lines Searchtinyint
18Allow VAT Difference Searchtinyint
19Cust_ Receipt Report ID Searchint
20Vendor Receipt Report ID Searchint
21Increment Batch Name Searchtinyint
22Copy to Posted Jnl_ Lines Searchtinyint
23Allow Posting Date From Searchdatetime
24Allow Posting Date To Searchdatetime
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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