UFN_REVENUE_PAYSINSTALLMENT

            CREATE function dbo.UFN_REVENUE_PAYSINSTALLMENT
            (
                @REVENUEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @r bit;

                select 
                  @r = case when FT.TYPECODE in (0) then 1 else 0 end
        from dbo.FINANCIALTRANSACTION FT inner join 
        FINANCIALTRANSACTIONLINEITEM FTL on FT.ID = FTL.FINANCIALTRANSACTIONID
        where FTL.ID = @REVENUEID;

                return @r;
            end