| Name | Description | Type | Additional 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 |