Bank Acc_ Reconciliation

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

Table Type: Company

Table Name: Bank Acc_ Reconciliation
Database Table Name: CRONUS UK Ltd_$Bank Acc_ Reconciliation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 273

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 Bank Acc_ Reconciliation can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Acc_ Reconciliation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Statement Type]
   ,[Bank Account No_]
   ,[Statement No_]
   ,[Statement Ending Balance]
   ,[Statement Date]
   ,[Balance Last Statement]
   ,[Bank Statement]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Post Payments Only]
   ,[Import Posted Transactions]
   ,[Copy VAT Setup to Jnl_ Line]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bank Acc_ Reconciliation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Bank Acc_ Reconciliation table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Statement Type Primary Key Searchint
3Bank Account No_ Primary Key Searchnvarchar(40)
4Statement No_ Primary Key Searchnvarchar(40)
5Statement Ending Balance Searchdecimal(38,38)
6Statement Date Searchdatetime
7Balance Last Statement Searchdecimal(38,38)
8Bank Statement Searchimage
9Shortcut Dimension 1 Code Searchnvarchar(40)
10Shortcut Dimension 2 Code Searchnvarchar(40)
11Post Payments Only Searchtinyint
12Import Posted Transactions Searchint
13Copy VAT Setup to Jnl_ Line Searchtinyint
14Dimension Set ID Searchint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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