USP_CREDITCARDTRANSACTION_MARKSETTLED

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

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

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

                        update dbo.[CREDITCARDPAYMENTMETHODDETAIL]
                        set
                            [SETTLEMENTTYPECODE] = 1,
                            [SETTLEMENTDATE] = @CURRENTDATE,
                            [CHANGEDBYID] = @CHANGEAGENTID,
                            [DATECHANGED] = @CURRENTDATE
                        where [ID] = @ID;

                    end