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;