Detailed CV Ledg. Entry Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DDetailed CV Ledg. Entry Buffer

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

Table Type: Company

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

Table Number: 383

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[CV Ledger Entry No_]
   ,[Entry Type]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Amount]
   ,[Amount (LCY)]
   ,[CV No_]
   ,[Currency Code]
   ,[User ID]
   ,[Source Code]
   ,[Transaction No_]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Debit Amount (LCY)]
   ,[Credit Amount (LCY)]
   ,[Initial Entry Due Date]
   ,[Initial Entry Global Dim_ 1]
   ,[Initial Entry Global Dim_ 2]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Additional-Currency Amount]
   ,[VAT Amount (LCY)]
   ,[Use Additional-Currency Amount]
   ,[Initial Document Type]
   ,[Applied CV Ledger Entry No_]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Max_ Payment Tolerance]
   ,[Tax Jurisdiction Code]
   ,[Exch_ Rate Adjmt_ Reg_ No_]
   ,[Non-Deductible VAT Amount LCY]
   ,[Non-Deductible VAT Amount ACY]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Detailed CV Ledg_ 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_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Detailed CV Ledg. Entry Buffer].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Detailed CV Ledg. Entry Buffer].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Detailed CV Ledg. Entry Buffer].[Document Type] = [Sales Header].[Document Type]
      AND
         [Detailed CV Ledg. Entry Buffer].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Detailed CV Ledg. Entry Buffer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Detailed CV Ledg. Entry Buffer].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Detailed CV Ledg. Entry Buffer].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Detailed CV Ledg. Entry Buffer].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Detailed CV Ledg. Entry Buffer].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
      ON
         [Detailed CV Ledg. Entry Buffer].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Detailed CV Ledg. Entry Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Detailed CV Ledg. Entry Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Detailed CV Ledg. 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
2	CV Ledger Entry No.	CV Ledger Entry No.	Normal	Integer	4	CV Ledger Entry No_	int
3	Entry Type	Entry Type	Normal	Option	4	Entry Type	int
	Available options are: “” “Initial Entry” “Application” “Unrealized Loss” “Unrealized Gain” “Realized Loss” “Realized Gain” “Payment Discount” “Payment Discount (VAT Excl.)” “Payment Discount (VAT Adjustment)” “Appln. Rounding” “Correction of Remaining Amount” “Payment Tolerance” “Payment Discount Tolerance” “Payment Tolerance (VAT Excl.)” “Payment Tolerance (VAT Adjustment)” “Payment Discount Tolerance (VAT Excl.)” “Payment Discount Tolerance (VAT Adjustment)”
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	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
8	Amount (LCY)	Amount ($)	Normal	Decimal	12	Amount (LCY)	decimal(38,38)
9	CV No.	CV No.	Normal	Code	20	CV No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[CV No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Detailed CV Ledg. Entry Buffer].[CV No_] = [Customer].[No_]
10	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Detailed CV Ledg. Entry Buffer].[Currency Code] = [Currency].[Code]
11	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
12	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(20)
	Key to join to the Source Code table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Source Code] ,[Source Code].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [Detailed CV Ledg. Entry Buffer].[Source Code] = [Source Code].[Code]
13	Transaction No.	Transaction No.	Normal	Integer	4	Transaction No_	int
14	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
15	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(20)
	Key to join to the Reason Code table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Detailed CV Ledg. Entry Buffer].[Reason Code] = [Reason Code].[Code]
16	Debit Amount	Debit Amount	Normal	Decimal	12	Debit Amount	decimal(38,38)
17	Credit Amount	Credit Amount	Normal	Decimal	12	Credit Amount	decimal(38,38)
18	Debit Amount (LCY)	Debit Amount ($)	Normal	Decimal	12	Debit Amount (LCY)	decimal(38,38)
19	Credit Amount (LCY)	Credit Amount ($)	Normal	Decimal	12	Credit Amount (LCY)	decimal(38,38)
20	Initial Entry Due Date	Initial Entry Due Date	Normal	Date	4	Initial Entry Due Date	datetime
21	Initial Entry Global Dim. 1	Initial Entry Global Dim. 1	Normal	Code	20	Initial Entry Global Dim_ 1	nvarchar(40)
22	Initial Entry Global Dim. 2	Initial Entry Global Dim. 2	Normal	Code	20	Initial Entry Global Dim_ 2	nvarchar(40)
23	Gen. Posting Type	Gen. Posting Type	Normal	Option	4	Gen_ Posting Type	int
	Available options are: ” “ “Purchase” “Sale” “Settlement”
