USP_DATALIST_SALESORDER_DONATIONS

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

    select
        SALESORDERITEM.ID,
        case
            when FT.ID is not null then
                'Refund ' + convert(nvarchar(20), cast(FT.DATE as datetime), 1) + ', ' + SALESORDERITEM.DESCRIPTION
            else
                SALESORDERITEM.DESCRIPTION
        end DESCRIPTION,
        SALESORDERITEM.PRICE,
        SALESORDERITEM.QUANTITY,
        SALESORDERITEM.TOTAL,
        SALESORDERITEM.TYPECODE,
        SALESORDERITEMDONATION.REVENUESPLITID,
        SALESORDERITEMDONATION.ECARDSDATA,
        case when FT.ID is null 
            then 
                0 
            else 
                1 
        end as ISREFUND
    from
        dbo.SALESORDERITEM
    inner join
        dbo.SALESORDERITEMDONATION on SALESORDERITEM.ID = SALESORDERITEMDONATION.ID
    left outer join
        dbo.CREDITITEM_EXT as EXT on EXT.SALESORDERITEMID = SALESORDERITEM.ID
    left outer join
        dbo.FINANCIALTRANSACTIONLINEITEM as LI on LI.ID = EXT.ID
    left outer join
        dbo.FINANCIALTRANSACTION as FT on FT.ID = LI.FINANCIALTRANSACTIONID
    where 
        SALESORDERITEM.SALESORDERID = @CONTEXTID;

    return 0;