USP_DATALIST_VENDOREVENTEXPENSE
Returns a list of all event expenses for a given vendor.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_VENDOREVENTEXPENSE(
@CONSTITUENTID uniqueidentifier
)
as
set nocount on;
select
EVENT.ID,
EVENT.NAME,
EVENT.STARTDATE,
(select NAME from dbo.EVENTLOCATION where ID = EVENT.EVENTLOCATIONID),
EVENTEXPENSE.ID,
(select DESCRIPTION from dbo.EVENTEXPENSETYPECODE where EVENTEXPENSETYPECODE.ID = EVENTEXPENSE.EVENTEXPENSETYPECODEID),
EVENTEXPENSE.BUDGETEDAMOUNT,
EVENTEXPENSE.ACTUALAMOUNT,
EVENTEXPENSE.AMOUNTPAID,
EVENTEXPENSE.DATEDUE,
EVENTEXPENSE.DATEPAID,
EVENTEXPENSE.BASECURRENCYID
from
dbo.CONSTITUENT as VENDOR
inner join dbo.EVENTEXPENSE on VENDOR.ID = EVENTEXPENSE.VENDORID
inner join dbo.EVENT on EVENTEXPENSE.EVENTID = EVENT.ID
where
VENDOR.ID = @CONSTITUENTID
order by
EVENT.NAME;