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