UFN_REVENUESPLIT_ISVALIDFORCOVENANT

            create function dbo.UFN_REVENUESPLIT_ISVALIDFORCOVENANT
            (
                @REVENUESPLITID uniqueidentifier
            )
            returns bit
            as
            begin
                -- Only pledge and pledge payments can be covenants

                declare @TRANSACTIONTYPECODE tinyint, @APPLICATIONCODE tinyint
                select
                    @APPLICATIONCODE = REVENUESPLIT.APPLICATIONCODE,
                    @TRANSACTIONTYPECODE = REVENUE.TRANSACTIONTYPECODE
                from dbo.REVENUESPLIT
                inner join dbo.REVENUE on REVENUESPLIT.REVENUEID = REVENUE.ID
                where REVENUESPLIT.ID = @REVENUESPLITID

                declare @RETURNVALUE bit
                if @TRANSACTIONTYPECODE = 1 or @APPLICATIONCODE = 2 -- Pledge codes

                    set @RETURNVALUE = 1
                else
                    set @RETURNVALUE = 0

                return @RETURNVALUE
            end