View Name:addrsitepmhpml
View Number:304
Group:Product Mgr
Description:Report for which the parameter set is used. Used by form Select [Installed Parts (689), Contact Quoted (9661), Contact Installed (9662), Contact (9663), Contact for Campaign (9664), Contact by Industry (9667)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsite_partobjidInternal record number 3 (UNIQUE)
pmlobjidmod_levelobjidInternal record number 
namepart_numdescriptionMaps to sales and manufacturing 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_numdomainUser-defined type of part 
prd_inst_namesite_partinstance_namePart name 
activemod_levelactiveActive/inactive/obsolete 
pmh_objidpart_numobjidInternal record number 
serial_nosite_partserial_noPart serial number 
invoice_nosite_partinvoice_noPart invoice number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
site_namesitenameSite name 
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 
site_objidsiteobjidInternal record number 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
cityaddresscityThe city for the specified address 
stateaddressstateThe state for the specified address 
inst_objidsite_partinst_objidObjid of parent installed part in the installed part's BOM. Zero if the part is not a child part 
x_res1part_numx_res1Data Restriction field 
x_res2part_numx_res2Data Restriction field 
x_res3part_numx_res3Data Restriction field 
x_res4part_numx_res4Data Restriction field 
x_res5part_numx_res5Data Restriction field 

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
addrsitepmhpml