View Name:contrconpart
View Number:5192
Group:Sales Mgr
Description:View to display all contacts where a part is quoted. Used by form Select Contact by Quoted Part (9661) and Select Contact Installed Part (9662)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontr_itmobjidLead_source internal record number 3 (UNIQUE)
con_objidcontactobjidContact's first name 
first_namecontactfirst_nameContact's first name 
last_namecontactlast_nameContact's last name 
contr_idcontractidID number of the quick quote 
part_numpart_numpart_numberPart number/name 
part_descriptionpart_numdescriptionDescription of the product 
quantitycontr_itmquantityQuantity quoted 
pricecontr_itmnet_prcQuoted price of the product 
create_datecontractcreate_dtThe create date of the quote 
expire_datecontractexpire_dateThe expiration date of the quote 
issue_datecontractq_issue_dtThe issue date of the quote 
part_familypart_numfamilyMarketing product family the part belongs 
part_linepart_numlineMarketing product line, within family, of the part 

Joins:

Join FromJoin To
(contract).primary2contact(contact).primary2contract
(contr_schedule).schedule2contract(contract).contract2contr_schedule
(contr_itm).contr_itm2contr_schedule(contr_schedule).schedule2contr_itm
(contr_itm).contr_itm2mod_level(mod_level).part_info2contr_itm
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
contrconpart