spLoadRecord_ClientDonations

Parameters

Parameter Parameter Type Mode Description
@PKID int IN

Definition

Copy


  CREATE procedure dbo.Sploadrecord_clientdonations (@PKID INT)
  as
    set nocount on;

    select id,
           clientsid,
           ownerid,
           deleted,
           guid,
           constitcodeid,
           emailtemplateid,
           donationoptions,
           tributeoptions,
           redirectpageid,
           contentID,
           merchantaccount,
           nomgpledges,
           attributes,
           donatebtn,
           recurrenceoptions,
           recurrenceoptionstruepledge,
           shoppingcartpageid,
           ereceiptpdfforcreditcard,
           ereceiptpdffordirectdebit,
           markreceiptedforcreditcard,
           markreceiptedfordirectdebit,
           ereceiptcontent,
           ereceiptpdfmargin,
           cartmessage,
           ecardpartid,
           ecardsenddateattributeid,
           ecardrecipientfirstnameattributeid,
           ecardrecipientlastnameattributeid,
           cartsenddonationacknowledgementalways,
           minimumgiftamount,
           minimumpledgepaymentamount,
           showpledgepaymentduedate,
           acknowledgementblock,
           allowspouseinfo,
           includechallengematch,
           challengematchintro,
           challengematch,
           impactstatementtypeid,
           appealHistoryQueryID,
           WelcomeEmailTemplateID
    from   dbo.clientdonations
    where  id = @PKID