Detailed Vendor Ledg_ Entry

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

Table Type: Company

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

Table Number: 0

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 Vendor Ledg_ Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Detailed Vendor Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Vendor Ledger Entry No_]
   ,[Entry Type]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Amount]
   ,[Amount (LCY)]
   ,[Vendor 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_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Initial Document Type]
   ,[Applied Vend_ Ledger Entry No_]
   ,[Unapplied]
   ,[Unapplied by Entry No_]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Max_ Payment Tolerance]
   ,[Tax Jurisdiction Code]
   ,[Application No_]
   ,[Ledger Entry Amount]
   ,[Posting Group]
   ,[Exch_ Rate Adjmt_ Reg_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Detailed Vendor Ledg_ Entry$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 Vendor Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Vendor Ledg_ Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Detailed Vendor Ledg_ Entry].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Detailed Vendor Ledg_ Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Detailed Vendor Ledg_ Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Vendor 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)
10Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Detailed Vendor Ledg_ Entry].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Detailed Vendor Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Vendor Ledg_ Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Detailed Vendor Ledg_ Entry].[Vendor No_] = [Vendor].[No_]
11Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Detailed Vendor Ledg_ Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Vendor Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Vendor Ledg_ Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Detailed Vendor Ledg_ Entry].[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_ Bus_ Posting Group Searchnvarchar(40)
25Gen_ Prod_ Posting Group Searchnvarchar(40)
26Use Tax Searchtinyint
27VAT Bus_ Posting Group Searchnvarchar(40)
28VAT Prod_ Posting Group Searchnvarchar(40)
29Initial Document Type Searchint
30Applied Vend_ Ledger Entry No_ Searchint
31Unapplied Searchtinyint
32Unapplied by Entry No_ Searchint
33Remaining Pmt_ Disc_ Possible Searchdecimal(38,38)
34Max_ Payment Tolerance Searchdecimal(38,38)
35Tax Jurisdiction Code Searchnvarchar(20)
36Application No_ Searchint
37Ledger Entry Amount Searchtinyint
38Posting Group Searchnvarchar(40)
39Exch_ Rate Adjmt_ Reg_ No_ Searchint
40$systemId Searchuniqueidentifier
41$systemCreatedAt Searchdatetime
42$systemCreatedBy Searchuniqueidentifier
43$systemModifiedAt Searchdatetime
44$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Detailed Vendor Ledg_ Entry table

Leave a Reply

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