/*
	Add the Exchange Rate from the buyout as data on 'each part' 
	so we have a reference to what the Exchange Rate was at the time 
	of the buyout calculation (we need it for later analysis)
*/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE 
	TABLE_NAME = 'publ_QuoteItemsFinal'
	AND COLUMN_NAME = 'ExchangeRate')
BEGIN
	ALTER TABLE [publ_QuoteItemsFinal] ADD [ExchangeRate] DECIMAL(18,2) NULL
END