Ledger Entry Matching Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables LLedger Entry Matching Buffer

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

Table Type: Company

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

Table Number: 1248

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Account Type]
   ,[Account No_]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Description]
   ,[Document Type]
   ,[Due Date]
   ,[Posting Date]
   ,[Document No_]
   ,[External Document No_]
   ,[Payment Reference]
   ,[Remaining Amount]
   ,[Remaining Amt_ Incl_ Discount]
   ,[Pmt_ Discount Due Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Ledger Entry Matching Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ledger Entry Matching Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Ledger Entry Matching Buffer].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Ledger Entry Matching Buffer].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Ledger Entry Matching Buffer].[Document Type] = [Sales Header].[Document Type]
      AND
         [Ledger Entry Matching Buffer].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Ledger Entry Matching Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Ledger Entry Matching Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Ledger Entry Matching Buffer 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	Account Type	Account Type	Normal	Option	4	Account Type	int
	Available options are: “Customer” “Vendor” “G/L Account” “Bank Account” “Employee”
3	Account No.	Account No.	Normal	Code	20	Account No_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Ledger Entry Matching Buffer].[Account No_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Ledger Entry Matching Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ledger Entry Matching Buffer] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Ledger Entry Matching Buffer].[Account No_] = [G/L Account].[No_]
4	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”
5	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
9	Due Date	Due Date	Normal	Date	4	Due Date	datetime
10	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
11	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
12	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
13	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
20	Remaining Amount	Remaining Amount	Normal	Decimal	12	Remaining Amount	decimal(38,38)
21	Remaining Amt. Incl. Discount	Remaining Amt. Incl. Discount	Normal	Decimal	12	Remaining Amt_ Incl_ Discount	decimal(38,38)
22	Pmt. Discount Due Date	Pmt. Discount Due Date	Normal	Date	4	Pmt_ Discount Due Date	datetime
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 [Ledger Entry Matching Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Ledger Entry Matching Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ledger Entry Matching Buffer] LEFT JOIN [User] AS [User] ON [Ledger Entry Matching Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier