UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT_2

Returns the tax claim amount from the REVENUESPLITGIFTAID record with the given ID.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@ACTUALONLY	bit	IN
@CURRENCYTYPE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT_2(
                @ID uniqueidentifier,
                @ACTUALONLY bit,
                @CURRENCYTYPE tinyint -- 0 = Base, 1 = Transaction, 2 = Organization

            )
                returns money
                with execute as caller
                as begin
                declare @TAXCLAIMAMOUNT money;

                select @TAXCLAIMAMOUNT = TAXCLAIMAMOUNT
                from dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE_2(@ACTUALONLY,@CURRENCYTYPE) REVENUESPLITGIFTAID
                where REVENUESPLITGIFTAID.ID = @ID

                if @TAXCLAIMAMOUNT is null
                  return 0;

                return @TAXCLAIMAMOUNT;
                end