Subscription_terms

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