View Name:svc_role_svc_view
View Number:9881
Group:Process Manager
Description:Report for site_part role to site_part. Used by forms Service Part (624) and Service Details (626) and Related Servcies (50102)
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 
dom_is_servicepart_numdom_is_serviceDomain is Service 
mod_levelmod_levelmod_levelRevision level 
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 
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
(mod_level).part_info2part_num(part_num).part_num2mod_level
(prt_prt_role).role_for2site_partservice_part(site_part).role_for2prt_prt_role
connect_part(site_part).site_part2part_info(mod_level).part_info2site_part
(prt_prt_role).player2site_partconnect_part(site_part).player2prt_prt_role
My Recent Objects
svc_role_svc_view