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 |
PK Column Name |
---|
plan_id |
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 |
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 |