Share via

Vendor Ledger Entry Table

  • Article

Specifies posted entries from purchase orders, purchase invoices, purchase credit memos, journal lines, finance charge memos, reminders, and refunds.

When you post to a vendor account, the program creates a vendor ledger entry, which you can see in the Vendor Ledger Entry table by clicking Vendor, Ledger Entries from the vendor card.

Vendor ledger entries are created by the posting of a purchase order, invoice, credit memo or journal line.

All adjustments made to the vendor ledger entry due to, for example, payment discounts or changes in currency exchange rates, are recorded in the Detailed Vendor Ledg. Entry table.

The only fields on a vendor ledger entry that can be changed are the following: On Hold, Due Date, Pmt. Discount Date, Remaining Pmt. Disc. Possible, Pmt. Disc. Tolerance Date and Payment Tolerance. You cannot change the other fields because the entry has been posted.

List of Fields in the Table

The following table lists the fields in this table.

Field Location
Vendor Bill List Field, Vendor Ledger Entry Table Italy Local Functionality
EFT Amount Transferred Field, Vendor Ledger Entry Table New Zealand Local Functionality
Vendor Bill No. Field, Vendor Ledger Entry Table Italy Local Functionality
Adjustment Applies-to Field, Vendor Ledger Entry Table New Zealand Local Functionality
EFT Register No. Field, Vendor Ledger Entry Table New Zealand Local Functionality
Input Service Distribution Field, Vendor Ledger Entry Table India Service Tax
Document Occurrence Field, Vendor Ledger Entry Table Italy Local Functionality
Serv. Tax on Advance Payment Field, Vendor Ledger Entry Table India Service Tax
Adjustment Field, Vendor Ledger Entry Table New Zealand Local Functionality
Payment Terms Code Field, Vendor Ledger Entry Table Spain Local Functionality
Int. Arrears Amount to Pay Field, Vendor Ledger Entry Table Italy Local Functionality
Applies-to Bill No. Field, Vendor Ledger Entry Table Spain Local Functionality
Document Situation Field, Vendor Ledger Entry Table Spain Local Functionality
Total TDS Including SHE CESS Field, Vendor Ledger Entry Table India Income Tax
IRS 1099 Amount Field, Vendor Ledger Entry Table United States Local Functionality
TDS Nature of Deduction Field, Vendor Ledger Entry Table India Income Tax
Org. Pmt. Disc. Possible (LCY) Field, Vendor Ledger Entry Table Belgium Local Functionality
Paid Int. Arrears Amount Field, Vendor Ledger Entry Table Italy Local Functionality
IRS 1099 Code Field, Vendor Ledger Entry Table United States Local Functionality
TDS Group Field, Vendor Ledger Entry Table India Income Tax
Journal Template Name Field, Vendor Ledger Entry Table Belgium Local Functionality
Connect Lines Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
WHT Amount (LCY) Field, Vendor Ledger Entry Table New Zealand Local Functionality
Generated Autodocument Field, Vendor Ledger Entry Table Spain Local Functionality
BAS Adjustment Field, Vendor Ledger Entry Table New Zealand Local Functionality
EFT Bank Account No. Field, Vendor Ledger Entry Table New Zealand Local Functionality
Connect Batches Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
Amount (LCY) stats. Field, Vendor Ledger Entry Table Spain Local Functionality
Rem. Amt Field, Vendor Ledger Entry Table New Zealand Local Functionality
Our Bank Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
Pre Adjmt. Reason Code Field, Vendor Ledger Entry Table New Zealand Local Functionality
Inv. Discount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Autodocument No. Field, Vendor Ledger Entry Table Spain Local Functionality
Closed by Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Original Amt. (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Bill No. Field, Vendor Ledger Entry Table Spain Local Functionality
Adjusted Currency Factor Field, Vendor Ledger Entry Table Purchases and Payables
WHT Amount Field, Vendor Ledger Entry Table New Zealand Local Functionality
Transaction Mode Code Field, Vendor Ledger Entry Table Netherlands Local Functionality
Debit Amount Field, Vendor Ledger Entry Table Purchases and Payables
Financialy Voided Cheque Field, Vendor Ledger Entry Table New Zealand Local Functionality
Remaining Amt. (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Original Pmt. Disc. Possible Field, Vendor Ledger Entry Table Purchases and Payables
Source Code Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Occurrence No. Field, Vendor Ledger Entry Table Italy Local Functionality
Buy-from Vendor No. Field, Vendor Ledger Entry Table Purchases and Payables
Rem. Amt for WHT Field, Vendor Ledger Entry Table New Zealand Local Functionality
Payments in Process Field, Vendor Ledger Entry Table Netherlands Local Functionality
Pmt. Disc. Tolerance Date Field, Vendor Ledger Entry Table Purchases and Payables
Date Filter Field, Vendor Ledger Entry Table Purchases and Payables
Remaining Amount (LCY) stats. Field, Vendor Ledger Entry Table Spain Local Functionality
Currency Code Field, Vendor Ledger Entry Table Purchases and Payables
Document Status Field, Vendor Ledger Entry Table Spain Local Functionality
User ID Field, Vendor Ledger Entry Table Purchases and Payables
Journal Batch Name Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Currency Amount Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Discount Date Field, Vendor Ledger Entry Table Purchases and Payables
Accepted Pmt. Disc. Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Global Dimension 1 Code Field, Vendor Ledger Entry Table Purchases and Payables
Purchaser Code Field, Vendor Ledger Entry Table Purchases and Payables
Max. Payment Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Amount Field, Vendor Ledger Entry Table Purchases and Payables
PoT Field, Vendor Ledger Entry Table India Local Functionality
Remaining Pmt. Disc. Possible Field, Vendor Ledger Entry Table Purchases and Payables
Vendor Posting Group Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Currency Code Field, Vendor Ledger Entry Table Purchases and Payables
Remaining Amount Field, Vendor Ledger Entry Table Purchases and Payables
Positive Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Disc. Rcd.(LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Tolerance (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Global Dimension 2 Code Field, Vendor Ledger Entry Table Purchases and Payables
Bal. Account No. Field, Vendor Ledger Entry Table Purchases and Payables
Credit Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Reversed Field, Vendor Ledger Entry Table Purchases and Payables
Bal. Account Type Field, Vendor Ledger Entry Table Purchases and Payables
Document Type Field, Vendor Ledger Entry Table Purchases and Payables
Closed at Date Field, Vendor Ledger Entry Table Purchases and Payables
Debit Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
External Document No. Field, Vendor Ledger Entry Table Purchases and Payables
Due Date Field, Vendor Ledger Entry Table Purchases and Payables
Open Field, Vendor Ledger Entry Table Purchases and Payables
Amount to Apply Field, Vendor Ledger Entry Table Purchases and Payables
Transaction No. Field, Vendor Ledger Entry Table Purchases and Payables
Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Doc. Type Field, Vendor Ledger Entry Table Purchases and Payables
Description Field, Vendor Ledger Entry Table Purchases and Payables
Prepayment Field, Vendor Ledger Entry Table Purchases and Payables
Document No. Field, Vendor Ledger Entry Table Purchases and Payables
On Hold Field, Vendor Ledger Entry Table Purchases and Payables
Applying Entry Field, Vendor Ledger Entry Table Purchases and Payables
Reversed Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Doc. No. Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Credit Amount Field, Vendor Ledger Entry Table Purchases and Payables
Vendor No. Field, Vendor Ledger Entry Table Purchases and Payables
Purchase (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Dimension Set ID Field, Vendor Ledger Entry Table Purchases and Payables
Document Date Field, Vendor Ledger Entry Table Purchases and Payables
Reason Code Field, Vendor Ledger Entry Table Purchases and Payables
IC Partner Code Field, Vendor Ledger Entry Table Purchases and Payables
Posting Date Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to ID Field, Vendor Ledger Entry Table Purchases and Payables
No. Series Field, Vendor Ledger Entry Table Purchases and Payables
Accepted Payment Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Reversed by Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Original Amount Field, Vendor Ledger Entry Table Purchases and Payables
Amount Field, Vendor Ledger Entry Table Purchases and Payables
Original Currency Factor Field, Vendor Ledger Entry Table Purchases and Payables
Agreement No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice Date Field, Vendor Ledger Entry Table Russia Local Functionality
Payroll Ledger Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
VAT Adjusted Field, Vendor Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Vend. Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice Rcvd Date Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Receipts Date Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Receipts No. Field, Vendor Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Appln. Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice No. Field, Vendor Ledger Entry Table Russia Local Functionality
Reference No. Field, Vendor Ledger Entry Table Switzerland Local Functionality
Specification (Norges Bank) Field, Vendor Ledger Entry Table Norway Local Functionality
Payment Type Code Abroad Field, Vendor Ledger Entry Table Norway Local Functionality
Remittance ID Field, Vendor Ledger Entry Table Norway Local Functionality
Agreement No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice Date Field, Vendor Ledger Entry Table Russia Local Functionality
KID Field, Vendor Ledger Entry Table Norway Local Functionality
Recipient Bank Account Field, Vendor Ledger Entry Table Purchases and Payables
Payment Method Code Field, Vendor Ledger Entry Table Purchases and Payables
Message to Recipient Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Ext. Doc. No. Field, Vendor Ledger Entry Table Purchases and Payables
Payroll Ledger Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
VAT Adjusted Field, Vendor Ledger Entry Table Russia Local Functionality
Exported to Payment File Field, Vendor Ledger Entry Table Purchases and Payables
Prepmt. Diff. Vend. Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice Rcvd Date Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Receipts Date Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Receipts No. Field, Vendor Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Appln. Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Bank Acc. No. Field, Vendor Ledger Entry Table Deleted Topics
Bank Code Field, Vendor Ledger Entry Table Deleted Topics
Bank Account Field Field, Vendor Ledger Entry Table Deleted Topics
Payment Method Field, Vendor Ledger Entry Table Deleted Topics
Org. Pmt. Disc. Possible (LCY) Field, Vendor Ledger Entry Table Belgium Local Functionality
Journal Template Name Field, Vendor Ledger Entry Table Belgium Local Functionality
Creditor No. Field, Vendor Ledger Entry Table General Ledger
Payment Reference Field, Vendor Ledger Entry Table General Ledger
Vendor Bank Acc. No. Field, Vendor Ledger Entry Table Deleted Topics
Bank Code Field, Vendor Ledger Entry Table Deleted Topics
Bank Account Field Field, Vendor Ledger Entry Table Deleted Topics
Payment Method Field, Vendor Ledger Entry Table Deleted Topics
Inv. Discount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Original Amt. (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Adjusted Currency Factor Field, Vendor Ledger Entry Table Purchases and Payables
Debit Amount Field, Vendor Ledger Entry Table Purchases and Payables
Remaining Amt. (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Original Pmt. Disc. Possible Field, Vendor Ledger Entry Table Purchases and Payables
Source Code Field, Vendor Ledger Entry Table Purchases and Payables
Buy-from Vendor No. Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Disc. Tolerance Date Field, Vendor Ledger Entry Table Purchases and Payables
Date Filter Field, Vendor Ledger Entry Table Purchases and Payables
Currency Code Field, Vendor Ledger Entry Table Purchases and Payables
Recipient Bank Account Field, Vendor Ledger Entry Table Purchases and Payables
User ID Field, Vendor Ledger Entry Table Purchases and Payables
Journal Batch Name Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Currency Amount Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Discount Date Field, Vendor Ledger Entry Table Purchases and Payables
Accepted Pmt. Disc. Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Payment Method Code Field, Vendor Ledger Entry Table Purchases and Payables
Global Dimension 1 Code Field, Vendor Ledger Entry Table Purchases and Payables
Purchaser Code Field, Vendor Ledger Entry Table Purchases and Payables
Max. Payment Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Amount Field, Vendor Ledger Entry Table Purchases and Payables
Message to Recipient Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Ext. Doc. No. Field, Vendor Ledger Entry Table Purchases and Payables
Remaining Pmt. Disc. Possible Field, Vendor Ledger Entry Table Purchases and Payables
Vendor Posting Group Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Currency Code Field, Vendor Ledger Entry Table Purchases and Payables
Remaining Amount Field, Vendor Ledger Entry Table Purchases and Payables
Creditor No. Field, Vendor Ledger Entry Table Purchases and Payables
Positive Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Disc. Rcd.(LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Tolerance (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Global Dimension 2 Code Field, Vendor Ledger Entry Table Purchases and Payables
Bal. Account No. Field, Vendor Ledger Entry Table Purchases and Payables
Credit Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Reversed Field, Vendor Ledger Entry Table Purchases and Payables
Bal. Account Type Field, Vendor Ledger Entry Table Purchases and Payables
Document Type Field, Vendor Ledger Entry Table Purchases and Payables
Closed at Date Field, Vendor Ledger Entry Table Purchases and Payables
Debit Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
External Document No. Field, Vendor Ledger Entry Table Purchases and Payables
Due Date Field, Vendor Ledger Entry Table Purchases and Payables
Open Field, Vendor Ledger Entry Table Purchases and Payables
Amount to Apply Field, Vendor Ledger Entry Table Purchases and Payables
Transaction No. Field, Vendor Ledger Entry Table Purchases and Payables
Amount (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Doc. Type Field, Vendor Ledger Entry Table Purchases and Payables
Description Field, Vendor Ledger Entry Table Purchases and Payables
Payment Reference Field, Vendor Ledger Entry Table Purchases and Payables
Prepayment Field, Vendor Ledger Entry Table Purchases and Payables
Document No. Field, Vendor Ledger Entry Table Purchases and Payables
On Hold Field, Vendor Ledger Entry Table Purchases and Payables
Applying Entry Field, Vendor Ledger Entry Table Purchases and Payables
Reversed Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Exported to Payment File Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to Doc. No. Field, Vendor Ledger Entry Table Purchases and Payables
Closed by Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Credit Amount Field, Vendor Ledger Entry Table Purchases and Payables
Vendor No. Field, Vendor Ledger Entry Table Purchases and Payables
Purchase (LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Dimension Set ID Field, Vendor Ledger Entry Table Purchases and Payables
Document Date Field, Vendor Ledger Entry Table Purchases and Payables
Reason Code Field, Vendor Ledger Entry Table Purchases and Payables
IC Partner Code Field, Vendor Ledger Entry Table Purchases and Payables
Posting Date Field, Vendor Ledger Entry Table Purchases and Payables
Applies-to ID Field, Vendor Ledger Entry Table Purchases and Payables
No. Series Field, Vendor Ledger Entry Table Purchases and Payables
Accepted Payment Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Reversed by Entry No. Field, Vendor Ledger Entry Table Purchases and Payables
Original Amount Field, Vendor Ledger Entry Table Purchases and Payables
Amount Field, Vendor Ledger Entry Table Purchases and Payables
Original Currency Factor Field, Vendor Ledger Entry Table Purchases and Payables
EFT Amount Transferred Field, Vendor Ledger Entry Table New Zealand Local Functionality
Giro Acc. No. Field, Vendor Ledger Entry Table Denmark Local Functionality
Payment Terms Code Field, Vendor Ledger Entry Table Spain Local Functionality
Applies-to Bill No. Field, Vendor Ledger Entry Table Spain Local Functionality
Document Situation Field, Vendor Ledger Entry Table Spain Local Functionality
Adjustment Applies-to Field, Vendor Ledger Entry Table New Zealand Local Functionality
EFT Register No. Field, Vendor Ledger Entry Table New Zealand Local Functionality
IRS 1099 Amount Field, Vendor Ledger Entry Table United States Local Functionality
IRS 1099 Code Field, Vendor Ledger Entry Table United States Local Functionality
Adjustment Field, Vendor Ledger Entry Table New Zealand Local Functionality
Vendor Bill List Field, Vendor Ledger Entry Table Italy Local Functionality
Generated Autodocument Field, Vendor Ledger Entry Table Spain Local Functionality
Amount (LCY) stats. Field, Vendor Ledger Entry Table Spain Local Functionality
Connect Lines Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
Specification (Norges Bank) Field, Vendor Ledger Entry Table Norway Local Functionality
Connect Batches Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
Our Bank Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
Autodocument No. Field, Vendor Ledger Entry Table Spain Local Functionality
Payment Type Code Abroad Field, Vendor Ledger Entry Table Norway Local Functionality
Bill No. Field, Vendor Ledger Entry Table Spain Local Functionality
Vendor Bill No. Field, Vendor Ledger Entry Table Italy Local Functionality
WHT Amount (LCY) Field, Vendor Ledger Entry Table New Zealand Local Functionality
BAS Adjustment Field, Vendor Ledger Entry Table New Zealand Local Functionality
EFT Bank Account No. Field, Vendor Ledger Entry Table New Zealand Local Functionality
Transaction Mode Code Field, Vendor Ledger Entry Table Netherlands Local Functionality
Remittance ID Field, Vendor Ledger Entry Table Norway Local Functionality
Rem. Amt Field, Vendor Ledger Entry Table New Zealand Local Functionality
Pre Adjmt. Reason Code Field, Vendor Ledger Entry Table New Zealand Local Functionality
Agreement No. Field, Vendor Ledger Entry Table Russia Local Functionality
Remaining Amount (LCY) stats. Field, Vendor Ledger Entry Table Spain Local Functionality
Vendor VAT Invoice Date Field, Vendor Ledger Entry Table Russia Local Functionality
Payments in Process Field, Vendor Ledger Entry Table Netherlands Local Functionality
Document Occurrence Field, Vendor Ledger Entry Table Italy Local Functionality
Document Status Field, Vendor Ledger Entry Table Spain Local Functionality
KID Field, Vendor Ledger Entry Table Norway Local Functionality
WHT Amount Field, Vendor Ledger Entry Table New Zealand Local Functionality
Financialy Voided Cheque Field, Vendor Ledger Entry Table New Zealand Local Functionality
Int. Arrears Amount to Pay Field, Vendor Ledger Entry Table Italy Local Functionality
Rem. Amt for WHT Field, Vendor Ledger Entry Table New Zealand Local Functionality
Paid Int. Arrears Amount Field, Vendor Ledger Entry Table Italy Local Functionality
Applies-to Occurrence No. Field, Vendor Ledger Entry Table Italy Local Functionality
Payroll Ledger Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
VAT Adjusted Field, Vendor Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Vend. Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice Rcvd Date Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Receipts Date Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor Receipts No. Field, Vendor Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Appln. Entry No. Field, Vendor Ledger Entry Table Russia Local Functionality
Vendor VAT Invoice No. Field, Vendor Ledger Entry Table Russia Local Functionality
Reference No. Field, Vendor Ledger Entry Table Switzerland Local Functionality
Vendor Bank Acc. No. Field, Vendor Ledger Entry Table Deleted Topics
Bank Code Field, Vendor Ledger Entry Table Deleted Topics
Bank Account Field Field, Vendor Ledger Entry Table Deleted Topics
Payment Method Field, Vendor Ledger Entry Table Deleted Topics

See Also

Reference

Vendor Ledger Entries