The GM_Profile table contains GoldMine® user-defined information that has been imported into Infor CRM.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
GM_PROFILEID (PK) |
STANDARDID(12) |
NOT NULL |
GM_PROFILE_GMPROFILE_PK (CA) |
|
|
|
PROFILE |
varchar(30) |
NULLS |
|
|
|
|
REFERENCE |
varchar(35) |
NULLS |
|
|
|
|
FIELD1 |
varchar(20) |
NULLS |
|
|
|
|
FIELD2 |
varchar(20) |
NULLS |
|
|
|
|
FIELD3 |
varchar(20) |
NULLS |
|
|
|
|
FIELD4 |
varchar(10) |
NULLS |
|
|
|
|
FIELD5 |
varchar(6) |
NULLS |
|
|
|
|
FIELD6 |
varchar(2) |
NULLS |
|
|
|
|
FIELD7 |
varchar(40) |
NULLS |
|
|
|
|
FIELD8 |
varchar(40) |
NULLS |
|
|
|
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
CONTACTID (FK) |
STANDARDID(12) |
NULLS |
GMPROFILE_CONTACTID (IE) |
(Many) to (One) |
|
|
ACCOUNTID (FK) |
STANDARDID(12) |
NULLS |
GMPROFILE_ACCOUNTID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|