Check Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCheck Ledger Entry

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

Table Type: Company

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

Table Number: 272

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Bank Account No_]
   ,[Bank Account Ledger Entry No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Amount]
   ,[Check Date]
   ,[Check No_]
   ,[Check Type]
   ,[Bank Payment Type]
   ,[Entry Status]
   ,[Original Entry Status]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Open]
   ,[Statement Status]
   ,[Statement No_]
   ,[Statement Line No_]
   ,[User ID]
   ,[External Document No_]
   ,[Data Exch_ Entry No_]
   ,[Data Exch_ Voided Entry No_]
   ,[Positive Pay Exported]
   ,[Record ID to Print]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Check 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_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Check Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Check Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Check Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Check Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Check Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Check Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Check Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Check 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
2	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 [Check Ledger Entry].[Bank Account No_] ,[Bank Account].[No_] FROM [CRONUS UK Ltd_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Check Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] ON [Check Ledger Entry].[Bank Account No_] = [Bank Account].[No_]
3	Bank Account Ledger Entry No.	Bank Account Ledger Entry No.	Normal	Integer	4	Bank Account Ledger Entry No_	int
	Key to join to the Bank Account Ledger Entry table. Show/hide example query SELECT [Check Ledger Entry].[Bank Account Ledger Entry No_] ,[Bank Account Ledger Entry].[Entry No_] FROM [CRONUS UK Ltd_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Check Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Bank Account Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Ledger Entry] ON [Check Ledger Entry].[Bank Account Ledger Entry No_] = [Bank Account Ledger Entry].[Entry 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)
8	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
9	Check Date	Check Date	Normal	Date	4	Check Date	datetime
10	Check No.	Check No.	Normal	Code	20	Check No_	nvarchar(40)
11	Check Type	Check Type	Normal	Option	4	Check Type	int
	Available options are: “Total Check” “Partial Check”
12	Bank Payment Type	Bank Payment Type	Normal	Option	4	Bank Payment Type	int
	Available options are: ” “ “Computer Check” “Manual Check” “Electronic Payment” “Electronic Payment-IAT”
13	Entry Status	Entry Status	Normal	Option	4	Entry Status	int
	Available options are: “” “Printed” “Voided” “Posted” “Financially Voided” “Test Print” “Exported” “Transmitted”
14	Original Entry Status	Original Entry Status	Normal	Option	4	Original Entry Status	int
	Available options are: ” “ “Printed” “Voided” “Posted” “Financially VoidedExported” “Transmitted”
15	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”
16	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
17	Open	Open	Normal	Boolean	4	Open	tinyint
18	Statement Status	Statement Status	Normal	Option	4	Statement Status	int
	Available options are: “Open” “Bank Acc. Entry Applied” “Check Entry Applied” “Closed”
19	Statement No.	Statement No.	Normal	Code	20	Statement No_	nvarchar(40)
20	Statement Line No.	Statement Line No.	Normal	Integer	4	Statement Line No_	int
21	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
22	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
23	Data Exch. Entry No.	Data Exch. Entry No.	Normal	Integer	4	Data Exch_ Entry No_	int
	Key to join to the Data Exch. table. Show/hide example query SELECT [Check Ledger Entry].[Data Exch_ Entry No_] ,[Data Exch.].[Entry No_] FROM [CRONUS UK Ltd_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Check Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.] ON [Check Ledger Entry].[Data Exch_ Entry No_] = [Data Exch.].[Entry No_]
24	Data Exch. Voided Entry No.	Data Exch. Voided Entry No.	Normal	Integer	4	Data Exch_ Voided Entry No_	int
	Key to join to the Data Exch. table. Show/hide example query SELECT [Check Ledger Entry].[Data Exch_ Voided Entry No_] ,[Data Exch.].[Entry No_] FROM [CRONUS UK Ltd_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Check Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Data Exch_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch.] ON [Check Ledger Entry].[Data Exch_ Voided Entry No_] = [Data Exch.].[Entry No_]
25	Positive Pay Exported	Positive Pay Exported	Normal	Boolean	4	Positive Pay Exported	tinyint
26	Record ID to Print	Record ID to Print	Normal	RecordID	448	Record ID to Print	varbinary(448)
10005	Trace No.	Trace No.	Normal	Code	30
10006	Transmission File Name	Transmission File Name	Normal	Text	30
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 [Check Ledger Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Check Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Check Ledger Entry] LEFT JOIN [User] AS [User] ON [Check 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 Check Ledger Entry table

Dynamics 365 BC Table Reference Tables Company Tables CCheck Ledger Entry

Leave a Reply Cancel reply