Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
billing_mode_id | VARCHAR2 | 32 | Billing mode ID | ||||
is_prorate_end_date | VARCHAR2 | 3 | Whether the end date proration is enabled | ||||
is_prorate_start_date | VARCHAR2 | 3 | Whether the start date proration is enabled | ||||
is_required | VARCHAR2 | 3 | When line item is required | ||||
item_id | NUMBER | 39 | 0 |
item_id |
Items |
Item ID | |
parent_id | NUMBER | 39 | 0 |
plan_id |
Subscription_plans |
Subscription plan ID | |
plan_line_id | NUMBER | 39 | 0 | Subscription plan line ID | |||
plan_line_number | NUMBER | 39 | 0 | Subscription plan line number | |||
plan_line_type | VARCHAR2 | 50 | Subscription plan line type | ||||
renewal_option | VARCHAR2 | 14 | Subscription plan renewal option | ||||
revenue_recognition_option_id | VARCHAR2 | 30 | Renewal recognition option ID | ||||
usage_multiplier_line_id | NUMBER | 39 | 0 |
plan_line_id |
Subscription_plan_lines |
Usage multiplier line ID |
PK Column Name |
---|
plan_line_id |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
subscription_plan_lines_items_fk | item_id | Items | item_id | 1 |
subscription_plan_lines_subscription_plan_lines_fk | usage_multiplier_line_id | Subscription_plan_lines | plan_line_id | 1 |
subscription_plan_lines_subscription_plans_fk | parent_id | Subscription_plans | plan_id | 1 |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Billing_subscription_lines_subscription_plan_lines_fk | plan_line_id | Billing_subscription_lines | subscription_plan_line_id | 1 |
Price_book_line_intervals_subscription_plan_lines_fk | plan_line_id | Price_book_line_intervals | plan_line_id | 1 |
Price_book_line_intervals_subscription_plan_lines_fk_2 | plan_line_id | Price_book_line_intervals | usage_multiplier_line_id | 1 |
Subscript_line_price_intervals_subscription_plan_lines_fk | plan_line_id | Subscript_line_price_intervals | plan_line_id | 1 |
Subscription_plan_lines_subscription_plan_lines_fk | plan_line_id | Subscription_plan_lines | usage_multiplier_line_id | 1 |