USP_SALESORDER_GETBASICPAYMENTINFO

CREATE procedure dbo.USP_SALESORDER_GETBASICPAYMENTINFO(
    @SALESORDERID uniqueidentifier
)
as 
begin
    select
        SALESORDERPAYMENT.PAYMENTID as PAYMENTID,
        SALESORDERPAYMENT.AMOUNT as AMOUNT,
        REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE as PAYMENTMETHODCODE,
        case REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE
            when 10 then -- 'Other' payments need information from a different table

                OTHERPAYMENTMETHODCODE.DESCRIPTION
            else
                REVENUEPAYMENTMETHOD.PAYMENTMETHOD
        end as PAYMENTMETHOD,
        CREDITCARDPAYMENTMETHODDETAIL.CREDITCARDPARTIALNUMBER as CREDITCARDPARTIALNUMBER,
        CREDITTYPECODE.DESCRIPTION as DESCRIPTION
    from
        dbo.SALESORDERPAYMENT
    inner join
        dbo.REVENUEPAYMENTMETHOD on REVENUEPAYMENTMETHOD.REVENUEID = SALESORDERPAYMENT.PAYMENTID
    left join
        dbo.CREDITCARDPAYMENTMETHODDETAIL on CREDITCARDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
    left join
        dbo.CREDITTYPECODE on CREDITTYPECODE.ID = CREDITCARDPAYMENTMETHODDETAIL.CREDITTYPECODEID
    left join
        dbo.OTHERPAYMENTMETHODDETAIL on OTHERPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
    left join
        dbo.OTHERPAYMENTMETHODCODE on OTHERPAYMENTMETHODCODE.ID = OTHERPAYMENTMETHODDETAIL.OTHERPAYMENTMETHODCODEID
    where
        SALESORDERID = @SALESORDERID
    order by
        SALESORDERPAYMENT.DATEADDED desc    

    return 0;
end