While this table does not have a field defined as a primary key, the IMPORTHISTORYID field should be unique and considered a primary key.
Added in Version 7.2.1
The IMPORTHISTORY table stores import information that occurs during a lead import and when it completed.
|
|
While this table does not have a field defined as a primary key, the IMPORTHISTORYID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
IMPORTHISTORYID (FK) |
char(12) |
NOT NULL |
IMPORTHISTORY_PRIMARY(AK) |
(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 |
|
|
|
|
SECCODEID (FK) |
char(12) |
NOT NULL |
|
(Many) to (One) |
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
ENTITYNAME |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
RECORDCOUNT |
int(4) |
NULLS |
|
|
|
|
PROCESSEDCOUNT |
int(4) |
NULLS |
|
|
|
|
IMPORTEDCOUNT |
int(4) |
NULLS |
|
|
|
|
TEMPLATE |
varchar(64) |
NULLS |
|
|
|
|
DATA |
text(16) |
NULLS |
|
|
|
|
ENTITYTYPE |
varchar(255) |
NULLS |
|
|
|
|
ERRORCOUNT |
int(4) |
NULLS |
|
|
|
|
WARNINGCOUNT |
int(4) |
NULLS |
|
|
|
|
DUPLICATECOUNT |
int(4) |
NULLS |
|
|
|
|
MERGECOUNT |
int(4) |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
|
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
|
|
|
|
PROCESSSTATE |
varchar(32) |
NULLS |
|
|
|
| PRIMARYENTITYGROUP |
nvarchar(255) |
NULLS |
|||
| STATUSCODE |
int |
NULLS |