Ledger 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Account Type Primary Key SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “Customer”
  • “Vendor”
  • “G/L Account”
  • “Bank Account”
  • “Employee”
3Account No. SearchAccount No.NormalCode20Account 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_]
4Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
5Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
9Due Date SearchDue DateNormalDate4Due Datedatetime
10Posting Date SearchPosting DateNormalDate4Posting Datedatetime
11Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
12External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
13Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
20Remaining Amount SearchRemaining AmountNormalDecimal12Remaining Amountdecimal(38,38)
21Remaining Amt. Incl. Discount SearchRemaining Amt. Incl. DiscountNormalDecimal12Remaining Amt_ Incl_ Discountdecimal(38,38)
22Pmt. Discount Due Date SearchPmt. Discount Due DateNormalDate4Pmt_ Discount Due Datedatetime
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
       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Ledger Entry Matching Buffer].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Ledger Entry Matching Buffer table

Leave a Reply

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