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: 271

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
   [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_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Bank Account Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Bank Account Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Bank Account Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Bank Account Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Bank Account Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Bank Account Ledger Entry].[Our Contact Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Bank Account Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Bank Account Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Bank Account Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Account Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Account Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Bank Account Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
3Bank Account No. SearchBank Account No.NormalCode20Bank Account No_nvarchar(40)
Key to join to the Bank Account table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Bank Account Ledger Entry].[Bank Account No_] = [Bank Account].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
11Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
13Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
14Remaining Amount SearchRemaining AmountNormalDecimal12Remaining Amountdecimal(38,38)
17Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
22Bank Acc. Posting Group SearchBank Acc. Posting GroupNormalCode20Bank Acc_ Posting Groupnvarchar(40)
Key to join to the Bank Account Posting Group table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Bank Acc_ Posting Group]
       ,[Bank Account Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Posting Group]
              ON
                     [Bank Account Ledger Entry].[Bank Acc_ Posting Group] = [Bank Account Posting Group].[Code]
23Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Bank Account Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
24Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Bank Account Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
25Our Contact Code SearchOur Contact CodeNormalCode20Our Contact Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Our Contact Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Bank Account Ledger Entry].[Our Contact Code] = [Salesperson/Purchaser].[Code]
27User ID SearchUser IDNormalCode50User IDnvarchar(100)
28Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Bank Account Ledger Entry].[Source Code] = [Source Code].[Code]
36Open SearchOpenNormalBoolean4Opentinyint
43Positive SearchPositiveNormalBoolean4Positivetinyint
44Closed by Entry No. SearchClosed by Entry No.NormalInteger4Closed by Entry No_int
45Closed at Date SearchClosed at DateNormalDate4Closed at Datedatetime
48Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
49Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
50Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Bank Account Ledger Entry].[Reason Code] = [Reason Code].[Code]
51Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
52Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
53Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
55Statement Status SearchStatement StatusNormalOption4Statement Statusint
Available options are:
  • “Open”
  • “Bank Acc. Entry Applied”
  • “Check Entry Applied”
  • “Closed”
56Statement No. SearchStatement No.NormalCode20Statement No_nvarchar(40)
57Statement Line No. SearchStatement Line No.NormalInteger4Statement Line No_int
58Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
59Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
60Debit Amount (LCY) SearchDebit Amount ($)NormalDecimal12Debit Amount (LCY)decimal(38,38)
61Credit Amount (LCY) SearchCredit Amount ($)NormalDecimal12Credit Amount (LCY)decimal(38,38)
62Document Date SearchDocument DateNormalDate4Document Datedatetime
63External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
64Reversed SearchReversedNormalBoolean4Reversedtinyint
65Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
66Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
70Check Ledger Entries SearchCheck Ledger EntriesFlowFieldInteger4
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Bank Account Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Bank Account Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Bank Account Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Bank Account Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Bank Account Ledger Entry table

Leave a Reply

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