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$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 21

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$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Customer No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Customer Name]
   ,[Your Reference]
   ,[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$437dbf0e-84ff-417a-965d-ed2bb9650972]

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_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Cust. Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Cust. Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Cust. Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Cust. Ledger Entry].[Document No_] = [Sales Header].[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 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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Cust. Ledger Entry].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Cust. Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Cust. Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Cust. Ledger Entry].[Closed by Currency Code] = [Currency].[Code]
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$ext] AS [Payment Method]
      ON
         [Cust. Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Cust. Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Cust. Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cust. Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cust. Ledger Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
3	Customer No.	Customer No.	Normal	Code	20	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$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_]
4	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
5	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
6	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Customer Name	Customer Name	Normal	Text	100	Customer Name	nvarchar(200)
10	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
11	Currency Code	Currency Code	Normal	Code	10	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$437dbf0e-84ff-417a-965d-ed2bb9650972] 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]
13	Amount	Amount	FlowField	Decimal	12
14	Remaining Amount	Remaining Amount	FlowField	Decimal	12
15	Original Amt. (LCY)	Original Amt. ($)	FlowField	Decimal	12
16	Remaining Amt. (LCY)	Remaining Amt. ($)	FlowField	Decimal	12
17	Amount (LCY)	Amount ($)	FlowField	Decimal	12
18	Sales (LCY)	Sales ($)	Normal	Decimal	12	Sales (LCY)	decimal(38,38)
19	Profit (LCY)	Profit ($)	Normal	Decimal	12	Profit (LCY)	decimal(38,38)
20	Inv. Discount (LCY)	Inv. Discount ($)	Normal	Decimal	12	Inv_ Discount (LCY)	decimal(38,38)
21	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	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$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].[Sell-to Customer No_] = [Customer].[No_]
22	Customer Posting Group	Customer Posting Group	Normal	Code	20	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$437dbf0e-84ff-417a-965d-ed2bb9650972] 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]
23	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
24	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
25	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Cust. Ledger Entry].[Salesperson Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] 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].[Code]
27	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
28	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(20)
	Key to join to the Source Code table. Show/hide example query SELECT [Cust. Ledger Entry].[Source Code] ,[Source Code].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [Cust. Ledger Entry].[Source Code] = [Source Code].[Code]
33	On Hold	On Hold	Normal	Code	3	On Hold	nvarchar(6)
34	Applies-to Doc. Type	Applies-to Doc. Type	Normal	Option	4	Applies-to Doc_ Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
35	Applies-to Doc. No.	Applies-to Doc. No.	Normal	Code	20	Applies-to Doc_ No_	nvarchar(40)
36	Open	Open	Normal	Boolean	4	Open	tinyint
37	Due Date	Due Date	Normal	Date	4	Due Date	datetime
38	Pmt. Discount Date	Pmt. Discount Date	Normal	Date	4	Pmt_ Discount Date	datetime
39	Original Pmt. Disc. Possible	Original Pmt. Disc. Possible	Normal	Decimal	12	Original Pmt_ Disc_ Possible	decimal(38,38)
40	Pmt. Disc. Given (LCY)	Pmt. Disc. Given ($)	Normal	Decimal	12	Pmt_ Disc_ Given (LCY)	decimal(38,38)
42	Orig. Pmt. Disc. Possible(LCY)	Orig. Pmt. Disc. Possible ($)	Normal	Decimal	12	Orig_ Pmt_ Disc_ Possible(LCY)	decimal(38,38)
43	Positive	Positive	Normal	Boolean	4	Positive	tinyint
44	Closed by Entry No.	Closed by Entry No.	Normal	Integer	4	Closed by Entry No_	int
45	Closed at Date	Closed at Date	Normal	Date	4	Closed at Date	datetime
46	Closed by Amount	Closed by Amount	Normal	Decimal	12	Closed by Amount	decimal(38,38)
47	Applies-to ID	Applies-to ID	Normal	Code	50	Applies-to ID	nvarchar(100)
48	Journal Templ. Name	Journal Template Name	Normal	Code	10	Journal Templ_ Name	nvarchar(20)
49	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
50	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(20)
	Key to join to the Reason Code table. Show/hide example query SELECT [Cust. Ledger Entry].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Cust. Ledger Entry].[Reason Code] = [Reason Code].[Code]
