Vendor Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVendor 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Vendor No_	nvarchar(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_]
4	Posting Date	datetime
5	Document Type	int
6	Document No_	nvarchar(40)
7	Description	nvarchar(200)
8	Vendor Name	nvarchar(200)
9	Currency Code	nvarchar(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]
10	Purchase (LCY)	decimal(38,38)
11	Inv_ Discount (LCY)	decimal(38,38)
12	Buy-from Vendor No_	nvarchar(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_]
13	Vendor Posting Group	nvarchar(40)
14	Global Dimension 1 Code	nvarchar(40)
15	Global Dimension 2 Code	nvarchar(40)
16	Purchaser Code	nvarchar(40)
17	User ID	nvarchar(100)
18	Source Code	nvarchar(20)
19	On Hold	nvarchar(6)
20	Applies-to Doc_ Type	int
21	Applies-to Doc_ No_	nvarchar(40)
22	Open	tinyint
23	Due Date	datetime
24	Pmt_ Discount Date	datetime
25	Original Pmt_ Disc_ Possible	decimal(38,38)
26	Pmt_ Disc_ Rcd_(LCY)	decimal(38,38)
27	Orig_ Pmt_ Disc_ Possible(LCY)	decimal(38,38)
28	Positive	tinyint
29	Closed by Entry No_	int
30	Closed at Date	datetime
31	Closed by Amount	decimal(38,38)
32	Applies-to ID	nvarchar(100)
33	Journal Templ_ Name	nvarchar(20)
34	Journal Batch Name	nvarchar(20)
35	Reason Code	nvarchar(20)
36	Bal_ Account Type	int
37	Bal_ Account No_	nvarchar(40)
38	Transaction No_	int
39	Closed by Amount (LCY)	decimal(38,38)
40	Document Date	datetime
41	External Document No_	nvarchar(70)
42	No_ Series	nvarchar(40)
43	Closed by Currency Code	nvarchar(20)
44	Closed by Currency Amount	decimal(38,38)
45	Adjusted Currency Factor	decimal(38,38)
46	Original Currency Factor	decimal(38,38)
47	Remaining Pmt_ Disc_ Possible	decimal(38,38)
48	Pmt_ Disc_ Tolerance Date	datetime
49	Max_ Payment Tolerance	decimal(38,38)
50	Accepted Payment Tolerance	decimal(38,38)
51	Accepted Pmt_ Disc_ Tolerance	tinyint
52	Pmt_ Tolerance (LCY)	decimal(38,38)
53	Amount to Apply	decimal(38,38)
54	IC Partner Code	nvarchar(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]
55	Applying Entry	tinyint
56	Reversed	tinyint
57	Reversed by Entry No_	int
58	Reversed Entry No_	int
59	Prepayment	tinyint
60	Creditor No_	nvarchar(40)
61	Payment Reference	nvarchar(100)
62	Payment Method Code	nvarchar(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]
63	Applies-to Ext_ Doc_ No_	nvarchar(70)
64	Recipient Bank Account	nvarchar(40)
65	Message to Recipient	nvarchar(280)
66	Exported to Payment File	tinyint
67	Dimension Set ID	int
68	Invoice Receipt Date	datetime
69	$systemId	uniqueidentifier
70	$systemCreatedAt	datetime
71	$systemCreatedBy	uniqueidentifier
72	$systemModifiedAt	datetime
73	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Vendor Ledger Entry table

Currency IC Partner Payment Method Vendor

Dynamics 365 BC Table Reference Tables Company Tables VVendor Ledger Entry

Leave a Reply Cancel reply