Table Name:	ce_clause
Table Number:	4313
Group:	fcQuery
Description:	A clause for a specific query
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_ce_clause

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			USER_DEFINED, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			USER_DEFINED	Internal record number
operation	CHAR	varchar		30		USER_DEFINED	Clause operation
parameterized	LONG	int				USER_DEFINED	Is the query clause parameterized (=1), or not (=0)
rank	LONG	int				USER_DEFINED	Order of query clause
value	CHAR	varchar		255		USER_DEFINED	Default Clause value

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
ce_clause2ce_col	MTO	ce_col	ce_col2ce_clause	The column for this clause	USER_DEFINED
ce_clause2ce_param	OTM	ce_param	ce_param2ce_clause	The parameters for this clause	USER_DEFINED
ce_clause2ce_query	MTO	ce_query	ce_query2ce_clause	The query this clause is in	USER_DEFINED

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

My Recent Objects

ce_clause

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user