Revenue_plan_versions
This table includes data only after the original revenue recognition plan has been edited. It includes the version number of each previous plan, the date of change, and the name of the user who made the change.
Important: This table's data is available only when the Advanced Revenue Management feature is enabled in the account.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
created_by_id |
NUMBER |
|
39 |
0 |
employee_id
|
Employees
|
The ID of the user who made the change that triggered the revenue plan version |
date_created |
TIMESTAMP |
|
|
|
|
|
Date stamp for the edit that triggered the version |
plan_id |
NUMBER |
|
39 |
0 |
plan_id
|
Revenue_plans
|
ID of the revenue plan that the version belongs to |
plan_version |
NUMBER |
|
39 |
0 |
|
|
Link to the previous version of the revenue plan |
plan_version_id |
NUMBER |
|
39 |
0 |
|
|
ID of the version record |
Primary key
PK Column Name |
plan_version_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
revenue_plan_versions_employees_fk |
created_by_id |
Employees |
employee_id |
1 |
revenue_plan_versions_revenue_plans_fk |
plan_id |
Revenue_plans |
plan_id |
1 |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Revenue_plan_version_lines_revenue_plan_versions_fk |
plan_version_id |
Revenue_plan_version_lines |
plan_version_id |
1 |