UFN_INSTALLMENT_GETINSTALLMENTSPLITBALANCE

Returns the unpaid balance for a given pledge installment split.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@INSTALLMENTSPLITID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITBALANCE
            (
                @INSTALLMENTSPLITID uniqueidentifier
            ) 
            returns money
            with execute as caller
            as begin
                declare @BALANCE money;

                select 
                    @BALANCE = INSTALLMENTSPLIT.TRANSACTIONAMOUNT - (coalesce((select sum(INSTALLMENTSPLITPAYMENT.AMOUNT) from dbo.INSTALLMENTSPLITPAYMENT where INSTALLMENTSPLITPAYMENT.INSTALLMENTSPLITID = @INSTALLMENTSPLITID), 0) + coalesce((select sum(INSTALLMENTSPLITWRITEOFF.TRANSACTIONAMOUNT) from dbo.INSTALLMENTSPLITWRITEOFF where INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = @INSTALLMENTSPLITID), 0))
                from 
                    dbo.INSTALLMENTSPLIT 
                where 
                    INSTALLMENTSPLIT.ID = @INSTALLMENTSPLITID;

                return @BALANCE;
            end