View Name:ai2oltsk_apt
View Number:5232
Group:Sales Mgr
Description:Used by form PIM Preference (9624) for Outlook integration
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 
task_notestasknotesNotes about the task 
statusgbst_stat(gbst_elm)titleStatus of the task 
status_rankgbst_stat(gbst_elm)rankRank order of the status in its list 
prioritygbst_pri(gbst_elm)titlePriority of the task 
priority_rankgbst_pri(gbst_elm)rankRank order of the priority in its list 
login_nameuserlogin_nameLogin name of the user 
user_objiduserobjidUser-owner internal record number 
first_namecontactfirst_nameFirst name of the contact 
last_namecontactlast_nameLast name of the contact 
contact_objidcontactobjidContact internal record number 
status_objidgbst_stat(gbst_elm)objidStaus internal record number 
priority_objidgbst_pri(gbst_elm)objidPriority internal record number 
condition_objidconditionobjidCondition internal record number 
condition_titleconditiontitleTitle of the condition 
task_desc_objidtask_descobjidTask description internal record number 
descriptiontask_descdescriptionDescription of or comments on a task 

Joins:

Join FromJoin To
(task).task_sts2gbst_elmgbst_stat(gbst_elm).status2task
(task).task_priority2gbst_elmgbst_pri(gbst_elm).priority2task
(task).task_owner2user(user).owner2task
(task).task2contactOUTER (contact).primary_contact2task
(task).task_state2condition(condition).task_condition2task
(task).task2task_descOUTER (task_desc).task_desc2task
My Recent Objects
ai2oltsk_apt