Subscription_change_orders

Columns

Name	Type	Length	Precision	Scale	References	In	Description
action_id	VARCHAR2	23
approval_status_id	VARCHAR2	18
change_order_extid	VARCHAR2	255
change_order_id	NUMBER		39	0
change_order_number	VARCHAR2	60
date_approval	TIMESTAMP
date_created	TIMESTAMP
date_effective	TIMESTAMP
date_last_modified	TIMESTAMP
date_new_end	TIMESTAMP
date_renewal_start	TIMESTAMP
memo	VARCHAR2	400
reactivation_option_id	VARCHAR2	31
renewal_method_id	VARCHAR2	30
renewal_price_book_id	NUMBER		39	0
renewal_subscription_plan_id	NUMBER		39	0	plan_id	Subscription_plans
renewal_term_id	NUMBER		39	0	term_id	Subscription_terms
renewal_transaction_type	VARCHAR2	8
requester_id	NUMBER		39	0	employee_id	Employees
subscription_id	NUMBER		39	0	subscription_id	Billing_subscriptions

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