Cust_ Ledger Entry

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

Table Type: Company

Table Name: Cust_ Ledger Entry
Database Table Name: CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Payment Prediction]
   ,[Customer No_]
   ,[Prediction Confidence]
   ,[Posting Date]
   ,[Prediction Confidence _]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Customer Name]
   ,[Currency Code]
   ,[Sales (LCY)]
   ,[Profit (LCY)]
   ,[Inv_ Discount (LCY)]
   ,[Sell-to Customer No_]
   ,[Customer Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Salesperson Code]
   ,[User ID]
   ,[Source Code]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Open]
   ,[Due Date]
   ,[Pmt_ Discount Date]
   ,[Original Pmt_ Disc_ Possible]
   ,[Pmt_ Disc_ Given (LCY)]
   ,[Orig_ Pmt_ Disc_ Possible(LCY)]
   ,[Positive]
   ,[Closed by Entry No_]
   ,[Closed at Date]
   ,[Closed by Amount]
   ,[Applies-to ID]
   ,[Journal Templ_ Name]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Transaction No_]
   ,[Closed by Amount (LCY)]
   ,[Document Date]
   ,[External Document No_]
   ,[Calculate Interest]
   ,[Closing Interest Calculated]
   ,[No_ Series]
   ,[Closed by Currency Code]
   ,[Closed by Currency Amount]
   ,[Adjusted Currency Factor]
   ,[Original Currency Factor]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Pmt_ Disc_ Tolerance Date]
   ,[Max_ Payment Tolerance]
   ,[Last Issued Reminder Level]
   ,[Accepted Payment Tolerance]
   ,[Accepted Pmt_ Disc_ Tolerance]
   ,[Pmt_ Tolerance (LCY)]
   ,[Amount to Apply]
   ,[IC Partner Code]
   ,[Applying Entry]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Prepayment]
   ,[Payment Reference]
   ,[Payment Method Code]
   ,[Applies-to Ext_ Doc_ No_]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[Direct Debit Mandate ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust_ Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Cust_ Ledger Entry].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Cust_ Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Cust_ Ledger Entry].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Cust_ Ledger Entry].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Cust_ Ledger Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Cust_ Ledger Entry].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Cust_ Ledger Entry].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Cust_ Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Cust_ Ledger Entry].[Customer No_] = [Customer].[No_]
3Payment Prediction Searchint
4Posting Date Searchdatetime
4Prediction Confidence Searchint
5Document Type Searchint
5Prediction Confidence _ Searchdecimal(38,38)
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Customer Name Searchnvarchar(200)
9Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Cust_ Ledger Entry].[Currency Code] = [Currency].[Code]
10Sales (LCY) Searchdecimal(38,38)
11Profit (LCY) Searchdecimal(38,38)
12Inv_ Discount (LCY) Searchdecimal(38,38)
13Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Cust_ Ledger Entry].[Sell-to Customer No_] = [Customer].[No_]
14Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Cust_ Ledger Entry].[Customer Posting Group] = [Customer Posting Group].[Code]
15Global Dimension 1 Code Searchnvarchar(40)
16Global Dimension 2 Code Searchnvarchar(40)
17Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Cust_ Ledger Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]
18User ID Searchnvarchar(100)
19Source Code Searchnvarchar(20)
20On Hold Searchnvarchar(6)
21Applies-to Doc_ Type Searchint
22Applies-to Doc_ No_ Searchnvarchar(40)
23Open Searchtinyint
24Due Date Searchdatetime
25Pmt_ Discount Date Searchdatetime
26Original Pmt_ Disc_ Possible Searchdecimal(38,38)
27Pmt_ Disc_ Given (LCY) Searchdecimal(38,38)
28Orig_ Pmt_ Disc_ Possible(LCY) Searchdecimal(38,38)
29Positive Searchtinyint
30Closed by Entry No_ Searchint
31Closed at Date Searchdatetime
32Closed by Amount Searchdecimal(38,38)
33Applies-to ID Searchnvarchar(100)
34Journal Templ_ Name Searchnvarchar(20)
35Journal Batch Name Searchnvarchar(20)
36Reason Code Searchnvarchar(20)
37Bal_ Account Type Searchint
38Bal_ Account No_ Searchnvarchar(40)
39Transaction No_ Searchint
40Closed by Amount (LCY) Searchdecimal(38,38)
41Document Date Searchdatetime
42External Document No_ Searchnvarchar(70)
43Calculate Interest Searchtinyint
44Closing Interest Calculated Searchtinyint
45No_ Series Searchnvarchar(40)
46Closed by Currency Code Searchnvarchar(20)
47Closed by Currency Amount Searchdecimal(38,38)
48Adjusted Currency Factor Searchdecimal(38,38)
49Original Currency Factor Searchdecimal(38,38)
50Remaining Pmt_ Disc_ Possible Searchdecimal(38,38)
51Pmt_ Disc_ Tolerance Date Searchdatetime
52Max_ Payment Tolerance Searchdecimal(38,38)
53Last Issued Reminder Level Searchint
54Accepted Payment Tolerance Searchdecimal(38,38)
55Accepted Pmt_ Disc_ Tolerance Searchtinyint
56Pmt_ Tolerance (LCY) Searchdecimal(38,38)
57Amount to Apply Searchdecimal(38,38)
58IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Cust_ Ledger Entry].[IC Partner Code] = [IC Partner].[Code]
59Applying Entry Searchtinyint
60Reversed Searchtinyint
61Reversed by Entry No_ Searchint
62Reversed Entry No_ Searchint
63Prepayment Searchtinyint
64Payment Reference Searchnvarchar(100)
65Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Cust_ Ledger Entry].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [Cust_ Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Cust_ Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
66Applies-to Ext_ Doc_ No_ Searchnvarchar(70)
67Recipient Bank Account Searchnvarchar(40)
68Message to Recipient Searchnvarchar(280)
69Exported to Payment File Searchtinyint
70Dimension Set ID Searchint
71Direct Debit Mandate ID Searchnvarchar(70)
72$systemId Searchuniqueidentifier
73$systemCreatedAt Searchdatetime
74$systemCreatedBy Searchuniqueidentifier
75$systemModifiedAt Searchdatetime
76$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Cust_ Ledger Entry table

Leave a Reply

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