View Name:pmhpml_view
View Number:112
Group:Product Mgr
Description:Joins part revison with its part number and part class; used by forms 329,381, 411, 412, 414, 415, 420, 421, 422, 502, 503, 613, 643, 680, 8100, and 8102
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidmod_levelobjidPart revision internal record number 3 (UNIQUE)
namepart_classnameA unique name for the part class 
familypart_numfamilyMarketing product family the part 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_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
part_typepart_numpart_typeUser-defined pop up to denote a part type separate from the domain 
activemod_levelactiveActive/inactive/obsolete 
pmh_objidpart_classobjidPart class internal record number 
descriptionpart_numdescriptionMaps to sales and mfg systems 
quantitypart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial number 
partnum_objidpart_numobjidPart num internal record number 
part_activepart_numactiveActive/inactive/obsolete 
domainpart_numdomainName of the domain for the part num 
std_warrantypart_numstd_warrantyDefines length of standard warranty for part 
dom_is_servicepart_numdom_is_serviceIndicates the part is a service part; i.e., 0=not a service, 1=a service 
warr_start_keypart_numwarr_start_keyIndicates whether warranty starts from shipment or installation 
part_litpart_numx_literatureIndicates location of literature for part 
x_ml_modify_stmpmod_levelx_modify_stmpThe date and time when mod level change fields were last updated 
x_pn_modify_stmppart_numx_modify_stmpThe date and time when part_number change fields were last updated 

Joins:

Join FromJoin To
(part_num).part_num2part_class(part_class).part_class2part_num
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
pmhpml_view