View Name:catprod
View Number:147
Group:Product Mgr
Description:Joins part revision to its part number and catalog
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidmod_levelobjidPart revision internal record number 3 (UNIQUE)
descriptionpart_numdescriptionMaps to sales and mfg systems 
part_nopart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
domainpart_numdomainName of the domain for the part num 
pmh_objidpart_numobjidPart num internal record number 
activemod_levelactiveActive/inactive/obsolete 
cat_objidcatalogobjidCatalog internal record number 
linepart_numlineMarketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm 
familypart_numfamilyMarketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm 
dom_is_servicepart_numdom_is_serviceIndicates the part is a service part, if selected, sit_prt_role will be set when installed; i.e., 0=not a service, 1=a service 

Joins:

Join FromJoin To
(mod_level).part_info2part_num(part_num).part_num2mod_level
(mod_level).part_info2catalog(catalog).catalog2part_info
My Recent Objects
catprod