Detailed Cust. Ledg. Entry

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

Table Type: Company

Table Name: Detailed Cust. Ledg. Entry
Database Table Name: CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 379

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 Detailed Cust. Ledg. Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Cust_ Ledger Entry No_]
   ,[Entry Type]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Amount]
   ,[Amount (LCY)]
   ,[Customer No_]
   ,[Currency Code]
   ,[User ID]
   ,[Source Code]
   ,[Transaction No_]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Debit Amount (LCY)]
   ,[Credit Amount (LCY)]
   ,[Initial Entry Due Date]
   ,[Initial Entry Global Dim_ 1]
   ,[Initial Entry Global Dim_ 2]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Initial Document Type]
   ,[Applied Cust_ Ledger Entry No_]
   ,[Unapplied]
   ,[Unapplied by Entry No_]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Max_ Payment Tolerance]
   ,[Tax Jurisdiction Code]
   ,[Application No_]
   ,[Ledger Entry Amount]
   ,[Posting Group]
   ,[Exch_ Rate Adjmt_ Reg_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Detailed Cust_ Ledg_ 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_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Detailed Cust. Ledg. Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Detailed Cust. Ledg. Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Detailed Cust. Ledg. Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Detailed Cust. Ledg. Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Detailed Cust. Ledg. Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Detailed Cust. Ledg. Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Detailed Cust. Ledg. Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
      ON
         [Detailed Cust. Ledg. Entry].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Detailed Cust. Ledg. Entry].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Detailed Cust. Ledg. Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Detailed Cust. Ledg. Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Detailed Cust. Ledg. Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Cust. Ledger Entry No. SearchCust. Ledger Entry No.NormalInteger4Cust_ Ledger Entry No_int
Key to join to the Cust. Ledger Entry table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Cust_ Ledger Entry No_]
       ,[Cust. Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
              ON
                     [Detailed Cust. Ledg. Entry].[Cust_ Ledger Entry No_] = [Cust. Ledger Entry].[Entry No_]
3Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “”
  • “Initial Entry”
  • “Application”
  • “Unrealized Loss”
  • “Unrealized Gain”
  • “Realized Loss”
  • “Realized Gain”
  • “Payment Discount”
  • “Payment Discount (VAT Excl.)”
  • “Payment Discount (VAT Adjustment)”
  • “Appln. Rounding”
  • “Correction of Remaining Amount”
  • “Payment Tolerance”
  • “Payment Discount Tolerance”
  • “Payment Tolerance (VAT Excl.)”
  • “Payment Tolerance (VAT Adjustment)”
  • “Payment Discount Tolerance (VAT Excl.)”
  • “Payment Discount Tolerance (VAT Adjustment)”
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
8Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
9Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Detailed Cust. Ledg. Entry].[Customer No_] = [Customer].[No_]
10Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Detailed Cust. Ledg. Entry].[Currency Code] = [Currency].[Code]
11User ID SearchUser IDNormalCode50User IDnvarchar(100)
12Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Detailed Cust. Ledg. Entry].[Source Code] = [Source Code].[Code]
13Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
14Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
15Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Detailed Cust. Ledg. Entry].[Reason Code] = [Reason Code].[Code]
16Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
17Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
18Debit Amount (LCY) SearchDebit Amount ($)NormalDecimal12Debit Amount (LCY)decimal(38,38)
19Credit Amount (LCY) SearchCredit Amount ($)NormalDecimal12Credit Amount (LCY)decimal(38,38)
20Initial Entry Due Date SearchInitial Entry Due DateNormalDate4Initial Entry Due Datedatetime
21Initial Entry Global Dim. 1 SearchInitial Entry Global Dim. 1NormalCode20Initial Entry Global Dim_ 1nvarchar(40)
22Initial Entry Global Dim. 2 SearchInitial Entry Global Dim. 2NormalCode20Initial Entry Global Dim_ 2nvarchar(40)
24Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Detailed Cust. Ledg. Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
25Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Detailed Cust. Ledg. Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
29Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
30VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Detailed Cust. Ledg. Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
31VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Detailed Cust. Ledg. Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
35Initial Document Type SearchInitial Document TypeNormalOption4Initial Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
36Applied Cust. Ledger Entry No. SearchApplied Cust. Ledger Entry No.NormalInteger4Applied Cust_ Ledger Entry No_int
37Unapplied SearchUnappliedNormalBoolean4Unappliedtinyint
38Unapplied by Entry No. SearchUnapplied by Entry No.NormalInteger4Unapplied by Entry No_int
39Remaining Pmt. Disc. Possible SearchRemaining Pmt. Disc. PossibleNormalDecimal12Remaining Pmt_ Disc_ Possibledecimal(38,38)
40Max. Payment Tolerance SearchMax. Payment ToleranceNormalDecimal12Max_ Payment Tolerancedecimal(38,38)
41Tax Jurisdiction Code SearchTax Jurisdiction CodeNormalCode10Tax Jurisdiction Codenvarchar(20)
Key to join to the Tax Jurisdiction table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Tax Jurisdiction Code]
       ,[Tax Jurisdiction].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
              ON
                     [Detailed Cust. Ledg. Entry].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
42Application No. SearchApplication No.NormalInteger4Application No_int
43Ledger Entry Amount SearchLedger Entry AmountNormalBoolean4Ledger Entry Amounttinyint
44Posting Group SearchCustomer Posting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Detailed Cust. Ledg. Entry].[Posting Group] = [Customer Posting Group].[Code]
45Exch. Rate Adjmt. Reg. No. SearchExch. Rate Adjmt. Reg. No.NormalInteger4Exch_ Rate Adjmt_ Reg_ No_int
Key to join to the Exch. Rate Adjmt. Reg. table.

Show/hide example query

SELECT
       [Detailed Cust. Ledg. Entry].[Exch_ Rate Adjmt_ Reg_ No_]
       ,[Exch. Rate Adjmt. Reg.].[No_]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch. Rate Adjmt. Reg.]
              ON
                     [Detailed Cust. Ledg. Entry].[Exch_ Rate Adjmt_ Reg_ No_] = [Exch. Rate Adjmt. Reg.].[No_]
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
       [Detailed Cust. Ledg. Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Detailed Cust. Ledg. Entry].[$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
       [Detailed Cust. Ledg. Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Detailed Cust_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Cust. Ledg. Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Detailed Cust. Ledg. Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Detailed Cust. Ledg. Entry table

Leave a Reply

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