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

   [timestamp]
   ,[Entry No_]
   ,[CV No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [CV Ledger Entry Buffer].[Currency Code] = [Currency].[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].[No_]

Show/hide columns in CV Ledger Entry Buffer table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	CV No_	nvarchar(40)
4	Posting Date	datetime
5	Document Type	int
6	Document No_	nvarchar(40)
7	Description	nvarchar(200)
8	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]
9	Amount	decimal(38,38)
10	Remaining Amount	decimal(38,38)
11	Original Amt_ (LCY)	decimal(38,38)
12	Remaining Amt_ (LCY)	decimal(38,38)
13	Amount (LCY)	decimal(38,38)
14	Sales_Purchase (LCY)	decimal(38,38)
15	Profit (LCY)	decimal(38,38)
16	Inv_ Discount (LCY)	decimal(38,38)
17	Bill-to_Pay-to CV No_	nvarchar(40)
18	CV Posting Group	nvarchar(40)
19	Global Dimension 1 Code	nvarchar(40)
20	Global Dimension 2 Code	nvarchar(40)
21	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].[No_] 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].[No_]
22	User ID	nvarchar(100)
23	Source Code	nvarchar(20)
24	On Hold	nvarchar(6)
25	Applies-to Doc_ Type	int
26	Applies-to Doc_ No_	nvarchar(40)
27	Open	tinyint
28	Due Date	datetime
29	Pmt_ Discount Date	datetime
30	Original Pmt_ Disc_ Possible	decimal(38,38)
31	Pmt_ Disc_ Given (LCY)	decimal(38,38)
32	Orig_ Pmt_ Disc_ Possible(LCY)	decimal(38,38)
33	Positive	tinyint
34	Closed by Entry No_	int
35	Closed at Date	datetime
36	Closed by Amount	decimal(38,38)
37	Applies-to ID	nvarchar(100)
38	Journal Templ_ Name	nvarchar(20)
39	Journal Batch Name	nvarchar(20)
40	Reason Code	nvarchar(20)
41	Bal_ Account Type	int
42	Bal_ Account No_	nvarchar(40)
43	Transaction No_	int
44	Closed by Amount (LCY)	decimal(38,38)
45	Debit Amount	decimal(38,38)
46	Credit Amount	decimal(38,38)
47	Debit Amount (LCY)	decimal(38,38)
48	Credit Amount (LCY)	decimal(38,38)
49	Document Date	datetime
50	External Document No_	nvarchar(70)
51	Calculate Interest	tinyint
52	Closing Interest Calculated	tinyint
53	No_ Series	nvarchar(40)
54	Closed by Currency Code	nvarchar(20)
55	Closed by Currency Amount	decimal(38,38)
56	Rounding Currency	nvarchar(20)
57	Rounding Amount	decimal(38,38)
58	Rounding Amount (LCY)	decimal(38,38)
59	Adjusted Currency Factor	decimal(38,38)
60	Original Currency Factor	decimal(38,38)
61	Original Amount	decimal(38,38)
62	Remaining Pmt_ Disc_ Possible	decimal(38,38)
63	Pmt_ Disc_ Tolerance Date	datetime
64	Max_ Payment Tolerance	decimal(38,38)
65	Accepted Payment Tolerance	decimal(38,38)
66	Accepted Pmt_ Disc_ Tolerance	tinyint
67	Pmt_ Tolerance (LCY)	decimal(38,38)
68	Amount to Apply	decimal(38,38)
69	Prepayment	tinyint
70	Dimension Set ID	int
71	$systemId	uniqueidentifier
72	$systemCreatedAt	datetime
73	$systemCreatedBy	uniqueidentifier
74	$systemModifiedAt	datetime
75	$systemModifiedBy	uniqueidentifier