UFN_BATCHEVENT_GETEXPENSES

Returns all expenses for a given batch event record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEVENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_BATCHEVENT_GETEXPENSES
(
    @BATCHEVENTID uniqueidentifier
) returns table as
    return (
        select
            ID,
            EVENTEXPENSETYPECODEID,
            VENDORID,
            BUDGETEDAMOUNT,
            ACTUALAMOUNT,
            DATEDUE,
            AMOUNTPAID,
            DATEPAID,
            COMMENT
        from
            dbo.BATCHEVENTEXPENSE
        where
            BATCHEVENTID = @BATCHEVENTID
    );