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

Show/hide tables related from CV Ledger Entry Buffer table

Leave a Reply

Your email address will not be published. Required fields are marked *