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 Activity table stores information about meetings, phone calls, and to-dos that are scheduled for a user. The information includes activity type, account name, contact name, opportunity name, start date, duration, description, alarms, and other variables associated with an Infor CRM activity. The ACTIVITY table also contains several user-defined fields with the datatype of variable character and length of 255 characters.
Events are stored in the EVENT table and literature requests are stored in the LITREQUEST table.
|
|
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 | Values | Relationship | Related Table and Field |
|---|---|---|---|---|---|---|
|
ACTIVITYID (PK) |
STANDARDID |
NOT NULL |
ACTIVITY_ACTIVITYID_PK (CA) |
|
(One) to (Many) |
ACTIVITYATTENDEE.ACTIVITYID |
|
(One) to (Many) |
ACTIVITYITEM.ACTIVITYID |
|||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
TYPE |
int |
NULLS |
ACTIVITY_TYPE (IE) |
262146=Phone Call, 262145=Meeting, |
|
|
|
ACCOUNTID (FK) |
STANDARDID |
NULLS |
ACTIVITY_ACCOUNTID (IE) |
|
(Many) to (One) |
|
|
CONTACTID (FK) |
STANDARDID |
NULLS |
ACTIVITY_CONTACTID (IE) |
|
(Many) to (One) |
|
|
OPPORTUNITYID (FK) |
STANDARDID |
NULLS |
ACTIVITY_OPPORTUNITYID(IE) |
|
(Many) to (One) |
|
|
PROJECTID |
varchar(32) |
NULLS |
|
|
(Many) to (One) |
|
|
ACCOUNTNAME |
varchar(128) |
NULLS |
|
|
|
|
|
CONTACTNAME |
varchar(128) |
NULLS |
|
|
|
|
|
OPPORTUNITYNAME |
varchar(64) |
NULLS |
|
|
|
|
|
PHONENUMBER |
varchar(32) |
NULLS |
|
|
|
|
|
PRIORITY |
varchar(64) |
NULLS |
|
|
|
|
|
CATEGORY |
varchar(64) |
NULLS |
|
|
|
|
|
STARTDATE |
datetime |
NULLS |
ACTIVITY_STARTDATE (IE) |
|
|
|
|
DURATION |
int |
NULLS |
|
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
|
ALARM |
BOOLEAN |
NULLS |
|
|
|
|
|
ALARMTIME |
datetime |
NULLS |
|
|
|
|
|
ACTIVITYBASEDON (FK) |
STANDARDID |
NULLS |
|
|
(Many) to (One) |
|
|
PROCESSID (FK) |
STANDARDID |
NULLS |
ACTIVITY_PROCESSID (IE) |
|
(Many) to (One) |
|
|
PROCESSNODE |
varchar(16) |
NULLS |
|
|
|
|
|
RECURRING |
BOOLEAN |
NULLS |
|
|
|
|
|
RECURITERATIONS |
int |
NULLS |
|
|
|
|
|
RECURPERIOD |
int |
NULLS |
|
|
|
|
|
RECURPERIODSPEC |
int |
NULLS |
|
|
|
|
|
RECURSKIP |
varchar(255) |
NULLS |
|
|
|
|
|
TIMELESS |
BOOLEAN |
NULLS |
|
|
|
|
|
ROLLOVER |
BOOLEAN |
NULLS |
|
|
|
|
|
USERID (FK) |
STANDARDID |
NOT NULL |
ACTIVITY_USERID (IE) |
|
(Many) to (One) |
|
|
ORIGINALDATE |
datetime |
NULLS |
|
|
|
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
|
(Many) to (One) |
|
|
NOTES |
varchar(255) |
NULLS |
|
|
|
|
|
LONGNOTES |
Textblob |
NULLS |
|
|
|
|
|
ATTACHMENT |
BOOLEAN |
NULLS |
|
|
|
|
|
FOREIGNID1 |
varchar(255) |
NULLS |
|
|
|
|
|
FOREIGNID2 |
varchar(255) |
NULLS |
|
|
|
|
|
FOREIGNID3 |
varchar(255) |
NULLS |
|
|
|
|
|
FOREIGNID4 |
varchar(255) |
NULLS |
|
|
|
|
|
USERDEF1 |
varchar(255) |
NULLS |
|
|
|
|
|
USERDEF2 |
varchar(255) |
NULLS |
|
|
|
|
|
USERDEF3 |
varchar(255) |
NULLS |
|
|
|
|
|
TICKETID (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
LEADID (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
LEADNAME |
varchar(64) |
NULLS |
|
|
|
|
|
TICKETNUMBER |
varchar(64) |
NULLS |
|
|
|
|
|
ATTACHMENTCOUNT |
int |
NULLS |
|
|
|
|
|
LOCATION |
varchar(255) |
NULLS |
|
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
|
|
APPID (FK) |
varchar (12) |
NULLS |
|
|
(Many) to (One) |
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
|
|
|
|
|
TICK |
int |
NULLS |
|
|
|
|
|
ATTENDEECOUNT |
int |
NULLS |
|
|
|
|
|
CHANGEKEY |
varchar(36) |
NULLS |
|
|
|