UFN_MATCHINGGIFTPLEDGE_CALCULATEMGAMOUNT

This function calculates the amount for a matching gift claim based on the matching organization's matching conditions for matching gift claims based in the organization currency.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@MGORGID	uniqueidentifier	IN
@AMOUNT	money	IN
@DATE	datetime	IN
@MAXMATCHPERGIFT	money	IN
@MAXMATCHANNUAL	money	IN
@MAXMATCHTOTAL	money	IN

Definition

Copy



            CREATE function dbo.UFN_MATCHINGGIFTPLEDGE_CALCULATEMGAMOUNT
            (
                @CONSTITUENTID uniqueidentifier,
                @MGORGID uniqueidentifier,
                @AMOUNT money,
                @DATE datetime,
                @MAXMATCHPERGIFT money,
                @MAXMATCHANNUAL money,
                @MAXMATCHTOTAL money
            )
            returns money
            with execute as caller
            as
            begin
                return dbo.UFN_MATCHINGGIFTPLEDGE_CALCULATEMGAMOUNTINCURRENCY(@CONSTITUENTID, @MGORGID, @AMOUNT, @DATE, @MAXMATCHPERGIFT, @MAXMATCHANNUAL, @MAXMATCHTOTAL, default);
            end