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 |
PK Column Name |
---|
term_id |
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 |