Billing_subscriptions
This table is available only for accounts with the SuiteBilling feature enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
advance_renewal_period_number |
NUMBER |
|
39 |
0 |
|
|
Number of periods in advance the auto-renewal is attempted |
advance_renewal_period_unit_id |
VARCHAR2 |
10 |
|
|
|
|
Unit ID of the advance renewal period |
amount |
NUMBER |
|
35 |
15 |
|
|
Total amount of the subscription |
billing_account_id |
NUMBER |
|
39 |
0 |
billing_account_id
|
Billing_accounts
|
Billing account ID associated with the subscription |
class_id |
NUMBER |
|
39 |
0 |
class_id
|
Classes
|
Class ID |
currency |
VARCHAR2 |
4 |
|
|
|
|
Currency |
customer_id |
NUMBER |
|
39 |
0 |
customer_id
|
Customers
|
Customer ID |
date_created |
TIMESTAMP |
|
|
|
|
|
Date subscription was created |
date_end |
TIMESTAMP |
|
|
|
|
|
Date subscription ends |
date_estimated_revrec_end |
TIMESTAMP |
|
|
|
|
|
For Evergreen subscriptions, date Revenue Recognition software uses to calculate the revenue to recognize |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date subscription last modified |
date_start |
TIMESTAMP |
|
|
|
|
|
Start date |
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_price_book_id |
NUMBER |
|
39 |
0 |
|
|
Default renewal price book 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 ID |
department_id |
NUMBER |
|
39 |
0 |
department_id
|
Departments
|
Department ID |
description |
VARCHAR2 |
400 |
|
|
|
|
Description of subscription |
generate_modification_elements |
VARCHAR2 |
3 |
|
|
|
|
Whether to generate modification elements |
initial_term_id |
NUMBER |
|
39 |
0 |
term_id
|
Subscription_terms
|
Initial term ID |
is_auto_renewal |
VARCHAR2 |
3 |
|
|
|
|
Whether the subscription will auto-renew |
is_sub_start_date_as_rsd |
VARCHAR2 |
3 |
|
|
|
|
Whether to use the start date as the recurrence start date |
location_id |
NUMBER |
|
39 |
0 |
location_id
|
Locations
|
Location ID |
name |
VARCHAR2 |
220 |
|
|
|
|
Subscription name |
plan_id |
NUMBER |
|
39 |
0 |
plan_id
|
Subscription_plans
|
Price plan ID |
price_book_id |
NUMBER |
|
39 |
0 |
|
|
Price book ID |
sales_order_id |
NUMBER |
|
39 |
0 |
transaction_id
|
Transactions
|
Sales order ID |
subscription_extid |
VARCHAR2 |
255 |
|
|
|
|
External ID |
subscription_id |
NUMBER |
|
39 |
0 |
|
|
Subscription ID |
subscription_number |
VARCHAR2 |
220 |
|
|
|
|
Number of the subscription |
subscription_revision |
NUMBER |
|
39 |
0 |
|
|
Number of revisions |
subscription_status |
VARCHAR2 |
25 |
|
|
|
|
Subscription status |
subsidiary_id |
NUMBER |
|
39 |
0 |
subsidiary_id
|
Subsidiaries
|
Subsidiary ID |
Primary key
PK Column Name |
subscription_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
billing_subscriptions_billing_accounts_fk |
billing_account_id |
Billing_accounts |
billing_account_id |
1 |
billing_subscriptions_classes_fk |
class_id |
Classes |
class_id |
1 |
billing_subscriptions_customers_fk |
customer_id |
Customers |
customer_id |
1 |
billing_subscriptions_departments_fk |
department_id |
Departments |
department_id |
1 |
billing_subscriptions_locations_fk |
location_id |
Locations |
location_id |
1 |
billing_subscriptions_subscription_plans_fk |
default_renewal_plan_id |
Subscription_plans |
plan_id |
1 |
billing_subscriptions_subscription_plans_fk_2 |
plan_id |
Subscription_plans |
plan_id |
1 |
billing_subscriptions_subscription_terms_fk |
default_renewal_term_id |
Subscription_terms |
term_id |
1 |
billing_subscriptions_subscription_terms_fk_2 |
initial_term_id |
Subscription_terms |
term_id |
1 |
billing_subscriptions_subsidiaries_fk |
subsidiary_id |
Subsidiaries |
subsidiary_id |
1 |
billing_subscriptions_transactions_fk |
sales_order_id |
Transactions |
transaction_id |
1 |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Billing_subscription_lines_billing_subscriptions_fk |
subscription_id |
Billing_subscription_lines |
subscription_id |
1 |
Subscription_change_orders_billing_subscriptions_fk |
subscription_id |
Subscription_change_orders |
subscription_id |
1 |
Subscription_co_lines_billing_subscriptions_fk |
subscription_id |
Subscription_co_lines |
subscription_id |
1 |