Bank Account Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables BBank 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
3	Bank Account No.	Bank Account No.	Normal	Code	20	Bank 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_]
4	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
5	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
6	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
11	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
13	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
14	Remaining Amount	Remaining Amount	Normal	Decimal	12	Remaining Amount	decimal(38,38)
17	Amount (LCY)	Amount ($)	Normal	Decimal	12	Amount (LCY)	decimal(38,38)
22	Bank Acc. Posting Group	Bank Acc. Posting Group	Normal	Code	20	Bank Acc_ Posting Group	nvarchar(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]
23	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(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]
24	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(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]
25	Our Contact Code	Our Contact Code	Normal	Code	20	Our Contact Code	nvarchar(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]
27	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
28	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(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]
36	Open	Open	Normal	Boolean	4	Open	tinyint
43	Positive	Positive	Normal	Boolean	4	Positive	tinyint
44	Closed by Entry No.	Closed by Entry No.	Normal	Integer	4	Closed by Entry No_	int
45	Closed at Date	Closed at Date	Normal	Date	4	Closed at Date	datetime
48	Journal Templ. Name	Journal Template Name	Normal	Code	10	Journal Templ_ Name	nvarchar(20)
49	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
50	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
51	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
52	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
53	Transaction No.	Transaction No.	Normal	Integer	4	Transaction No_	int
55	Statement Status	Statement Status	Normal	Option	4	Statement Status	int
	Available options are: “Open” “Bank Acc. Entry Applied” “Check Entry Applied” “Closed”
56	Statement No.	Statement No.	Normal	Code	20	Statement No_	nvarchar(40)
57	Statement Line No.	Statement Line No.	Normal	Integer	4	Statement Line No_	int
58	Debit Amount	Debit Amount	Normal	Decimal	12	Debit Amount	decimal(38,38)
59	Credit Amount	Credit Amount	Normal	Decimal	12	Credit Amount	decimal(38,38)
60	Debit Amount (LCY)	Debit Amount ($)	Normal	Decimal	12	Debit Amount (LCY)	decimal(38,38)
61	Credit Amount (LCY)	Credit Amount ($)	Normal	Decimal	12	Credit Amount (LCY)	decimal(38,38)
62	Document Date	Document Date	Normal	Date	4	Document Date	datetime
63	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
64	Reversed	Reversed	Normal	Boolean	4	Reversed	tinyint
65	Reversed by Entry No.	Reversed by Entry No.	Normal	Integer	4	Reversed by Entry No_	int
66	Reversed Entry No.	Reversed Entry No.	Normal	Integer	4	Reversed Entry No_	int
70	Check Ledger Entries	Check Ledger Entries	FlowField	Integer	4
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
481	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account Ledger Entry].[] ,[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].[] = [Dimension].[Code]
482	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account Ledger Entry].[] ,[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].[] = [Dimension].[Code]
483	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account Ledger Entry].[] ,[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].[] = [Dimension].[Code]
484	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account Ledger Entry].[] ,[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].[] = [Dimension].[Code]
485	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account Ledger Entry].[] ,[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].[] = [Dimension].[Code]
486	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account Ledger Entry].[] ,[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].[] = [Dimension].[Code]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Bank Account Ledger Entry table

Dynamics 365 BC Table Reference Tables Company Tables BBank Account Ledger Entry

Leave a Reply Cancel reply