select c.companyId, c.companyPType, c.companyPKeyId, case when c.companyPType = 'MFR' then ( select mfr_name from tblManufacturers where mfr_id = c.companyPKeyId ) when c.companyPType = 'BRO' then ( select broker_name from tblBrokers where broker_id = c.companyPKeyId ) when c.companyPType = 'MSC' then ( select company from tbl_MSC_FSLibraryUsers where userId = c.companyPKeyId ) when c.companyPType = 'CHO' then ( select cho_name from tbl_CHO_Operators where cho_Id = c.companyPKeyId ) else 'Unknown' end companyName from tbl_LIB_Companies c where c.companyPType in ( 'MFR', 'BRO', 'MSC', 'CHO' ) order by companyName Init Dev Library Account:

Library Account:	--- select library account --- #htmleditformat( companyName )# (#companyPType#:#companyPKeyId# )
User Email:

Sales Team Portal Development

MFR: --- MFR Sales Team Portals --- Arthur Schuman Aryzta LLC Asian Food Solutions Azar Foodservice Basic American Foods Barrel O'Fun Snacks Beaver Street Fisheries Brakebush Bush Brothers & Company Butterball Campbell's Foodservice Chicken of the Sea International ConAgra Foodservice Custom Culinary Dannon Company Dans Prize Diamond Crystal Brands Dole Foodservice Elmhurst Milked Fiesta Foods FoodHandler (BarrierSafe) Foster Farms Furmano's Ghirardelli Girard's Dressings Hershey foodservice Hormel Health Labs Idahoan Foods J and J Snack Foods Jennie-O Kellogg's Away From Home Kens Kent Precision Foods Kerry Foodservice Solutions King & Prince Krusteaz (Continental Mills) Lactalis Lesaffre Yeast Lamb Weston Lantmannen-Unibake LBP Manufacturing McCormick MegaMex Foodservice Michael Foods Mission Food Service Muffin Town Neil Jones Food Company Nestle Professional Oatka Milk Ocean Spray Oneida Food Service Perdue Food Service PanaPesca Pilgrims Pride/Pierce Chicken Post Consumer Brands Resers Fine Foods RPC Food Service RPC In-Store Bakery Rosina Food Service Smucker's Foodservice Seawatch Smithfield Sovena Group StarKist Food Service Super Bakery Surlean Foods Sweet Street TreeHouse Foods (Bay Valley Foods) T.W. Garner Upper Crust Ent. Upstate Farms Ventura Foods Vie de France Wayne Farms Windsor Foods

BRO: --- BRO Sales Team Portals --- ABC Sales Acosta Foodservice Acosta | Blue Advantage Marketing NY Affinity Group (AG Foodservice) Affinity Group (Infusion) AMCA Eiserloh IBA (Stillwater Provisions) Institutional Sales, Inc. Internationl Pacific Jones-Neitzel Krehbiel and Associates, Inc. Legacy Foodservice Alliance MAP Foodservice Master Sales, Inc. Michaels and Associates Network Services Scooter Bay Summit Marketing (Canada) Supreme Great Lakes Sales Synergy Enterprises Thomas Marketing Yankee Marketers

Archived Sites

--- Archived Site(s) - Restored by Request ---