Subscription_change_orders

Columns

Name Type Length Precision Scale References In Description
action_id VARCHAR2 23 Action ID
approval_status_id VARCHAR2 18 Approval Status ID
change_order_extid VARCHAR2 255 Change order external ID
change_order_id NUMBER 39 0 Change order ID
change_order_number VARCHAR2 60 Change order number
date_approval TIMESTAMP Date approved
date_created TIMESTAMP Date created
date_effective TIMESTAMP Effective date
date_last_modified TIMESTAMP Date last modified
date_new_end TIMESTAMP New end date
date_renewal_start TIMESTAMP Renewal start date
memo VARCHAR2 400 Memo. Long messages may be truncated. If you need a longer message, try joining the Message column from the Message table.
reactivation_option_id VARCHAR2 31 Reactivation option ID
renewal_method_id VARCHAR2 30 Renewal method ID
renewal_price_book_id NUMBER 39 0 Renewal price book ID
renewal_subscription_plan_id NUMBER 39 0 plan_id
Subscription_plans
Renewal subscription plan ID
renewal_term_id NUMBER 39 0 term_id
Subscription_terms
Renewal term ID
renewal_transaction_type VARCHAR2 8 Renewal transaction type
requester_id NUMBER 39 0 employee_id
Employees
Requester ID
status_id VARCHAR2 30 Status ID
subscription_id NUMBER 39 0 subscription_id
Billing_subscriptions
Subscription ID

Primary key

PK Column Name
change_order_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
subscription_change_orders_billing_subscriptions_fk subscription_id Billing_subscriptions subscription_id 1
subscription_change_orders_employees_fk requester_id Employees employee_id 1
subscription_change_orders_subscription_plans_fk renewal_subscription_plan_id Subscription_plans plan_id 1
subscription_change_orders_subscription_terms_fk renewal_term_id Subscription_terms term_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Subscription_co_lines_subscription_change_orders_fk change_order_id Subscription_co_lines change_order_id 1
Subscription_line_revisions_subscription_change_orders_fk change_order_id Subscription_line_revisions change_order_id 1