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: 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Bank Account No_	nvarchar(40)
4	Posting Date	datetime
5	Document Type	int
6	Document No_	nvarchar(40)
7	Description	nvarchar(200)
8	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]
9	Amount	decimal(38,38)
10	Remaining Amount	decimal(38,38)
11	Amount (LCY)	decimal(38,38)
12	Bank Acc_ Posting Group	nvarchar(40)
13	Global Dimension 1 Code	nvarchar(40)
14	Global Dimension 2 Code	nvarchar(40)
15	Our Contact Code	nvarchar(40)
16	User ID	nvarchar(100)
17	Source Code	nvarchar(20)
18	Open	tinyint
19	Positive	tinyint
20	Closed by Entry No_	int
21	Closed at Date	datetime
22	Journal Templ_ Name	nvarchar(20)
23	Journal Batch Name	nvarchar(20)
24	Reason Code	nvarchar(20)
25	Bal_ Account Type	int
26	Bal_ Account No_	nvarchar(40)
27	Transaction No_	int
28	Statement Status	int
29	Statement No_	nvarchar(40)
30	Statement Line No_	int
31	Debit Amount	decimal(38,38)
32	Credit Amount	decimal(38,38)
33	Debit Amount (LCY)	decimal(38,38)
34	Credit Amount (LCY)	decimal(38,38)
35	Document Date	datetime
36	External Document No_	nvarchar(70)
37	Reversed	tinyint
38	Reversed by Entry No_	int
39	Reversed Entry No_	int
40	Dimension Set ID	int
41	$systemId	uniqueidentifier
42	$systemCreatedAt	datetime
43	$systemCreatedBy	uniqueidentifier
44	$systemModifiedAt	datetime
45	$systemModifiedBy	uniqueidentifier