UFN_FINANCIALTRANSACTION_PAID

    CREATE function dbo.UFN_FINANCIALTRANSACTION_PAID(
    @ID uniqueidentifier
    )
    returns bit
    with execute as caller
    as begin
      -- do work here and return a value

      declare @FTID uniqueidentifier
      declare @PAID bit = 0

      select  @FTID = isnull(FT.ID,'')
      from dbo.FINANCIALTRANSACTION FT
      join dbo.FINANCIALTRANSACTIONSCHEDULE FTS on FT.ID = FTS.FINANCIALTRANSACTIONID
      join dbo.FINANCIALTRANSACTIONAPPLICATION FTA on FTA.FINANCIALTRANSACTIONSCHEDULEID = FTS.ID
      where FTA.STATUSCODE <> 2 and FT.ID = @ID

      if len(@FTID) > 0
      set @PAID = 1


    return @PAID
    end