Subscription_terms

This table includes term information for subscriptions. The table's data is available only for accounts with the SuiteBilling feature enabled.

Columns

Name Type Length Precision Scale References In Description
duration NUMBER 39 0 Together with unit_id field, defines the length of the subscription term.
is_inactive VARCHAR2 3 Whether the subscription term is inactive
name VARCHAR2 200 Subscription term name
term_extid VARCHAR2 255 Subscription term external ID
term_id NUMBER 39 0 Subscription term ID
term_type_id VARCHAR2 10 Subscription term type ID
unit_id VARCHAR2 10 Together with duration field, defines the length of the subscription term

Primary key

PK Column Name
term_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Billing_subscriptions_subscription_terms_fk term_id Billing_subscriptions default_renewal_term_id 1
Billing_subscriptions_subscription_terms_fk_2 term_id Billing_subscriptions initial_term_id 1
Subscription_change_orders_subscription_terms_fk term_id Subscription_change_orders renewal_term_id 1
Subscription_plans_subscription_terms_fk term_id Subscription_plans initial_term_id 1
Subscription_plans_subscription_terms_fk_2 term_id Subscription_plans default_renewal_term_id 1