UFN_REVENUEBATCH_GETDEFAULTMATCHINGGIFTS_4

Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@DATE	datetime	IN
@DONATIONAMOUNT	money	IN
@DONATIONRECEIPTAMOUNT	money	IN
@DONATIONSPLITS	xml	IN
@DONATIONTRANSACTIONCURRENCYID	uniqueidentifier	IN
@REVENUESTREAMS	xml	IN
@ADDITIONALAPPLICATIONSSTREAM	xml	IN
Definition

Copy


            create function dbo.UFN_REVENUEBATCH_GETDEFAULTMATCHINGGIFTS_4
            (
                @CONSTITUENTID uniqueidentifier,
                @DATE datetime,
                @DONATIONAMOUNT money,
                @DONATIONRECEIPTAMOUNT money,
                @DONATIONSPLITS xml,
                @DONATIONTRANSACTIONCURRENCYID uniqueidentifier,
                @REVENUESTREAMS xml = null,
                @ADDITIONALAPPLICATIONSSTREAM xml = null
            )
            returns @R table
            (
                MATCHEDCONSTITUENTID uniqueidentifier,
                ORGANIZATIONID uniqueidentifier,
                RELATIONSHIPID uniqueidentifier,
                MATCHINGGIFTCONDITIONTYPEID uniqueidentifier,
                AMOUNT money,
                DATE datetime,
                SPLITS xml,
                COULDNOTDEFAULTMATCHINGGIFT bit
            )
            as 
            begin
                if @CONSTITUENTID is null
                    return;

                if @DONATIONTRANSACTIONCURRENCYID is null set @DONATIONTRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                if dbo.UFN_MATCHINGGIFTPREFERENCE_AUTOADDMG() > 0
                begin
                    insert into @R(MATCHEDCONSTITUENTID, ORGANIZATIONID, RELATIONSHIPID, MATCHINGGIFTCONDITIONTYPEID, AMOUNT, DATE, SPLITS, COULDNOTDEFAULTMATCHINGGIFT)
                        select 
                            @CONSTITUENTID,
                            ORGANIZATIONID,
                            RELATIONSHIPID,
                            MATCHINGGIFTCONDITIONTYPEID,
                            AMOUNT,
                            DATE,
                            SPLITS,
                            COULDNOTDEFAULTMATCHINGGIFT
                        from dbo.UFN_REVENUEBATCH_GETDEFAULTMATCHINGGIFTS_FORCONSTITUENT_4(@CONSTITUENTID, @DATE, @DONATIONAMOUNT, @DONATIONRECEIPTAMOUNT, @DONATIONSPLITS, @DONATIONTRANSACTIONCURRENCYID, @REVENUESTREAMS, @ADDITIONALAPPLICATIONSSTREAM);

                end

                if dbo.UFN_MATCHINGGIFTPREFERENCE_AUTOADDSPOUSEMG() > 0
                begin
                    declare @SPOUSEID uniqueidentifier;
                    select @SPOUSEID = RECIPROCALCONSTITUENTID 
                    from dbo.RELATIONSHIP 
                    where RELATIONSHIPCONSTITUENTID = @CONSTITUENTID 
                        and ISSPOUSE = 1;

                    if @SPOUSEID is not null
                        insert into @R(MATCHEDCONSTITUENTID, ORGANIZATIONID, RELATIONSHIPID, MATCHINGGIFTCONDITIONTYPEID, AMOUNT, DATE, SPLITS, COULDNOTDEFAULTMATCHINGGIFT)
                            select 
                                @SPOUSEID,
                                ORGANIZATIONID,
                                RELATIONSHIPID,
                                MATCHINGGIFTCONDITIONTYPEID,
                                AMOUNT,
                                DATE,
                                SPLITS,
                                COULDNOTDEFAULTMATCHINGGIFT
                            from dbo.UFN_REVENUEBATCH_GETDEFAULTMATCHINGGIFTS_FORCONSTITUENT_4(@SPOUSEID, @DATE, @DONATIONAMOUNT, @DONATIONRECEIPTAMOUNT, @DONATIONSPLITS, @DONATIONTRANSACTIONCURRENCYID, @REVENUESTREAMS, @ADDITIONALAPPLICATIONSSTREAM);
                end

                return;
            end