USP_RECEIVABLEPAYMENT_UPDATECREDITCARDPROCESSED

Updates the given receivable payment with the credit card processing information.

Parameters

Parameter Parameter Type Mode Description
@RECEIVABLEPAYMENTID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN
@AUTHORIZATIONCODE nvarchar(20) IN
@TRANSACTIONID uniqueidentifier IN

Definition

Copy


            CREATE procedure dbo.USP_RECEIVABLEPAYMENT_UPDATECREDITCARDPROCESSED
            (
                @RECEIVABLEPAYMENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @AUTHORIZATIONCODE nvarchar(20),
                @TRANSACTIONID uniqueidentifier
            )
            as
            begin
                declare @CURRENTDATE datetime;        
                set @CURRENTDATE = GetDate();

                update dbo.RECEIVABLEPAYMENTCREDITCARD
                    set AUTHORIZATIONCODE = @AUTHORIZATIONCODE,
                        TRANSACTIONID = @TRANSACTIONID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                where RECEIVABLEPAYMENTCREDITCARD.ID = @RECEIVABLEPAYMENTID;
            end