UFN_PLEDGE_INSTALLMENTSPLITSSUMTOINSTALLMENTS

Validates that the amounts of splits on pledge installments sum up to the installment amounts.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@PLEDGEID	uniqueidentifier	IN

Definition

Copy


CREATE function dbo.UFN_PLEDGE_INSTALLMENTSPLITSSUMTOINSTALLMENTS (@PLEDGEID uniqueidentifier)
returns bit
  with execute as caller
as
begin
  declare @r as int;

  if exists (
      select top 1 1
      from (
        select INSTALLMENTID
          ,sum(INSTALLMENTSPLIT.TRANSACTIONAMOUNT) AMOUNT
        from INSTALLMENTSPLIT
        where PLEDGEID = @PLEDGEID
        group by INSTALLMENTID
        ) a
      full join (
        select ID INSTALLMENTID
          ,TRANSACTIONAMOUNT AMOUNT
        from INSTALLMENT
        where REVENUEID = @PLEDGEID
        ) b on a.INSTALLMENTID = b.INSTALLMENTID
      where coalesce(a.AMOUNT, 0.00) <> coalesce(b.AMOUNT, 0.00)
      )
    return 0

  return 1
end