UFN_INSTALLMENT_GETAMOUNTTORESCHEDULE

Returns the installment amount available for rescheduling for a given pledge.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@LASTPAYMENTSEQUENCE	int	IN

Definition

Copy



            create function dbo.UFN_INSTALLMENT_GETAMOUNTTORESCHEDULE
            (
                @REVENUEID uniqueidentifier,
                @LASTPAYMENTSEQUENCE int
            )
            returns money
            with execute as caller
            as 
            begin
                declare @AMOUNT money;

                select 
                    @AMOUNT = sum(INSTALLMENT.AMOUNT)
                from
                    dbo.INSTALLMENT 
                where
                    INSTALLMENT.REVENUEID = @REVENUEID
                    and INSTALLMENT.SEQUENCE > @LASTPAYMENTSEQUENCE;

                return @AMOUNT;
            end