View Name:sfa_acct_tm
View Number:5348
Group:Sales Mgr
Description:Displays account team members. Used by forms Account Manager (11650), Console-Sales (12000)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidusr_bus_roleobjidUsr_bus_role internal record number 3 (UNIQUE)
acct_objidbus_orgobjidBus_org internal record number 
user_objiduserobjidUser internal record number 
empl_objidemployeeobjidEmployee internal record number 
con_objidcontactobjidContact internal record number 
role_nameusr_bus_rolerole_nameUser's account team role 
member_nameuserlogin_nameUser's login name 
acct_idbus_orgorg_idID of bus org for which the employee plays a role 
acct_namebus_orgnameName of bus org for which the employee plays a role 
empl_first_nameemployeefirst_nameEmployee's first name 
empl_last_nameemployeelast_nameEmployee's last name 
empl_phoneemployeephoneEmployee's phone number 
empl_faxemployeefaxEmployee's fax number which includes area code, number, and extension 
empl_beeperemployeebeeperEmployee's beeper number which includes area code and number 
empl_e_mailemployeee_mailEmployee's e-mail address 
con_first_namecontactfirst_nameContact's first name 
con_last_namecontactlast_nameContact's last name 
con_phonecontactphoneContact's phone number 
con_e_mailcontacte_mailContact's primary e-mail address 
empl_titleemployeetitleEmployee's professional title 
empl_salutationemployeesalutationEmployee's form of address; e.g., Mr., Miss, Mrs 
con_titlecontacttitleContact's professional title 
con_salutationcontactsalutationContact's form of address; e.g., Mr., Miss, Mrs 

Joins:

Join FromJoin To
(usr_bus_role).usr_bus_role2user(user).user2usr_bus_role
(usr_bus_role).usr_bus_role2bus_org(bus_org).bus_org2usr_bus_role
OUTER (employee).employee2user(user).user2employee
OUTER (contact).caller2user(user).employees2contact
My Recent Objects
sfa_acct_tm