USP_GLACCOUNTMAPPINGERROR_DELETE
Executes the "Unmapped Transaction Error: Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | nvarchar(255) | 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_GLACCOUNTMAPPINGERROR_DELETE
(
@ID nvarchar(255),
@CHANGEAGENTID uniqueidentifier
)
as begin
update dbo.GLACCOUNTMAPPINGERROR set
DELETED = 1
,CHANGEDBYID = @CHANGEAGENTID
,DATECHANGED = GETDATE()
where DELETED = 0 and ERRORMESSAGE = @ID
return 0;
end