Payment Jnl_ Export Error Text

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

Table Type: Company

Table Name: Payment Jnl_ Export Error Text
Database Table Name: CRONUS UK Ltd_$Payment Jnl_ Export Error Text$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1228

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 Payment Jnl_ Export Error Text can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Payment Jnl_ Export Error Text$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[Document No_]
   ,[Journal Line No_]
   ,[Line No_]
   ,[Error Text]
   ,[Additional Information]
   ,[Support URL]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Payment Jnl_ Export Error Text$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Payment Jnl_ Export Error Text table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Document No_ Primary Key Searchnvarchar(40)
5Journal Line No_ Primary Key Searchint
6Line No_ Primary Key Searchint
7Error Text Searchnvarchar(500)
8Additional Information Searchnvarchar(500)
9Support URL Searchnvarchar(500)
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 *