UFN_BATCHEVENT_GETEXPENSES_2

Returns all expenses for a given batch event record with currency.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEVENTID	uniqueidentifier	IN

Definition

Copy



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