USP_REVENUESPLIT_UPDATEDECLINESGIFTAID

Updates whether a revenue split declines gift aid.
Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@APPLICATIONCODE	tinyint	IN
@REVENUESPLITID	uniqueidentifier	IN
@DESIGNATIONID	uniqueidentifier	IN
@DECLINESGIFTAID	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@ISGIFTAIDSPONSORSHIP	bit	IN
Definition

Copy


            CREATE procedure dbo.USP_REVENUESPLIT_UPDATEDECLINESGIFTAID
            (
                @REVENUEID uniqueidentifier,
                @APPLICATIONCODE tinyint,
                @REVENUESPLITID uniqueidentifier,
                @DESIGNATIONID uniqueidentifier,
                @DECLINESGIFTAID bit,
                @CHANGEAGENTID uniqueidentifier,
                @CURRENTDATE datetime,
                @ISGIFTAIDSPONSORSHIP bit = null
            )
            as
                set nocount on

                -- Gift Aid is for UK only

                if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45fd-8F54-21FE9654EE2D') = 1
                begin
                    declare @TRANSACTIONTYPECODE tinyint,
                            @CONSTITUENTID uniqueidentifier,
                            @DATE datetime,
                            @AMOUNT money,
                            @TRANSACTIONAMOUNT money,
                            @TYPECODE tinyint,
                            @BASECURRENCYID uniqueidentifier,
                            @TRANSACTIONCURRENCYID uniqueidentifier,
                            @BASEEXCHANGERATEID uniqueidentifier,
                            @ORGANIZATIONEXCHANGERATEID uniqueidentifier

                    select
                        @TRANSACTIONTYPECODE = REVENUE.TYPECODE,
                        @CONSTITUENTID = REVENUE.CONSTITUENTID,
                        @DATE = cast(REVENUE.DATE as datetime),
                        @AMOUNT = REVENUESPLIT.BASEAMOUNT,
                        @TRANSACTIONAMOUNT = REVENUESPLIT.TRANSACTIONAMOUNT,
                        @TYPECODE = REVENUESPLIT_EXT.TYPECODE,
                        @BASECURRENCYID = isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, V.BASECURRENCYID),
                        @TRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID,
                        @BASEEXCHANGERATEID = REVENUE.BASEEXCHANGERATEID,
                        @ORGANIZATIONEXCHANGERATEID = REVENUE.ORGEXCHANGERATEID
                    from dbo.FINANCIALTRANSACTIONLINEITEM REVENUESPLIT
                    inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT.ID = REVENUESPLIT_EXT.ID
                    inner join dbo.FINANCIALTRANSACTION REVENUE on REVENUESPLIT.FINANCIALTRANSACTIONID = REVENUE.ID
                    inner join dbo.REVENUE_EXT on REVENUE.ID = REVENUE_EXT.ID
                    left outer join dbo.V_BASECURRENCYFORFINANCIALTRANSACTION_I V with (noexpand) on REVENUE.ID = V.FINANCIALTRANSACTIONID
                    where REVENUESPLIT.ID = @REVENUESPLITID
                        and REVENUESPLIT.TYPECODE <> 1
                        and REVENUESPLIT.DELETEDON is null
                        and REVENUE.DELETEDON is null

                    exec dbo.USP_GIFTAIDREVENUESPLIT_ADDUPDATESPLIT
                                    @REVENUEID = @REVENUEID,
                                    @TRANSACTIONTYPECODE = @TRANSACTIONTYPECODE,
                                    @CONSTITUENTID = @CONSTITUENTID,
                                    @DATE = @DATE,
                                    @SPLITID = @REVENUESPLITID,
                                    @DESIGNATIONID = @DESIGNATIONID,
                                    @AMOUNT = @AMOUNT,
                                    @DECLINESGIFTAID = @DECLINESGIFTAID,
                                    @APPLICATIONCODE = @APPLICATIONCODE,
                                    @TYPECODE = @TYPECODE,
                                    @DISQUALIFIEDBYATTRIBUTES = 1,
                                    @CHANGEAGENTID = @CHANGEAGENTID,
                                    @ISSPONSORSHIP = @ISGIFTAIDSPONSORSHIP,
                                    @TRANSACTIONAMOUNT = @TRANSACTIONAMOUNT,
                                    @BASECURRENCYID = @BASECURRENCYID,
                                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                                    @ORGANIZATIONEXCHANGERATEID = @ORGANIZATIONEXCHANGERATEID
                end