Vendor Ledger Entry

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

Table Type: Company

Table Name: Vendor Ledger Entry
Database Table Name: CRONUS UK Ltd_$Vendor Ledger 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 Vendor Ledger Entry can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Vendor No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Vendor Name]
   ,[Currency Code]
   ,[Purchase (LCY)]
   ,[Inv_ Discount (LCY)]
   ,[Buy-from Vendor No_]
   ,[Vendor Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Purchaser 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_ Rcd_(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)]
   ,[Document Date]
   ,[External Document No_]
   ,[No_ Series]
   ,[Closed by Currency Code]
   ,[Closed by Currency Amount]
   ,[Adjusted Currency Factor]
   ,[Original Currency Factor]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Pmt_ Disc_ Tolerance Date]
   ,[Max_ Payment Tolerance]
   ,[Accepted Payment Tolerance]
   ,[Accepted Pmt_ Disc_ Tolerance]
   ,[Pmt_ Tolerance (LCY)]
   ,[Amount to Apply]
   ,[IC Partner Code]
   ,[Applying Entry]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Prepayment]
   ,[Creditor No_]
   ,[Payment Reference]
   ,[Payment Method Code]
   ,[Applies-to Ext_ Doc_ No_]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[Invoice Receipt Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Vendor Ledger 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_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Vendor Ledger Entry].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Vendor Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Vendor Ledger Entry].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Vendor Ledger Entry].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Vendor Ledger Entry].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Vendor Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Vendor Ledger Entry].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Vendor Ledger Entry].[Vendor No_] = [Vendor].[No_]
4Posting Date Searchdatetime
5Document Type Searchint
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Vendor Name Searchnvarchar(200)
9Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Vendor Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Vendor Ledger Entry].[Currency Code] = [Currency].[Code]
10Purchase (LCY) Searchdecimal(38,38)
11Inv_ Discount (LCY) Searchdecimal(38,38)
12Buy-from Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Vendor Ledger Entry].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Vendor Ledger Entry].[Buy-from Vendor No_] = [Vendor].[No_]
13Vendor Posting Group Searchnvarchar(40)
14Global Dimension 1 Code Searchnvarchar(40)
15Global Dimension 2 Code Searchnvarchar(40)
16Purchaser Code Searchnvarchar(40)
17User ID Searchnvarchar(100)
18Source Code Searchnvarchar(20)
19On Hold Searchnvarchar(6)
20Applies-to Doc_ Type Searchint
21Applies-to Doc_ No_ Searchnvarchar(40)
22Open Searchtinyint
23Due Date Searchdatetime
24Pmt_ Discount Date Searchdatetime
25Original Pmt_ Disc_ Possible Searchdecimal(38,38)
26Pmt_ Disc_ Rcd_(LCY) Searchdecimal(38,38)
27Orig_ Pmt_ Disc_ Possible(LCY) Searchdecimal(38,38)
28Positive Searchtinyint
29Closed by Entry No_ Searchint
30Closed at Date Searchdatetime
31Closed by Amount Searchdecimal(38,38)
32Applies-to ID Searchnvarchar(100)
33Journal Templ_ Name Searchnvarchar(20)
34Journal Batch Name Searchnvarchar(20)
35Reason Code Searchnvarchar(20)
36Bal_ Account Type Searchint
37Bal_ Account No_ Searchnvarchar(40)
38Transaction No_ Searchint
39Closed by Amount (LCY) Searchdecimal(38,38)
40Document Date Searchdatetime
41External Document No_ Searchnvarchar(70)
42No_ Series Searchnvarchar(40)
43Closed by Currency Code Searchnvarchar(20)
44Closed by Currency Amount Searchdecimal(38,38)
45Adjusted Currency Factor Searchdecimal(38,38)
46Original Currency Factor Searchdecimal(38,38)
47Remaining Pmt_ Disc_ Possible Searchdecimal(38,38)
48Pmt_ Disc_ Tolerance Date Searchdatetime
49Max_ Payment Tolerance Searchdecimal(38,38)
50Accepted Payment Tolerance Searchdecimal(38,38)
51Accepted Pmt_ Disc_ Tolerance Searchtinyint
52Pmt_ Tolerance (LCY) Searchdecimal(38,38)
53Amount to Apply Searchdecimal(38,38)
54IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Vendor Ledger Entry].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Vendor Ledger Entry].[IC Partner Code] = [IC Partner].[Code]
55Applying Entry Searchtinyint
56Reversed Searchtinyint
57Reversed by Entry No_ Searchint
58Reversed Entry No_ Searchint
59Prepayment Searchtinyint
60Creditor No_ Searchnvarchar(40)
61Payment Reference Searchnvarchar(100)
62Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Vendor Ledger Entry].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Vendor Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
63Applies-to Ext_ Doc_ No_ Searchnvarchar(70)
64Recipient Bank Account Searchnvarchar(40)
65Message to Recipient Searchnvarchar(280)
66Exported to Payment File Searchtinyint
67Dimension Set ID Searchint
68Invoice Receipt Date Searchdatetime
69$systemId Searchuniqueidentifier
70$systemCreatedAt Searchdatetime
71$systemCreatedBy Searchuniqueidentifier
72$systemModifiedAt Searchdatetime
73$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Vendor Ledger Entry table

Leave a Reply

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