OPPORTUNITY (4.0SP12)

Stores opportunity information for a plan.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
PROSPECTPLANID	uniqueidentifier	false	PROSPECTPLAN.ID	FK to PROSPECTPLAN
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
LIKELIHOODTYPECODEID	uniqueidentifier	true	LIKELIHOODTYPECODE.ID	FK to LIKELIHOODTYPECODE
OPPORTUNITYTYPECODEID	uniqueidentifier	true	OPPORTUNITYTYPECODE.ID	FK to OPPORTUNITYTYPECODE
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this opportunity (always the same as the base currency on the prospect plan to which this opportunity belongs).
TRANSACTIONCURRENCYID	uniqueidentifier	true	CURRENCY.ID	The transaction currency associated with this opportunity.
BASEEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID	FK to CURRENCYEXCHANGERATE
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID	FK to CURRENCYEXCHANGERATE

Fields
Field	Field Type	Null	Notes	Description
EXPECTEDASKAMOUNT	money	false	0
ASKAMOUNT	money	false	0
EXPECTEDASKDATE	datetime	true
ASKDATE	datetime	true
RESPONSEDATE	datetime	true
STATUSCODE	tinyint	false	0	0=Unqualified, 1=Qualified, 2=Response pending, 3=Accepted, 4=Rejected, 5=Canceled
COMMENT	nvarchar(max)	false	''
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
STATUS	nvarchar(16) (Computed)	true		Provides a translation for the 'STATUSCODE' field.
ORGANIZATIONEXPECTEDASKAMOUNT	money	false	0	EXPECTEDASKAMOUNT in organization currency.
ORGANIZATIONASKAMOUNT	money	false	0	ASKAMOUNT in organization currency.
TRANSACTIONEXPECTEDASKAMOUNT	money	false	0	EXPECTEDASKAMOUNT in transaction currency.
TRANSACTIONASKAMOUNT	money	false	0	ASKAMOUNT in transaction currency.
ACCEPTEDASKAMOUNT	money	false	0
TRANSACTIONACCEPTEDASKAMOUNT	money	false	0
ORGANIZATIONACCEPTEDASKAMOUNT	money	false	0
AMOUNT	money (Computed)	true
TRANSACTIONAMOUNT	money (Computed)	true
ORGANIZATIONAMOUNT	money (Computed)	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_OPPORTUNITY_DATEADDED	DATEADDED	False	False	True
IX_OPPORTUNITY_DATECHANGED	DATECHANGED	False	False	False
IX_OPPORTUNITY_PROSPECTPLANID	PROSPECTPLANID	False	False	False
PK_OPPORTUNITY	ID	True	True	False

Triggers
Trigger Name	Description
TR_OPPORTUNITY_TASYNC_I
TR_OPPORTUNITY_TASYNC_U
TR_OPPORTUNITY_TASYNC_D
TR_OPPORTUNITY_AUDIT_UPDATE
TR_OPPORTUNITY_AUDIT_DELETE
TR_OPPORTUNITY_AUDIT_ETLDELETEDID
TR_OPPORTUNITY_INSERTUPDATE_CURRENCY

Referenced by
Referenced by	Field
BATCHEVENTREGISTRANT	OPPORTUNITYID
BATCHMEMBERSHIPDUES	DONATIONOPPORTUNITYID
BATCHREVENUE	OPPORTUNITYID
BATCHREVENUEADDITIONALAPPLICATIONS	OPPORTUNITYID
BATCHREVENUEAPPLICATIONPLEDGE	OPPORTUNITYID
BATCHREVENUEENHANCEDMATCHINGGIFTS	OPPORTUNITYID
EVENTREGISTRATIONOPPORTUNITY	OPPORTUNITYID
NAMINGOPPORTUNITYMGOPPORTUNITY	OPPORTUNITYID
OPPORTUNITYCAMPAIGN	OPPORTUNITYID
OPPORTUNITYDESIGNATION	OPPORTUNITYID
OPPORTUNITYFUNDINGTYPE	OPPORTUNITYID
OPPORTUNITYSOLICITOR	OPPORTUNITYID
REVENUEOPPORTUNITY	OPPORTUNITYID