USP_DATALIST_ORDERREFUNDS

CREATE procedure dbo.USP_DATALIST_ORDERREFUNDS
(
    @CONTEXTID uniqueidentifier
)
as
    set nocount on;

    select
        REFUND.ID REFUNDID,
        REFUND.CALCULATEDDATE [DATE],
        REFUND.TRANSACTIONAMOUNT TOTAL,
        dbo.UDA_BUILDLIST(distinct EXT.[TYPE]) TYPES,
        REFUND.TRANSACTIONCURRENCYID CURRENCYID
    from dbo.SALESORDER SO
    inner join dbo.FINANCIALTRANSACTION REFUND on REFUND.PARENTID = SO.REVENUEID
    inner join dbo.FINANCIALTRANSACTIONLINEITEM REFUNDLI on REFUNDLI.FINANCIALTRANSACTIONID = REFUND.ID
    inner join dbo.CREDITITEM_EXT EXT on EXT.ID = REFUNDLI.ID
    where SO.ID = @CONTEXTID
    group by
        REFUND.ID,
        REFUND.CALCULATEDDATE,
        REFUND.TRANSACTIONAMOUNT,
        REFUND.TRANSACTIONCURRENCYID,
        REFUND.[DATE]
    order by REFUND.[DATE];