The OPPORTUNITY_USER table stores information about Infor CRM users who are members of the sales team for an opportunity.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OPPUSERID (PK) |
STANDARDID (12) |
NOT NULL |
OPPORTUNITY_USER_OPPUSERID_PK (CA) |
||
|
USERID (FK) |
STANDARDID (12) |
NOT NULL |
OPPORTUNITY_USER_USERID (IE) |
(Many) to (One) |
|
|
OPPORTUNITYID (FK) |
STANDARDID (12) |
NOT NULL |
OPPORTUNITY_USER_OPPID (IE) |
(Many) to (One) |
|
|
SLXROLE |
varchar(32) |
NULLS |
|
|
|
|
NOTES |
varchar(128) |
NULLS |
|
|
|
|
ISPRIMARY |
BOOLEAN(1) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SALESROLE |
varchar(32) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|