The OPPORTUNITY_CONTACT table stores information about contacts that are associated with an opportunity. The information includes the contact's influence in the decision, whether the contact is the primary individual for the opportunity, their sales role, and other details.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OPPCONTACTID (PK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_CONTACT_OPPCONTACTID_PK (CA) |
|
|
|
CONTACTID (FK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_CONTACTID (IE) |
(Many) to One) |
|
|
OPPORTUNITYID (FK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_CONTACT_OPPID (IE) |
(Many) to One) |
|
|
ISPRIMARY |
BOOLEAN(1) |
NULLS |
|
|
|
|
INFLUENCE |
varchar(64) |
NULLS |
|
|
|
|
ISSUES |
varchar(128) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to One) |
|
|
COMPETITORID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to One) |
|
|
STRATEGY |
varchar(64) |
NULLS |
|
|
|
|
STANDING |
varchar(64) |
NULLS |
|
|
|
|
PERSONALBENEFITS |
varchar(128) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to One) |
|
|
SALESROLE |
varchar(64) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|