USP_RECORDOPERATION_FINANCIALTRANSACTIONNOTEDELETEPROMPT
Provides the prompt for the "Financial Transaction Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @FINANCIALTRANSACTIONTYPE | nvarchar(100) | INOUT |
Definition
Copy
create procedure dbo.USP_RECORDOPERATION_FINANCIALTRANSACTIONNOTEDELETEPROMPT
(
@ID uniqueidentifier,
@FINANCIALTRANSACTIONTYPE nvarchar(100) output
)
as
set nocount on;
select
@FINANCIALTRANSACTIONTYPE = LOWER(TYPE)
from
dbo.FINANCIALTRANSACTION
where
ID = @ID;
return 0;