Task table - SuperOffice

Task Table (67)

Task MDO list item table. Task list table, activity types, like Phone, Meeting

Fields

Name	Description	Type	Nullable
Task_id	Primary key	PK	No
name	The list item	String(239)	No
rank	Rank order	UShort	Yes
tooltip	Tooltip or other description	String(254)	Yes
deleted	0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists	UShort	Yes
record_type	1 = app, 2 = doc, 3 = email, 4 = fax, 5 = phone, 6 = todo - see EAppntRecordTypes	Enum TaskType	No
direction	1 = incoming, 2 = outgoing, see EAppntDirection	Enum TaskDirection	Yes
color_index	JAP	UShort	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
defaultAlldayEvent	Default value for alldayEvent flag	Enum AllDayEvent	Yes
defaultFreeBusy	Default value for Free/Busy indicator	Enum FreeBusy	Yes
defaultPublishType	Should this field be published by default?	Enum PublishType	Yes
intentId	Link to the intention of this kind of task (used by SAINT)	FK Intent	Yes
default_videomeeting_status	Default video-meeting status for meetings created in SuperOffice CRM.	Enum VideoMeetingStatus	No

Task table relationship diagram

Indexes

Fields	Types	Description
name	String(239)	Unique

Relationships

Table	Description
appointment	Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.
associate	Employees, resources and other users - except for External persons
ExternalEvent	The definition of projects as events in Audience (or other Collaborative apps)
Intent	Intent list for SAINT. More information regarding SuperOffice Sales Intelligence on http://techdoc.superoffice.com
s_link	Links in messages to measure success rate of a campaign.
StatusDef	Status definitions. Name and description are in LocaleText for internationalization
SuggestedAppointment	Defines a suggested appointment for use in a Sale Guide or Project Guide
TaskGroupLink	User group link table for Task, for MDO item hiding
TaskHeadingLink	Heading link table for Task, for MDO headers

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

task scheduled_task table BatchTask table BatchTasks TaskMenu table TaskHeadingLink table

⌘I