UFN_CHARGE_ISREVERSED

        CREATE function dbo.UFN_CHARGE_ISREVERSED
        (
            @CHARGEID uniqueidentifier            
        )
        returns bit
        with execute as caller
        as begin
            declare @ISREVERSED bit
            set @ISREVERSED = 0

      if exists(select FTLI.ID from dbo.CHARGERECEIVABLECREDITLINEITEMS CCLI inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI on CCLI.CHARGELINEITEMID = FTLI.ID where FTLI.FINANCIALTRANSACTIONID=@CHARGEID AND FTLI.TYPECODE =0 AND FTLI.DELETEDON is null)
          set @ISREVERSED = 1

            return @ISREVERSED
        end