NameDescriptionTypeAdditional information
id

Primary Key

globally unique identifier

Required

task_id

Task id

globally unique identifier

Optionally required : task_id, task_reference_back_office or task must be provided

task_reference_back_office

Embedded code "task" using ERP PK when adding/updating task_activity_log

string

Optionally required : task_id, task_reference_back_office or task must be provided

task

Embedded entity "task" using node when adding/updating task_activity_log

task

Optionally required : task_id, task_reference_back_office or task must be provided

task_activity_id

task_activity_id

globally unique identifier

Optionally required : task_activity_id, task_activity_reference_back_office or task_activity must be provided

task_activity_reference_back_office

Embedded code "task_activity" using ERP PK when adding/updating task_activity_log

string

Optionally required : task_activity_id, task_activity_reference_back_office or task_activity must be provided

task_activity

Embedded entity "task_activity" using node when adding/updating task_activity_log

task_activity

Optionally required : task_activity_id, task_activity_reference_back_office or task_activity must be provided

user_id

user_id

globally unique identifier

Optionally required : user_id, user_code or user must be provided

user_code

Embedded code "user" using ERP PK when adding/updating task_activity_log

string

Optionally required : user_id, user_code or user must be provided

user

Embedded entity "user" using node when adding/updating task_activity_log

user

Optionally required : user_id, user_code or user must be provided

contact_id

contact_id

globally unique identifier

Optionally required : contact_id, contact_reference_back_office or contact must be provided

contact_reference_back_office

Embedded code "contact" using ERP PK when adding/updating task_activity_log

string

Optionally required : contact_id, contact_reference_back_office or contact must be provided

contact

Embedded entity "contact" using node when adding/updating task_activity_log

contact

Optionally required : contact_id, contact_reference_back_office or contact must be provided

subject

Saubject

string

Max length: 64

description

Description

string
due_date

Date+Time of the due date

date

Required

is_closed

is_closed

boolean
date_closed

Date+Time of the date_closed

date

Required

reference_back_office

reference_back_office of task_activity_log

string
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

date