V_QUERY_NAMINGOPPORTUNITYRECOGNITION
Provides the ability to query naming opportunity recognitions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ID | |
| NAME | nvarchar(200) | yes | Name |
| NAMINGOPPORTUNITYID | uniqueidentifier | Naming opportunity ID | |
| NAMINGOPPORTUNITY | nvarchar(100) | Naming opportunity | |
| REVENUESPLITID | uniqueidentifier | yes | Revenue split ID |
| REVENUEID | uniqueidentifier | yes | Revenue ID |
| MGOPPORTUNITYLINKID | uniqueidentifier | yes | MG opportunity link ID |
| CONSTITUENT | nvarchar(154) | yes | Constituent |
| CONSTITUENTID | uniqueidentifier | Constituent ID | |
| CONSTITUENTNAMEFORMAT | nvarchar(700) | yes | Constituent name format |
| CONSTITUENTNAMEFORMATID | uniqueidentifier | yes | Constituent name format ID |
| RECOGNITIONNAME | nvarchar(700) | yes | Recognition name |
| STARTDATE | UDT_FUZZYDATE | Recognition date | |
| ENDDATE | UDT_FUZZYDATE | Recognition ends | |
| AMOUNT | money | Amount | |
| QUANTITY | int | Quantity | |
| INSCRIPTION | nvarchar(max) | Inscription | |
| SPECIALREQUEST | nvarchar(max) | Special request | |
| COMMENTS | nvarchar(max) | Comments | |
| OPPORTUNITYID | uniqueidentifier | yes | Opportunity ID |
| PROSPECTPLANID | uniqueidentifier | yes | Prospect plan ID |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ORGANIZATIONAMOUNT | money | Amount (organization currency) | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Currency exchange rate |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:42 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_NAMINGOPPORTUNITYRECOGNITION AS
select
NAMINGOPPORTUNITYRECOGNITION.ID,
dbo.UFN_NAMINGOPPORTUNITYRECOGNITION_BUILDNAME(NAMINGOPPORTUNITYRECOGNITION.ID) as NAME,
NAMINGOPPORTUNITYRECOGNITION.NAMINGOPPORTUNITYID,
NAMINGOPPORTUNITY.NAME as NAMINGOPPORTUNITY,
NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.REVENUESPLITID,
REVENUESPLIT.REVENUEID,
NAMINGOPPORTUNITYRECOGNITIONMGLINK.MGOPPORTUNITYLINKID,
dbo.UFN_CONSTITUENT_BUILDNAME(NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTID) as CONSTITUENT,
NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTID,
dbo.UFN_NAMEFORMAT_GETFORMATTEDNAME(NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAMEFORMATID) as CONSTITUENTNAMEFORMAT,
NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAMEFORMATID,
NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAME as RECOGNITIONNAME,
NAMINGOPPORTUNITYRECOGNITION.STARTDATE,
NAMINGOPPORTUNITYRECOGNITION.ENDDATE,
NAMINGOPPORTUNITYRECOGNITION.AMOUNT,
NAMINGOPPORTUNITYRECOGNITION.QUANTITY,
NAMINGOPPORTUNITYRECOGNITION.INSCRIPTION,
NAMINGOPPORTUNITYRECOGNITION.SPECIALREQUEST,
NAMINGOPPORTUNITYRECOGNITION.COMMENTS,
NAMINGOPPORTUNITYMGOPPORTUNITY.OPPORTUNITYID,
OPPORTUNITY.PROSPECTPLANID,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
NAMINGOPPORTUNITYRECOGNITION.DATEADDED,
NAMINGOPPORTUNITYRECOGNITION.DATECHANGED,
NAMINGOPPORTUNITYRECOGNITION.TSLONG,
NAMINGOPPORTUNITYRECOGNITION.ORGANIZATIONAMOUNT,
NAMINGOPPORTUNITYRECOGNITION.ORGANIZATIONEXCHANGERATEID,
NAMINGOPPORTUNITYRECOGNITION.BASECURRENCYID
/*#EXTENSION*/
from
dbo.NAMINGOPPORTUNITYRECOGNITION
inner join dbo.NAMINGOPPORTUNITY on NAMINGOPPORTUNITY.ID = NAMINGOPPORTUNITYRECOGNITION.NAMINGOPPORTUNITYID
left join dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT on NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.NAMINGOPPORTUNITYRECOGNITIONID = NAMINGOPPORTUNITYRECOGNITION.ID
left join dbo.NAMINGOPPORTUNITYRECOGNITIONMGLINK on NAMINGOPPORTUNITYRECOGNITIONMGLINK.NAMINGOPPORTUNITYRECOGNITIONID = NAMINGOPPORTUNITYRECOGNITION.ID
left join dbo.REVENUESPLIT on REVENUESPLIT.ID = NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.REVENUESPLITID
left join dbo.NAMINGOPPORTUNITYMGOPPORTUNITY on NAMINGOPPORTUNITYMGOPPORTUNITY.ID = NAMINGOPPORTUNITYRECOGNITIONMGLINK.MGOPPORTUNITYLINKID
left join dbo.OPPORTUNITY on OPPORTUNITY.ID = NAMINGOPPORTUNITYMGOPPORTUNITY.OPPORTUNITYID
left join dbo.CHANGEAGENT as ADDEDBY ON ADDEDBY.ID = NAMINGOPPORTUNITYRECOGNITION.ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY ON CHANGEDBY.ID = NAMINGOPPORTUNITYRECOGNITION.CHANGEDBYID