Subscription_plan_lines

Columns

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

Primary key

PK Column Name
plan_line_id

Foreign keys in this table

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

Foreign keys referencing this table

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