SELECT GroupName, GroupID FROM #request.applicationFslDSN#.dbo.tbl_SEC_Groups WHERE (GroupTypeCD = 'MPR') OR (OwnerID = AND FSL_TableCode = AND BrokerRole = ) ORDER BY GroupName; select distinct mems.OwnerID from #request.applicationFslDSN#.dbo.tbl_FSPro_Members mems inner join #request.applicationFslDSN#.dbo.tbl_sec_memgrplink smg on smg.FSPro_UserID = mems.FSPro_UserID inner join #request.applicationFslDSN#.dbo.tbl_SEC_Groups sec on sec.GroupID = smg.GroupID and sec.GroupID in ( ) where mems.FSPro_UserID =

SELECT sku, ptValue, bonusPts AS multiUnitPts, bonusPtsApproved AS multiUnitPtsApproved, preOct15bonusPts AS earlyBirdPts, preOct15bonusPtsApproved AS earlyBirdPtsApproved, focusProductBonusPts, focusProductBonusPtsApproved, LTO, LTObonusPts, LTObonusPtsApproved, menuPermanently, menuPermanentlyBonusPts, menuPermanentlyBonusPtsApproved FROM tbl_HRSY_BroRew_SelectedSKUs WHERE submissionid = *"> " & trim(qmd_getSelectedSKUs.sku) & ""> --->

Submission Date

Submission Type

Region #

Broker #

Broker Name

BSR Name

Operator Name

Operator # Units

Operator Segment

Operator Address

Operator Contact Name

Operator Phone #

Distributor Name and No.

Date of Sales Call

Date of Shipment

Product Code(s)

Points Earned (DST Placment)

Points Approved (DST Placment)

Points Earned (LTO Placment)

Points Approved (LTO Placment)

Points Earned (Perm. Menu Placment)

Points Approved (Perm. Menu Placment)

Points Earned (Product Placment)

Points Approved (Product Placment)

Focus Product Bonus Points

Focus Product Bonus Points Approved

Multi Unit Points

Multi Unit Points Approved

Total Approved Points

#variables.submitDate#

#qmd_slctBRWsubmissions.submissionType#

#trim(qmd_slctBRWsubmissions.regnum)#

#trim(qmd_slctBRWsubmissions.brokernum)#

#trim(qmd_slctBRWsubmissions.brokername)#

#variables.column_05#

#trim(qmd_slctBRWsubmissions.opr_CompanyName)#

#trim(qmd_slctBRWsubmissions.numLocations)#1

#trim(qmd_slctBRWsubmissions.opr_Segment)#

#variables.oprAddy#

#variables.contactName#

#variables.column_10#

#variables.column_11#

#dateformat(qmd_slctBRWsubmissions.dateofsalescall,"mm/dd/yy")#

#dateformat(qmd_slctBRWsubmissions.dateofshipment,"mm/dd/yy")#

#removechars(variables.skuDisplay,1,1)#

#variables.ptsEarned#0

#variables.ptsApproved#0

#variables.LTOpts#

#variables.LTOptsApproved#

#variables.permMenuPts#

#variables.permMenuPtsApproved#

#variables.ptsEarned#

#variables.ptsApproved#

#variables.focusProductPts#

#variables.focusProductPtsApproved#

#variables.multiUnitPts#

#variables.multiUnitPtsApproved#

#variables.ttlApprovedPts#

BSR Total

#variables.column_05#

#variables.ttl_bsrPts#

#variables.ttl_bsrPtsApproved#

#variables.ttl_bsrPtsLTOBonusPts#

#variables.ttl_bsrPtsLTOBonusPtsApproved#

#variables.ttl_bsrPtsPermMenuBonusPts#

#variables.ttl_bsrPtsPermMenuBonusPtsApproved#

#variables.ttl_bsrPts#

#variables.ttl_bsrPtsApproved#

#variables.ttl_bsrPtsFocusPrdsBonusPts#

#variables.ttl_bsrPtsFocusPrdsBonusPtsApproved#

#variables.ttl_bsrPtsMultiUnitPts#

#variables.ttl_bsrPtsMultiUnitPtsApproved#

#val(variables.ttl_bsrTotalPtsApproved)#

Broker Total

#trim(qmd_slctBRWsubmissions.brokernum)#

#trim(qmd_slctBRWsubmissions.brokername)#

#variables.ttl_brokerPts#

#variables.ttl_brokerPtsApproved#

#variables.ttl_brokerPtsLTOBonusPts#

#variables.ttl_brokerPtsLTOBonusPtsApproved#

#variables.ttl_brokerPtsPermMenuBonusPts#

#variables.ttl_brokerPtsPermMenuBonusPtsApproved#

#variables.ttl_brokerPts#

#variables.ttl_brokerPtsApproved#

#variables.ttl_brokerPtsFocusPrdsBonusPts#

#variables.ttl_brokerPtsFocusPrdsBonusPtsApproved#

#variables.ttl_brokerPtsMultiUnitPts#

#variables.ttl_brokerPtsMultiUnitPtsApproved#

#val(variables.ttl_brokerTotalPtsApproved)#

Region Total

#trim(qmd_slctBRWsubmissions.regnum)#

#variables.ttl_regionPts#

#variables.ttl_regionPtsApproved#

#variables.ttl_regionPtsLTOBonusPts#

#variables.ttl_regionPtsLTOBonusPtsApproved#

#variables.ttl_regionPtsPermMenuBonusPts#

#variables.ttl_regionPtsPermMenuBonusPtsApproved#

#variables.ttl_regionPts#

#variables.ttl_regionPtsApproved#

#variables.ttl_regionPtsFocusPrdsBonusPts#

#variables.ttl_regionPtsFocusPrdsBonusPtsApproved#

#variables.ttl_regionPtsMultiUnitPts#

#variables.ttl_regionPtsMultiUnitPtsApproved#

#val(variables.ttl_regionTotalPtsApproved)#

* Submissions awaiting approval