If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.)
The Contact table stores detailed information about Infor CRM contacts. The information contains contact first name, last name, department, type of contact, telephone numbers, e-mail addresses, account name, contact interests and personal details, contact location, weight in the account relationship, preferred method of corresponding with the contact, and other information. The CONTACT table also includes many user-defined fields.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.) |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CONTACTID (PK) |
STANDARDID |
NOT NULL |
CONTACT_CONTACTID_PK (AK) |
(One) to (Many) |
|
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
CONTACTACCOUNTINGENTITY.CONTACTID | ||||
| (One) to (Many) | CONTACTAUDIT.CONTACTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | CONTACTUSER.CONTACTID | ||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPBILLTOCONTACT.CONTACTID | ||||
| (One) to (Many) | ERPCONTACTACCOUNT.CONTACTID | ||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPPAYFROMCONTACT.CONTACTID | ||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPSHIPTOCONTACT.CONTACTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | QUOTE.REQUESTEDBYID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
TYPE |
varchar(64) |
NULLS |
CONTACT_TYPE (IE) |
|
|
|
ACCOUNTID(FK) |
STANDARDID |
NULLS |
CONTACT_ACCOUNTID (IE) |
(Many) to (One) |
|
|
ACCOUNT |
varchar(128) |
NULLS |
CONTACT_ACCOUNT (IE) |
|
|
|
DEPARTMENT |
varchar(32) |
NULLS |
|
|
|
|
ISPRIMARY |
BOOLEAN |
NULLS |
|
|
|
|
LASTNAME |
varchar(32) |
NULLS |
CONTACT_LASTNAME (IE) |
|
|
|
FIRSTNAME |
varchar(32) |
NULLS |
CONTACT_FIRSTNAME (IE) |
|
|
|
MIDDLENAME |
varchar(32) |
NULLS |
|
|
|
|
PREFIX |
varchar(16) |
NULLS |
|
|
|
|
SUFFIX |
varchar(16) |
NULLS |
|
|
|
|
ADDRESSID(FK) |
STANDARDID |
NULLS |
CONTACT_ADDRESSID (IE) |
(Many) to (One) |
(primary address) |
|
SHIPPINGID(FK) |
STANDARDID |
NULLS |
CONTACT_SHIPPINGID (IE) |
(Many) to (One) |
|
|
WORKPHONE |
varchar(32) |
NULLS |
|
|
|
|
HOMEPHONE |
varchar(32) |
NULLS |
|
|
|
|
FAX |
varchar(32) |
NULLS |
|
|
|
|
MOBILE |
varchar(32) |
NULLS |
|
|
|
|
PAGER |
varchar(32) |
NULLS |
|
|
|
|
PINNUMBER |
varchar(7) |
NULLS |
|
|
|
|
PAGERNUMERIC |
varchar(32) |
NULLS |
|
|
|
|
|
varchar(128) |
NULLS |
CONTACT_EMAIL (IE) |
|
|
|
SECONDARYEMAIL |
varchar(128) |
NULLS |
CONTACT_SECONDARY |
|
|
|
WEBADDRESS |
varchar(128) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
TITLE |
varchar(64) |
NULLS |
CONTACT_TITLE (IE) |
|
|
|
ASSISTANT |
varchar(64) |
NULLS |
|
|
|
|
BIRTHDAY |
datetime(8) |
NULLS |
|
|
|
|
SPOUSE |
varchar(64) |
NULLS |
|
|
|
|
SPOUSEBIRTHDAY |
datetime(8) |
NULLS |
|
|
|
|
ALUMNI |
varchar(64) |
NULLS |
|
|
|
|
YEARGRADUATED |
int |
NULLS |
|
|
|
|
INTERESTS |
varchar(128) |
NULLS |
|
|
|
|
PREVIOUSEMPLOYER |
varchar(64) |
NULLS |
|
|
|
|
DIRECTIONS |
Textblob |
NULLS |
|
|
|
|
REPORTSTO |
varchar(64) |
NULLS |
|
|
|
|
SECCODEID (FK) |
STANDARDID |
NOT NULL |
CONTACT_SECCODEID (CA) |
(Many) to (One) |
|
|
ACCOUNTMANAGERID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
REGIONALMANAGERID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
DIVISIONALMANAGERID(FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
STATUS |
varchar(64) |
NULLS |
CONTACT_STATUS (IE) |
|
|
|
CREATEDATE |
datetime |
NULLS |
CONTACT_CREATEDATE (IE) |
|
|
|
CREATEUSER(FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
CONTACT_MODIFYDATE (IE) |
|
|
|
MODIFYUSER(FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
REFERRAL |
varchar(64) |
NULLS |
|
|
|
|
LASTNAME_UC |
varchar(32) |
NULLS |
CONTACT_LASTNAMEUC (IE) |
|
|
|
INITIALS |
varchar(32) |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
CONTACT_ALTERNATEKEYPREFIX (IE) |
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
CONTACT_ALTERNATEKEYSUFFIX (IE) |
|
|
|
LOCATIONCODE |
STANDARDID |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
WEBPASSWORD |
varchar(20) |
NULLS |
|
|
|
|
WEBUSERNAME |
varchar(30) |
NULLS |
CONTACT_WEBUSERNAME (IE) |
|
|
|
WEIGHT |
STANDARDID |
NULLS |
|
|
|
|
DONOTSOLICIT |
BOOLEAN |
NULLS |
|
|
|
|
SCORE |
varchar(32) |
NULLS |
|
|
|
|
EMAIL3 |
varchar(128) |
NULLS |
CONTACT_EMAIL3 (IE) |
|
|
|
DONOTEMAIL |
char(1) |
NULLS |
|
|
|
|
DONOTPHONE |
char(1) |
NULLS |
|
|
|
|
DONOTMAIL |
char(1) |
NULLS |
|
|
|
|
DONOTFAX |
char(1) |
NULLS |
|
|
|
|
IMPORTSOURCE |
varchar(24) |
NULLS |
|
|
|
|
SUBTYPE |
varchar(64) |
NULLS |
|
|
|
|
OTHERPHONE |
varchar(32) |
NULLS |
|
|
|
|
PREFERRED_CONTACT |
varchar(64) |
NULLS |
|
|
|
|
WEBPASSWORDHINT |
varchar(64) |
NULLS |
|
|
|
|
ISSERVICEAUTHORIZED |
char(1) |
NULLS |
|
|
|
|
CUISINEPREF |
varchar(64) |
NULLS |
|
|
|
|
CHILDREN |
varchar(64) |
NULLS |
|
|
|
|
LASTHISTORYDATE |
datetime |
NULLS |
|
|
|
|
LASTHISTORYBY |
char(12) |
NULLS |
|
(Many) to (One)
|
|
|
WEBADDRESS2 |
varchar(128) |
NULLS |
|
|
|
|
SALUTATION |
varchar(64) |
NULLS |
|
|
|
|
CATEGORIES |
varchar(255) |
NULLS |
|
|
|
|
APPID (FK) |
char(12) |
NULLS |
(Many) to (One) | ||
|
GLOBALSYNCID |
varchar(36) |
NULLS |
|||
|
TICK |
int |
NULLS |
|||
|
ACTIVEFLAG |
varchar(1) |
NULLS |
|
|
|
|
GENDER |
varchar(16) |
NULLS |
|
|
|
|
PREFERREDNAME |
varchar(32) |
NULLS |
|
|
|
|
NATIONALITY |
varchar(64) |
NULLS |
|
|
|
|
PRIMARYLANGUAGE |
varchar(2) |
NULLS |
|
|
|
|
MARITALSTATUS |
varchar(32) |
NULLS |
|
|
|
|
COMPANYCONTEXT |
varchar(32) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
|
SLXUSERASSOCIATIONID |
char(12) |
NULLS |
|
|
|
|
CHANGEKEY |
varchar(36) |
NULLS |
|
|
|
| WEBPASSWORDRESETTOKEN | varchar(32) | NULLS | |||
| WEBTOKENEXPIRATION | datetime(8) | NULLS | |||
| ERPLASTUPDATEDATE | datetime(8) | NULLS | |||
| ERPEXTID | varchar(100) | NULLS | CONTACT_ERPEXTID(IE) | ||
| ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS | |||
| ERPLOGICALID | varchar(255) | NULLS | |||
| ERPSTATUS | varchar(64) | NULLS | |||
| ERPUNIQUEID | varchar(377) | NULLS | CONTACT_ERPUNIQUEID(IE) | ||
| ERPVARIATIONID | varchar(22) | NULLS | |||
| SYNCSTATUS | varchar(64) | NULLS | |||
| ALTERNATEKEYPREFIX | varchar(8) | NULLS | |||
| ALTERNATEKEYSUFFIX | varchar(24) | NULLS | |||
|
ERPNOTES |
text |
NULLS |