INSTALLMENTWRITEOFF

                CREATE view [dbo].[INSTALLMENTWRITEOFF]
                as 
                select ISW.WRITEOFFID, ISPLIT.INSTALLMENTID, sum(ISW.AMOUNT) AMOUNT, sum(ISW.TRANSACTIONAMOUNT) TRANSACTIONAMOUNT, sum(ISW.ORGANIZATIONAMOUNT) ORGANIZATIONAMOUNT
                from INSTALLMENTSPLITWRITEOFF ISW
                inner join INSTALLMENTSPLIT ISPLIT
                    on ISW.INSTALLMENTSPLITID = ISPLIT.ID
                group by ISPLIT.INSTALLMENTID, ISW.WRITEOFFID, ISPLIT.INSTALLMENTID