Subscription_plans
This table includes information for 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 |
advance_renewal_period_number |
VARCHAR2 |
11 |
|
|
|
|
Together with advance_renewal_period_unit_id field, defines how far in advance NetSuite initiates automatic subscription renewal. |
advance_renewal_period_unit_id |
VARCHAR2 |
10 |
|
|
|
|
Together with advance_renewal_period_number field, defines how far in advance NetSuite initiates automatic subscription renewal. |
class_id |
NUMBER |
|
39 |
0 |
class_id
|
Classes
|
Class ID |
date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
default_renewal_method_id |
VARCHAR2 |
30 |
|
|
|
|
Default renewal method ID |
default_renewal_plan_id |
NUMBER |
|
39 |
0 |
plan_id
|
Subscription_plans
|
Default renewal plan ID |
default_renewal_term_id |
NUMBER |
|
39 |
0 |
term_id
|
Subscription_terms
|
Default renewal term ID |
default_renewal_trantype_id |
VARCHAR2 |
8 |
|
|
|
|
Default renewal transaction type ID |
department_id |
NUMBER |
|
39 |
0 |
department_id
|
Departments
|
Department ID |
description |
VARCHAR2 |
4000 |
|
|
|
|
Description |
display_name |
VARCHAR2 |
4000 |
|
|
|
|
Subscription plan name visible to the customer |
income_account_id |
NUMBER |
|
39 |
0 |
income_account_id
|
Income_accounts
|
Income account ID |
initial_term_id |
NUMBER |
|
39 |
0 |
term_id
|
Subscription_terms
|
Initial subscription term ID |
is_auto_renewal |
VARCHAR2 |
3 |
|
|
|
|
Whether subscription renews automatically |
is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Whether the subscription is inactive |
is_include_children |
VARCHAR2 |
3 |
|
|
|
|
Whether the subscription plan is automatically available to all child subsidiaries of the selected subsidiaries |
location_id |
NUMBER |
|
39 |
0 |
location_id
|
Locations
|
Location ID |
name |
VARCHAR2 |
250 |
|
|
|
|
Name |
plan_extid |
VARCHAR2 |
255 |
|
|
|
|
Plan external ID |
plan_id |
NUMBER |
|
39 |
0 |
|
|
Subscription plan ID |
subsidiary_id |
NUMBER |
|
39 |
0 |
subsidiary_id
|
Subsidiaries
|
Subsidiary ID |
Primary key
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
subscription_plans_classes_fk |
class_id |
Classes |
class_id |
1 |
subscription_plans_departments_fk |
department_id |
Departments |
department_id |
1 |
subscription_plans_income_accounts_fk |
income_account_id |
Income_accounts |
income_account_id |
1 |
subscription_plans_locations_fk |
location_id |
Locations |
location_id |
1 |
subscription_plans_subscription_plans_fk |
default_renewal_plan_id |
Subscription_plans |
plan_id |
1 |
subscription_plans_subscription_terms_fk |
initial_term_id |
Subscription_terms |
term_id |
1 |
subscription_plans_subscription_terms_fk_2 |
default_renewal_term_id |
Subscription_terms |
term_id |
1 |
subscription_plans_subsidiaries_fk |
subsidiary_id |
Subsidiaries |
subsidiary_id |
1 |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Billing_subscriptions_subscription_plans_fk |
plan_id |
Billing_subscriptions |
default_renewal_plan_id |
1 |
Billing_subscriptions_subscription_plans_fk_2 |
plan_id |
Billing_subscriptions |
plan_id |
1 |
Price_books_subscription_plans_fk |
plan_id |
Price_books |
plan_id |
1 |
Subscription_change_orders_subscription_plans_fk |
plan_id |
Subscription_change_orders |
renewal_subscription_plan_id |
1 |
Subscription_plan_lines_subscription_plans_fk |
plan_id |
Subscription_plan_lines |
parent_id |
1 |
Subscription_plans_subscription_plans_fk |
plan_id |
Subscription_plans |
default_renewal_plan_id |
1 |