- Territory Scope: My Territories
- Territory Scope: All Territories
select name
from tbl_ter_territories with (nolock)
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 with (nolock)
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 cdr_dstname
from tbl_cdr_distributors with (nolock)
where cdr_recordid =
and ownerid =
and fsl_tablecode =
- Buying Group: #qryBg.cdr_dstname#
select sku, skuDesc
from tbl_prd_skus with (nolock)
where skuid =
and ownerid =
and fsl_tablecode =
- #_prdStatus#: #qryProd.sku# #qryProd.skuDesc#
select shortdesc
from tbl_prd_products with (nolock)
where prodid =
and ownerid =
and fsl_tablecode =
- #_prdStatus#: #qryProd.shortdesc#
select category
from tbl_prd_categories with (nolock)
where categoryid =
and ownerid =
and fsl_tablecode =
- #_prdStatus#: #qryProd.category#
select cdr_dstname
from tbl_CDR_Distributors with (nolock)
where OwnerID =
and FSL_TableCode =
and cdr_dstcompanytype = 'P'
and FSL_dstid =
- Parent: #qryParent.cdr_dstname#
- Parent Distributors
- Branch Distributors
- Buying Groups
- Re-Distributors
- US Distributors
- Canada Distributors
- Other Countries