UFN_REVENUE_GETNEXTINSTALLMENT

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

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GETNEXTINSTALLMENT
            (
                @REVENUEID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @INSTALLMENTID uniqueidentifier;

                select 
                    @INSTALLMENTID = NEXTINSTALLMENT.INSTALLMENTID
                from 
                    dbo.UFN_REVENUE_GETNEXTINSTALLMENT_BULK() as NEXTINSTALLMENT 
                where 
                    NEXTINSTALLMENT.REVENUEID = @REVENUEID;

                return @INSTALLMENTID;
            end