• Territory Scope: My Territories
• Territory Scope: All Territories
select name from tbl_ter_territories where ownerid = and fsl_tablecode = and territoryid =
• Territory Scope: #qryTer.name#
• Active Contracts
• Contracts Expiring in 30 Days
• Contracts Expiring in 60 Days
• Contracts Expiring in 90 Days
• Expired Contracts
• Future Contracts
• No Contracts
• Operator Accounts Only
• Distributor Accounts Only
• Priority: #replace(replace(url.priority,"*","A+"),",",", ","all")#
select listname from tbl_lst_partnerlists where ownerid = and ownertype = and listid =
• Opr List: #qryList.listname#
• Last interaction within past year
• Last interaction over one year
• Last interaction within past #url.lastInteractionDays# days
• Last interaction over #(url.lastInteractionDays * -1)# days ago
• Never interacted with
select companyname from tbl_opr_clientoperators where operatorid = and ownerid = and fsltablecode =
• GPO: #qryGpo.companyname#
select companyname from tbl_opr_clientoperators where operatorid = and ownerid = and fsltablecode =
• CMC: #qryCmc.companyname#
select sku, skuDesc from tbl_prd_skus where skuid = and ownerid = and fsl_tablecode =
• #_prdStatus#: #qryProd.sku# #qryProd.skuDesc#
select shortdesc from tbl_prd_products where prodid = and ownerid = and fsl_tablecode =
• #_prdStatus#: #qryProd.shortdesc#
select category from tbl_prd_categories where categoryid = and ownerid = and fsl_tablecode =
• #_prdStatus#: #qryProd.category#
• Sorted by Relevance
• Sorted by Account Name
• Sorted by Distance
• Sorted by Annual Cases, High to Low
• Sorted by Annual Cases, Low to High
select firstname, lastname from tbl_fspro_members with (nolock) where fspro_userid = and ownerid = and fsl_tablecode =
• Acct Mgr: #qryRep.firstname# #qryRep.lastname#
select mfr_name from tblmanufacturers where mfr_id =
• Manufacturer Mapping: #qryMfr.mfr_name#