Cust. Ledger Entry Table

  • Article

Specifies posted entries from sales orders, sales invoices, sales credit memos, journal lines, finance charge memos, reminders, and refunds. When you post to a customer account, the program creates a customer ledger entry, which you can see in the Cust. Ledger Entry table by clicking Customer, Ledger Entries from the customer card.

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

The only fields on a customer ledger entry that you can fill in are the following: On Hold, Due Date, Pmt. Discount Date, Remaining Pmt. Disc. Possible, Pmt. Disc. Tolerance Date and Max. 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
Total TDS/TCS Incl SHE CESS Field, Cust. Ledger Entry Table Income Tax
Certificate Received Field, Cust. Ledger Entry Table Income Tax
Document Occurrence to Close Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Payment Method Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
TDS Certificate Received Field, Cust. Ledger Entry Table Income Tax
TDS Group Field, Cust. Ledger Entry Table Income Tax
Serv. Tax on Advance Payment Field, Cust. Ledger Entry Table Service Tax
Financial Year Field, Cust. Ledger Entry Table Income Tax
Document No. to Close Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
TDS Certificate Amount Field, Cust. Ledger Entry Table Income Tax
TDS Certificate Receivable Field, Cust. Ledger Entry Table Income Tax
Bank Receipt Temp. No. Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
TDS Receivable Group Field, Cust. Ledger Entry Table Income Tax
Paid Int. Arrears Amount Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Int. Arrears Amount to Pay Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Amount (LCY) stats. Field, Cust. Ledger Entry Table Spain Local Functionality
Document Situation Field, Cust. Ledger Entry Table Spain Local Functionality
PoT Field, Cust. Ledger Entry Table Service Tax
Document Occurrence Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
TDS Nature of Deduction Field, Cust. Ledger Entry Table Income Tax
Allow Issue Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
TCS Type Field, Cust. Ledger Entry Table Income Tax
Bank Receipt Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Certificate No. Field, Cust. Ledger Entry Table Income Tax
Bank Receipts List No. Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Cumulative Bank Receipts Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
TDS Certificate Rcpt Date Field, Cust. Ledger Entry Table Income Tax
Remaining Amount (LCY) stats. Field, Cust. Ledger Entry Table Spain Local Functionality
TCS Nature of Collection Field, Cust. Ledger Entry Table Income Tax
Bill No. Field, Cust. Ledger Entry Table Spain Local Functionality
Document Type to Close Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Applies-to Bill No. Field, Cust. Ledger Entry Table Spain Local Functionality
Payment Terms Code Field, Cust. Ledger Entry Table Spain Local Functionality
Applies-to Occurrence No. Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Customer Bill No. Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Bank Account Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Bank Receipt Issued Field, Cust. Ledger Entry Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Document Status Field, Cust. Ledger Entry Table Spain Local Functionality
Disreg. Pmt. Disc. at Full Pmt Field, Cust. Ledger Entry Table Finland Local Functionality
Org. Pmt. Disc. Possible (LCY) Field, Cust. Ledger Entry Table Belgium Local Functionality
Journal Template Name Field, Cust. Ledger Entry Table Belgium Local Functionality
Connect Lines Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Connect Batches Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Bank Account Code Field, Cust. Ledger Entry Table Netherlands Local Functionality
Transaction Mode Code Field, Cust. Ledger Entry Table Netherlands Local Functionality
Our Bank Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Payments in Process Field, Cust. Ledger Entry Table Netherlands Local Functionality
Bal. Account No. Field, Cust. Ledger Entry Table Sales and Receivables
Customer No. Field, Cust. Ledger Entry Table Sales and Receivables
Global Dimension 2 Code Field, Cust. Ledger Entry Table Sales and Receivables
Inv. Discount (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Pmt. Tolerance (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Reversed by Entry No. Field, Cust. Ledger Entry Table Sales and Receivables
Amount Field, Cust. Ledger Entry Table Sales and Receivables
Max. Payment Tolerance Field, Cust. Ledger Entry Table Sales and Receivables
Pmt. Discount Date Field, Cust. Ledger Entry Table Sales and Receivables
On Hold Field, Cust. Ledger Entry Table Sales and Receivables
Closed by Currency Amount Field, Cust. Ledger Entry Table Sales and Receivables
Applies-to Doc. No. Field, Cust. Ledger Entry Table Sales and Receivables
Sales (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Prepayment Field, Cust. Ledger Entry Table Sales and Receivables
Closed by Amount (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Transaction No. Field, Cust. Ledger Entry Table Sales and Receivables
Closed at Date Field, Cust. Ledger Entry Table Sales and Receivables
Dimension Set ID Field, Cust. Ledger Entry Table Sales and Receivables
Amount (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Entry No. Field, Cust. Ledger Entry Table Sales and Receivables
Pmt. Disc. Tolerance Date Field, Cust. Ledger Entry Table Sales and Receivables
Reversed Entry No. Field, Cust. Ledger Entry Table Sales and Receivables
Credit Amount Field, Cust. Ledger Entry Table Sales and Receivables
Original Amt. (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Document Date Field, Cust. Ledger Entry Table Sales and Receivables
Credit Amount (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Remaining Amt. (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Original Currency Factor Field, Cust. Ledger Entry Table Sales and Receivables
Reversed Field, Cust. Ledger Entry Table Sales and Receivables
Profit (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Salesperson Code Field, Cust. Ledger Entry Table Sales and Receivables
Document No. Field, Cust. Ledger Entry Table Sales and Receivables
Document Type Field, Cust. Ledger Entry Table Sales and Receivables
User ID Field, Cust. Ledger Entry Table Sales and Receivables
No. Series Field, Cust. Ledger Entry Table Sales and Receivables
Bal. Account Type Field, Cust. Ledger Entry Table Sales and Receivables
Debit Amount (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Global Dimension 1 Code Field, Cust. Ledger Entry Table Sales and Receivables
Accepted Payment Tolerance Field, Cust. Ledger Entry Table Sales and Receivables
Reason Code Field, Cust. Ledger Entry Table Sales and Receivables
Journal Batch Name Field, Cust. Ledger Entry Table Sales and Receivables
Applies-to ID Field, Cust. Ledger Entry Table Sales and Receivables
Amount to Apply Field, Cust. Ledger Entry Table Sales and Receivables
Posting Date Field, Cust. Ledger Entry Table Sales and Receivables
Currency Code Field, Cust. Ledger Entry Table Sales and Receivables
Applying Entry Field, Cust. Ledger Entry Table Sales and Receivables
Debit Amount Field, Cust. Ledger Entry Table Sales and Receivables
Closed by Entry No. Field, Cust. Ledger Entry Table Sales and Receivables
Due Date Field, Cust. Ledger Entry Table Sales and Receivables
Positive Field, Cust. Ledger Entry Table Sales and Receivables
Adjusted Currency Factor Field, Cust. Ledger Entry Table Sales and Receivables
Sell-to Customer No. Field, Cust. Ledger Entry Table Sales and Receivables
Customer Posting Group Field, Cust. Ledger Entry Table Sales and Receivables
Source Code Field, Cust. Ledger Entry Table Sales and Receivables
Original Pmt. Disc. Possible Field, Cust. Ledger Entry Table Sales and Receivables
IC Partner Code Field, Cust. Ledger Entry Table Sales and Receivables
Pmt. Disc. Given (LCY) Field, Cust. Ledger Entry Table Sales and Receivables
Applies-to Doc. Type Field, Cust. Ledger Entry Table Sales and Receivables
Original Amount Field, Cust. Ledger Entry Table Sales and Receivables
Remaining Pmt. Disc. Possible Field, Cust. Ledger Entry Table Sales and Receivables
Open Field, Cust. Ledger Entry Table Sales and Receivables
Date Filter Field, Cust. Ledger Entry Table Sales and Receivables
Closing Interest Calculated Field, Cust. Ledger Entry Table Sales and Receivables
Closed by Currency Code Field, Cust. Ledger Entry Table Sales and Receivables
Description Field, Cust. Ledger Entry Table Sales and Receivables
External Document No. Field, Cust. Ledger Entry Table Sales and Receivables
Accepted Pmt. Disc. Tolerance Field, Cust. Ledger Entry Table Sales and Receivables
Closed by Amount Field, Cust. Ledger Entry Table Sales and Receivables
Calculate Interest Field, Cust. Ledger Entry Table Sales and Receivables
Last Issued Reminder Level Field, Cust. Ledger Entry Table Sales and Receivables
Remaining Amount Field, Cust. Ledger Entry Table Sales and Receivables
Total TDS/TCS Incl SHE CESS Field, Cust. Ledger Entry Table India Income Tax
Certificate Received Field, Cust. Ledger Entry Table India Income Tax
TDS Certificate Received Field, Cust. Ledger Entry Table India Income Tax
TDS Group Field, Cust. Ledger Entry Table India Income Tax
Serv. Tax on Advance Payment Field, Cust. Ledger Entry Table India Service Tax
Financial Year Field, Cust. Ledger Entry Table India Income Tax
TDS Certificate Amount Field, Cust. Ledger Entry Table India Income Tax
TDS Certificate Receivable Field, Cust. Ledger Entry Table India Income Tax
TDS Receivable Group Field, Cust. Ledger Entry Table India Income Tax
Int. Arrears Amount to Pay Field, Cust. Ledger Entry Table Italy Local Functionality
TDS Nature of Deduction Field, Cust. Ledger Entry Table India Income Tax
TCS Type Field, Cust. Ledger Entry Table India Income Tax
Certificate No. Field, Cust. Ledger Entry Table India Income Tax
TDS Certificate Rcpt Date Field, Cust. Ledger Entry Table India Income Tax
TCS Nature of Collection Field, Cust. Ledger Entry Table India Income Tax
Transaction Mode Code Field, Cust. Ledger Entry Table Netherlands Local Functionality
Payments in Process Field, Cust. Ledger Entry Table Netherlands Local Functionality
Adjustment Field, Cust. Ledger Entry Table New Zealand Local Functionality
Rem. Amt Field, Cust. Ledger Entry Table New Zealand Local Functionality
Pre Adjmt. Reason Code Field, Cust. Ledger Entry Table New Zealand Local Functionality
WHT Payment Field, Cust. Ledger Entry Table New Zealand Local Functionality
Adjustment Applies-to Field, Cust. Ledger Entry Table New Zealand Local Functionality
WHT Amount (LCY) Field, Cust. Ledger Entry Table New Zealand Local Functionality
WHT Amount Field, Cust. Ledger Entry Table New Zealand Local Functionality
BAS Adjustment Field, Cust. Ledger Entry Table New Zealand Local Functionality
Rem. Amt for WHT Field, Cust. Ledger Entry Table New Zealand Local Functionality
Credit Memo Document Field, Cust. Ledger Entry Table Iceland Local Functionality
LSV No. Field, Cust. Ledger Entry Table Switzerland Local Functionality
Total TDS/TCS Incl SHE CESS Field, Cust. Ledger Entry Table Income Tax
Certificate Received Field, Cust. Ledger Entry Table Income Tax
TDS Certificate Received Field, Cust. Ledger Entry Table Income Tax
TDS Group Field, Cust. Ledger Entry Table Income Tax
Financial Year Field, Cust. Ledger Entry Table Income Tax
TDS Certificate Amount Field, Cust. Ledger Entry Table Income Tax
TDS Certificate Receivable Field, Cust. Ledger Entry Table Income Tax
Serv. Tax On Advance Payment Field, Cust. Ledger Entry Table Service Tax
TDS Receivable Group Field, Cust. Ledger Entry Table Income Tax
TDS Nature of Deduction Field, Cust. Ledger Entry Table Income Tax
TCS Type Field, Cust. Ledger Entry Table Income Tax
Certificate No. Field, Cust. Ledger Entry Table Income Tax
TDS Certificate Rcpt. Date Field, Cust. Ledger Entry Table Income Tax
TCS Nature of Collection Field, Cust. Ledger Entry Table Income Tax
Int. Arrears Amount to Pay Field, Cust. Ledger Entry Table Italy Local Functionality
Transaction Mode Code Field, Cust. Ledger Entry Table Netherlands Local Functionality
Payments in Process Field, Cust. Ledger Entry Table Netherlands Local Functionality
Bank Account Field Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field Field, Cust. Ledger Entry Table Deleted Topics
Int. Arrears Amount to Pay Field, Cust. Ledger Entry Table Italy Local Functionality
Transaction Mode Code Field, Cust. Ledger Entry Table Netherlands Local Functionality
Payments in Process Field, Cust. Ledger Entry Table Netherlands Local Functionality
Bank Account Field Field, Cust. Ledger Entry Table Deleted Topics

See Also

Reference

Customer Ledger Entries