select firstname, lastname from tbl_fspro_members where fspro_userid = select firstname, lastname from tbl_fspro_members where fspro_userid = --->
Promotion Request Detail
select cdr_dstName, cdr_dstCity, cdr_dstState, cdr_dstCode, cdr_recordId, cdr_dstAddress1 from tbl_CDR_Distributors where ownerId= and fsl_tablecode = and cdr_recordId in ( ) and nullif( cdr_dstcode, '' ) is not null order by cdr_dstName
Status #replace(qmd_requests.status,"DRAFT","SET UP")#
Account #partnername#
#partnername#
Contact #qryContact.firstname# #qryContact.lastname#
Contract Num #qmd_requests.assignedContractNbr#
Contract Type #qmd_requestTypes.requestType#
Begin Date #dateformat(qmd_requests.startdate,"mm/dd/yyyy")#
End Date #dateformat(qmd_requests.enddate,"mm/dd/yyyy")#
Payable To OperatorDistributor
Billing/Pay Freq MonthlyQuarterly
Distributors
#htmleditformat( cdr_dstName )#
#htmleditformat( cdr_dstAddress1 )#
 #htmleditformat( cdr_dstCity)# #htmleditformat( cdr_dstState )#
Customer Num: #htmleditformat( cdr_dstCode )#
Products
#htmleditformat( qmd_product.code )# #htmleditformat( qmd_product.description )#
Case Wt #qmd_weightValue.netWeight# LBS
UOM #UOM# @ $#lsnumberformat( _pricePerLb, "0.00" )#$#lsnumberformat( _pricePerCase, "0.00" )#
Allowance #htmleditformat( allowanceAmt )#
Fixed #htmleditformat( fixedAmt )#
Est Annual Vol #estAnnualVolume# caseslbs