USP_DATALIST_INSTALLMENTPLANWRITEOFFSBYTRANSACTION

                create procedure dbo.USP_DATALIST_INSTALLMENTPLANWRITEOFFSBYTRANSACTION
                (
                    @ID uniqueidentifier
                )
                as

                set nocount on;

                select 
                    WRITEOFF.ID,
                    WRITEOFF.DATE,
                    (select sum(INSTALLMENTWRITEOFF.TRANSACTIONAMOUNT) from dbo.INSTALLMENTWRITEOFF where WRITEOFFID = WRITEOFF.ID) as AMOUNT,
                    WRITEOFF.REASON,
                    WRITEOFFREASONCODE.CODE as REASONCODE,
                    WRITEOFFREASONCODE.DESCRIPTION as REASONDESCRIPTION,
                    FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                from 
                    dbo.WRITEOFF
                inner join 
                    dbo.FINANCIALTRANSACTION on WRITEOFF.REVENUEID = FINANCIALTRANSACTION.ID
                left join
                    dbo.WRITEOFFREASONCODE on WRITEOFFREASONCODE.ID = WRITEOFF.REASONCODEID
                where 
                    FINANCIALTRANSACTION.ID = @ID
                order by 
                    WRITEOFF.DATE, WRITEOFF.DATEADDED;