UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFS

        CREATE function dbo.UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFS(@INSTALLMENTID uniqueidentifier = null)
        returns table
        as return
            select 
                IW.ID,
                W.ID WRITEOFFID,
                W.DATE,
                IW.TRANSACTIONAMOUNT AMOUNT,
                W.REASONCODEID,
                W.REASONTYPECODE,
                W.REASONTYPE
            from dbo.RECURRINGGIFTWRITEOFF W
            inner join dbo.RECURRINGGIFTINSTALLMENTWRITEOFF IW on IW.WRITEOFFID = W.ID
            where IW.RECURRINGGIFTINSTALLMENTID = @INSTALLMENTID
            and W.TYPECODE = 0;