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
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 |