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