UFN_REVENUE_GETOLDNEXTINSTALLMENT

Returns the installment ID of the next installment that is due for a revenue detail.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@PAYMENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_GETOLDNEXTINSTALLMENT
            (
                @REVENUEID uniqueidentifier,
                @PAYMENTID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                if @PAYMENTID is null
                    return dbo.UFN_REVENUE_GETNEXTINSTALLMENT(@REVENUEID);

                return
                (
                    select top 1 ID
                    from dbo.INSTALLMENT
                    where REVENUEID = @REVENUEID
                    and dbo.UFN_INSTALLMENT_GETOLDINSTALLMENTBALANCE(INSTALLMENT.ID, @PAYMENTID) <> 0
                    order by DATE asc
                );
            end