| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| advance_renewal_period_number | NUMBER | 39 | 0 | ||||
| advance_renewal_period_unit_id | VARCHAR2 | 10 | |||||
| amount | NUMBER | 35 | 15 | ||||
| billing_account_id | NUMBER | 39 | 0 |
billing_account_id |
Billing_accounts |
||
| currency | VARCHAR2 | 4 | |||||
| date_created | TIMESTAMP | ||||||
| date_end | TIMESTAMP | ||||||
| date_estimated_revrec_end | TIMESTAMP | ||||||
| date_last_modified | TIMESTAMP | ||||||
| date_start | TIMESTAMP | ||||||
| default_renewal_method_id | VARCHAR2 | 30 | |||||
| default_renewal_plan_id | NUMBER | 39 | 0 |
plan_id |
Subscription_plans |
||
| default_renewal_price_book_id | NUMBER | 39 | 0 | ||||
| default_renewal_term_id | NUMBER | 39 | 0 |
term_id |
Subscription_terms |
||
| default_renewal_trantype_id | VARCHAR2 | 8 | |||||
| description | VARCHAR2 | 400 | |||||
| generate_modification_elements | VARCHAR2 | 3 | |||||
| initial_term_id | NUMBER | 39 | 0 |
term_id |
Subscription_terms |
||
| is_auto_renewal | VARCHAR2 | 3 | |||||
| is_sub_start_date_as_rsd | VARCHAR2 | 3 | |||||
| name | VARCHAR2 | 220 | |||||
| plan_id | NUMBER | 39 | 0 |
plan_id |
Subscription_plans |
||
| price_book_id | NUMBER | 39 | 0 | ||||
| sales_order_id | NUMBER | 39 | 0 |
transaction_id |
Transactions |
||
| subscription_extid | VARCHAR2 | 255 | |||||
| subscription_id | NUMBER | 39 | 0 | ||||
| subscription_number | VARCHAR2 | 220 | |||||
| subscription_revision | NUMBER | 39 | 0 |
| PK Column Name |
|---|
| subscription_id |
| 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_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_transactions_fk | sales_order_id | Transactions | transaction_id | 1 |
| 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 |