View Name:addrsitepmhpml2
View Number:5652
Group:Support
Description:Do not customize
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsite_partobjidInternal record number 3 (UNIQUE)
site_objidsiteobjidInternal record number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
part_typepart_numdomainUser-defined type of part 
serial_nosite_partserial_noPart serial number 
site_namesitenameSite name 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
level_to_partsite_partlevel_to_partRelative installation hierarchy level to a part 
mod_objidmod_levelobjidMod_level internal record number 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
descriptionpart_numdescriptionDescription of the product 
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, default=0 
partnum_objidpart_numobjidPart_num internal record number 
devsite_partdevRow version number for mobile distribution purposes 

Joins:

Join FromJoin To
(site_part).site_part2part_info(mod_level).part_info2site_part
(site_part).all_site_part2site(site).site2all_site_part
(site).cust_primaddr2address(address).primary_addr2site
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
addrsitepmhpml2