View Name:sp_bus_con_view
View Number:5871
Group:Billing Manager
Description:This view is required to Subscription Search Results List screen
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_sp_bus_con_view
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
role_objidcon_sp_roleobjidInternal record number for con_sp_role 3 (UNIQUE)
role_namecon_sp_rolerole_nameName of the role 
sp_objidsite_partobjidSite_part Internal record number 
serial_nosite_partserial_noInstalled part serial number 
bus_org_namebus_orgnameName of the organization 
con_objidcontactobjidContact Internal record number 
con_first_namecontactfirst_nameContact's first name 
con_last_namecontactlast_nameContact's last name 
con_phonecontactphoneContact's phone number which includes area code, number, and extension 
bus_org_objidbus_orgobjidBus_org internal record number 
sub_namesite_partinstance_nameDefault is the concatination of part name, part number, and part revision. May be customized 

Joins:

Join FromJoin To
(con_sp_role).con_sp_role2contact(contact).contact2con_sp_role
(con_sp_role).con_sp_role2site_part(site_part).site_part2con_sp_role
(site_part).site_part2site(site).customer2site_part
(site).primary2bus_org(bus_org).primary_org2site
My Recent Objects
sp_bus_con_view      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user