View Name:sfa_terr_tm
View Number:5349
Group:Sales Mgr
Description:Displays territor team information. Used by form Accounts (9681, Territory (9680), Hierarchy (9683, Team (9682)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidusr_ter_roleobjidUsr_ter_role internal record number 3 (UNIQUE)
terr_objidterritoryobjidTerritory internal record number 
user_objiduserobjidUser internal record number 
empl_objidemployeeobjidEmployee internal record number 
con_objidcontactobjidContact internal record number 
role_nameusr_ter_rolerole_nameUser's territory team role 
member_nameuserlogin_nameUser's login name 
terr_idterritoryterr_idUser-specified ID number of the territory 
terr_nameterritorynameName of territory for which the employee plays a role 
empl_first_nameemployeefirst_nameIf the user is an employee, the employee's first name 
empl_last_nameemployeelast_nameIf the user is an employee, the employee's last name 
empl_phoneemployeephoneIf the user is an employee, the employee's phone number 
empl_faxemployeefaxIf the user is an employee, the employee's fax number which includes area code, number, and extension 
empl_beeperemployeebeeperIf the user is an employee, the employee's beeper number which includes area code and number 
empl_e_mailemployeee_mailIf the user is an employee, the employee's e-mail address 
con_first_namecontactfirst_nameIf the user is a contact, the contact's first name 
con_last_namecontactlast_nameIf the user is a contact, the contact's last name 
con_phonecontactphoneIf the user is a contact, the contact's phone number 
con_e_mailcontacte_mailThe contact's e-mail address 
con_faxcontactfax_numberThe contact's fax number which includes area code, number, and extension 

Joins:

Join FromJoin To
(usr_ter_role).usr_ter_role2user(user).user2usr_ter_role
(usr_ter_role).user_role2territory(territory).terr2usr_ter_role
OUTER (employee).employee2user(user).user2employee
OUTER (contact).caller2user(user).employees2contact
My Recent Objects
sfa_terr_tm