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: 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 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
   [timestamp]
   ,[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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Detailed Cust_ Ledg_ Entry].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Detailed Cust_ Ledg_ Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Detailed Cust_ Ledg_ Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Cust_ Ledger Entry No_ Searchint
4Entry Type Searchint
5Posting Date Searchdatetime
6Document Type Searchint
7Document No_ Searchnvarchar(40)
8Amount Searchdecimal(38,38)
9Amount (LCY) Searchdecimal(38,38)
10Customer No_ Searchnvarchar(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_]
11Currency Code Searchnvarchar(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]
12User ID Searchnvarchar(100)
13Source Code Searchnvarchar(20)
14Transaction No_ Searchint
15Journal Batch Name Searchnvarchar(20)
16Reason Code Searchnvarchar(20)
17Debit Amount Searchdecimal(38,38)
18Credit Amount Searchdecimal(38,38)
19Debit Amount (LCY) Searchdecimal(38,38)
20Credit Amount (LCY) Searchdecimal(38,38)
21Initial Entry Due Date Searchdatetime
22Initial Entry Global Dim_ 1 Searchnvarchar(40)
23Initial Entry Global Dim_ 2 Searchnvarchar(40)
24Gen_ Bus_ Posting Group Searchnvarchar(40)
25Gen_ Prod_ Posting Group Searchnvarchar(40)
26Use Tax Searchtinyint
27VAT Bus_ Posting Group Searchnvarchar(40)
28VAT Prod_ Posting Group Searchnvarchar(40)
29Initial Document Type Searchint
30Applied Cust_ Ledger Entry No_ Searchint
31Unapplied Searchtinyint
32Unapplied by Entry No_ Searchint
33Remaining Pmt_ Disc_ Possible Searchdecimal(38,38)
34Max_ Payment Tolerance Searchdecimal(38,38)
35Tax Jurisdiction Code Searchnvarchar(20)
36Application No_ Searchint
37Ledger Entry Amount Searchtinyint
38Posting Group Searchnvarchar(40)
39Exch_ Rate Adjmt_ Reg_ No_ Searchint
40$systemId Searchuniqueidentifier
41$systemCreatedAt Searchdatetime
42$systemCreatedBy Searchuniqueidentifier
43$systemModifiedAt Searchdatetime
44$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Detailed Cust_ Ledg_ Entry table

Leave a Reply

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