UFN_BBNC_GETSPLITSFORAPPEAL

Returns prorated splits for an appeal from a Blackbaud Internet Solutions donation transaction.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALID	uniqueidentifier	IN
@AMOUNT	money	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETSPLITSFORAPPEAL
            (
                @APPEALID uniqueidentifier,
                @AMOUNT money
            )
            returns @SPLITS table
            (
                DESIGNATIONID uniqueidentifier,
                AMOUNT money
            )
            as 
            begin
                insert into @SPLITS(DESIGNATIONID, AMOUNT)
                    select top 1 
                        DESIGNATIONID, @AMOUNT
                    from dbo.APPEALDESIGNATION
                    where APPEALID = @APPEALID
                        and ISDEFAULT = 1;

                return;
            end