USP_DATALIST_REVENUEBATCHDEFAULTMATCHINGGIFTS

Returns default matching gifts for a constituent in revenue batch.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@DATE	datetime	IN	Date
@DONATIONAMOUNT	money	IN	Donation amount
@DONATIONRECEIPTAMOUNT	money	IN	Donation receipt amount
@DONATIONSPLITS	xml	IN	Donation splits
@DONATIONTRANSACTIONCURRENCYID	uniqueidentifier	IN	Donation transaction currency ID
@REVENUESTREAMS	xml	IN	Revenue Streams

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVENUEBATCHDEFAULTMATCHINGGIFTS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @DATE datetime,
                    @DONATIONAMOUNT money,
                    @DONATIONRECEIPTAMOUNT money,
                    @DONATIONSPLITS xml,
                    @DONATIONTRANSACTIONCURRENCYID uniqueidentifier = null,
                    @REVENUESTREAMS xml = null
                )
                as
                set nocount on;

                select
                    DEFAULTMATCHINGGIFT.MATCHEDCONSTITUENTID,
                    DEFAULTMATCHINGGIFT.ORGANIZATIONID,
                    coalesce(CONSTITUENT.[NAME], N'') as [ORGANIZATIONNAME],
                    DEFAULTMATCHINGGIFT.RELATIONSHIPID,
                    dbo.UFN_RELATIONSHIP_GETNAME(DEFAULTMATCHINGGIFT.RELATIONSHIPID) as [RELATIONSHIPLABEL],
                    DEFAULTMATCHINGGIFT.MATCHINGGIFTCONDITIONTYPEID,
                    dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITION.[MATCHINGGIFTCONDITIONTYPECODEID]) as [MATCHINGGIFTCONDITIONLABEL],
                    DEFAULTMATCHINGGIFT.AMOUNT,
                    DEFAULTMATCHINGGIFT.DATE,
                    DEFAULTMATCHINGGIFT.SPLITS,
                    DEFAULTMATCHINGGIFT.COULDNOTDEFAULTMATCHINGGIFT,
                    @DONATIONTRANSACTIONCURRENCYID as [TRANSACTIONCURRENCYID]
                from dbo.UFN_REVENUEBATCH_GETDEFAULTMATCHINGGIFTS_3(@CONSTITUENTID, @DATE, @DONATIONAMOUNT, @DONATIONRECEIPTAMOUNT, @DONATIONSPLITS, @DONATIONTRANSACTIONCURRENCYID, @REVENUESTREAMS) as [DEFAULTMATCHINGGIFT]
                left outer join dbo.CONSTITUENT on CONSTITUENT.[ID] = ORGANIZATIONID
                left outer join dbo.MATCHINGGIFTCONDITION on MATCHINGGIFTCONDITION.[ID] = MATCHINGGIFTCONDITIONTYPEID