V_QUERY_RE7_EVENTEXPENSES
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| EVENT_LOCALID | int | yes | |
| EVENTEXPENSETYPE | nvarchar(100) | yes | |
| EXPENSEAMOUNT | money | yes | |
| BUDGETEDAMOUNT | money | yes | |
| AMOUNTPAID | money | yes | |
| EXPENSEDATE | UDT_FUZZYDATE | ||
| SEQUENCE | int | yes | |
| VENDOR_LOCALID | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:26 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_EVENTEXPENSES AS
select
[EE].[LOCALID],
[EE].[EVENT_LOCALID],
[EETC].[DESCRIPTION] [EVENTEXPENSETYPE],
[EE].[EXPENSEAMOUNT],
[EE].[BUDGETEDAMOUNT],
[EE].[AMOUNTPAID],
[EE].[EXPENSEDATE],
[EE].[SEQUENCE],
[EE].[VENDOR_LOCALID]
from dbo.[RE7_EVENTEXPENSES] [EE]
left outer join dbo.[RE7_EVENTEXPENSETYPECODE] [EETC] on [EE].[EXPENSETYPECODE_LOCALID] = [EETC].[LOCALID];