UFN_PLEDGE_GETINSTALLMENTS

Returns all the installments for a pledge.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PLEDGE_GETINSTALLMENTS
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return 
                (
                    select
                        INSTALLMENT.ID,
                        INSTALLMENT.TRANSACTIONAMOUNT,
                        INSTALLMENT.DATE,
                        INSTALLMENT.TRANSACTIONAMOUNT - coalesce(sum([PAYMENT].AMOUNT), 0) as [BALANCE],
                        cast(0.0 as money) as [APPLIED],
                        INSTALLMENT.SEQUENCE
                    from dbo.INSTALLMENT
                    left join INSTALLMENTPAYMENT as [PAYMENT] on [PAYMENT].INSTALLMENTID = INSTALLMENT.ID
                    where INSTALLMENT.REVENUEID = @REVENUEID
                    group by INSTALLMENT.ID, INSTALLMENT.TRANSACTIONAMOUNT, INSTALLMENT.DATE, INSTALLMENT.SEQUENCE
                );