View Name:spart_site_srole
View Number:5298
Group:ClearSupport
Description:View provider site and xref information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_spart_site_srole
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
site_objidsiteobjidSite internal record number 
spart_objidsite_partobjidSite_part internal record number 
objidsit_prt_roleobjidSit_prt_role internal record number 3 (UNIQUE)
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
site_namesitenameSite name 
serial_nosite_partserial_noInstalled part serial number 
instance_namesite_partinstance_nameDefault is the concatination of part name, part number, and part revision. May be customized 
role_namesit_prt_rolerole_nameName of the role. This is a user-defined popup with default name SERVICE_ROLE 
xref_idsit_prt_rolevendor_part_noVendor's part number 

Joins:

Join FromJoin To
(sit_prt_role).prt_role2site(site).site2sit_prt_role
(sit_prt_role).prt_role2site_part(site_part).part2sit_prt_role
My Recent Objects
spart_site_srole      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user