CONTACTUSER Table

Added in Version 8.1

The CONTACTUSER table associates a contact to a Infor CRM user. This table was added for multiple attendees per activity functionality.

 

  • While this table does not have a field defined as a primary key, the CONTACTUSERID field should be unique and considered a primary key.

  • CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.

Legend

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

CONTACTUSERID

STANDARDID

NOT NULL

CONTACTUSER_PRIMARY (AK)

 

 

CONTACTID (FK)

STANDARDID

NOT NULL

 

(Many) to (One)

CONTACT.CONTACTID

CREATEUSER

STANDARDID

NULLS

 

 

 

CREATEDATE

datetime

NULLS

 

 

 

MODIFYUSER

STANDARDID

NULLS

 

 

 

MODIFYDATE

datetime

NULLS

 

 

 

USERID

STANDARDID

NOT NULL

 

(Many) to (One)

USERSECURITY_USERID