UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNT

            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNT
            (
                @ID uniqueidentifier,
                @ACTUALONLY bit
            )
            returns money
            with execute as caller
            as 
            begin
                declare @TAXCLAIMAMOUNT money;

                select @TAXCLAIMAMOUNT = sum(TAXCLAIMAMOUNT)
                from dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE(@ACTUALONLY)
                where ID in (select ID from dbo.REVENUESPLIT where REVENUEID = @ID);

                if @TAXCLAIMAMOUNT is null
                return 0;

                return @TAXCLAIMAMOUNT;
            end