UFN_REVENUE_CONSTITUENTREVENUEHISTORYDETAIL_BULK

Returns the appropriate value for the Detail column of the Constituent Revenue History List for revenue records.

Return

Return Type
table

Definition

Copy



create function dbo.UFN_REVENUE_CONSTITUENTREVENUEHISTORYDETAIL_BULK()
returns table
as return (

    select
        REVENUE.ID,
        convert(nvarchar(1024), dbo.UDA_BUILDLIST(distinct RSDETAIL.DETAIL)) as DETAIL
    from dbo.REVENUE
    inner join dbo.REVENUESPLIT on REVENUESPLIT.REVENUEID = REVENUE.ID
    inner join dbo.UFN_REVENUESPLIT_CONSTITUENTREVENUEHISTORYDETAIL_BULK()
        as RSDETAIL on RSDETAIL.ID = REVENUESPLIT.ID
    group by REVENUE.ID
)