The OPPORTUNITY_PRODUCT table stores information about products that are associated with each opportunity.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OPPPRODUCTID (PK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_PRODUCT_OPPRODUCTID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
OPPORTUNITYID (FK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_PRODUCT_OPPID (IE) |
(Many) to (One) |
|
|
PRODUCTID (FK) |
STANDARDID(12) |
NOT NULL |
OPPORTUNITY_PRODUCT_PRODUCTID (IE) |
(Many) to (One) |
|
|
QUANTITY |
float(8) |
NULLS |
|
|
|
|
DISCOUNT |
float(8) |
NULLS |
|
|
|
|
PRICE |
decimal(17,4) |
NULLS |
|
|
|
|
NOTES |
varchar(128) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
EXTENDEDPRICE |
decimal(17,4) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
CALCPRICE |
decimal(17,4) |
NULLS |
|
|
|
|
UNIT |
varchar(64) |
NULLS |
|
|
|
|
PROGRAM |
varchar(64) |
NULLS |
|
|
|
|
PRICEEFFDATE |
datetime(8) |
NULLS |
|
|
|
|
PRICEADJUSTED |
BOOLEAN(1) |
NULLS |
|
|
|
|
ESTIMATEDCLOSE |
datetime(8) |
NULLS |
|
|
|
|
ACTUALCLOSE |
datetime(8) |
NULLS |
|
|
|
|
CLOSEPROBABILITY |
float(8) |
NULLS |
|
|
|
|
SORT |
int(4) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| UNITOFMEASUREID | nchar(12) |
NULLS |
|||
| ATPDATE | datetime(8) |
NULLS |
|||
| AVAILABLEQUANTITY | float |
NULLS |
|||
| DOCCALCULATEDPRICE | decimal(17,4) |
NULLS |
|||
| DOCEXTENDEDPRICE | decimal(17,4) |
NULLS |
|||
| CONFIGURATIONID |
nvarchar(64) |
NULLS |
|||
| CONFIGURATIONDETAILID |
nvarchar(64) |
NULLS |