UFN_INSTALLMENT_GETWRITEOFFINSTALLMENTS_2

Returns all installments that can be written off for a given pledge.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_INSTALLMENT_GETWRITEOFFINSTALLMENTS_2(@REVENUEID uniqueidentifier)
            returns table            
            as            
            return (
                select 
                    INSTALLMENT.ID, 
                    INSTALLMENT.DATE,
                    INSTALLMENT.AMOUNT,
                    coalesce(dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(INSTALLMENT.ID),0) as BALANCE,
                    cast(0.0 as money) as WRITEOFFAMOUNT,
                    INSTALLMENT.SEQUENCE,
                    INSTALLMENT.BASECURRENCYID,
                    INSTALLMENT.ORGANIZATIONAMOUNT,
                    INSTALLMENT.ORGANIZATIONEXCHANGERATEID,
                    INSTALLMENT.TRANSACTIONAMOUNT,
                    INSTALLMENT.TRANSACTIONCURRENCYID,
                    INSTALLMENT.BASEEXCHANGERATEID
                from 
                    dbo.INSTALLMENT 
                where 
                    REVENUEID = @REVENUEID
                    and dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(ID) > 0
                )