OPPORTUNITYDESIGNATION
Stores Designation for an opportunity.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| AMOUNT | money | Default = 0 | ||
| SEQUENCE | int | Default = 0 | ||
| DATEADDED | datetime | Default = getdate() | Indicates the date this record was added. | |
| DATECHANGED | datetime | Default = getdate() | Indicates the date this record was last changed. | |
| TS | timestamp | Timestamp. | ||
| TSLONG | bigint (Computed) | yes | CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| ORGANIZATIONAMOUNT | money | Default = 0 | The amount of the designation in organization currency. | |
| TRANSACTIONAMOUNT | money | Default = 0 | The amount of the designation in transaction currency. |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| OPPORTUNITYID | uniqueidentifier | OPPORTUNITY.ID | FK to OPPORTUNITY | |
| DESIGNATIONID | uniqueidentifier | yes | DESIGNATION.ID | FK to DESIGNATION |
| ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CONSTITUENTID | uniqueidentifier | yes | CONSTITUENT.LOCALID | FK to CONSTITUENT |
| BASECURRENCYID | uniqueidentifier | yes | CURRENCY.ID | The base currency associated with this designation. |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | CURRENCYEXCHANGERATE.ID | The exchange rate used to convert from amount to organization amount. |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | CURRENCY.ID | The transaction currency associated with this designation. |
| BASEEXCHANGERATEID | uniqueidentifier | yes | CURRENCYEXCHANGERATE.ID | FK to CURRENCYEXCHANGERATE |
| FUNDINGMETHODCODEID | uniqueidentifier | yes | OPPORTUNITYDESIGNATIONFMCODE.ID | FK to OPPORTUNITYDESIGNATIONFMCODE |
| CATEGORYCODEID | uniqueidentifier | yes | PLANNEDGIFTDESCATEGORYCODE.ID | FK to PLANNEDGIFTDESCATEGORYCODE |
| TYPECODEID | uniqueidentifier | yes | OPPORTUNITYDESIGNATIONTYPECODE.ID | FK to OPPORTUNITYDESIGNATIONTYPECODE |
| USECODEID | uniqueidentifier | yes | DESIGNATIONUSECODE.ID | FK to DESIGNATIONUSECODE |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_OPPORTUNITYDESIGNATION_BASECURRENCYID | BASECURRENCYID | |||
| IX_OPPORTUNITYDESIGNATION_CONSTITUENTID | CONSTITUENTID | |||
| IX_OPPORTUNITYDESIGNATION_DATEADDED | DATEADDED | yes | ||
| IX_OPPORTUNITYDESIGNATION_DATECHANGED | DATECHANGED | |||
| IX_OPPORTUNITYDESIGNATION_OPPORTUNITYID | OPPORTUNITYID | |||
| IX_OPPORTUNITYDESIGNATION_ORGANIZATIONEXCHANGERATEID | ORGANIZATIONEXCHANGERATEID | |||
| PK_OPPORTUNITYDESIGNATION | ID | yes | yes |
Triggers
Referenced by
| Referenced by | Field |
|---|---|
| OPPORTUNITYDESIGNATIONCAMPAIGN | OPPORTUNITYDESIGNATIONID |