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: 25

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

   [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_]
   ,[Invoice Received Date]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[Remit-to Code]
   ,[$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_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Vendor Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Vendor Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Vendor Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Vendor Ledger Entry].[Document No_] = [Sales Header].[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 Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Vendor Ledger Entry].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Vendor Ledger Entry].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Vendor Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Vendor Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Vendor Ledger Entry].[Closed by Currency Code] = [Currency].[Code]
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$ext] AS [Payment Method]
      ON
         [Vendor Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Vendor Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Vendor Ledger Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
3	Vendor No.	Vendor No.	Normal	Code	20	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	Posting Date	Normal	Date	4	Posting Date	datetime
5	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
6	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Vendor Name	Vendor Name	Normal	Text	100	Vendor Name	nvarchar(200)
11	Currency Code	Currency Code	Normal	Code	10	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]
13	Amount	Amount	FlowField	Decimal	12
14	Remaining Amount	Remaining Amount	FlowField	Decimal	12
15	Original Amt. (LCY)	Original Amt. ($)	FlowField	Decimal	12
16	Remaining Amt. (LCY)	Remaining Amt. ($)	FlowField	Decimal	12
17	Amount (LCY)	Amount ($)	FlowField	Decimal	12
18	Purchase (LCY)	Purchase ($)	Normal	Decimal	12	Purchase (LCY)	decimal(38,38)
20	Inv. Discount (LCY)	Inv. Discount ($)	Normal	Decimal	12	Inv_ Discount (LCY)	decimal(38,38)
21	Buy-from Vendor No.	Buy-from Vendor No.	Normal	Code	20	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_]
22	Vendor Posting Group	Vendor Posting Group	Normal	Code	20	Vendor Posting Group	nvarchar(40)
	Key to join to the Vendor Posting Group table. Show/hide example query SELECT [Vendor Ledger Entry].[Vendor Posting Group] ,[Vendor Posting Group].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group] ON [Vendor Ledger Entry].[Vendor Posting Group] = [Vendor Posting Group].[Code]
23	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
24	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
25	Purchaser Code	Purchaser Code	Normal	Code	20	Purchaser Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Vendor Ledger Entry].[Purchaser Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Vendor Ledger Entry].[Purchaser Code] = [Salesperson/Purchaser].[Code]
27	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
28	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(20)
	Key to join to the Source Code table. Show/hide example query SELECT [Vendor Ledger Entry].[Source Code] ,[Source Code].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code] ON [Vendor Ledger Entry].[Source Code] = [Source Code].[Code]
33	On Hold	On Hold	Normal	Code	3	On Hold	nvarchar(6)
34	Applies-to Doc. Type	Applies-to Doc. Type	Normal	Option	4	Applies-to Doc_ Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
35	Applies-to Doc. No.	Applies-to Doc. No.	Normal	Code	20	Applies-to Doc_ No_	nvarchar(40)
36	Open	Open	Normal	Boolean	4	Open	tinyint
37	Due Date	Due Date	Normal	Date	4	Due Date	datetime
38	Pmt. Discount Date	Pmt. Discount Date	Normal	Date	4	Pmt_ Discount Date	datetime
39	Original Pmt. Disc. Possible	Original Pmt. Disc. Possible	Normal	Decimal	12	Original Pmt_ Disc_ Possible	decimal(38,38)
40	Pmt. Disc. Rcd.(LCY)	Pmt. Disc. Rcd.($)	Normal	Decimal	12	Pmt_ Disc_ Rcd_(LCY)	decimal(38,38)
42	Orig. Pmt. Disc. Possible(LCY)	Org. Pmt. Disc. Possible ($)	Normal	Decimal	12	Orig_ Pmt_ Disc_ Possible(LCY)	decimal(38,38)
43	Positive	Positive	Normal	Boolean	4	Positive	tinyint
44	Closed by Entry No.	Closed by Entry No.	Normal	Integer	4	Closed by Entry No_	int
45	Closed at Date	Closed at Date	Normal	Date	4	Closed at Date	datetime
46	Closed by Amount	Closed by Amount	Normal	Decimal	12	Closed by Amount	decimal(38,38)
47	Applies-to ID	Applies-to ID	Normal	Code	50	Applies-to ID	nvarchar(100)
48	Journal Templ. Name	Journal Template Name	Normal	Code	10	Journal Templ_ Name	nvarchar(20)
49	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
50	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(20)
	Key to join to the Reason Code table. Show/hide example query SELECT [Vendor Ledger Entry].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Vendor Ledger Entry].[Reason Code] = [Reason Code].[Code]
51	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
52	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
53	Transaction No.	Transaction No.	Normal	Integer	4	Transaction No_	int
54	Closed by Amount (LCY)	Closed by Amount ($)	Normal	Decimal	12	Closed by Amount (LCY)	decimal(38,38)
58	Debit Amount	Debit Amount	FlowField	Decimal	12
59	Credit Amount	Credit Amount	FlowField	Decimal	12
60	Debit Amount (LCY)	Debit Amount ($)	FlowField	Decimal	12
61	Credit Amount (LCY)	Credit Amount ($)	FlowField	Decimal	12
62	Document Date	Document Date	Normal	Date	4	Document Date	datetime
63	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
64	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Vendor Ledger Entry].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Vendor Ledger Entry].[No_ Series] = [No. Series].[Code]
65	Closed by Currency Code	Closed by Currency Code	Normal	Code	10	Closed by Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Vendor Ledger Entry].[Closed by 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].[Closed by Currency Code] = [Currency].[Code]
66	Closed by Currency Amount	Closed by Currency Amount	Normal	Decimal	12	Closed by Currency Amount	decimal(38,38)
73	Adjusted Currency Factor	Adjusted Currency Factor	Normal	Decimal	12	Adjusted Currency Factor	decimal(38,38)
74	Original Currency Factor	Original Currency Factor	Normal	Decimal	12	Original Currency Factor	decimal(38,38)
75	Original Amount	Original Amount	FlowField	Decimal	12
76	Date Filter	Date Filter	FlowFilter	Date	4
77	Remaining Pmt. Disc. Possible	Remaining Pmt. Disc. Possible	Normal	Decimal	12	Remaining Pmt_ Disc_ Possible	decimal(38,38)
78	Pmt. Disc. Tolerance Date	Pmt. Disc. Tolerance Date	Normal	Date	4	Pmt_ Disc_ Tolerance Date	datetime
79	Max. Payment Tolerance	Max. Payment Tolerance	Normal	Decimal	12	Max_ Payment Tolerance	decimal(38,38)
81	Accepted Payment Tolerance	Accepted Payment Tolerance	Normal	Decimal	12	Accepted Payment Tolerance	decimal(38,38)
82	Accepted Pmt. Disc. Tolerance	Accepted Pmt. Disc. Tolerance	Normal	Boolean	4	Accepted Pmt_ Disc_ Tolerance	tinyint
83	Pmt. Tolerance (LCY)	Pmt. Tolerance ($)	Normal	Decimal	12	Pmt_ Tolerance (LCY)	decimal(38,38)
84	Amount to Apply	Amount to Apply	Normal	Decimal	12	Amount to Apply	decimal(38,38)
85	IC Partner Code	IC Partner Code	Normal	Code	20	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]
86	Applying Entry	Applying Entry	Normal	Boolean	4	Applying Entry	tinyint
87	Reversed	Reversed	Normal	Boolean	4	Reversed	tinyint
88	Reversed by Entry No.	Reversed by Entry No.	Normal	Integer	4	Reversed by Entry No_	int
89	Reversed Entry No.	Reversed Entry No.	Normal	Integer	4	Reversed Entry No_	int
90	Prepayment	Prepayment	Normal	Boolean	4	Prepayment	tinyint
170	Creditor No.	Creditor No.	Normal	Code	20	Creditor No_	nvarchar(40)
171	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
172	Payment Method Code	Payment Method Code	Normal	Code	10	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$ext] AS [Payment Method] ON [Vendor Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
173	Applies-to Ext. Doc. No.	Applies-to Ext. Doc. No.	Normal	Code	35	Applies-to Ext_ Doc_ No_	nvarchar(70)
175	Invoice Received Date	Invoice Received Date	Normal	Date	4	Invoice Received Date	datetime
288	Recipient Bank Account	Recipient Bank Account	Normal	Code	20	Recipient Bank Account	nvarchar(40)
289	Message to Recipient	Message to Recipient	Normal	Text	140	Message to Recipient	nvarchar(280)
290	Exported to Payment File	Exported to Payment File	Normal	Boolean	4	Exported to Payment File	tinyint
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Vendor Ledger Entry].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Vendor Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[] = [Dimension].[Code]
482	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[] = [Dimension].[Code]
483	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[] = [Dimension].[Code]
484	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[] = [Dimension].[Code]
485	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[] = [Dimension].[Code]
486	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Vendor Ledger Entry].[] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Vendor Ledger Entry].[] = [Dimension].[Code]
1000	Remit-to Code	Remit-to Code	Normal	Code	20	Remit-to Code	nvarchar(40)
10020	IRS 1099 Code	IRS 1099 Code	Normal	Code	10
10021	IRS 1099 Amount	IRS 1099 Amount	Normal	Decimal	12
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Vendor Ledger Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] LEFT JOIN [User] AS [User] ON [Vendor Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Vendor Ledger Entry table

Dynamics 365 BC Table Reference Tables Company Tables VVendor Ledger Entry

Leave a Reply Cancel reply