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, int.partnerid, int.partnertype, int.cdrDistributorid 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
Account #qcfInteractionInfo.oprname##qcfInteractionInfo.cdrname# #qcfInteractionInfo.oprname##qcfInteractionInfo.cdrname#
Call Date TBD #dateformat(qcfInteractionInfo.interactiondate,"mmm d, yyyy")#
#daysAgoDisplay#
Call Status PlannedCompleted
Sales Rep #qcfInteractionInfo.repfirst# #qcfInteractionInfo.replast#
Contact #qcfInteractionInfo.contactfirst# #qcfInteractionInfo.contactlast#
Distributor #qcfInteractionInfo.distname#
Notes
#qcfInteractionInfo.notes#
Item Presentations
Add Item
Mfr #mfrname#
Item #sku# #description# #packsize#
Item #sku# #description# #packsize#
Status #_statusDisp#
Note #comment#