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

PK Column Name
plan_id

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