USP_SAVE_TRANSACTIONSTATE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TransactionId | uniqueidentifier | IN | |
| @OrderId | uniqueidentifier | IN | |
| @data | ntext | IN | |
| @Status | int | IN |
Definition
Copy
create procedure dbo.USP_SAVE_TRANSACTIONSTATE
@TransactionId uniqueidentifier,
@OrderId uniqueidentifier,
@data ntext,
@Status integer
as
begin
declare @CHANGEAGENTID uniqueidentifier;
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
insert into [dbo].[CMSTRANSACTIONSTATE](TRANSACTIONID,ORDERID,DATA,STATUS,ADDEDBYID,CHANGEDBYID)
values(@TransactionId,@OrderId,@data,@Status,@CHANGEAGENTID,@CHANGEAGENTID);
end