UFN_REVENUEBATCH_GETINSTALLMENTSPLITSFORPAYMENTPLEDGE

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENTID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_REVENUEBATCH_GETINSTALLMENTSPLITSFORPAYMENTPLEDGE
      (
          @BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENTID uniqueidentifier
      )
      returns table
      as return
      (
          select
              ID,
              INSTALLMENTSPLITID,
              DESIGNATIONID,
              AMOUNT
          from BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENTSPLIT
          where BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENTID = @BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENTID
      )