Table Name:	notes_log
Table Number:	27
Group:	Workflow Mgr
Description:	Object which contains notes logged to a queueable object; e.g., case, opportunity, change request, etc
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_notes_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 Note Log Action Type	Search (1)
commitment	CHAR	varchar	42	80			Title of commitment made during the activity. This is a user-defined popup with default name COMMITMENT	Search (1)
creation_time	CLK_TIME	datetime	1				Date and time the notes log entry was created	Search (1)
description	CHAR	text	23			ALLOW_NULL	Text of the note	Search (1)
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 on the notes log is due
internal	CHAR	varchar	33	255			For-internal-use-only text	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
x_is_internal	LONG	int				USER_DEFINED	Internal note log indicator
x_rating	LONG	int				USER_DEFINED	Rating / Score that goes along with the note. Used for solution comments/notes.

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
notes_log2act_entry	OTM	act_entry	act_entry2notes_log	Activity log entries for the notes log
bug_notes2bug	MTO	bug	bug_notes2notes_log	Related change request
notes_log2bug_desc	OTOF	bug	bug_desc2notes_log	Change request description stored in notes object through the relation
case_notes2case	MTO	case	case_notes2notes_log	Related case
notes_log2contact	MTO	contact	contact2notes_log		USER_DEFINED
contr_notes2contract	MTO	contract	contr_notes2notes_log	Related contract
old_notes_stat2gbst_elm	MTO	gbst_elm	old_cas_stat2notes_log	Old status prior to changes made for the activity
new_notes_stat2gbst_elm	MTO	gbst_elm	new_cas_stat2notes_log	New status based on changes made in the activity
notes_log2interact	MTO	interact	interact2notes_log	Note Logs for the interaction	USER_DEFINED
job_notes2job	MTO	job	job_notes2notes_log	Related job
opp_notes2opportunity	MTO	opportunity	opp_notes2notes_log	Reserved; not used
notes_log2probdesc	MTO	probdesc	probdesc2notes_log		USER_DEFINED
qq_notes2quick_quote	MTO	quick_quote	q_quote2notes_log	Related quick quote
site_notes2site	MTO	site	site2notes_log		USER_DEFINED
subc_notes2subcase	MTO	subcase	subc_notes2notes_log	Related subcase
task_notes2task	MTO	task	task2notes_log	Related task			Search (1)
notes_owner2user	MTO	user	originator2notes_log	User that created notes log			Search (1)
notes_log2user_touch	OTM	user_touch	user_touch2notes_log	Last user touches for the notes_log				touched_by	source_type	source_lowid

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_bug_notes2bug	bug_notes2bug, objid	nonclustered, unique located on PRIMARY
ind_case_notes2case	case_notes2case, objid	nonclustered, unique located on PRIMARY
ind_notes_owner2user	notes_owner2user, objid	nonclustered located on PRIMARY
ind_opp_notes2opportunity	opp_notes2opportunity, objid	nonclustered, unique located on PRIMARY
ind_subc_notes2subcase	subc_notes2subcase, objid	nonclustered, unique located on PRIMARY
ind_task_notes2task	task_notes2task, objid	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4624	fc_acct_notes_view	act_entry, gbst_elm, notes_log, participant, user
5106	nlog_actitm	notes_log, task, user

My Recent Objects

notes_log

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user