51	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
52	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
53	Transaction No.	Transaction No.	Normal	Integer	4	Transaction No_	int
54	Closed by Amount (LCY)	Closed by Amount ($)	Normal	Decimal	12	Closed by Amount (LCY)	decimal(38,38)
58	Debit Amount	Debit Amount	FlowField	Decimal	12
59	Credit Amount	Credit Amount	FlowField	Decimal	12
60	Debit Amount (LCY)	Debit Amount ($)	FlowField	Decimal	12
61	Credit Amount (LCY)	Credit Amount ($)	FlowField	Decimal	12
62	Document Date	Document Date	Normal	Date	4	Document Date	datetime
63	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
64	Calculate Interest	Calculate Interest	Normal	Boolean	4	Calculate Interest	tinyint
65	Closing Interest Calculated	Closing Interest Calculated	Normal	Boolean	4	Closing Interest Calculated	tinyint
66	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Cust. Ledger Entry].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Cust. Ledger Entry].[No_ Series] = [No. Series].[Code]
67	Closed by Currency Code	Closed by Currency Code	Normal	Code	10	Closed by Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Cust. Ledger Entry].[Closed by Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Cust. Ledger Entry].[Closed by Currency Code] = [Currency].[Code]
68	Closed by Currency Amount	Closed by Currency Amount	Normal	Decimal	12	Closed by Currency Amount	decimal(38,38)
73	Adjusted Currency Factor	Adjusted Currency Factor	Normal	Decimal	12	Adjusted Currency Factor	decimal(38,38)
74	Original Currency Factor	Original Currency Factor	Normal	Decimal	12	Original Currency Factor	decimal(38,38)
75	Original Amount	Original Amount	FlowField	Decimal	12
76	Date Filter	Date Filter	FlowFilter	Date	4
77	Remaining Pmt. Disc. Possible	Remaining Pmt. Disc. Possible	Normal	Decimal	12	Remaining Pmt_ Disc_ Possible	decimal(38,38)
78	Pmt. Disc. Tolerance Date	Pmt. Disc. Tolerance Date	Normal	Date	4	Pmt_ Disc_ Tolerance Date	datetime
79	Max. Payment Tolerance	Max. Payment Tolerance	Normal	Decimal	12	Max_ Payment Tolerance	decimal(38,38)
80	Last Issued Reminder Level	Last Issued Reminder Level	Normal	Integer	4	Last Issued Reminder Level	int
81	Accepted Payment Tolerance	Accepted Payment Tolerance	Normal	Decimal	12	Accepted Payment Tolerance	decimal(38,38)
82	Accepted Pmt. Disc. Tolerance	Accepted Pmt. Disc. Tolerance	Normal	Boolean	4	Accepted Pmt_ Disc_ Tolerance	tinyint
83	Pmt. Tolerance (LCY)	Pmt. Tolerance ($)	Normal	Decimal	12	Pmt_ Tolerance (LCY)	decimal(38,38)
84	Amount to Apply	Amount to Apply	Normal	Decimal	12	Amount to Apply	decimal(38,38)
85	IC Partner Code	IC Partner Code	Normal	Code	20	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$437dbf0e-84ff-417a-965d-ed2bb9650972] 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]
86	Applying Entry	Applying Entry	Normal	Boolean	4	Applying Entry	tinyint
87	Reversed	Reversed	Normal	Boolean	4	Reversed	tinyint
88	Reversed by Entry No.	Reversed by Entry No.	Normal	Integer	4	Reversed by Entry No_	int
89	Reversed Entry No.	Reversed Entry No.	Normal	Integer	4	Reversed Entry No_	int
90	Prepayment	Prepayment	Normal	Boolean	4	Prepayment	tinyint
171	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
172	Payment Method Code	Payment Method Code	Normal	Code	10	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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method] ON [Cust. Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
173	Applies-to Ext. Doc. No.	Applies-to Ext. Doc. No.	Normal	Code	35	Applies-to Ext_ Doc_ No_	nvarchar(70)
288	Recipient Bank Account	Recipient Bank Account	Normal	Code	20	Recipient Bank Account	nvarchar(40)
289	Message to Recipient	Message to Recipient	Normal	Text	140	Message to Recipient	nvarchar(280)
290	Exported to Payment File	Exported to Payment File	Normal	Boolean	4	Exported to Payment File	tinyint
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Cust. Ledger Entry].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Cust. Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[] = [Dimension].[Code]
482	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[] = [Dimension].[Code]
483	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[] = [Dimension].[Code]
484	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[] = [Dimension].[Code]
485	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[] = [Dimension].[Code]
486	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Cust. Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cust. Ledger Entry].[] = [Dimension].[Code]
1200	Direct Debit Mandate ID	Direct Debit Mandate ID	Normal	Code	35	Direct Debit Mandate ID	nvarchar(70)
1300	Payment Prediction	Payment Prediction	Normal	Option	4
1301	Prediction Confidence	Prediction Confidence	Normal	Option	4
1302	Prediction Confidence %	Prediction Confidence %	Normal	Decimal	12
10015	Tax Exemption No.	Tax Exemption No.	Normal	Text	30
10018	STE Transaction ID	STE Transaction ID	Normal	Text	20
10019	Electronic Document Sent	Electronic Document Sent	Normal	Boolean	4
10020	Original Document XML	Original Document XML	Normal	BLOB	8
10021	No. of E-Documents Sent	No. of E-Documents Sent	Normal	Integer	4
10022	Original String	Original String	Normal	BLOB	8
10023	Digital Stamp SAT	Digital Stamp SAT	Normal	BLOB	8
10024	Certificate Serial No.	Certificate Serial No.	Normal	Text	250
10025	Signed Document XML	Signed Document XML	Normal	BLOB	8
10026	Digital Stamp PAC	Digital Stamp PAC	Normal	BLOB	8
10030	Electronic Document Status	Electronic Document Status	Normal	Option	4
10031	Date/Time Stamped	Date/Time Stamped	Normal	Text	50
10032	Date/Time Sent	Date/Time Sent	Normal	Text	50
10033	Date/Time Canceled	Date/Time Canceled	Normal	Text	50
10035	Error Code	Error Code	Normal	Code	10
10036	Error Description	Error Description	Normal	Text	250
10037	Date/Time Stamp Received	Date/Time Stamp Received	Normal	DateTime	8
10038	Date/Time Cancel Sent	Date/Time Cancel Sent	Normal	DateTime	8
10040	PAC Web Service Name	PAC Web Service Name	Normal	Text	50
10041	QR Code	QR Code	Normal	BLOB	8
10042	Fiscal Invoice Number PAC	Fiscal Invoice Number PAC	Normal	Text	50
10043	Date/Time First Req. Sent	Date/Time First Req. Sent	Normal	Text	50
27002	CFDI Cancellation Reason Code	CFDI Cancelation Reason Code	Normal	Code	10
27003	Substitution Entry No.	Substitution Entry No.	Normal	Integer	4
27007	CFDI Cancellation ID	CFDI Cancelation ID	Normal	Text	50
27008	Marked as Canceled	Marked as Canceled	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Cust. Ledger Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry] LEFT JOIN [User] AS [User] ON [Cust. Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Cust. Ledger Entry table

Dynamics 365 BC Table Reference Tables Company Tables CCust. Ledger Entry

Leave a Reply Cancel reply