UFN_DISBURSEMENTPROCESSSIGNATURE_GETRANGE

Get the next value for the disbursement process template signature

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode
@DISBURSEMENTPROCESSID	uniqueidentifier	IN
@TYPECODE	tinyint	IN
@FROMAMOUNT	money	IN

Definition

Copy



            create function dbo.UFN_DISBURSEMENTPROCESSSIGNATURE_GETRANGE
            (
                @DISBURSEMENTPROCESSID 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.DISBURSEMENTPROCESSSIGNATURE S
            where 
                S.FROMAMOUNT > @FROMAMOUNT and 
                S.DISBURSEMENTPROCESSID = @DISBURSEMENTPROCESSID and 
                S.TYPECODE = @TYPECODE
            return substring(@DESC, 0, len(@DESC) - 1)

            end