Table Name:	opp_qstn
Table Number:	5086
Group:	Sales Mgr
Description:	Analysis questions for Opportunities
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_opp_qstn

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
answer	CHAR	varchar		255			Text of the answer to the question
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			DIRECT	Internal record number
poss_answer	CHAR	varchar		255			Text of possible answers to the question
question	CHAR	varchar		80			Text of the question
seq_num	LONG	smallint				DIRECT	Sequence number of the question
status	CHAR	varchar		30			Question status. This is from a user-defined popup

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
opp_qstn2opportunity	MTO	opportunity	opp2opp_qstn	Related opportunity

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
opp_qstn_ind	opp_qstn2opportunity:seq_num	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_opp_qstn2opportunity	opp_qstn2opportunity	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
opp_qstn_ind	opp_qstn2opportunity, seq_num	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

opp_qstn

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user