Cust_ Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCust_ 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Customer No_	nvarchar(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_]
3	Payment Prediction	int
4	Posting Date	datetime
4	Prediction Confidence	int
5	Document Type	int
5	Prediction Confidence _	decimal(38,38)
6	Document No_	nvarchar(40)
7	Description	nvarchar(200)
8	Customer Name	nvarchar(200)
9	Currency Code	nvarchar(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]
10	Sales (LCY)	decimal(38,38)
11	Profit (LCY)	decimal(38,38)
12	Inv_ Discount (LCY)	decimal(38,38)
13	Sell-to Customer No_	nvarchar(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_]
14	Customer Posting Group	nvarchar(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]
15	Global Dimension 1 Code	nvarchar(40)
16	Global Dimension 2 Code	nvarchar(40)
17	Salesperson Code	nvarchar(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_]
18	User ID	nvarchar(100)
19	Source Code	nvarchar(20)
20	On Hold	nvarchar(6)
21	Applies-to Doc_ Type	int
22	Applies-to Doc_ No_	nvarchar(40)
23	Open	tinyint
24	Due Date	datetime
25	Pmt_ Discount Date	datetime
26	Original Pmt_ Disc_ Possible	decimal(38,38)
27	Pmt_ Disc_ Given (LCY)	decimal(38,38)
28	Orig_ Pmt_ Disc_ Possible(LCY)	decimal(38,38)
29	Positive	tinyint
30	Closed by Entry No_	int
31	Closed at Date	datetime
32	Closed by Amount	decimal(38,38)
33	Applies-to ID	nvarchar(100)
34	Journal Templ_ Name	nvarchar(20)
35	Journal Batch Name	nvarchar(20)
36	Reason Code	nvarchar(20)
37	Bal_ Account Type	int
38	Bal_ Account No_	nvarchar(40)
39	Transaction No_	int
40	Closed by Amount (LCY)	decimal(38,38)
41	Document Date	datetime
42	External Document No_	nvarchar(70)
43	Calculate Interest	tinyint
44	Closing Interest Calculated	tinyint
45	No_ Series	nvarchar(40)
46	Closed by Currency Code	nvarchar(20)
47	Closed by Currency Amount	decimal(38,38)
48	Adjusted Currency Factor	decimal(38,38)
49	Original Currency Factor	decimal(38,38)
50	Remaining Pmt_ Disc_ Possible	decimal(38,38)
51	Pmt_ Disc_ Tolerance Date	datetime
52	Max_ Payment Tolerance	decimal(38,38)
53	Last Issued Reminder Level	int
54	Accepted Payment Tolerance	decimal(38,38)
55	Accepted Pmt_ Disc_ Tolerance	tinyint
56	Pmt_ Tolerance (LCY)	decimal(38,38)
57	Amount to Apply	decimal(38,38)
58	IC Partner Code	nvarchar(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]
59	Applying Entry	tinyint
60	Reversed	tinyint
61	Reversed by Entry No_	int
62	Reversed Entry No_	int
63	Prepayment	tinyint
64	Payment Reference	nvarchar(100)
65	Payment Method Code	nvarchar(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]
66	Applies-to Ext_ Doc_ No_	nvarchar(70)
67	Recipient Bank Account	nvarchar(40)
68	Message to Recipient	nvarchar(280)
69	Exported to Payment File	tinyint
70	Dimension Set ID	int
71	Direct Debit Mandate ID	nvarchar(70)
72	$systemId	uniqueidentifier
73	$systemCreatedAt	datetime
74	$systemCreatedBy	uniqueidentifier
75	$systemModifiedAt	datetime
76	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Cust_ Ledger Entry table

Currency Customer Customer Posting Group IC Partner Payment Method Salesperson_Purchaser

Dynamics 365 BC Table Reference Tables Company Tables CCust_ Ledger Entry

Leave a Reply Cancel reply