UFN_REVENUEBATCH_GETSPLITSFORPAYMENTPLEDGE

Returns all splits 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_GETSPLITSFORPAYMENTPLEDGE
      (
          @BATCHREVENUEAPPLICATIONPLEDGEID uniqueidentifier
      )
      returns table
      as return
      (
          select
              ID,
              DESIGNATIONID,
              AMOUNT,
          DECLINESGIFTAID
          from BATCHREVENUEAPPLICATIONPLEDGESPLIT
          where BATCHREVENUEAPPLICATIONPLEDGEID = @BATCHREVENUEAPPLICATIONPLEDGEID
      )