USP_INVOICE_RELEASEPAYMENT
Executes the "Invoice: Release Hold Payment" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being updated. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the update. |
Definition
Copy
create procedure dbo.USP_INVOICE_RELEASEPAYMENT
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
update dbo.INVOICE
set HOLDPAYMENT = 0
,CHANGEDBYID = @CHANGEAGENTID
,DATECHANGED = @CURRENTDATE
from dbo.INVOICE I
where I.ID = @ID
return 0;
end