UFN_DESIGNATIONLEVELGIFTFEE_GETGIFTFEESTRUCTURE_2

Returns gift fee structure with currency info for a fundraising purpose.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVELID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_DESIGNATIONLEVELGIFTFEE_GETGIFTFEESTRUCTURE_2(@DESIGNATIONLEVELID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    ID,
                    FROMAMOUNT,
                    FEE,
                    BASECURRENCYID,
                    ORGANIZATIONFROMAMOUNT,
                    ORGANIZATIONEXCHANGERATEID,
                    USEORGANIZATIONCURRENCY
                from
                    dbo.DESIGNATIONLEVELGIFTFEESTRUCTURE
                where
                    DESIGNATIONLEVELID = @DESIGNATIONLEVELID
            );