UFN_REVENUESPLIT_GETTAXCLAIMAMOUNT_2

Returns the tax claim amount for the split.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@REVENUESPLITID	uniqueidentifier	IN
@TRANSACTIONTYPECODE	tinyint	IN
@APPLICATIONCODE	tinyint	IN
@CURRENCYTYPE	tinyint	IN

Definition

Copy



            create function dbo.UFN_REVENUESPLIT_GETTAXCLAIMAMOUNT_2
            (
                @REVENUESPLITID uniqueidentifier,
                @TRANSACTIONTYPECODE tinyint,
                @APPLICATIONCODE tinyint,
                @CURRENCYTYPE tinyint -- 0 = Base, 1 = Transaction, 2 = Organization

            )
            returns money
            as
            begin
                declare @TAXCLAIMAMOUNT money

                -- Transaction type = Payment, Application code = Donation, Event, Pledge, Recurring Gift or Membership

                if @TRANSACTIONTYPECODE = 0 and @APPLICATIONCODE in (0, 1, 2, 3, 5)
                    set @TAXCLAIMAMOUNT = dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT_2(@REVENUESPLITID, 1, @CURRENCYTYPE)
                else if @TRANSACTIONTYPECODE = 1
                    select top 1 @TAXCLAIMAMOUNT = (BASETAXCLAIMAMOUNT + TRANSITIONALTAXCLAIMAMOUNT) from dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGETAXCLAIMAMOUNT_2(@REVENUESPLITID, @CURRENCYTYPE)

                set @TAXCLAIMAMOUNT = coalesce(@TAXCLAIMAMOUNT, 0)

                return @TAXCLAIMAMOUNT
            end