USP_SIMPLEDATALIST_MATCHINGGIFTCONDITION

This simple datalist returns the matching gift conditions for a given organization.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID
@CURRENCYID	uniqueidentifier	IN	CURRENCYID

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_MATCHINGGIFTCONDITION(
                    @CONSTITUENTID uniqueidentifier = null,
                    @CURRENCYID uniqueidentifier = null
                )
                as
                set nocount on;

                select 
                    MATCHINGGIFTCONDITION.ID as VALUE,
                    dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID) as LABEL
                from dbo.MATCHINGGIFTCONDITION
                where ORGANIZATIONID = @CONSTITUENTID
                    and (@CURRENCYID is null or MATCHINGGIFTCONDITION.BASECURRENCYID = @CURRENCYID)
                order by LABEL;