View Name:act_vw
View Number:5706
Group:Sales Mgr
Description:Used by act_hist_list.jsp JSP page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_act_vw
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidact_entryobjidUnique object ID number 3 (UNIQUE)
entry_timeact_entryentry_timeActivity log entry time 1
act_codeact_entryact_codeActivity code 10
addnl_infoact_entryaddnl_infoAdditional information such as notes 11
drillin_typeact_entryfocus_typeObject type ID of the default drill down object for the event 
drillin_objidact_entryfocus_lowidInternal record number of the default drill down object for the event 
login_nameuserlogin_nameLogin name of user that made activity log entry 12
act_namegbst_elmtitleName of activity 2
user_objiduserobjidUser internal record number of the user that made activity log entry 
gbst_elm_objidgbst_elmobjidGbst_elm internal record number 
add_infoact_entryaddnl_infoAdditional information such as notes 

Joins:

Join FromJoin To
(act_entry).act_entry2user(user).originator2act_entry
(act_entry).entry_name2gbst_elm(gbst_elm).act_name2act_entry
My Recent Objects
act_vw      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user