UFN_REVENUE_GETGIFTFEES_2

            CREATE function dbo.UFN_REVENUE_GETGIFTFEES_2(@REVENUEID uniqueidentifier)
            returns table
            AS            
            return 
            (
                select 
                    REVENUESPLIT.ID,
                    REVENUESPLIT.[APPLICATION],
                    REVENUESPLIT.TRANSACTIONAMOUNT AMOUNT,
                    dbo.UFN_PAYMENTAPPLICATION_GETDESCRIPTION(REVENUESPLIT.ID) DETAILS,
                    cast(coalesce(REVENUESPLITGIFTFEE.FEE, 0.00) as money) FEE,
                    cast(coalesce(REVENUESPLITGIFTFEE.TRANSACTIONAMOUNT, 0.00) as money) TRANSACTIONFEE,
                    cast(coalesce(REVENUESPLITGIFTFEE.ORGANIZATIONAMOUNT, 0.00) as money) ORGANIZATIONFEE,
                    cast(coalesce(REVENUESPLITGIFTFEE.WAIVED, 0) as bit) WAIVED,
                    REVENUESPLIT.TRANSACTIONCURRENCYID
                from dbo.REVENUESPLIT
                left outer join dbo.REVENUESPLITGIFTFEE on REVENUESPLIT.ID = REVENUESPLITGIFTFEE.ID
                where 
                    REVENUESPLIT.REVENUEID = @REVENUEID and
                    -- Exclude splits with an application of Order and type of Fee or Taxes since they aren't mapped

                    not (REVENUESPLIT.APPLICATIONCODE = 10 and (REVENUESPLIT.TYPECODE = 6 or REVENUESPLIT.TYPECODE = 7))
            )