UFN_DESIGNATIONLEVELGIFTFEE_GETGIFTFEESTRUCTURE

Returns gift fee structure 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(@DESIGNATIONLEVELID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    ID,
                    FROMAMOUNT,
                    FEE
                from
                    dbo.DESIGNATIONLEVELGIFTFEESTRUCTURE
                where
                    DESIGNATIONLEVELID = @DESIGNATIONLEVELID
            );