USP_REVENUETRANSACTION_CHANGERECEIPTPREFERENCE
Executes the "Revenue Transaction: Change Receipt Preference" 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_REVENUETRANSACTION_CHANGERECEIPTPREFERENCE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
if (select top 1 RECEIPTTYPECODE from dbo.REVENUE where ID = @ID) = 0
update
dbo.REVENUE
set
RECEIPTTYPECODE = 1,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = getdate()
where
ID = @ID;
else
update
dbo.REVENUE
set
RECEIPTTYPECODE = 0,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = getdate()
where
ID = @ID;
return 0;
end