UFN_PLEDGE_GETMISSEDTRANSACTIONCOUNT

Returns the number of consecutive missed installments between the last paid installment and the as of date.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            create function [dbo].[UFN_PLEDGE_GETMISSEDTRANSACTIONCOUNT] (
                    @REVENUEID uniqueidentifier, 
                    @ASOFDATE datetime) 
                returns int

            begin
                declare @LASTINSTALLMENTPAIDDATE datetime
                declare @RETVAL  int

                set @RETVAL = 0

                select @LASTINSTALLMENTPAIDDATE = min(INSTALLMENT.DATE) 
                from dbo.INSTALLMENT 
                where INSTALLMENT.ID = dbo.UFN_INSTALLMENT_GETLASTINSTALLMENTPAID(@REVENUEID)

                select @RETVAL = count(INSTALLMENT.ID) 
                from dbo.INSTALLMENT
                where (@LASTINSTALLMENTPAIDDATE is null or INSTALLMENT.DATE > @LASTINSTALLMENTPAIDDATE)
                and INSTALLMENT.DATE <= @ASOFDATE
                and INSTALLMENT.REVENUEID = @REVENUEID

                return @RETVAL
            end