Detailed Cust. Ledg. Entry Table

The Detailed Cust. Ledg. Entry table contains all posted entries, including adjustments, related to the document and journal line entries in the Cust. Ledger Entry table.

Besides the original entry and the applied entry, the Detailed Cust. Ledg. Entry table includes any adjustments made to the customer ledger entry. These could be payment discounts, realized and unrealized losses and gains due to changes in the currency exchange rate, application rounding and corrections due to the rounding of different currencies.

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
TCS Nature of Collection Field, Detailed Cust. Ledg. Entry Table	Income Tax
TDS Nature of Deduction Field, Detailed Cust. Ledg. Entry Table	Income Tax
TDS Group Field, Detailed Cust. Ledg. Entry Table	Income Tax
TCS Type Field, Detailed Cust. Ledg. Entry Table	Income Tax
Total TDS/TCS Incl. SHECESS Field, Detailed Cust. Ledg. Entry Table	Income Tax
Document Situation Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Excluded from calculation Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Document Status Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Bill No. Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Bank Receipt Field, Detailed Cust. Ledg. Entry Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Applies-to Bill No. Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Bank Receipt Issued Field, Detailed Cust. Ledg. Entry Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Entry No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Unapplied Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Applied Cust. Ledger Entry No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Customer No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Gen. Prod. Posting Group Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Credit Amount (LCY) Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
User ID Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Credit Amount Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Cust. Ledger Entry No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Debit Amount Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Document No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Initial Document Type Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Use Tax Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Max. Payment Tolerance Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Remaining Pmt. Disc. Possible Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Initial Entry Due Date Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Currency Code Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Amount Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Initial Entry Global Dim. 2 Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Unapplied by Entry No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Debit Amount (LCY) Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Source Code Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
VAT Prod. Posting Group Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Initial Entry Global Dim. 1 Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Posting Date Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
VAT Bus. Posting Group Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Amount (LCY) Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Document Type Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Tax Jurisdiction Code Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Gen. Bus. Posting Group Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Journal Batch Name Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Reason Code Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Transaction No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Application No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
TCS Nature of Collection Field, Detailed Cust. Ledg. Entry Table	India Income Tax
TDS Nature of Deduction Field, Detailed Cust. Ledg. Entry Table	India Income Tax
TDS Group Field, Detailed Cust. Ledg. Entry Table	India Income Tax
TCS Type Field, Detailed Cust. Ledg. Entry Table	India Income Tax
Total TDS/TCS Incl. SHECESS Field, Detailed Cust. Ledg. Entry Table	India Income Tax
Document Date Field, Detailed Cust. Ledg. Entry Table	New Zealand Local Functionality
TCS Nature of Collection Field, Detailed Cust. Ledg. Entry Table	Income Tax
TDS Nature of Deduction Field, Detailed Cust. Ledg. Entry Table	Income Tax
TDS Group Field, Detailed Cust. Ledg. Entry Table	Income Tax
TCS Type Field, Detailed Cust. Ledg. Entry Table	Income Tax
Total TDS/TCS Incl. SHECESS Field, Detailed Cust. Ledg. Entry Table	Income Tax
Entry Type Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables

See Also

Reference

Detailed Cust. Ledg. Entries