UFN_GIFTFEE_PAYMENTMETHODEXCLUDED

Returns true is an constituent should be excluded from gift fees because of a Payment method.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@REVENUEID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_GIFTFEE_PAYMENTMETHODEXCLUDED(@REVENUEID uniqueidentifier)
returns bit
as

begin;
    declare @retval bit;
    set @retval = 0;

    declare @PAYMENTMETHODCODE as int

    select top 1 @PAYMENTMETHODCODE = REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE
        from REVENUEPAYMENTMETHOD
        where REVENUEID = @REVENUEID

    exec @retval = UFN_GIFTFEE_PAYMENTMETHODEXCLUDED_2 @PAYMENTMETHODCODE


    return @retval;
end