UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETRANGE
Get the next value for the disbursement process template signature
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DISBURSEMENTPROCESSTEMPLATEID | uniqueidentifier | IN | |
| @TYPECODE | tinyint | IN | |
| @FROMAMOUNT | money | IN |
Definition
Copy
create function dbo.UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETRANGE
(
@DISBURSEMENTPROCESSTEMPLATEID uniqueidentifier,
@TYPECODE tinyint,
@FROMAMOUNT money
)
returns nvarchar(100)
with execute as caller
as begin
declare @DESC nvarchar(100);
declare @ID uniqueidentifier;
select @DESC = CAST((MIN(S.FROMAMOUNT) - 0.01) as nvarchar)
from dbo.DISBURSEMENTPROCESSTEMPLATESIGNATURE S
where S.FROMAMOUNT > @FROMAMOUNT and
S.DISBURSEMENTPROCESSTEMPLATEID = @DISBURSEMENTPROCESSTEMPLATEID and
S.TYPECODE = @TYPECODE
return substring(@DESC, 0, len(@DESC) - 1)
end