UFN_REVENUE_EVENTREVENUEDETAILS

Provide revenue details per constituent in a given FAF event

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



CREATE function [dbo].[UFN_REVENUE_EVENTREVENUEDETAILS]
(
    @EVENTID as uniqueidentifier
)
returns TABLE
as
return
    select  
             CONSTITUENTID
            ,TRANSACTIONTYPE
            ,sum([ORIGINAL AMOUNT]) as [ORIGINAL AMOUNT]
            ,sum([APPLIED AMOUNT])  as [APPLIED AMOUNT]                
    from    [dbo].[UFN_REVENUE_EVENT](@EVENTID)
    group    by CONSTITUENTID,TRANSACTIONTYPE;