| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| task_id |
Foreign key of the task this activity was performed on. |
globally unique identifier | |
| task_activity_id |
Foreign key of the activity type (see ). |
globally unique identifier | |
| user_id |
Foreign key of the user who performed this activity. |
globally unique identifier | |
| contact_id |
Foreign key of the contact this activity was performed with (e.g. who was called). |
globally unique identifier | |
| subject |
Short subject/title of this activity. |
string | |
| description |
Free-text description/notes about this activity. |
string | |
| due_date |
Deadline by which this activity should be completed. |
date | |
| is_closed |
Indicates whether this activity has been completed/closed. |
boolean | |
| date_closed |
Date and time this activity was closed. |
date | |
| reference_back_office |
The Id/Ref of the back office for this activity log. Used by Embedded entity. |
string | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |