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

The following table lists the fields in this table.

Field	Location
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
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
Bank Receipt Field, Detailed Cust. Ledg. Entry Table	Italy Local Functionality
Bank Receipt Issued Field, Detailed Cust. Ledg. Entry Table	Italy Local Functionality
Bill No. Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Applies-to Bill No. Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Entry No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Applied Cust. Ledger Entry No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Gen. Prod. Posting Group Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
User ID 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
Currency Code 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
Posting Date Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
VAT Bus. Posting Group 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
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
Initial Entry Posting Date Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Tax Diff. Transaction No. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Agreement No. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepmt. Diff. in TA Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Amount Difference Field, Detailed Cust. Ledg. Entry Table	Deleted Topics
Prepayment Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Customer Posting Group Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Amount Difference in TA Field, Detailed Cust. Ledg. Entry Table	Deleted Topics
Initial Entry Positive Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepmt. Diff. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Initial Entry Posting Date Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Tax Diff. Transaction No. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Agreement No. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepmt. Diff. in TA Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepayment Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Customer Posting Group Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Initial Entry Positive Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepmt. Diff. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Unapplied Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Customer No. Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Credit Amount (LCY) 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
Entry Type 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 Entry Due Date 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
Initial Entry Global Dim. 1 Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Amount (LCY) Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
Journal Batch Name Field, Detailed Cust. Ledg. Entry Table	Sales and Receivables
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
Entry Type 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
Document Situation Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Document Date Field, Detailed Cust. Ledg. Entry Table	New Zealand 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
Applies-to Bill No. Field, Detailed Cust. Ledg. Entry Table	Spain Local Functionality
Initial Entry Posting Date Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Tax Diff. Transaction No. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Agreement No. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepmt. Diff. in TA Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Bank Receipt Field, Detailed Cust. Ledg. Entry Table	Italy Local Functionality
Bank Receipt Issued Field, Detailed Cust. Ledg. Entry Table	Italy Local Functionality
Prepayment Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Customer Posting Group Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Initial Entry Positive Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality
Prepmt. Diff. Field, Detailed Cust. Ledg. Entry Table	Russia Local Functionality

See Also

Reference

Detailed Cust. Ledg. Entries