Table Name:	flex_tmpl
Table Number:	5803
Group:	Flexible Attributes
Description:	Defines templates for flexible attributes
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_flex_tmpl

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
condition	CHAR	varchar		1300			A condition that determines if the template is active
description	CHAR	varchar		255			A user supplied description of the template
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
tmpl_name	CHAR	varchar		255			The user supplied name of the template	Search (1)
tmpl_type	LONG	tinyint				DIRECT, ALLOW_NULL	A flag describing if or in what way this template is a direct relation	Search (1)
type_id	LONG	int				DIRECT	The object type for which this template applies	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
flex_tmpl2flex_defn	MTM	flex_defn	flex_defn2flex_tmpl	Flexible attribute definitions for a flexible attribute template		mtm_flex_defn0_ flex_tmpl0
flex_tmpl2mod_level	MTM	mod_level	mod_level2flex_tmpl	Part version using a flexible attribute template by a direct relations		mtm_mod_level53_ flex_tmpl1	Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
5858	prod_dest_attr_tmpl_view	flex_tmpl, mod_level

My Recent Objects

flex_tmpl

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user