spGet_ShoppingCartDonations

Parameters

Parameter Parameter Type Mode Description
@ShoppingCartID int IN

Definition

Copy


        CREATE procedure [dbo].[spGet_ShoppingCartDonations](@ShoppingCartID integer) as
        select
            ID,
            ShoppingCartID,
            TransactionXml,
            AcknowledgementXml,
            Amount,
            CreateDate,
            UpdateDate,
            AllowsMatchingGifts,
            EReceiptPdfForCreditCard,
            EReceiptPdfForDirectDebit,
            MarkReceiptedForCreditCard,
            MarkReceiptedForDirectDebit,
            ECardsXml,
            CartSendDonationAcknowledgementAlways
        from dbo.ShoppingCartDonation
        where ShoppingCartID = @ShoppingCartID
        order by CreateDate;