The ACT_UserDef table contains Act! user-defined contact information that has been imported into Infor CRM and is a child table of the CONTACT table.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CONTACTID (PK)(FK) |
STANDARDID |
NOT NULL |
ACT_USERDEF_CONTACTID_PK (CA) |
(One) to (One) |
|
|
USER1 |
varchar(50) |
NULLS |
|
|
|
|
USER2 |
varchar(50) |
NULLS |
|
|
|
|
USER3 |
varchar(50) |
NULLS |
|
|
|
|
USER4 |
varchar(50) |
NULLS |
|
|
|
|
USER5 |
varchar(50) |
NULLS |
|
|
|
|
USER6 |
varchar(50) |
NULLS |
|
|
|
|
USER7 |
varchar(75) |
NULLS |
|
|
|
|
USER8 |
varchar(75) |
NULLS |
|
|
|
|
USER9 |
varchar(75) |
NULLS |
|
|
|
|
USER10 |
varchar(50) |
NULLS |
|
|
|
|
USER11 |
varchar(50) |
NULLS |
|
|
|
|
USER12 |
varchar(50) |
NULLS |
|
|
|
|
USER13 |
varchar(50) |
NULLS |
|
|
|
|
USER14 |
varchar(50) |
NULLS |
|
|
|
|
USER15 |
varchar(50) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
ALT1_CONT |
varchar(64) |
NULLS |
|
|
|
|
ALT1_PHONE |
varchar(32) |
NULLS |
|
|
|
|
ALT1_TITL |
varchar(64) |
NULLS |
|
|
|
|
ALT2_CONT |
varchar(64) |
NULLS |
|
|
|
|
ALT2_PHONE |
varchar(32) |
NULLS |
|
|
|
|
ALT2_TITL |
varchar(64) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |