View Name:sp_role_sp
View Number:5143
Group:Product Mgr
Description:Report for site_part role to site_part. Used by forms Service Part (624) and Service Details (626) and Related Hardware (627)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidconnect_part(site_part)objidInternal record number 3 (UNIQUE)
pmlobjidmod_levelobjidInternal record number 
namepart_numdescriptionMaps to sales and manufacturing systems 
familypart_numfamilyMarketing product family the user belongs to; new user-defined pop up replaces relation to gbst_elm 
linepart_numlineMarketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm 
part_typepart_numdomainUser-defined type of part 
prd_inst_nameconnect_part(site_part)instance_namePart name 
activemod_levelactiveActive/inactive/obsolete 
pmh_objidpart_numobjidInternal record number 
serial_noconnect_part(site_part)serial_noPart serial number 
invoice_noconnect_part(site_part)invoice_noPart invoice number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
site_namesitenameSite name 
sn_trackpart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial num ber 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
site_objidsiteobjidInternal record number 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
cityaddresscityThe city for the specified address 
stateaddressstateThe state for the specified address 
inst_objidconnect_part(site_part)inst_objidObjid of parent installed part in the installed part's BOM. Zero if the part is not a child part 
svc_part_objidservice_part(site_part)objidObjid of service part serving this site_part 
role_nameprt_prt_rolerole_nameServicing role 
role_objidprt_prt_roleobjidServicing role objid 

Joins:

Join FromJoin To
connect_part(site_part).site_part2part_info(mod_level).part_info2site_part
connect_part(site_part).all_site_part2site(site).site2all_site_part
(site).cust_primaddr2address(address).primary_addr2site
(mod_level).part_info2part_num(part_num).part_num2mod_level
(prt_prt_role).role_for2site_partservice_part(site_part).role_for2prt_prt_role
(prt_prt_role).player2site_partconnect_part(site_part).player2prt_prt_role
My Recent Objects
sp_role_sp