CLEARING DATA Table
View exposing clearing attributes for financial document line items, including customer and vendor references, clearing activity, dunning information, and company code used for financial reconciliation and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLEARING_DATE |
Date on which the financial document line item was cleared through a clearing transaction. |
DATE |
|
CLEARING_DOCUMENT_NUMBER |
Identifier of the financial document used to clear the original document line item. |
VARCHAR2 |
10 |
COMPANY_CODE |
Financial company code under which the document was posted. |
VARCHAR2 |
4 |
CUSTOMER_KEY |
Identifier of the customer associated with the financial document line item when applicable. |
VARCHAR2 |
11 |
DOCUMENT_LINE_ITEM |
Line item number within the financial document. |
NUMBER |
|
DOCUMENT_NUMBER |
Identifier of the original financial document containing the line item. |
VARCHAR2 |
10 |
DUNNING_AREA_KEY |
Identifier of the dunning area responsible for managing collections for the item. |
VARCHAR2 |
7 |
LAST_DUNNED_DATE |
Most recent date on which a dunning action was performed for the outstanding item. |
DATE |
|
VENDOR_KEY |
Identifier of the vendor associated with the financial document line item when applicable. |
VARCHAR2 |
11 |