Table Name:	order_action
Table Number:	5768
Group:	Morder
Description:	Ordering activity for an order to stream line post order capture process
Flags:	CACHEOBJIDS, ALLOW_FLEX
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_order_action

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action_date	CLK_TIME	datetime					The date the action should take place. Default is current time
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
last_service_status	CHAR	varchar		40			The status of the affected service before this action was performed on it. Populated through a user defined popup list
last_subscription_status	CHAR	varchar		40			The status of the affected subscription before this action was performed on it. Populated through a user defined popup list
last_update	CLK_TIME	datetime	46				Date time of last update
name	CHAR	varchar		40			Name of action for presentation of order	Search (3)
objid	LONG	int	3			DIRECT	Internal record number	Search (8)
reason	CHAR	varchar		40			The reason for the action. Required by external systems. Populated through a user defined popup list
status	CHAR	varchar		40			The status of the order_action

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
order_action2blg_argmnt	MTO	blg_argmnt	blg_argmnt2order_action	The billing arrangement to cover this service
order_action2bus_org	MTO	bus_org	bus_org2order_action	Account that will be used for billing purposes
order_action2contact	MTO	contact	contact2order_action	Contact to be used for this order action			Search (2)
order_action2contract	MTO	contract	contract2order_action	Order header for order			Search (9)
order_action2fa_order_action	OTM	fa_order_action	fa_order_action2order_action
order_action2fr_agrmnt	MTO	fr_agrmnt	fr_agrmnt2order_action	The framework agreement covering this action
order_action2offering	MTO	offering	offering2order_action	The offering related to the order action
order_action2order_line	OTM	order_line	order_line2order_action	The products / services ordered, lost or changed as part of this action
order_action2order_shipping	MTO	order_shipping	order_shipping2order_action	Shipping location for order action parts			Search (2)
order_action2part_action	MTO	part_action	part_action2order_action	Action definition for order action			Search (1)
order_action2pp_bucket	MTO	pp_bucket	pp_bucket2order_action	The pre-paid to covering this service
order_action2site	MTO	site	site2order_action	Site that will be used for installation of order_action parts
order_action_svc2site_part	MTO	site_part	site_part_svc2order_action	The existing site_part affected by the action			Search (1)
order_action_bus2site_part	MTO	site_part	bus_site_part2order_action	The top level account level product affected by this order action
order_action_subs2site_part	MTO	site_part	site_part_subs2order_action	The top level part (subscription) that the action affects

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
oa2c5768	order_action2contact	nonclustered located on PRIMARY
oa2ct5768	order_action2contract	nonclustered located on PRIMARY
oa2os5768	order_action2order_shipping	nonclustered located on PRIMARY
oa2pa5768	order_action2part_action	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5796	order_shipping_view	address, contact, contract, country, order_action, order_shipping, site
5798	sp_order_line_actions_v	contract, order_action, order_line, site_part
5801	sp_order_actions_v	contract, order_action, site_part
5807	order_line_v	contract, mod_level, offr_prod, order_action, order_line, price_qty
5856	order_line_parts_v	contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty
6031	sp_orders_v	bus_org, condition, contact, contract, gbst_elm, order_action, order_line, site_part
6032	order_line_view	contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty
6055	order_shipping_vw	address, contract, country, order_action, order_shipping, site

My Recent Objects

order_action

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user