Bank Account Ledger Entry

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

Table Type: Company

Table Name: Bank Account Ledger Entry
Database Table Name: CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Account Ledger Entry can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Bank Account No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Currency Code]
   ,[Amount]
   ,[Remaining Amount]
   ,[Amount (LCY)]
   ,[Bank Acc_ Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Our Contact Code]
   ,[User ID]
   ,[Source Code]
   ,[Open]
   ,[Positive]
   ,[Closed by Entry No_]
   ,[Closed at Date]
   ,[Journal Templ_ Name]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Transaction No_]
   ,[Statement Status]
   ,[Statement No_]
   ,[Statement Line No_]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Debit Amount (LCY)]
   ,[Credit Amount (LCY)]
   ,[Document Date]
   ,[External Document No_]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Bank Account Ledger Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Bank Account Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Bank Account No_ Searchnvarchar(40)
4Posting Date Searchdatetime
5Document Type Searchint
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Bank Account Ledger Entry].[Currency Code] = [Currency].[Code]
9Amount Searchdecimal(38,38)
10Remaining Amount Searchdecimal(38,38)
11Amount (LCY) Searchdecimal(38,38)
12Bank Acc_ Posting Group Searchnvarchar(40)
13Global Dimension 1 Code Searchnvarchar(40)
14Global Dimension 2 Code Searchnvarchar(40)
15Our Contact Code Searchnvarchar(40)
16User ID Searchnvarchar(100)
17Source Code Searchnvarchar(20)
18Open Searchtinyint
19Positive Searchtinyint
20Closed by Entry No_ Searchint
21Closed at Date Searchdatetime
22Journal Templ_ Name Searchnvarchar(20)
23Journal Batch Name Searchnvarchar(20)
24Reason Code Searchnvarchar(20)
25Bal_ Account Type Searchint
26Bal_ Account No_ Searchnvarchar(40)
27Transaction No_ Searchint
28Statement Status Searchint
29Statement No_ Searchnvarchar(40)
30Statement Line No_ Searchint
31Debit Amount Searchdecimal(38,38)
32Credit Amount Searchdecimal(38,38)
33Debit Amount (LCY) Searchdecimal(38,38)
34Credit Amount (LCY) Searchdecimal(38,38)
35Document Date Searchdatetime
36External Document No_ Searchnvarchar(70)
37Reversed Searchtinyint
38Reversed by Entry No_ Searchint
39Reversed Entry No_ Searchint
40Dimension Set ID Searchint
41$systemId Searchuniqueidentifier
42$systemCreatedAt Searchdatetime
43$systemCreatedBy Searchuniqueidentifier
44$systemModifiedAt Searchdatetime
45$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Bank Account Ledger Entry table

Leave a Reply

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