Revisions to a subscription line.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
change_order_id | NUMBER | 39 | 0 |
change_order_id |
Subscription_change_orders |
ID of the Change Order that triggered the revision | |
created_by | VARCHAR2 | 167 | Who created the revision | ||||
date_change_order_effective | TIMESTAMP | Effective date of change order that triggered the revision | |||||
date_created | TIMESTAMP | Date of revision | |||||
date_last_modified | TIMESTAMP | Date revision was last modified | |||||
delta_amount | NUMBER | 26 | 8 | Change in amount since last revision | |||
delta_quantity | NUMBER | 18 | 8 | Change in quantity since last revision | |||
discount | NUMBER | 39 | 0 | Initial subscription line discount, or new discount of revised subscription line | |||
is_applied_to_change_order | VARCHAR2 | 3 | Whether revision is from a subscription line unchecked in a change order | ||||
is_created_from_void | VARCHAR2 | 3 | Whether revision results from voided change order | ||||
is_discount_percentage | VARCHAR2 | 3 | Whether the discount is a percentage | ||||
is_overage_discount_percentage | VARCHAR2 | 3 | Whether the overage discount is a percentage | ||||
overage_discount | NUMBER | 39 | 0 | Initial overage discount of subscription line, or new overage discount of revised subscription line | |||
overage_price_plan_id | NUMBER | 39 | 0 |
price_plan_id |
Price_plans |
Initial overage price plan of subscription line, or new overage price plan of revised subscription line | |
price_plan_id | NUMBER | 39 | 0 |
price_plan_id |
Price_plans |
Initial price plan of subscription line, or new price plan of revised subscription line | |
quantity | NUMBER | 39 | 0 | Initial subscription line quantity, or new quantity of revised subscription line | |||
recurring_amount | NUMBER | 39 | 0 | Initial recurring amount of subscription line, or new recurring amount of revised subscription line | |||
revenue_element_id | NUMBER | 39 | 0 |
revenue_element_id |
Revenue_elements |
Revenue element associated with revision when updated version has usage, or with subscription line | |
subscription_line_id | NUMBER | 39 | 0 |
subline_id |
Billing_subscription_lines |
ID of line revision | |
subscription_revision | NUMBER | 39 | 0 | Line revision number | |||
total_contract_value | NUMBER | 26 | 8 | Change in total contract value since last revision |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
subscription_line_revisions_billing_subscription_lines_fk | subscription_line_id | Billing_subscription_lines | subline_id | 1 |
subscription_line_revisions_price_plans_fk | price_plan_id | Price_plans | price_plan_id | 1 |
subscription_line_revisions_price_plans_fk_2 | overage_price_plan_id | Price_plans | price_plan_id | 1 |
subscription_line_revisions_revenue_elements_fk | revenue_element_id | Revenue_elements | revenue_element_id | 1 |
subscription_line_revisions_subscription_change_orders_fk | change_order_id | Subscription_change_orders | change_order_id | 1 |