UFN_INSTALLMENT_GETINSTALLMENTSPLITAMOUNTAPPLIED

Returns the amount applied for an installment split

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@INSTALLMENTSPLITID	uniqueidentifier	IN

Definition

Copy



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

                select 
                    @RETVAL = (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 @RETVAL;
            end