View Name:oa_prt_prt_view
View Number:9880
Group:Process Manager
Description:Report for site_part role to site_part Used by CreateQuote API
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 manufa cturing 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_numpart_typeUser-defined type of part 
domainpart_numdomainName of the domain for the part num 
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 
instance_idconnect_part(site_part)instance_idPart serial number 
invoice_noconnect_part(site_part)invoice_noPart invoice number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
sn_trackpart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial number 
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 
config_typemod_levelconfig_typeDeclares Configurator constraints for the part: i.e., 0=not to be configured, 1=configure as a product, 2=configure as an option, default=0 
part_statusconnect_part(site_part)part_statusSite Configuration installed part status. This is a user-defined popup with default name PART_STATUS 

Joins:

Join FromJoin To
(prt_prt_role).role_for2site_partservice_part(site_part).role_for2prt_prt_role
(prt_prt_role).player2site_partconnect_part(site_part).player2prt_prt_role
(mod_level).part_info2part_num(part_num).part_num2mod_level
connect_part(site_part).site_part2part_info(mod_level).part_info2site_part
My Recent Objects
oa_prt_prt_view