USP_DATALIST_EVENTEXPENSES

Displays the expenses for the given event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@INCLUDESUBEVENTS	bit	IN	Include sub-events

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTEXPENSES(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier = null, 
    @INCLUDESUBEVENTS bit = 0
    )
as
    set nocount on;

    select EVENTEXPENSE.ID,
           TYPECODE.DESCRIPTION,
           EVENTEXPENSE.VENDORID,
           VENDOR_NF.NAME,
           EVENTEXPENSE.BUDGETEDAMOUNT,
           EVENTEXPENSE.ACTUALAMOUNT,
           EVENTEXPENSE.AMOUNTPAID,
           EVENTEXPENSE.DATEDUE,
           EVENTEXPENSE.DATEPAID,
           EVENTEXPENSE.COMMENT,
           EVENTS.NAME EVENTNAME,
           EVENTEXPENSE.BASECURRENCYID
    from 
        dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID) EVENTS
    inner join
        dbo.EVENTEXPENSE on EVENTEXPENSE.EVENTID = EVENTS.ID
    inner join
        dbo.EVENTEXPENSETYPECODE TYPECODE on TYPECODE.ID = EVENTEXPENSE.EVENTEXPENSETYPECODEID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTEXPENSE.VENDORID) VENDOR_NF
    where 
        EVENTS.ID = @EVENTID
    or
        @INCLUDESUBEVENTS = 1
    order by
        EVENTS.LEVEL asc,
        EVENTS.NAME asc,
        DESCRIPTION;