24	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(40)
	Key to join to the Gen. Business Posting Group table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Detailed CV Ledg. Entry Buffer].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
25	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Detailed CV Ledg. Entry Buffer].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
26	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Detailed CV Ledg. Entry Buffer].[Tax Area Code] = [Tax Area].[Code]
27	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
28	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Detailed CV Ledg. Entry Buffer].[Tax Group Code] = [Tax Group].[Code]
29	Use Tax	Use Tax	Normal	Boolean	4	Use Tax	tinyint
30	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(40)
	Key to join to the VAT Business Posting Group table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Detailed CV Ledg. Entry Buffer].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
31	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(40)
	Key to join to the VAT Product Posting Group table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Detailed CV Ledg. Entry Buffer].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
32	Additional-Currency Amount	Additional-Currency Amount	Normal	Decimal	12	Additional-Currency Amount	decimal(38,38)
33	VAT Amount (LCY)	Tax Amount ($)	Normal	Decimal	12	VAT Amount (LCY)	decimal(38,38)
34	Use Additional-Currency Amount	Use Additional-Currency Amount	Normal	Boolean	4	Use Additional-Currency Amount	tinyint
35	Initial Document Type	Initial Document Type	Normal	Option	4	Initial Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
36	Applied CV Ledger Entry No.	Applied CV Ledger Entry No.	Normal	Integer	4	Applied CV Ledger Entry No_	int
39	Remaining Pmt. Disc. Possible	Remaining Pmt. Disc. Possible	Normal	Decimal	12	Remaining Pmt_ Disc_ Possible	decimal(38,38)
40	Max. Payment Tolerance	Max. Payment Tolerance	Normal	Decimal	12	Max_ Payment Tolerance	decimal(38,38)
41	Tax Jurisdiction Code	Tax Jurisdiction Code	Normal	Code	10	Tax Jurisdiction Code	nvarchar(20)
	Key to join to the Tax Jurisdiction table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Tax Jurisdiction Code] ,[Tax Jurisdiction].[Code] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction] ON [Detailed CV Ledg. Entry Buffer].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
45	Exch. Rate Adjmt. Reg. No.	Exch. Rate Adjmt. Reg. No.	Normal	Integer	4	Exch_ Rate Adjmt_ Reg_ No_	int
	Key to join to the Exch. Rate Adjmt. Reg. table. Show/hide example query SELECT [Detailed CV Ledg. Entry Buffer].[Exch_ Rate Adjmt_ Reg_ No_] ,[Exch. Rate Adjmt. Reg.].[No_] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch. Rate Adjmt. Reg.] ON [Detailed CV Ledg. Entry Buffer].[Exch_ Rate Adjmt_ Reg_ No_] = [Exch. Rate Adjmt. Reg.].[No_]
6200	Non-Deductible VAT Amount LCY	Non-Deductible Tax Amount LCY	Normal	Decimal	12	Non-Deductible VAT Amount LCY	decimal(38,38)
6201	Non-Deductible VAT Amount ACY	Non-Deductible Tax Amount ACY	Normal	Decimal	12	Non-Deductible VAT Amount ACY	decimal(38,38)
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 [Detailed CV Ledg. Entry Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [User] AS [User] ON [Detailed CV Ledg. 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 [Detailed CV Ledg. Entry Buffer].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Detailed CV Ledg_ Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed CV Ledg. Entry Buffer] LEFT JOIN [User] AS [User] ON [Detailed CV Ledg. Entry Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Detailed CV Ledg. Entry Buffer table

Currency Sales Header Sales Header Archive Tax Area Tax Group

Dynamics 365 BC Table Reference Tables Company Tables DDetailed CV Ledg. Entry Buffer

Leave a Reply Cancel reply