select fspro_userId from tbl_FSPRO_members m where staffMember = 1 and loginEnabled = 1 and (( fsl_tablecode = 'MFR' and ownerId = 26 ) or ( fsl_tablecode = 'BRO' and ownerId in ( select brokerId from tbl_SMA_BrokerOfficeLink where mfr_id = 26 ))) and email = select cdr.cdr_recordId, cdr.cdr_dstName, cdr.cdr_dstCode, ter.territoryId, ter.name territoryName, ter.internalSalesId from tbl_CDR_Distributors cdr inner join tbl_CDR_DstCodes cdrd on cdrd.cdr_recordId = cdr.cdr_recordId inner join tbl_TER_territories ter on ter.territoryId = cdr.cdr_territoryId where cdr.ownerId = 26 and cdr.fsl_tablecode = 'MFR' and cdrd.cdr_dstCode =

Distributor is #qmd_distributor.cdr_dstCode# #qmd_distributor.cdr_dstName# in #qmd_distributor.territoryName#

select ter.territoryId, ter.name territoryName, lvl.levelId, lvl.name levelName, lvl.zipCodeMapping from tbl_TER_Territories ter inner join tbl_TER_TerritoryLevels lvl on lvl.levelId = ter.levelId and lvl.ownerId = ter.ownerId and lvl.fsl_tablecode = ter.fsl_tablecode where ter.ownerId = 26 and ter.fsl_tablecode = 'MFR' and ter.territoryid = select skuId, sku, skuDesc, salesAreaId from tbl_PRD_Skus where ownerId = 26 and fsl_tablecode = 'MFR' and sku =

SKUs is #qmd_sku.sku# #qmd_sku.skuDesc#

select salesAreaId, salesAreaName from tbl_SLS_SalesAreas where salesAreaId =

Sales Area is #qmd_salesArea.salesAreaName#

select ter.territoryId, ter.name territoryName, lvl.levelId, lvl.name levelName, lvl.zipCodeMapping from tbl_TER_Territories ter inner join tbl_TER_TerritoryLevels lvl on lvl.levelId = ter.levelId and lvl.ownerId = ter.ownerId and lvl.fsl_tablecode = ter.fsl_tablecode inner join tbl_SLS_SalesAreaTerritories sat on sat.territoryId = ter.territoryId where ter.ownerId = 26 and ter.fsl_tablecode = 'MFR' and sat.cdr_recordId = and sat.salesAreaId = and sat.salesAreaId <> 0 and sat.cdr_recordId <> 0

Using Cross Reference Data

Trying Cross Reference for Product in TSM Territory: #qmd_tsmTerritory.territoryName#

select territoryId from tbl_SLS_SalesAreaTerritories where ownerId = 26 and ownerType = 'MFR' and territoryId = and salesAreaId =

None Found in #qmd_tsmTerritory.territoryName#

Trying Cross Reference for Product in TSM Territory: #qmd_operatorTerritory.territoryName#

select territoryId from tbl_SLS_SalesAreaTerritories where ownerId = 26 and ownerType = 'MFR' and territoryId = and salesAreaId =

None Found in #qmd_operatorTerritory.territoryName#

Using Distributor Territory: #qmd_distributorTerritory.territoryName#

Using Operator Territory: #qmd_operatorTerritory.territoryName#

Using Distributor Territory: #qmd_distributorTerritory.territoryName#

Using Operator Territory: #qmd_operatorTerritory.territoryName#

select ter.territoryId, ter.name territoryName, lvl.levelId, lvl.name levelName, lvl.zipCodeMapping, ter.primaryManager from tbl_TER_Territories ter inner join tbl_TER_TerritoryLevels lvl on lvl.levelId = ter.levelId and lvl.ownerId = ter.ownerId and lvl.fsl_tablecode = ter.fsl_tablecode where ter.ownerId = 26 and ter.fsl_tablecode = 'MFR' and ter.territoryid =

Call Assigned to Primary Manager of #qmd_salesPersonTerritory.territoryName#
(by: #_method#)

select ownerType, firstName, lastName, email from tbl_fspro_members where fspro_userid =