Subscription_plan_lines
This table includes subscription plan lines, which are subrecords of subscription plans. The table's data is available only for accounts with the SuiteBilling feature enabled.
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