While this table does not have a field defined as a primary key, the IMPORTTEMPLATEID field should be unique and considered a primary key.
Added in Version 7.2.1
The IMPORTTEMPLATE table stores import template information that can be reused in future lead imports. The template includes field mappings, defaults and Comma Separated Value (CSV) file format options settings.
|
|
While this table does not have a field defined as a primary key, the IMPORTTEMPLATEID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
IMPORTTEMPLATEID |
char(12) |
NOT NULL |
IMPORTTEMPLATE_PRIMARY (AK) |
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
TEMPLATENAME |
varchar(64) |
NOT NULL |
|
|
|
|
DATA |
text(16) |
NULLS |
|
|
|
|
ENTITYTYPE |
varchar(255) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
| ENTITYNAME | varchar(64) | NULLS | |||
| ISSYSTEMTEMPLATE | char(1) | NULLS |