SETTLEMENT RULE CURRENT Table
View exposing current settlement rules for cost collectors, including settlement type, receiver attributes, percentages, validity fiscal periods, and company code used for controlling and allocation processing.
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. |
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 |
RECORD_COUNTER |
Counter indicating record sequencing or versioning. |
NUMBER |
|
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_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 |