UFN_RECOGNITIONCREDIT_GETTAXCLAIMAMOUNT

Returns the gift aid amount for a recognition credit.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@REVENUESPLITID	uniqueidentifier	IN
@REVENUESPLITAMOUNT	money	IN
@RECOGNITIONAMOUNT	money	IN
@TRANSACTIONTYPECODE	tinyint	IN
@APPLICATIONCODE	tinyint	IN

Definition

Copy



            create function dbo.UFN_RECOGNITIONCREDIT_GETTAXCLAIMAMOUNT
            (
                @REVENUESPLITID uniqueidentifier,
                @REVENUESPLITAMOUNT money,
                @RECOGNITIONAMOUNT money,
                @TRANSACTIONTYPECODE tinyint,
                @APPLICATIONCODE tinyint
            )
            returns money
            as
            begin
                declare @REVENUESPLITTAXCLAIMAMOUNT money
                set @REVENUESPLITTAXCLAIMAMOUNT = dbo.UFN_REVENUESPLIT_GETTAXCLAIMAMOUNT(@REVENUESPLITID, @TRANSACTIONTYPECODE, @APPLICATIONCODE)

                declare @RECOGNITIONTAXCLAIMAMOUNT money
                if @RECOGNITIONAMOUNT >= @REVENUESPLITAMOUNT
                    set @RECOGNITIONTAXCLAIMAMOUNT = @REVENUESPLITTAXCLAIMAMOUNT
                else
                begin
                    -- Calculate the recognition tax claim amount based on the ratio of the revenue split's amount to the recognition's amount


                    -- Cast @RECOGNITIONAMOUNT to a decimal(20, 10) so @RATIO has its full precision.

                    declare @RATIO decimal(20, 10)
                    set @RATIO = 0

                    if @REVENUESPLITAMOUNT > 0
                        set @RATIO = cast(@RECOGNITIONAMOUNT as decimal(20, 10)) / @REVENUESPLITAMOUNT

                    set @RECOGNITIONTAXCLAIMAMOUNT = @RATIO * @REVENUESPLITTAXCLAIMAMOUNT
                end

                return @RECOGNITIONTAXCLAIMAMOUNT
            end