Mfr Like: #url.mfrkeyword#

Program: #_prgDisp#

select companyname from tbl_opr_clientoperators with (nolock) where operatorid = and ownerid = and fsltablecode =

#qryAffiliation.companyname#

select cho_name from tbl_cho_operators with (nolock) where cho_id =

#qryAffiliation.cho_name#

select cdr.cdr_dstname from tbl_cdr_distributors cdr with (nolock) where cdr.cdr_recordid = and ownerid = and fsl_tablecode =

#qryCustomer.cdr_dstname#

select shortdesc from tbl_prd_products with (nolock) where prodid = and ownerid = and fsl_tablecode =

#qryProd.shortdesc#

select category from tbl_prd_categories with (nolock) where categoryid = and ownerid = and fsl_tablecode =

Category: #qryCat.category#

Budget Cat: #qryBudgetCategories.bgtCategory#

select brand from tbl_MFR_Brands with (nolock) where brand_id =

#qryBrand.brand#

Discontinued Items Included

Private Label Items Excluded

select listName from tbl_LST_PartnerLists with (nolock) where listId = and ownerId = and ownerType =

Product Set: #qryproductSet.listName#

select label as tradeChannel from tbl_prd_tradechannels with (nolock) where codeValue =

Trade Channel: #qryTradeChannel.tradeChannel#

Claims: #_claims#

Kosher Certified

Halal Certified