Activities Table Formats (Activity)
Follow Vision specifications for preparing a file containing activity data.
Field Name | Data Type | Length | Notes |
---|---|---|---|
Client | varchar | ||
ContactLastName | varchar | ||
ContactFirstName | varchar | ||
Opportunity | varchar | ||
WBS1 | varchar | ||
WBS2 | varchar | ||
WBS3 | varchar | ||
Employee | varchar | ||
Type | varchar | ||
Subject | varchar | ||
StartDate | datetime | ||
EndDate | datetime | ||
Location | varchar | ||
ReminderDate | datetime | ||
ReminderTime | varchar | ||
Priority | varchar | ||
Notes | text | ||
ShowTimeAs | varchar | ||
AllDayEventInd | varchar | ||
CompletionInd | varchar | ||
RecurrenceInd | varchar | ||
PrivateInd | varchar | ||
TaskStatus | varchar | ||
TaskCompletionDate | datetime | ||
CampaignCode | varchar | ||
RecurrType | varchar | ||
RecurrDailyFreq | smallint | ||
RecurrDailyWeekDay | varchar | ||
RecurrWeeklyFreq | smallint | ||
RecurWeeklySun | varchar | ||
RecurrWeeklyMon | varchar | ||
RecurrWeeklyTue | varchar | ||
RecurrWeeklyWed | varchar | ||
RecurrWeeklyThu | varchar | ||
RecurrWeeklyFri | varchar | ||
RecurrWeeklySat | varchar | ||
RecurrMonthlyFreq | smallint | ||
RecurrMonthlyDay | smallint | ||
RecurrYearlyMonth | smallint | ||
RecurrYearlyDay | smallint | ||
RecurrStartDate | datetime | ||
RecurrEndType | varchar | ||
RP | varchar | ||
EmailAlertSent | datetime |