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