USP_DATALIST_CREDITCREDITCARDPAYMENTS

Lists credit card payments for a refund.

Parameters

Parameter	Parameter Type	Mode	Description
@CREDITID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



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

    select
        CREDITPAYMENT.ID
    from
        dbo.FINANCIALTRANSACTION as FT
    inner join
        dbo.CREDITPAYMENT on CREDITPAYMENT.CREDITID = FT.ID
    where 
        FT.ID = @CREDITID
        and FT.TYPECODE = 23  -- Refund

        and CREDITPAYMENT.PAYMENTMETHODCODE = 2  -- Credit card

        and CREDITPAYMENT.REFUNDPROCESSED = 1
    order by
        CREDITPAYMENT.AMOUNT desc;

    return 0;