Detailed 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
   [timestamp]
   ,[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_]
   ,[$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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Detailed CV Ledg_ Entry Buffer].[Currency Code] = [Currency].[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]

Show/hide columns in Detailed CV Ledg_ Entry Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3CV Ledger Entry No_ Searchint
4Entry Type Searchint
5Posting Date Searchdatetime
6Document Type Searchint
7Document No_ Searchnvarchar(40)
8Amount Searchdecimal(38,38)
9Amount (LCY) Searchdecimal(38,38)
10CV No_ Searchnvarchar(40)
11Currency Code Searchnvarchar(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]
12User ID Searchnvarchar(100)
13Source Code Searchnvarchar(20)
14Transaction No_ Searchint
15Journal Batch Name Searchnvarchar(20)
16Reason Code Searchnvarchar(20)
17Debit Amount Searchdecimal(38,38)
18Credit Amount Searchdecimal(38,38)
19Debit Amount (LCY) Searchdecimal(38,38)
20Credit Amount (LCY) Searchdecimal(38,38)
21Initial Entry Due Date Searchdatetime
22Initial Entry Global Dim_ 1 Searchnvarchar(40)
23Initial Entry Global Dim_ 2 Searchnvarchar(40)
24Gen_ Posting Type Searchint
25Gen_ Bus_ Posting Group Searchnvarchar(40)
26Gen_ Prod_ Posting Group Searchnvarchar(40)
27Tax Area Code Searchnvarchar(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]
28Tax Liable Searchtinyint
29Tax Group Code Searchnvarchar(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]
30Use Tax Searchtinyint
31VAT Bus_ Posting Group Searchnvarchar(40)
32VAT Prod_ Posting Group Searchnvarchar(40)
33Additional-Currency Amount Searchdecimal(38,38)
34VAT Amount (LCY) Searchdecimal(38,38)
35Use Additional-Currency Amount Searchtinyint
36Initial Document Type Searchint
37Applied CV Ledger Entry No_ Searchint
38Remaining Pmt_ Disc_ Possible Searchdecimal(38,38)
39Max_ Payment Tolerance Searchdecimal(38,38)
40Tax Jurisdiction Code Searchnvarchar(20)
41Exch_ Rate Adjmt_ Reg_ No_ Searchint
42$systemId Searchuniqueidentifier
43$systemCreatedAt Searchdatetime
44$systemCreatedBy Searchuniqueidentifier
45$systemModifiedAt Searchdatetime
46$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Detailed CV Ledg_ Entry Buffer table

Leave a Reply

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