USP_DATALIST_EVENTGROUPEXPENSES

Displays the expenses for the given event group.

Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENTGROUPEXPENSES(
                    @MAINEVENTID uniqueidentifier
                    )
                as
                    set nocount on;

                    select 
                        EVENTEXPENSE.ID,                        
                        (select DESCRIPTION from dbo.EVENTEXPENSETYPECODE where EVENTEXPENSETYPECODE.ID = EVENTEXPENSE.EVENTEXPENSETYPECODEID),
                        EVENTEXPENSE.VENDORID,
                        NF.NAME,
                        EVENTEXPENSE.BUDGETEDAMOUNT,
                        EVENTEXPENSE.ACTUALAMOUNT,
                        EVENTEXPENSE.AMOUNTPAID,
                        EVENTEXPENSE.DATEDUE,
                        EVENTEXPENSE.DATEPAID,
                        EVENTEXPENSE.COMMENT,
                        EVENT.NAME,
                        EVENT.ID,
                        EVENT.BASECURRENCYID
                    from 
                        dbo.EVENTEXPENSE                         
                        inner join dbo.EVENT on EVENT.ID = EVENTEXPENSE.EVENTID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTEXPENSE.VENDORID) NF
                    where 
                        EVENT.MAINEVENTID = @MAINEVENTID or EVENT.ID = @MAINEVENTID
                    order by
                        EVENTEXPENSE.DATEADDED;