USP_DATALIST_CREDITREFUND_ADJUSTMENTS2

CREATE procedure dbo.USP_DATALIST_CREDITREFUND_ADJUSTMENTS2
(
    @CREDITID uniqueidentifier
)
as
    set nocount on;

    select
        SALESORDERITEM.SALESORDERID,
        SALESORDERITEM.[DESCRIPTION],
        LI.BASEAMOUNT as AMOUNTREFUNDED,
        SALESORDERITEM.TYPECODE,
        SALESORDERITEM.[TYPE]
    from
        dbo.FINANCIALTRANSACTIONLINEITEM as LI
    inner join
        dbo.CREDITITEM_EXT as EXT on EXT.ID = LI.ID
    inner join
        dbo.SALESORDERITEM on SALESORDERITEM.ID = EXT.SALESORDERITEMID
    where
        LI.FINANCIALTRANSACTIONID = @CREDITID
        and SALESORDERITEM.TYPECODE in (3,4)  -- 3 is fee, 4 is tax

    order by
        TYPECODE asc,
        [DESCRIPTION] asc

    return 0;