select top 10 orderDate, OrderNo, COUNT( distinct mfrSku ) skuCount, SUM( qtySold ) orderQty, SUM( price ) orderTotal from tbl_CDR_Orders where MfrId = and DistributorId = and ownerId = and ownerType = group by OrderDate, OrderNo order by OrderDate desc select datepart( month, orderDate ) orderMonth, datepart( year, orderDate ) orderYear, COUNT( distinct orderNo ) orderCount, count( distinct mfrSku) skuCount, SUM( qtySold ) orderQty, SUM( price ) orderTotal from tbl_CDR_Orders where MfrId = and DistributorId = and ownerId = and ownerType = group by DATEPART( month, OrderDate ), DATEPART( year, OrderDate ) having COUNT( distinct orderNo ) > 0 order by DATEPART( year, OrderDate ) desc, DATEPART( month, OrderDate ) desc select s.sku, s.skuDesc, min( o.orderDate) firstOrderDate, SUM( o.qtySold ) quantity, count( distinct o.orderNo ) orderCount, SUM( o.price ) ordertotal from tbl_CDR_Orders o inner join tbl_PRD_SKUs s on s.sku = o.mfrSku and s.MfrID = o.mfrId and s.OwnerID = o.OwnerId and s.FSL_TableCode = o.ownerType where o.MfrId = and o.DistributorId = and o.OwnerId = and o.ownerType = group by s.sku, s.skuDesc having datediff( day, MIN( o.orderDate ), GETDATE() ) <= 120 order by firstOrderDate desc select * from qmd_stages where stateCode = 'O' select * from qmd_principalResources where principalId = select firstName, lastName, title, email from tbl_FSPro_members where fspro_userid =

#htmleditformat( mfrName )#

#htmleditformat( address )#
#htmleditformat( address2 )#

#city#, #state# #zipcode#

select * from qmd_brokerStaff where fspro_userid =

MFR Contact Name:	#htmleditformat( qmd_principal.primaryContactFirstName )# #htmleditformat( qmd_principal.primaryContactLastName )#unknown
	#htmleditformat( qmd_principal.primaryContactEmail )#email unknown
Market Manager/AE CRM/Sales Mgr. Customer Service :	#htmleditformat( _fullName )# [#htmleditformat( _email )#]

#htmleditformat( cdr_dstname )#

#htmleditformat( cdr_dstaddress1 )#
#htmleditformat( cdr_dstaddress2 )#

#cdr_dstcity#, #cdr_dststate# #cdr_dstzip#

Internal Cust. Nbr:	#htmleditformat( cdr_dstcode )#unknown
Contact for MFR:	#htmleditformat( qmd_mfrContactLookup.firstName )# #htmleditformat( qmd_mfrcontactLookup.lastName )#n/a
	#htmleditformat( qmd_mfrContactLookup.email )#email unknown
MFR Cust. Nbr:	#htmleditformat( qmd_principalResources.mfrCustNbr )#unknown

#_distributorInfoHTML#

#_principalInfoHTML#

Last 10 Orders

Date	Order #	Items	Quantity	Total
#lsDateFormat( orderDate, "MM/DD/YYYY")#	#htmleditformat( orderNo )#	#lsNumberformat( skuCount )#	#lsnumberformat( orderQty )#	#lscurrencyFormat( orderTotal )#
No Order History

Sales Summary

Month	Order Count	SKU Count	Total
#lsDateFormat( createDate( orderYear, orderMonth, 1 ), "MMMM YYYY")#	#lsNumberformat( orderCount )#	#lsnumberformat( skuCount )#	#lscurrencyFormat( orderTotal )#
No Order History

New Stocking in last 120 days

SKU	Description	First Order Date	Order Count	Dollars to Date
#htmleditformat( sku )#	#htmleditformat( skuDesc )#	#lsdateformat( firstOrderDate, "mm/dd/yyyy" )#	#lsnumberformat( orderCount )#	#lscurrencyFormat( orderTotal )#

select * from qmd_opportunities_cdr order by quantityAmt desc

Opportunities with this Distributor

Product	Type	#qmd_mfrUnitOfMeasure.unitOfMeasurePlural#	Dollars	Est. Ord. Date	Likelihood
#htmleditformat( subjectDescription )#	ANNUAL#durationAmt# Weeks	#lsnumberFormat( quantityAmt )#	#lscurrencyformat( incomeAmt )#	#lsdateformat( availableDate, "mm/dd/yy")#	#likelihoodpercent * 100#%
No Open Opportunities

select * from qmd_opportunities_opr order by quantityAmt desc

Operator Opportunities likely to use this Distributor

Product	Operator	Type	#qmd_mfrUnitOfMeasure.unitOfMeasurePlural#	Dollars	Est. Ord. Date	Likelihood
#htmleditformat( subjectDescription )#	#htmleditformat( partnerName )#	ANNUAL#durationAmt# Weeks	#lsnumberFormat( quantityAmt )#	#lscurrencyformat( incomeAmt )#	#lsdateformat( availableDate, "mm/dd/yy" )#	#likelihoodpercent * 100#%
No Open Opportunities

#_css# #_partnerInfoHTML# #_cdrOpportunitiesHTML# #_oprOpportunitiesHTML# #_last10OrdersHTML# #_orderHistorySummaryHTML# #_newSkusHTML# #_css#

#htmlEditFormat( qmd_distributorDetails.cdr_dstname )# / #htmleditformat( qmd_principal.mfrName )# Summary

#htmleditformat( _brokerName )#

#_pageHeaderHTML# #_css#

#lsdateformat( now(), "mm/dd/yyyy" )#

#htmleditformat( clientName )#

Page #cfdocument.currentPageNumber# of #cfdocument.totalPageCount#

#_contentHTML# #_pageHeaderHTML# #_css#

#lsdateformat( now(), "mm/dd/yyyy" )#

#htmleditformat( _brokerName )#

#cfdocument.currentPageNumber# of #cfdocument.totalPageCount#

#_contentHTML#