UFN_REVENUEBATCH_GETINSTALLMENTSFORPAYMENTPLEDGE

Returns all installments for a pledge added during the revenue batch process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEAPPLICATIONPLEDGEID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_REVENUEBATCH_GETINSTALLMENTSFORPAYMENTPLEDGE
      (
          @BATCHREVENUEAPPLICATIONPLEDGEID uniqueidentifier
      )
      returns table
      as return
      (
          select
              ID,
              AMOUNT,
              DATE,
              SEQUENCE,
              RECEIPTAMOUNT
          from BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENT
          where BATCHREVENUEAPPLICATIONPLEDGEID = @BATCHREVENUEAPPLICATIONPLEDGEID
      )