While this table does not have a field defined as a primary key, the SALESPROCESSAUDITID field should be unique and considered a primary key.
Added in Version 6.2
The SALESPROCESSAUDIT table is a child table to SalesProcesses and stores sales process items.
|
|
While this table does not have a field defined as a primary key, the SALESPROCESSAUDITID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SALESPROCESSAUDITID |
char(12) |
NULLS |
SALESPROCESSAUDIT_ID (IE) |
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
COMPLETED |
char(1) |
NULLS |
|
|
|
|
STARTEDBY |
varchar(64) |
NULLS |
|
|
|
|
COMPLETEDBY |
varchar(64) |
NULLS |
|
|
|
|
NAME |
varchar(64) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
STATUS |
varchar(32) |
NULLS |
|
|
|
|
ENTITYID |
char(12) |
NULLS |
SALESPROCESSAUDIT_ENTITYID (IE) |
(Many) to (One) |
|
|
PROBABILITY |
float(8) |
NULLS |
|
|
|
|
STAGEORDER |
int(4) |
NULLS |
|
|
|
|
STEPORDER |
int(4) |
NULLS |
|
|
|
|
PROCESSTYPE |
varchar(32) |
NULLS |
|
|
|
|
NEXTID |
varchar(64) |
NULLS |
|
|
|
|
ACTIONTYPE |
varchar(32) |
NULLS |
|
|
|
|
REQUIRED |
char(1) |
NULLS |
|
|
|
|
ESTDAYS |
float(8) |
NULLS |
|
|
|
|
DATA |
image(16) |
NULLS |
|
|
|
|
SEQ |
int(4) |
NULLS |
|
|
|
|
STAGENAME |
varchar(64) |
NULLS |
|
|
|
|
STEPNAME |
varchar(64) |
NULLS |
|
|
|
|
STARTDATE |
datetime(8) |
NULLS |
|
|
|
|
COMPLETEDDATE |
datetime(8) |
NULLS |
|
|
|
|
STAGEGUIDID |
varchar(64) |
NULLS |
|
|
|
|
STEPGUIDID |
varchar(64) |
NULLS |
|
|
|
|
STAGEID |
char(12) |
NULLS |
SALESPROCESSAUDIT_STAGEID (IE) |
|
|
|
UPDATEPROBABILITY |
char(1) |
NULLS |
|
|
|
|
INWEB |
char(1) |
NULLS |
|
|
|
|
INLAN |
char(1) |
NULLS |
|
|
|
|
ISCURRENT |
char(1) |
NULLS |
|
|
|
|
SALESPROCESSID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |