Table Name:	part_action
Table Number:	5766
Group:	Morder
Description:	A list of actions that can be performed on products
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_part_action

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
is_no_vldn_reqd	LONG	tinyint			0	DIRECT, ALLOW_NULL	Indicates that the affected product does not have to have a relation to the action to perform the action. If not set the action can only be performed on products that have a relation to the action. (Default = 0)
is_svc_reqd	LONG	smallint			0	DIRECT, ALLOW_NULL	Indicates that the action requires an affected installed part or a previously selected offering for it to be performed on. 0=no selection required, 1=installed product required, 2=previously selected offering required; Default=0
last_update	CLK_TIME	datetime	46				Date time of last update
name	CHAR	varchar		40			Name of action	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
part_action2mod_level	MTM	mod_level	mod_level2part_action	Parts for which this action is valid		mtm_mod_level52_ part_action0	Search (1)
part_action2order_action	OTM	order_action	order_action2part_action	Orders using this action

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I5766	name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
I5766	name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5787	order_modify_v	contact, contract, order_line, part_action, part_num
5810	partaction_mod_view	mod_level, part_action

My Recent Objects

part_action

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user