View Name:acct_team
View Number:254
Group:Resource Mgr
Description:Displays account team members. Used by Account Team Form (8504)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
role_namebus_empl_rolerole_nameName of the account team role 
first_nameemployeefirst_nameEmployee's first name 
last_nameemployeelast_nameEmployee's last name 
site_idsiteobjidSite internal record number 
login_nameuserlogin_nameUser login name 
phoneemployeephoneEmployee's phone number 
faxemployeefaxEmployee's fax number which includes area code, number, and extension 
beeperemployeebeeperEmployee's beeper number which includes area code and number 
e_mailemployeee_mailEmployee's e-mail address 
org_idbus_orgorg_idID of bus org for which the employee plays a role 
org_namebus_orgnameName of bus org for which the employee plays a role 
role_objidbus_empl_roleobjidInternal record number of the employee's business role 3 (UNIQUE)

Joins:

Join FromJoin To
(employee).employee2user(user).user2employee
(employee).supp_person_off2site(site).support_off2employee
(bus_empl_role).bus_empl_role2employee(employee).empl2bus_empl_role
(bus_empl_role).bus_empl_role2bus_org(bus_org).org2bus_empl_role
My Recent Objects
acct_team