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