If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The OPPORTUNITY table stores information about potential sales opportunities. The information includes opportunity name, account ID, description, products associated to the opportunity, stage, sales potential, estimated and actual closing dates, commitments by key personnel, and other details.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OPPORTUNITYID (PK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_OPPORTUNITYID_PK (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
|
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
ACCOUNTID (FK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_ACCOUNTID (IE) |
(Many) to (One) |
|
|
DESCRIPTION |
varchar(64) |
NULLS |
OPPORTUNITY_DESCRIPTION (IE) |
|
|
|
CLOSED |
BOOLEAN(1) |
NULLS |
|
|
|
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
STAGE |
varchar(64) |
NULLS |
|
|
|
|
SALESCYCLE |
varchar(64) |
NULLS |
|
|
|
|
PRODUCTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SALESPOTENTIAL |
float(8) |
NULLS |
|
|
|
|
CLOSEPROBABILITY |
int(4) |
NULLS |
|
|
|
|
SALESAMOUNT |
decimal (17,4) |
NULLS |
|
|
|
|
ACTUALAMOUNT |
decimal (17,4) |
NULLS |
|
|
|
|
ESTIMATEDCLOSE |
datetime(8) |
NULLS |
|
|
|
|
ACTUALCLOSE |
datetime(8) |
NULLS |
|
|
|
|
SUMMARY |
varchar(128) |
NULLS |
|
|
|
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
ACCOUNTMANAGERID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
REGIONALMANAGERID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
DIVISIONALMANAGERID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
STATUS |
varchar(64) |
NULLS |
OPPORTUNITY_STATUS (IE) |
|
|
|
FIELDCOMMIT |
BOOLEAN(1) |
NULLS |
|
|
|
|
MGTCOMMIT |
BOOLEAN(1) |
NULLS |
|
|
|
|
CORPCOMMIT |
BOOLEAN(1) |
NULLS |
|
|
|
|
MANUFCOMMIT |
BOOLEAN(1) |
NULLS |
|
|
|
|
KEYEDPOTENTIAL |
BOOLEAN(1) |
NULLS |
|
|
|
|
KEYEDPROBABILITY |
BOOLEAN(1) |
NULLS |
|
|
|
|
DAYSINPIPELINE |
int(4) |
NULLS |
|
|
|
|
CURRENTSTEP |
varchar(64) |
NULLS |
|
|
|
|
NEXTSTEP |
varchar(64) |
NULLS |
|
|
|
|
PROJCLOSESTEP |
varchar(64) |
NULLS |
|
|
|
|
REASON |
varchar(64) |
NULLS |
|
|
|
|
CURRENTSTEPDATE |
datetime(8) |
NULLS |
|
|
|
|
NEXTSTEPDATE |
datetime(8) |
NULLS |
|
|
|
|
PROJCLOSEDATE |
datetime(8) |
NULLS |
|
|
|
|
LEADSOURCEID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
LEADDATE |
datetime(8) |
NULLS |
|
|
|
|
SECCODEID (FK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_SECCODEID (CA) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
OPPORTUNITY_CREATEDATE (IE) |
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
OPPORTUNITY_MODIFYDATE (IE) |
|
|
|
WIN |
BOOLEAN(1) |
NULLS |
|
|
|
|
CAMPAIGNID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SUBTYPE |
varchar(64) |
NULLS |
|
|
|
|
ENGINEERID |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SALESENGINEERID |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ESTCLOSEDATE_PROBABILITY |
int(4) |
NULLS |
|
|
|
|
ADDTOFORECAST |
char(1) |
NULLS |
|
|
|
|
EXCHANGERATECODE |
varchar(3) |
NULLS |
|
|
|
|
EXCHANGERATE |
float(8) |
NULLS |
|
|
|
|
EXCHANGERATEDATE |
datetime(8) |
NULLS |
|
|
|
|
EXCHANGERATELOCKED |
char(1) |
NULLS |
|
|
|
|
LASTHISTORYDATE |
datetime(8) |
NULLS |
|
|
|
|
LASTHISTORYBY |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
RESELLERID |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
DATEOPENED |
datetime(8)
|
NULLS
|
|
|
|
|
OVERRIDESALESPOTENTIAL |
varchar(1) |
NULLS |
|
|
|
|
OPERATINGCOMPANYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
PRICELISTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| ALTERNATEKEYPREFIX | varchar(64) |
NULLS |
|||
| ALTERNATEKEYSUFFIX | varchar(64) |
NULLS |
|||
| ERPEXTID | varchar(100) |
NULLS |
|||
| ERPVARIATIONID | varchar(22) |
NULLS |
|||
| SYNCSTATUS | varchar(64) |
NULLS |
|||
| ERPLOCATION | varchar(22) |
NULLS |
|||
| DOCACTUALAMOUNT | decimal(17,4) |
NULLS |
|||
| DOCSALESPOTENTIAL | double |
NULLS |
|||
| ERPUNIQUEID | nvarchar(377) |
NULLS |
|||
| ISNORMALIZED |
nchar(12) |
NULLS |