Table Name:	dialogue
Table Number:	5200
Group:	Mixed Media
Description:	Records a series of communications which comprise a dialogue
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_dialogue

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
creation_time	CLK_TIME	datetime	1				Date and time the dialogue was created	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
id_number	CHAR	varchar	4	40			Unique dialogue number assigned based on auto-numbering definition	Search (3)
last_update	CLK_TIME	datetime					Date and time the dialogue was modified
objid	LONG	int	3			DIRECT	Internal record number	Search (5)
title	CHAR	varchar	2	255			Dialogue title or subject	Search (4)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
dialogue2communication	OTM	communication	communication2dialogue	Communications which comprise the dialogue
dialogue2condition	OTOP	condition	condition2dialogue	The condition of the dialogue			Search (3)
dialogue_sts2gbst_elm	MTO	gbst_elm	dialogue_sts2dialogue	Status of the dialogue			Search (3)
dialogue_pty2gbst_elm	MTO	gbst_elm	dialogue_pty2dialogue	Priority of the dialogue			Search (3)
dialogue_currq2queue	MTO	queue	currq2dialogue	The queue to which the dialogue is dispatched			Search (1)
dialogue_prevq2queue	MTO	queue	prevq2dialogue	The queue from which the dialogue was accepted; for temporary accept
dialogue2r_rqst	OTM	r_rqst	r_rqst2dialogue	Routing request for which the dialogue is the subject				route_for	source_type	source_lowid
dialogue2reject_msg	OTM	reject_msg	reject_msg2dialogue	Reasons the dialogue was rejected
dialogue2status_chg	OTM	status_chg	status_chg2dialogue	Status changes for the dialogue
dialogue2topic	OTM	topic	topic2dialogue	Dialogue related to this topic				interaction_for	focus_type	focus_lowid
dialogue_orig2user	MTO	user	originator2dialogue	The user who originated the dialogue
dialogue_owner2user	MTO	user	curr_owner2dialogue	The user who owns the dialogue			Search (1)
dialogue_wip2wipbin	MTO	wipbin	wipbin2dialogue	The WIPbin containing the dialogue			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
dialogue_ind	id_number	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
d2c5200	dialogue2condition, dialogue_pty2gbst_elm, dialogue_sts2gbst_elm, dialogue_owner2user	nonclustered located on PRIMARY
dialogue_ind	id_number	nonclustered, unique located on PRIMARY
do2u5200	dialogue_owner2user	nonclustered located on PRIMARY
dw2w5200	dialogue_wip2wipbin, objid	nonclustered, unique located on PRIMARY
ind_creation_time	creation_time, last_update	nonclustered located on PRIMARY
ind_dialogue_currq2queue	dialogue_currq2queue, objid	nonclustered, unique located on PRIMARY
ind_last_update	last_update	nonclustered located on PRIMARY
ind_title	title	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5319	wipelm_dlg	condition, dialogue, gbst_elm, wipbin
5329	queelm_dlg	condition, dialogue, gbst_elm, queue
5377	dlg_cmcn	channel, communication, dialogue, medium
5397	select_dialog	condition, dialogue, gbst_elm, user
5449	eaddr_cmcn	communication, dialogue, e_addr, edr_com_role

My Recent Objects

dialogue

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user