View Name:c_install_part
View Number:5097
Group:Sales Mgr
Description:Used in service pricing by forms Select Installed Part (9145), Select Part Number (9146), Select Part Number (SFA version) (9669) and Account (11650)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
site_part_objidsite_partobjidInstalled part internal record nubmer 3 (UNIQUE)
site_objidsiteobjidSite internal record number 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
site_namesitenamesite name 
serial_nosite_partserial_noInstalled part serial number 
warranty_endsite_partwarranty_dateInstalled part warranty ending date 
part_num_objidpart_numobjidGeneric part internal record number 
part_numberpart_numpart_numberGeneric part number/name 
part_descpart_numdescriptionGeneric part description 
part_domainpart_numdomainName of the domain for the part num. See object prt_domain 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
mod_level_objidmod_levelobjidPart revision internal record number 
mod_levelmod_levelmod_levelName of the part revision 
activemod_levelactivePart revision status; i.e., Active/inactive/obsolete 
part_linepart_numlineMarketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm 
part_familypart_numfamilyMarketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm 
part_typepart_numpart_typeUser-defined pop up to denote a part type separate from the domain 
part_statuspart_numactiveGeneric part status; i.e., active/inactive/obsolete 
p_standalonepart_nump_standaloneIndicates whether the part MAY receive standalone pricing; i.e. 0=no, 1=yes, default=0 
p_as_parentpart_nump_as_parentIndicates whether the part MAY be priced with options under it; i.e. 0=no, 1=yes, default=0 
p_as_childpart_nump_as_childIndicates whether the part MAY be priced as an option; i.e. 0=no, 1=yes, default=0 
install_datesite_partinstall_datePart installation date 
is_sppt_progpart_numis_sppt_progIndicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature 
site_part_qtysite_partquantityInstalled part quantity; equal to 1 for serialized parts 
mod_eff_dtmod_leveleff_dateThe date the support program version becomes effective 
mod_exp_dtmod_levelend_dateThe date the support program version expires 
sn_trackpart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial number 

Joins:

Join FromJoin To
(mod_level).part_info2part_num(part_num).part_num2mod_level
(site_part).site_part2part_info(mod_level).part_info2site_part
(site_part).all_site_part2site(site).site2all_site_part
My Recent Objects
c_install_part