UFN_REVENUE_GETPLANNEDGIFTPAYOUTSPLITS

Gets the planned gift payout splits for the given revenue record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_GETPLANNEDGIFTPAYOUTSPLITS
            (
                @REVENUEID uniqueidentifier
            )
            returns table            
            as
            return 
            (
                select 
                    PLANNEDGIFTPAYOUTSPLIT.ID,
                    PLANNEDGIFTPAYOUTSPLIT.APPLICATIONCODE,
                    PLANNEDGIFTPAYOUTSPLIT.TYPECODE,
                    PLANNEDGIFTPAYOUTSPLIT.AMOUNT,
                    PLANNEDGIFTPAYOUTSPLIT.DESIGNATIONID,
                    PLANNEDGIFTPAYOUTSPLIT.BASECURRENCYID,
                    PLANNEDGIFTPAYOUTSPLIT.ORGANIZATIONAMOUNT,
                    PLANNEDGIFTPAYOUTSPLIT.ORGANIZATIONEXCHANGERATEID,
                    PLANNEDGIFTPAYOUTSPLIT.TRANSACTIONAMOUNT,
                    PLANNEDGIFTPAYOUTSPLIT.TRANSACTIONCURRENCYID,
                    PLANNEDGIFTPAYOUTSPLIT.BASEEXCHANGERATEID
                from 
                    dbo.PLANNEDGIFTPAYOUTSPLIT 
                where 
                    REVENUEID = @REVENUEID
            );