UFN_REVENUESPLIT_ISWRITEOFF

            create function dbo.UFN_REVENUESPLIT_ISWRITEOFF
            (
                @REVENUESPLITID uniqueidentifier = null                
            ) 
            returns bit 
            with execute as caller
            as
            begin                
                if @REVENUESPLITID is not null 
                begin
                    if (select FINANCIALTRANSACTION.ID 
                            from dbo.FINANCIALTRANSACTION
                            inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                            where FINANCIALTRANSACTIONLINEITEM.ID = @REVENUESPLITID and FINANCIALTRANSACTION.TYPECODE = 20) is not null
                        return 1
                    else
                        return 0
                end 

                return 0
            end