Subscription_plans

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