View Name:sp_rol_site_rol_contact
View Number:5738
Group:Billing Manager
Description:Used in 16205,16210,16215,16225
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
con_sp_role_objidcon_sp_roleobjidCon_sp_role internal record number 3 (UNIQUE)
contact_role_objidcontact_roleobjidContact role internal record number 
con_objidcontactobjidContact internal record number 
loc_objidsiteobjidSite internal record number 
sp_objidsite_partobjidSite_part internal record number 
instance_namesite_partinstance_nameDefault is the concatination of part name, part number, and part revision. May be customized 
serial_nosite_partserial_noInstalled part serial number 
con_sp_role_namecon_sp_rolerole_nameRole name of contact 
level_to_binsite_partlevel_to_binRelative level to a bin 
level_to_partsite_partlevel_to_partRelative installation hierarchy level to a part 
first_namecontactfirst_nameContact first name 
last_namecontactlast_nameContact last name 
phonecontactphoneContact phone number which includes area code, number, and extension 
e_mailcontacte_mailContact e-mail address 
mobile_phonecontactmobile_phoneContact mobile phone number which includes area code, number, and extension 
contact_role_namecontact_rolerole_nameRole name of contact 
site_namesitenameSite name 

Joins:

Join FromJoin To
(contact_role).contact_role2site(site).site2contact_role
(contact_role).contact_role2contact(contact).contact2contact_role
(bus_org).primary2site(site).primary_site2bus_org
(con_sp_role).con_sp_role2contact(contact).contact2con_sp_role
(con_sp_role).con_sp_role2site_part(site_part).site_part2con_sp_role
My Recent Objects
sp_rol_site_rol_contact