V_SEARCH_RE7REVENUE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | yes | |
| DESCRIPTION | nvarchar(391) | yes | |
| FULLNAME | nvarchar(255) | yes | |
| DATE | datetime | yes | |
| REVENUETYPE | nvarchar(30) | yes | |
| AMOUNT | money | ||
| FUND | nvarchar(100) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:21 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_RE7REVENUE AS
select
[R].[LOCALID] [ID],
[C].[FULLNAME] + ' - ' + [TC].[DESCRIPTION] + ' - ' + [F].[DESCRIPTION] [DESCRIPTION],
[C].[FULLNAME],
[R].[DATE],
[TC].[DESCRIPTION] [REVENUETYPE],
[RS].[AMOUNT],
[F].[DESCRIPTION] [FUND]
from dbo.[RE7_REVENUESPLIT] [RS]
left outer join dbo.[RE7_REVENUE] [R] on [RS].[REVENUE_LOCALID] = [R].[LOCALID]
left outer join dbo.[RE7_CONSTITUENT] [C] on [R].[CONSTITUENT_LOCALID] = [C].[LOCALID]
left outer join dbo.[RE7_REVENUETYPECODE] [TC] on [R].[TYPECODE_LOCALID] = [TC].[LOCALID]
left outer join dbo.[RE7_FUND] [F] on [RS].[FUND_LOCALID] = [F].[LOCALID]