spLoadRecord_GivingHistory2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SiteContentID | int | IN |
Definition
Copy
CREATE procedure [dbo].[spLoadRecord_GivingHistory2]
(
@SiteContentID int
)
as
begin
select
[ID],
[GiftTypes],
[Campaigns],
[Funds],
[Appeals],
[GiftQueryID],
[IncludeSoftCredit],
[ResultsPerPage],
[UseCustomFilter],
[UseCustomColumn],
[IncludePending],
[IncludeSummary],
[IncludeGiftTotal],
[IncludeGiftAidTotal],
[IncludePendingTotal],
[IncludePledgeTotal],
[IncludeBalanceTotal],
[IncludeTotalsCurrency],
[PledgePaymentPageID],
[RecGiftEditAllowAmtUpdate],
[RecGiftEditAllowFreqUpdates],
[RecGiftEditAllowPmntTypeUpdate],
[RecGiftEditMinUpdateAmt],
[RecGiftEditFilterFunds],
[RecGiftEditFilterAppeals],
[RecGiftEditFilterQueryID],
[RecGiftEditFilterUseCustomFilter],
[RecGiftEditFreqUseGeneralRecurrence],
[RecGiftEditFreqAllowStartDateUpdates],
[RecGiftEditFreqAllowEndDateUpdates],
[RecGiftEditFreqSpecifics],
[RecGiftAdditionalDonationPageID],
[IncludeSoftCreditsTotal],
[IncludeHardCreditsTotal],
[RecurringGiftPaymentPageID],
[IncludeUnpaidEvents],
[UnpaidEventsPaymentPageID],
[MerchantAccountID],
[CheckoutThemeUseSiteDefault],
[CheckoutThemePrimaryColor],
[CheckoutThemeSecondaryColor],
[CheckoutThemeFontType]
FROM
[dbo].[GivingHistory2]
WHERE
[SiteContentID] = @SiteContentID
END