While this table does not have a field defined as a primary key, the SALESPROCESSID field should be unique and considered a primary key.
Added in Version 6.2
The SALESPROCESSES table stores information required for sales processes.
|
|
While this table does not have a field defined as a primary key, the SALESPROCESSID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SALESPROCESSID |
char(12) |
NULLS |
SALESPROCESSES_SALESPROCESSID (CA) |
(One) to (Many) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
ENTITYID |
char(12) |
NULLS |
SALESPROCESSES_ENTITYID (IE) |
(Many) to (One) |
|
|
BASEDONID |
char(12) |
NULLS |
|
|
unknown |
|
NAME |
varchar(64) |
NULLS |
|
|
|
|
ISACTIVE |
char(1) |
NULLS |
|
|
|
|
DATA |
image(16) |
NULLS |
|
|
|
|
LOCKLEVEL |
int(4) |
NULLS |
|
|
|
|
CURRENTSTAGEID |
char(12) |
NULLS |
|
|
unknown |