select promotionName, primaryPartnerType, payableTo 
		from (	values
			( 'FS Region Chains (Rebate)', 'OPR', 'OPR' ),
	        ( 'Contract Management - Rebate', 'OPR','OPR' ),
	        ( 'Local Operator', 'OPR','CDR' ),
	        ( 'Local Distributor', 'CDR','CDR' ), 
	        ( 'Contract Management - Deviated', 'OPR','CDR' ),
	        ( 'FS Self Op College & Univ (Reb','OPR','OPR' ),
	        ( 'FS Top 100 Chain (Rebate)','OPR','OPR' ),
	        ( 'FS Corporate Distributor','CDR','CDR' ),
	        ( 'FS Top 100 Chain (Pricing)','OPR','CDR' ),
	        ( 'FS Corporate Distributor by so','CDR','CDR' ),
	        ( 'K-12 Schools - Commercial','OPR','CDR' ),
	        ( 'FS Buying Group by sold to','CDR','CDR' ),
            ('FS GPO''s (Rebate)', 'OPR', 'OPR' ),
            ('FS GPO''s (Pricing)', 'OPR', 'CDR' ),
            ('FS Military (Pricing)', 'OPR', 'CDR' ),
            ('K-12 Schools - Commodity', 'OPR', 'CDR' ),
            ('ISB Everyday Trade (Exc. SPR)', '???', '???'  ),
            ('FS Freight', '???', '???'  ),
            ('Recall Non-Trade', '???', '???'  ),
            ('Non-Trade', '???', '???' ),
            ('FS Self Op College & Univ (Pri', 'OPR', 'OPR' ),
            ('ISB Distributor', '???','???' ),
            ('FS Region Chains (Pricing)', 'OPR', 'OPR' )
		) x (promotionName, primaryPartnerType, payableTo)