UFN_INSTALLMENT_GETINSTALLMENTSPLITBALANCE_BULK

            create function dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITBALANCE_BULK()
            returns table
            as
            return
            (
                select
                    INSTALLMENTSPLIT.ID,
                    INSTALLMENTSPLIT.PLEDGEID,
                    INSTALLMENTSPLIT.DESIGNATIONID,
                    INSTALLMENTSPLIT.INSTALLMENTID,
                    INSTALLMENTSPLIT.TRANSACTIONAMOUNT - (
                        coalesce((
                                select sum(INSTALLMENTSPLITPAYMENT.AMOUNT)
                                from dbo.INSTALLMENTSPLITPAYMENT
                                where INSTALLMENTSPLITPAYMENT.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID
                            ), 0)
                        + coalesce((
                                select sum(INSTALLMENTSPLITWRITEOFF.TRANSACTIONAMOUNT)
                                from dbo.INSTALLMENTSPLITWRITEOFF
                                where INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID
                            ), 0)
                    ) as BALANCE
                from
                    dbo.INSTALLMENTSPLIT            
            )