USP_CREDITCARDTRANSACTION_MARKUNSETTLED

                    CREATE procedure dbo.USP_CREDITCARDTRANSACTION_MARKUNSETTLED
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as begin

                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        declare @MATCHEDID uniqueidentifier

                        select top 1
                            @MATCHEDID = ID
                        from
                            dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW
                        where
                            DATABASETRANSACTIONID = @ID

                        exec dbo.USP_RECORDOPERATION_VIEWBYDISBURSEMENT_MARKUNMATCHED @MATCHEDID, null

                        if exists (select 1 from dbo.[CREDITCARDPAYMENTMETHODDETAIL] where [ID] = @ID)
                            update dbo.[CREDITCARDPAYMENTMETHODDETAIL]
                            set
                                [SETTLEMENTTYPECODE] = 0,
                                [SETTLEMENTDATE] = null,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where [ID] = @ID;
                        else if exists (select 1 from dbo.[CREDITPAYMENT] where [ID] = @ID)
                            update dbo.[CREDITPAYMENT]
                            set
                                [SETTLEMENTTYPECODE] = 0,
                                [SETTLEMENTDATE] = null,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where [ID] = @ID;

                    end