spLoadRecord_FundRaiserDonations

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN
Definition

Copy


            CREATE       PROCEDURE [dbo].[spLoadRecord_FundRaiserDonations]
            (
            @PKID int
            )
            AS

            SELECT     fd.[ID],
            fd.[SolicitorID],
            fd.[Amount],
            fd.[IsOffline],
            fd.[DonationTransactionsID],
            fd.[CurrencyType],
            fd.[IsAthon],
            fd.[InvoiceDate],
            fd.[InvoicePaid],
            fd.[PledgeID],
            fd.[GiftBackOfficeID],
            fd.[IsChangeBucket],
            dt.processed_date DateProcessed,
            dt.IsDeleted,
            dt.Status
            FROM FundRaiserDonations fd
            inner join DonationTransactions dt on dt.DonationTransactionsID = fd.DonationTransactionsID
            WHERE fd.ID = @PKID