UFN_CREDIT_GETSPLITREFUNDAMOUNT_BULK

        CREATE function dbo.UFN_CREDIT_GETSPLITREFUNDAMOUNT_BULK()
        returns table
        as return
        (
            select
                REFUNDSPLIT.SOURCELINEITEMID,
                sum(REFUNDSPLIT.TRANSACTIONAMOUNT) + sum(CREDITITEM_EXT.DISCOUNTS) REFUNDTOTAL
            from dbo.FINANCIALTRANSACTION REFUND
            inner join dbo.FINANCIALTRANSACTIONLINEITEM REFUNDSPLIT
                on REFUNDSPLIT.FINANCIALTRANSACTIONID = REFUND.ID
            inner join dbo.CREDITITEM_EXT
                on CREDITITEM_EXT.ID = REFUNDSPLIT.ID
            left outer join dbo.CREDITITEMITEMDISCOUNT ITEMDISCOUNT
                on ITEMDISCOUNT.CREDITITEMID = REFUNDSPLIT.ID
            where REFUND.TYPECODE = 23
            group by REFUNDSPLIT.SOURCELINEITEMID
        )