UFN_REVENUESPLIT_GETTAXCLAIMAMOUNT

            CREATE function dbo.UFN_REVENUESPLIT_GETTAXCLAIMAMOUNT
            (
                @REVENUESPLITID uniqueidentifier,
                @TRANSACTIONTYPECODE tinyint,
                @APPLICATIONCODE tinyint
            )
            returns money
            as
            begin
                declare @TAXCLAIMAMOUNT money

                -- Transaction type = Payment, Application code = Donation, Event, Pledge, Recurring Gift or Membership

                if @TRANSACTIONTYPECODE = 0 and @APPLICATIONCODE in (0, 1, 2, 3, 5)
                    set @TAXCLAIMAMOUNT = dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT(@REVENUESPLITID, 1)
                else if @TRANSACTIONTYPECODE = 1
                    select top 1 @TAXCLAIMAMOUNT = (BASETAXCLAIMAMOUNT + TRANSITIONALTAXCLAIMAMOUNT) from dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGETAXCLAIMAMOUNT(@REVENUESPLITID)

                set @TAXCLAIMAMOUNT = coalesce(@TAXCLAIMAMOUNT, 0)

                return @TAXCLAIMAMOUNT
            end