Share via

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

The following table lists the fields in this table.

Field Location
Total TDS/TCS Incl SHE CESS Field, Cust. Ledger Entry Table India Income Tax
Certificate Received Field, Cust. Ledger Entry Table India Income Tax
Document Occurrence to Close Field, Cust. Ledger Entry Table Italy Local Functionality
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
Document No. to Close Field, Cust. Ledger Entry Table Italy Local Functionality
TDS Certificate Amount Field, Cust. Ledger Entry Table India Income Tax
Adjustment Field, Cust. Ledger Entry Table New Zealand Local Functionality
TDS Certificate Receivable Field, Cust. Ledger Entry Table India Income Tax
Bank Receipt Temp. No. Field, Cust. Ledger Entry Table Italy Local Functionality
TDS Receivable Group Field, Cust. Ledger Entry Table India Income Tax
Rem. Amt Field, Cust. Ledger Entry Table New Zealand Local Functionality
Paid Int. Arrears Amount Field, Cust. Ledger Entry Table Italy Local Functionality
Int. Arrears Amount to Pay Field, Cust. Ledger Entry Table Italy Local Functionality
PoT Field, Cust. Ledger Entry Table India Service Tax
Document Occurrence Field, Cust. Ledger Entry Table Italy Local Functionality
TDS Nature of Deduction Field, Cust. Ledger Entry Table India Income Tax
Allow Issue Field, Cust. Ledger Entry Table Italy Local Functionality
TCS Type Field, Cust. Ledger Entry Table India Income Tax
Amount (LCY) stats. Field, Cust. Ledger Entry Table Spain Local Functionality
Document Situation Field, Cust. Ledger Entry Table Spain Local Functionality
Pre Adjmt. Reason Code Field, Cust. Ledger Entry Table New Zealand Local Functionality
Bank Receipt Field, Cust. Ledger Entry Table Italy Local Functionality
Certificate No. Field, Cust. Ledger Entry Table India Income Tax
Org. Pmt. Disc. Possible (LCY) Field, Cust. Ledger Entry Table Belgium Local Functionality
Bank Receipts List No. Field, Cust. Ledger Entry Table Italy Local Functionality
Disreg. Pmt. Disc. at Full Pmt Field, Cust. Ledger Entry Table Finland Local Functionality
Cumulative Bank Receipts Field, Cust. Ledger Entry Table Italy Local Functionality
WHT Payment Field, Cust. Ledger Entry Table New Zealand Local Functionality
TDS Certificate Rcpt Date Field, Cust. Ledger Entry Table India Income Tax
Journal Template Name Field, Cust. Ledger Entry Table Belgium Local Functionality
TCS Nature of Collection Field, Cust. Ledger Entry Table India Income Tax
Document Type to Close Field, Cust. Ledger Entry Table Italy Local Functionality
Remaining Amount (LCY) stats. Field, Cust. Ledger Entry Table Spain Local Functionality
Connect Lines Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Connect Batches Filter Field, Cust. Ledger Entry Table Netherlands 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
Bill No. Field, Cust. Ledger Entry Table Spain Local Functionality
WHT Amount Field, Cust. Ledger Entry Table New Zealand Local Functionality
BAS Adjustment Field, Cust. Ledger Entry Table New Zealand Local Functionality
Applies-to Occurrence No. Field, Cust. Ledger Entry Table Italy Local Functionality
Rem. Amt for WHT Field, Cust. Ledger Entry Table New Zealand Local Functionality
Customer Bill No. Field, Cust. Ledger Entry Table Italy Local Functionality
Bank Receipt Issued Field, Cust. Ledger Entry Table Italy Local Functionality
Applies-to Bill No. Field, Cust. Ledger Entry Table Spain Local Functionality
Payment Terms Code Field, Cust. Ledger Entry Table Spain 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
Document Status Field, Cust. Ledger Entry Table Spain 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
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
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
Remaining Amount Field, Cust. Ledger Entry Table Sales and Receivables
Prepmt. Diff. Appln. Entry No. Field, Cust. Ledger Entry Table Russia Local Functionality
Agreement No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Cust. Entry No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepayment Document No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepayment Status Field, Cust. Ledger Entry Table Russia Local Functionality
VAT Adjusted Field, Cust. Ledger Entry Table Russia Local Functionality
LSV No. Field, Cust. Ledger Entry Table Switzerland Local Functionality
Credit Memo Document Field, Cust. Ledger Entry Table Iceland Local Functionality
Prepmt. Diff. Appln. Entry No. Field, Cust. Ledger Entry Table Russia Local Functionality
Agreement No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Cust. Entry No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepayment Document No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepayment Status Field, Cust. Ledger Entry Table Russia Local Functionality
VAT Adjusted Field, Cust. Ledger Entry Table Russia Local Functionality
Payment Method Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field, Cust. Ledger Entry Table Deleted Topics
Org. Pmt. Disc. Possible (LCY) Field, Cust. Ledger Entry Table Belgium Local Functionality
Journal Template Name Field, Cust. Ledger Entry Table Belgium Local Functionality
Direct Debit Mandate ID Field, Cust. Ledger Entry Table Sales and Receivables
Payment Method Code Field, Cust. Ledger Entry Table Sales and Receivables
Dimension Set ID Field, Cust. Ledger Entry Table Sales and Receivables
Recipient Bank Account Field, Cust. Ledger Entry Table Sales and Receivables
Applies-to ID Field, Cust. Ledger Entry Table Sales and Receivables
Exported to Payment File Field, Cust. Ledger Entry Table Sales and Receivables
Applies-to Ext. Doc. No. Field, Cust. Ledger Entry Table Sales and Receivables
Message to Recipient Field, Cust. Ledger Entry Table Sales and Receivables
Last Issued Reminder Level Field, Cust. Ledger Entry Table Sales and Receivables
Payment Method Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field, Cust. Ledger Entry Table Deleted Topics
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
Direct Debit Mandate ID 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
Payment Method Code 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
Recipient Bank Account 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
Exported to Payment File 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
Applies-to Ext. Doc. No. 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
Message to Recipient 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
Adjustment Field, Cust. Ledger Entry Table New Zealand Local Functionality
Amount (LCY) stats. Field, Cust. Ledger Entry Table Spain Local Functionality
Document Situation Field, Cust. Ledger Entry Table Spain Local Functionality
Rem. Amt Field, Cust. Ledger Entry Table New Zealand Local Functionality
Disreg. Pmt. Disc. at Full Pmt Field, Cust. Ledger Entry Table Finland Local Functionality
Credit Memo Document Field, Cust. Ledger Entry Table Iceland Local Functionality
Pre Adjmt. Reason Code Field, Cust. Ledger Entry Table New Zealand Local Functionality
Remaining Amount (LCY) stats. Field, Cust. Ledger Entry Table Spain Local Functionality
Bill No. Field, Cust. Ledger Entry Table Spain Local Functionality
WHT Payment Field, Cust. Ledger Entry Table New Zealand Local Functionality
Connect Lines Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Connect Batches Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Document Occurrence to Close Field, Cust. Ledger Entry Table Italy 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
Applies-to Bill No. Field, Cust. Ledger Entry Table Spain Local Functionality
Payment Terms Code Field, Cust. Ledger Entry Table Spain Local Functionality
Document No. to Close Field, Cust. Ledger Entry Table Italy Local Functionality
Prepmt. Diff. Appln. Entry No. Field, Cust. Ledger Entry Table Russia Local Functionality
Bank Receipt Temp. No. Field, Cust. Ledger Entry Table Italy Local Functionality
Paid Int. Arrears Amount Field, Cust. Ledger Entry Table Italy Local Functionality
Int. Arrears Amount to Pay Field, Cust. Ledger Entry Table Italy Local Functionality
Transaction Mode Code Field, Cust. Ledger Entry Table Netherlands Local Functionality
Document Status Field, Cust. Ledger Entry Table Spain Local Functionality
Our Bank Filter Field, Cust. Ledger Entry Table Netherlands Local Functionality
Payments in Process Field, Cust. Ledger Entry Table Netherlands Local Functionality
Document Occurrence Field, Cust. Ledger Entry Table Italy 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
Allow Issue Field, Cust. Ledger Entry Table Italy Local Functionality
Bank Receipt Field, Cust. Ledger Entry Table Italy Local Functionality
Bank Receipts List No. Field, Cust. Ledger Entry Table Italy Local Functionality
Cumulative Bank Receipts Field, Cust. Ledger Entry Table Italy Local Functionality
Document Type to Close Field, Cust. Ledger Entry Table Italy Local Functionality
Applies-to Occurrence No. Field, Cust. Ledger Entry Table Italy Local Functionality
Customer Bill No. Field, Cust. Ledger Entry Table Italy Local Functionality
Bank Receipt Issued Field, Cust. Ledger Entry Table Italy Local Functionality
Agreement No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepmt. Diff. Cust. Entry No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepayment Document No. Field, Cust. Ledger Entry Table Russia Local Functionality
Prepayment Status Field, Cust. Ledger Entry Table Russia Local Functionality
VAT Adjusted Field, Cust. Ledger Entry Table Russia Local Functionality
LSV No. Field, Cust. Ledger Entry Table Switzerland Local Functionality
Payment Method Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field Field, Cust. Ledger Entry Table Deleted Topics
Bank Account Field, Cust. Ledger Entry Table Deleted Topics

See Also

Reference

Customer Ledger Entries