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;