UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNT_2

Returns the tax claim amount of a given record.

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_GETTAXCLAIMAMOUNT_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 = sum(ELIGIBLE.TAXCLAIMAMOUNT)
                from 
                    dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE_2(@ACTUALONLY,@CURRENCYTYPE) ELIGIBLE
                where 
                    ELIGIBLE.ID in (select FINANCIALTRANSACTIONLINEITEM.ID from dbo.FINANCIALTRANSACTIONLINEITEM where FINANCIALTRANSACTIONID = @ID);

                if @TAXCLAIMAMOUNT is null
                return 0;

                return @TAXCLAIMAMOUNT;
            end