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

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
EFT Amount Transferred Field, Vendor Ledger Entry Table New Zealand Local Functionality
Total TDS/TCS Incl SHE CESS Field, Vendor Ledger Entry Table Income Tax
Input Service Distributor Field, Vendor Ledger Entry Table Service Tax
TDS Nature of Deduction Field, Vendor Ledger Entry Table Income Tax
Adjustment Applies-to Field, Vendor Ledger Entry Table New Zealand Local Functionality
Serv. Tax on Advance Payment Field, Vendor Ledger Entry Table Service Tax
EFT Register No. Field, Vendor Ledger Entry Table New Zealand Local Functionality
TDS Group Field, Vendor Ledger Entry Table Income Tax
Adjustment 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
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
Rem. Amt Field, Vendor Ledger Entry Table New Zealand Local Functionality
Pre Adjmt. Reason Code Field, Vendor Ledger Entry Table New Zealand 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
Specification (Norges Bank) Field, Vendor Ledger Entry Table Norway Local Functionality
Rem. Amt for WHT Field, Vendor Ledger Entry Table New Zealand Local Functionality
Payment Type Code Abroad Field, Vendor Ledger Entry Table Norway Local Functionality
Remittance ID Field, Vendor Ledger Entry Table Norway Local Functionality
KID Field, Vendor Ledger Entry Table Norway Local Functionality
PoT Field, Vendor Ledger Entry Table India 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
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
Connect Lines Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
Adjusted Currency Factor Field, Vendor Ledger Entry Table Purchases and Payables
Debit Amount Field, Vendor Ledger Entry Table Purchases and Payables
Connect Batches Filter Field, Vendor Ledger Entry Table Netherlands 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
Our Bank Filter Field, Vendor Ledger Entry Table Netherlands Local Functionality
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
Generated Autodocument Field, Vendor Ledger Entry Table Spain Local Functionality
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
Amount (LCY) stats. Field, Vendor Ledger Entry Table Spain Local Functionality
Max. Payment Tolerance Field, Vendor Ledger Entry Table Purchases and Payables
Autodocument No. Field, Vendor Ledger Entry Table Spain Local Functionality
Closed by Amount Field, Vendor Ledger Entry Table Purchases and Payables
Bill No. Field, Vendor Ledger Entry Table Spain Local Functionality
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
Positive Field, Vendor Ledger Entry Table Purchases and Payables
Pmt. Disc. Rcd.(LCY) Field, Vendor Ledger Entry Table Purchases and Payables
Remaining Amount (LCY) stats. Field, Vendor Ledger Entry Table Spain Local Functionality
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
Document Status Field, Vendor Ledger Entry Table Spain Local Functionality
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
Creditor No. Field, Vendor Ledger Entry Table General Ledger
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
Payment Reference Field, Vendor Ledger Entry Table General Ledger
Vendor Bill List Field, Vendor Ledger Entry Table Italy Local Functionality
Reference No. Field, Vendor Ledger Entry Table Switzerland Local Functionality
Vendor Bill No. Field, Vendor Ledger Entry Table Italy Local Functionality
Transaction Mode Code Field, Vendor Ledger Entry Table Netherlands Local Functionality
Payments in Process Field, Vendor Ledger Entry Table Netherlands Local Functionality
Document Occurrence Field, Vendor Ledger Entry Table Italy Local Functionality
Int. Arrears Amount to Pay Field, Vendor Ledger Entry Table Italy 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

See Also

Reference

Vendor Ledger Entries