Revenue_recognition_rules
Important: This table’s data is available only to the accounts that have Advanced Revenue Management enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
amount_source |
VARCHAR2 |
150 |
|
|
|
|
How the amount is derived |
date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
end_date_change_impact |
VARCHAR2 |
150 |
|
|
|
|
How the rules are updated when the end date changes |
end_date_source |
VARCHAR2 |
150 |
|
|
|
|
The source of the default end date |
initial_amount |
VARCHAR2 |
42 |
|
|
|
|
Initial amount |
name |
VARCHAR2 |
99 |
|
|
|
|
Name |
period_offset |
NUMBER |
|
39 |
0 |
|
|
Periods to postpone the start of revenue recognition plan; the plan end date is also postponed |
recognition_period |
NUMBER |
|
39 |
0 |
|
|
The number of periods to include in plans based on the rule |
reforecast_method |
VARCHAR2 |
150 |
|
|
|
|
Reforecast method |
rev_rec_rule_id |
NUMBER |
|
39 |
0 |
|
|
Revenue recognition rule ID |
rule_method |
VARCHAR2 |
150 |
|
|
|
|
Rule method |
start_date_source |
VARCHAR2 |
150 |
|
|
|
|
The source of the start date |
start_offset |
NUMBER |
|
39 |
0 |
|
|
Periods to postpone the start of revenue recognition, while keeping the end date |
term_in_days |
NUMBER |
|
39 |
0 |
|
|
Term in days |
term_in_months |
NUMBER |
|
39 |
0 |
|
|
The number of months from the start date to include in plans based on the rule. |
Primary key
PK Column Name |
rev_rec_rule_id |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Revenue_plans_revenue_recognition_rules_fk |
rev_rec_rule_id |
Revenue_plans |
rev_rec_rule_id |
1 |