Added in Version 6.2
The OPPORTUNITY_CAMPAIGN table stores information about opportunities that are the result of marketing campaigns. This table links the Opportunity table to the CAMPAIGN table.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OPPORTUNITY_CAMPAIGNID (PK) (FK) |
STANDARDID (12) |
NOT NULL |
OPPORTUNITY_CAMPAIGN_ID_PK (CA) |
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
OPPORTUNITYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CAMPAIGNID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |