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