Table Name:	email_log
Table Number:	154
Group:	Workflow Mgr
Description:	Email object for recording emails sent for a queueable object; e.g., bug, case, or subcase
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_email_log

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action_type	CHAR	varchar	49	40			Action type for the log: This is a user-defined pop up with default name Mail Log Action Type	Search (1)
cc_list	CHAR	varchar		255			Email addresses for those copied on the email message	Search (1)
commitment	CHAR	varchar	42	80			Title of commitment made during the activity. This is a user-defined popup with default name COMMITMENT
creation_time	CLK_TIME	datetime	1				The date and time the email_log activity began
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
due_date	CLK_TIME	datetime	43				Date and time commitment made in the email log is due
message	CHAR	text	23			ALLOW_NULL	Email message text	Search (1)
objid	LONG	int	3			DIRECT	Internal record number
recipient	CHAR	varchar		255			Email addresse(s) for recipient(s) of email	Search (1)
sender	CHAR	varchar		255			User name of originator of email message	Search (1)
stop_time	CLK_TIME	datetime	6				Date and time email log activity was completed
x_del_recpt	LONG	int				USER_DEFINED	delivery receipt requested
x_id	CHAR	varchar		1000		USER_DEFINED	Message Id of email message
x_internal_use	LONG	int				USER_DEFINED	Internal Use Only
x_read_recpt	LONG	int				USER_DEFINED	read receipt requested
x_subject	CHAR	varchar		255		USER_DEFINED		Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
email_log2act_entry	OTM	act_entry	act_entry2email_log	Related activity log entry
bug_email2bug	MTO	bug	bug_email2email_log	Related change request
case_email2case	MTO	case	case_email2email_log	Case for the email log entry
cont_email2contact	MTO	contact	contact2email_log	Contact for the email log entry
contr_email2contract	MTO	contract	contr_email2email_log	Contract for the email log entry
email_log2doc_inst	OTM	doc_inst	doc_inst2email_log	Attachments to the email
email_log2recipients	OTOP	email_recipients	recipients2email_log		USER_DEFINED
email_log2cc_list	OTOP	email_recipients	cc_list2email_log		USER_DEFINED
email_log2bcc_list	OTOP	email_recipients	bcc_list2email_log		USER_DEFINED
email_log2employee	MTO	employee	employee2email_log		USER_DEFINED
old_email_stat2gbst_elm	MTO	gbst_elm	old_cas_stat2email_log	Case status before the email log entry
new_email_stat2gbst_elm	MTO	gbst_elm	new_cas_stat2email_log	Case status after the email log entry
opp_email2opportunity	MTO	opportunity	opp_email2email_log	Opportunity for the email log entry
subc_email2subcase	MTO	subcase	subc_email2email_log	Subcase for the email log entry
task_email2task	MTO	task	task_email2email_log	Task for the email log entry

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_bug_email2bug	bug_email2bug	nonclustered located on PRIMARY
ind_case_email2case	case_email2case	nonclustered located on PRIMARY
ind_cont_email2contact	cont_email2contact	nonclustered located on PRIMARY
ind_contr_email2contract	contr_email2contract	nonclustered located on PRIMARY
ind_contr_email2opportunity	opp_email2opportunity	nonclustered located on PRIMARY
ind_subc_email2subcase	subc_email2subcase	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4626	fc_acct_email_view	act_entry, email_log, gbst_elm, participant, user

My Recent Objects

email_log

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user