select interactiondate, fsp.firstname as repfirst, fsp.lastname as replast, fsp2.firstname as contactfirst, fsp2.lastname as contactlast, int.disposition, intdst.cdr_dstname as distname, cdrname.cdr_dstname as cdrname, oprname.companyname as oprname, fsp.fspro_userid as repid, fsp2.fspro_userid as contactid, int.notes from tbl_crm_interactions int left outer join tbl_fspro_members fsp on fsp.fspro_userid = int.dispositionuserid left outer join tbl_fspro_members fsp2 on int.contactid = fsp2.fspro_userid left outer join tbl_cdr_distributors intdst on intdst.cdr_recordid = int.cdrDistributorid left outer join tbl_opr_clientoperators oprname on oprname.operatorid = int.partnerid and int.partnertype = 'opr' left outer join tbl_cdr_distributors cdrname on cdrname.cdr_recordid = int.partnerid and int.partnertype in ('cdr','dst') where int.ownerid = and int.ownertype = and int.interactionid =
  
Sales Call Detail:
Call DateTBD#dateformat(qcfInteractionInfo.interactiondate,"mmmm d, yyyy")#
#daysAgoDisplay#
Sales Rep#qcfInteractionInfo.repfirst# #qcfInteractionInfo.replast#
Call StatusPLANNEDCompleted
Contact#qcfInteractionInfo.contactfirst# #qcfInteractionInfo.contactlast#
Distributor#qcfInteractionInfo.distname#
Notes#qcfInteractionInfo.notes#
Item Presentations
Mfr#mfrname#
Item#sku# #description# #packsize#
Item#sku# #description# #packsize#
Status#_statusDisp#
Comment#comment#
Customer Signature: