CV Ledger Entry Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCV Ledger Entry Buffer

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

Table Type: Company

Table Name: CV Ledger Entry Buffer
Database Table Name: CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 382

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[CV No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Your Reference]
   ,[Currency Code]
   ,[Amount]
   ,[Remaining Amount]
   ,[Original Amt_ (LCY)]
   ,[Remaining Amt_ (LCY)]
   ,[Amount (LCY)]
   ,[Sales_Purchase (LCY)]
   ,[Profit (LCY)]
   ,[Inv_ Discount (LCY)]
   ,[Bill-to_Pay-to CV No_]
   ,[CV 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)]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Debit Amount (LCY)]
   ,[Credit Amount (LCY)]
   ,[Document Date]
   ,[External Document No_]
   ,[Calculate Interest]
   ,[Closing Interest Calculated]
   ,[No_ Series]
   ,[Closed by Currency Code]
   ,[Closed by Currency Amount]
   ,[Rounding Currency]
   ,[Rounding Amount]
   ,[Rounding Amount (LCY)]
   ,[Adjusted Currency Factor]
   ,[Original Currency Factor]
   ,[Original Amount]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Pmt_ Disc_ Tolerance Date]
   ,[Max_ Payment Tolerance]
   ,[Accepted Payment Tolerance]
   ,[Accepted Pmt_ Disc_ Tolerance]
   ,[Pmt_ Tolerance (LCY)]
   ,[Amount to Apply]
   ,[Prepayment]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [CV Ledger Entry Buffer].[Document Type] = [Sales Header].[Document Type]
      AND
         [CV Ledger Entry Buffer].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [CV Ledger Entry Buffer].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [CV Ledger Entry Buffer].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [CV Ledger Entry Buffer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [CV Ledger Entry Buffer].[CV Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [CV Ledger Entry Buffer].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [CV Ledger Entry Buffer].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [CV Ledger Entry Buffer].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [CV Ledger Entry Buffer].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [CV Ledger Entry Buffer].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [CV Ledger Entry Buffer].[Closed by Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [CV Ledger Entry Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CV Ledger Entry Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CV Ledger Entry Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in CV Ledger Entry Buffer 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	CV No.	CV No.	Normal	Code	20	CV No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [CV Ledger Entry Buffer].[CV No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [CV Ledger Entry Buffer].[CV 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)
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 [CV Ledger Entry Buffer].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [CV Ledger Entry Buffer].[Currency Code] = [Currency].[Code]
13	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
14	Remaining Amount	Remaining Amount	Normal	Decimal	12	Remaining Amount	decimal(38,38)
15	Original Amt. (LCY)	Original Amt. ($)	Normal	Decimal	12	Original Amt_ (LCY)	decimal(38,38)
16	Remaining Amt. (LCY)	Remaining Amt. ($)	Normal	Decimal	12	Remaining Amt_ (LCY)	decimal(38,38)
17	Amount (LCY)	Amount ($)	Normal	Decimal	12	Amount (LCY)	decimal(38,38)
18	Sales/Purchase (LCY)	Sales/Purchase ($)	Normal	Decimal	12	Sales_Purchase (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	Bill-to/Pay-to CV No.	Bill-to/Pay-to CV No.	Normal	Code	20	Bill-to_Pay-to CV No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [CV Ledger Entry Buffer].[Bill-to_Pay-to CV No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [CV Ledger Entry Buffer].[Bill-to_Pay-to CV No_] = [Customer].[No_]
22	CV Posting Group	CV Posting Group	Normal	Code	20	CV Posting Group	nvarchar(40)
	Key to join to the Customer Posting Group table. Show/hide example query SELECT [CV Ledger Entry Buffer].[CV Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [CV Ledger Entry Buffer].[CV 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 [CV Ledger Entry Buffer].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [CV Ledger Entry Buffer].[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 [CV Ledger Entry Buffer].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [CV Ledger Entry Buffer].[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 [CV Ledger Entry Buffer].[Salesperson Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [CV Ledger Entry Buffer].[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 [CV Ledger Entry Buffer].[Source Code] ,[Source Code].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [CV Ledger Entry Buffer].[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 [CV Ledger Entry Buffer].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [CV Ledger Entry Buffer].[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	Normal	Decimal	12	Debit Amount	decimal(38,38)
59	Credit Amount	Credit Amount	Normal	Decimal	12	Credit Amount	decimal(38,38)
60	Debit Amount (LCY)	Debit Amount ($)	Normal	Decimal	12	Debit Amount (LCY)	decimal(38,38)
61	Credit Amount (LCY)	Credit Amount ($)	Normal	Decimal	12	Credit Amount (LCY)	decimal(38,38)
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 [CV Ledger Entry Buffer].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [CV Ledger Entry Buffer].[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 [CV Ledger Entry Buffer].[Closed by Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [CV Ledger Entry Buffer].[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)
70	Rounding Currency	Rounding Currency	Normal	Code	10	Rounding Currency	nvarchar(20)
71	Rounding Amount	Rounding Amount	Normal	Decimal	12	Rounding Amount	decimal(38,38)
72	Rounding Amount (LCY)	Rounding Amount ($)	Normal	Decimal	12	Rounding Amount (LCY)	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	Normal	Decimal	12	Original Amount	decimal(38,38)
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)
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)
90	Prepayment	Prepayment	Normal	Boolean	4	Prepayment	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 [CV Ledger Entry Buffer].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [CV Ledger Entry Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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 [CV Ledger Entry Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [User] AS [User] ON [CV Ledger Entry Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [CV Ledger Entry Buffer].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$CV Ledger Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CV Ledger Entry Buffer] LEFT JOIN [User] AS [User] ON [CV Ledger Entry Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from CV Ledger Entry Buffer table

Currency Sales Header Sales Header Archive Salesperson/Purchaser Salesperson/Purchaser

Dynamics 365 BC Table Reference Tables Company Tables CCV Ledger Entry Buffer

Leave a Reply Cancel reply