View Name:task_con
View Number:5077
Group:Sales Mgr
Description:Used by forms Incoming Call (9580), Action Items (9620), Contact (11401), Recent Interactions (11403), Contact History (11404) and Customer interaction (11400)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidtaskobjidTask internal record number 3 (UNIQUE)
idtasktask_idTask ID 
titletasktitleTitle of the task 
due_datetaskdue_dateDue date of the task 
start_datetaskstart_dateStart date of the task 
comp_datetaskcomp_dateActual completion date of the task 
statusgbst_stat(gbst_elm)titleStatus of the task 
prioritygbst_pri(gbst_elm)titlePriority of the task 
tas_typegbst_type(gbst_elm)titleType of the task 
login_nameuserlogin_nameLogin name of the user 
user_objiduserobjidUser-owner internal record number 
opp_objidopportunityobjidOpportunity internal record number 
opp_idopportunityidID of the opportunity 
opp_nameopportunitynameTitle of the opportunity 
cond_titleconditiontitleTitle of the condition 
first_namecontactfirst_namefirst name of the contact 
last_namecontactlast_namelast name of the contact 
contact_objidcontactobjidContact internal record number 
cond_objidconditionobjidCondition internal record number 
bus_org_objidbus_orgobjidBus_org internal record number 
bus_org_namebus_orgnameName of bus_org 
phonecontactphonephone of the contact 
e_mailcontacte_maile-mail of the contact 
priority_objidgbst_pri(gbst_elm)objidPriority internal record number 
status_objidgbst_stat(gbst_elm)objidStatus internal record number 
tas_type_objidgbst_type(gbst_elm)objidTask type internal record number 

Joins:

Join FromJoin To
(task).task_sts2gbst_elmgbst_stat(gbst_elm).status2task
(task).task_priority2gbst_elmgbst_pri(gbst_elm).priority2task
(task).type_task2gbst_elmgbst_type(gbst_elm).type_task2task
(task).task_owner2user(user).owner2task
(task).task_state2conditionOUTER (condition).task_condition2task
(task).task_for2bus_orgOUTER (bus_org).receiver_org2task
(task).task2contactOUTER (contact).primary_contact2task
(task).sm_task2opportunityOUTER (opportunity).opp_task2task
My Recent Objects
task_con