#qcfAccountDetails.companyname#
#qcfAccountDetails.address#
#qcfAccountDetails.address2#
#qcfAccountDetails.city# #trim(qcfAccountDetails.state)#, #qcfAccountDetails.zipcode#
#qcfAccountDetails.phone#
#qcfAccountDetails.url#

#qcfAccountDetails.cdr_dstname#
#qcfAccountDetails.cdr_dstaddress1#
#qcfAccountDetails.cdr_dstaddress2#
#qcfAccountDetails.cdr_dstcity# #trim(qcfAccountDetails.cdr_dststate)#, #qcfAccountDetails.cdr_dstzip#
#qcfAccountDetails.cdr_dstPhone#

#qcf_acctAdditionalInfo.dsturl#

1FS RECOMMENDED

CONTACTS

AGREEMENTS

STOCKING GUIDE

PURCHASING

select ownerid as mfrId, cdr_recordid from tbl_cdr_distributors cdr where fsl_dstid = and ownerid in () and ownerid in () and fsl_tablecode = 'mfr' and crmActive = 'y' and fsl_dstid > 0

MFR SALES DATA VIEWER

sales data not available for this distributor

ORDER HISTORY

ITEM HISTORY

SALES CALLS

Add New Call

OPPORTUNITIES

PURCHASING PROFILE

select ownerid as mfrId, operatorid from tbl_opr_clientoperators opr with (nolock) where fsl_choid = and ownerid in () and ownerid in () and fsltablecode = 'mfr' and crmActive = 'y' and fsl_choid > 0 and exists ( select * from tbl_opr_productStatus with (nolock) where ownerid = opr.ownerid and ownertype = opr.fsltablecode and operatorid = opr.operatorid and confirmedVolumeDate is not null )

MFR PURCHASING DATA VIEWER

purchasing data not available for this operator

TRADE PROMOTION

LOCATIONS

COMPETITIVE INTEL

MEMBERS

BRANCHES

OPERATORS

TASKS

Add New Task

FILES

NOTES

PHOTOS

Attach Photo

UNITS

select count(*) ttl from tbl_opr_availableequipment where ownerid = and ownertype =