USE [Billing]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER FUNCTION [dbo].[fn_RevenueForLoyaltyPoints] (@RevenueID as varchar(2))  
RETURNS varchar(1) AS  
BEGIN 

declare @DrCr as varchar(1)

select @DrCr = DrCr
from BUILD_FILE..tbCoRevenueCode
where RevenueID = @RevenueID;

RETURN case
	when @DrCr = 'P' then 'N'
	when @RevenueID in ('CT','DI','AB','EN') then 'N'
	else 'Y'
	end
END