USP_REVENUESPLIT_CREATEREFUND

            CREATE procedure dbo.USP_REVENUESPLIT_CREATEREFUND
            (
                @REVENUESPLITID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime,
                @REFUNDSOURCECODE tinyint
            )
            as
                set nocount on

                insert into dbo.REVENUESPLITGIFTAIDREFUND
                (
                    REVENUESPLITID, 
                    CONSTITUENTID,
                    ORIGINALGIFTAMOUNT, 
                    ORIGINALTAXCLAIMNUMBER, 
                    ORIGINALBASETAXCLAIMAMOUNT, 
                    ORIGINALTRANSITIONALTAXCLAIMAMOUNT, 
                    INCLUDETRANSITIONALAMOUNTCODE, 
                    DATEREFUNDED, 
                    REFUNDSOURCECODE, 
                    ORIGINALCHARITYCLAIMREFERENCENUMBER,
                    ORIGINALGIFTDATE,
                    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED,
                    ORIGINALCLAIMEDASSPONSORSHIP,
                    ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT, 
                    ORIGINALTRANSACTIONCURRENCYID, 
                    ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT,
                    ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT, 
                    ORIGINALORGANIZATIONEXCHANGERATEID, 
                    ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT,
                    ORIGINALBASECURRENCYID, 
                    ORIGINALBASEEXCHANGERATEID,
                    ORIGINALTRANSACTIONGIFTAMOUNT,
                    ORIGINALORGANIZATIONGIFTAMOUNT
                )
                select 
                    @REVENUESPLITID, 
                    REVENUE.CONSTITUENTID,
                    REVENUESPLIT.BASEAMOUNT,
                    REVENUESPLITGIFTAID.TAXCLAIMNUMBER, 
                    REVENUESPLITGIFTAID.BASETAXCLAIMAMOUNT, 
                    REVENUESPLITGIFTAID.TRANSITIONALTAXCLAIMAMOUNT, 
                    REVENUESPLITGIFTAID.INCLUDETRANSITIONALAMOUNTCODE,                    
                    @CHANGEDATE, 
                    @REFUNDSOURCECODE, 
                    REVENUESPLITGIFTAID.CHARITYCLAIMREFERENCENUMBER,
                    cast(REVENUE.DATE as datetime),
                    @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE,
                    REVENUESPLITGIFTAID.CLAIMEDASSPONSORSHIP,
                    REVENUESPLITGIFTAID.TRANSACTIONBASETAXCLAIMAMOUNT,
                    REVENUESPLITGIFTAID.TRANSACTIONCURRENCYID,
                    REVENUESPLITGIFTAID.TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT,
                    REVENUESPLITGIFTAID.ORGANIZATIONBASETAXCLAIMAMOUNT,
                    REVENUESPLITGIFTAID.ORGANIZATIONEXCHANGERATEID,
                    REVENUESPLITGIFTAID.ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT,
                    REVENUESPLITGIFTAID.BASECURRENCYID,
                    REVENUESPLITGIFTAID.BASEEXCHANGERATEID,
                    REVENUESPLIT.TRANSACTIONAMOUNT,
                    REVENUESPLIT.ORGAMOUNT
                from dbo.FINANCIALTRANSACTIONLINEITEM REVENUESPLIT
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT.ID = REVENUESPLIT_EXT.ID
                inner join dbo.REVENUESPLITGIFTAID on REVENUESPLIT.ID = REVENUESPLITGIFTAID.ID
                inner join dbo.FINANCIALTRANSACTION REVENUE on REVENUESPLIT.FINANCIALTRANSACTIONID = REVENUE.ID
                inner join dbo.REVENUE_EXT on REVENUE.ID = REVENUE_EXT.ID
                where REVENUESPLIT.ID = @REVENUESPLITID
                    and REVENUE.TYPECODE in (0,1,2,3,4,5,6,7,8,9) and REVENUESPLIT.DELETEDON is null and REVENUESPLIT.TYPECODE != 1

                update dbo.REVENUESPLITGIFTAID set 
                    TAXCLAIMNUMBER = '',
                    CHARITYCLAIMREFERENCENUMBER = '',
                    INCLUDETRANSITIONALAMOUNTCODE = 0                    
                    where ID = @REVENUESPLITID