SETTLEMENT RULE HISTORY Table
View exposing historical settlement rules for cost collectors by validity fiscal periods, including settlement type, receiver attributes, percentages, transaction identifiers, and company code used for audit and time-based analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPANY_CODE |
Company code associated with the settlement rule. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Identifier for the cost collector associated with the settlement rule history. |
VARCHAR2 |
12 |
FISCAL_PERIOD_FIRST_USE |
First fiscal period in which the settlement rule is used. |
VARCHAR2 |
6 |
FISCAL_PERIOD_LAST_USE |
Last fiscal period in which the settlement rule is used. |
VARCHAR2 |
6 |
SETTLEMENT_PERCENT |
Percentage used to allocate settlement to the receiver. |
NUMBER |
18,2 |
SETTLEMENT_RECEIVER_CODE |
Business code identifying the settlement receiver. |
VARCHAR2 |
17 |
SETTLEMENT_RECEIVER_DESC |
Description of the settlement receiver. |
VARCHAR2 |
50 |
SETTLEMENT_RECEIVER_KEY |
Identifier for the settlement receiver. |
VARCHAR2 |
17 |
SETTLEMENT_RECEIVER_TYPE |
Receiver type for the settlement, such as cost center, internal order, or WBS element. |
VARCHAR2 |
20 |
SETTLEMENT_TRANSACTION |
Code identifying the settlement transaction type. |
VARCHAR2 |
4 |
SETTLEMENT_TYPE |
Description of the settlement type code. |
VARCHAR2 |
30 |
SETTLEMENT_TYPE_CODE |
Code identifying the settlement type. |
VARCHAR2 |
3 |
VALID_FROM_FISCAL_PERIOD |
Fiscal period from which the settlement rule is valid. |
VARCHAR2 |
6 |
VALID_THRU_FISCAL_PERIOD |
Fiscal period through which the settlement rule is valid. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |