contact_notes_v1
Contact notes are used to raise queries, complaints and log interaction to improve communication, understanding and traceability throughout the whole site.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the contact note. |
| reference | VARCHAR(80) | The reference of the contact note that is auto populated or inputted as free text. |
| subject | VARCHAR(200) | The subject of the contact note inputted as free text. |
| contact | VARCHAR(256) | The contact of the contact note. |
| parent_contact | VARCHAR(256) | The parent contact of the contact note. |
| contact_group | VARCHAR(100) | The group of the contact of the contact note. |
| creator | VARCHAR(100) | The creator of the contact note. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the contact note creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the contact note was deleted. |
| owner | VARCHAR(100) | The owner of the contact note. |
| progress_percentage | NUMBER(38,0) | The percentage progress indicator of the contact note. |
| progressed_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the contact note progress update. |
| due_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the contact note is due. |
| completed_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the contact note completion. |
| completion_details | VARCHAR(16777216) | Any comments related to the completion of the task or activity represented on the note. |
| type | VARCHAR(100) | The type of the contact note as configured by the user in Administration panel. |
| status | VARCHAR(50) | The status of the contact note. Possible values: 'Open', 'Completed', 'Cancelled'. |
| flag | VARCHAR(100) | The 'Note Flag' field is used to indicate the status or stage of a note in a process, or to signal if input is needed from another department or identify areas of interest quickly. |
| priority | VARCHAR(100) | The 'Note Priority' field is used to classify the importance or urgency of a note. This field helps in prioritising tasks or actions based on the value assigned to each note. |
| description | VARCHAR(16777216) | The note description that is inputted as free text. |
| open_in_hours | NUMBER(38,2) | The duration that the contact note was open for (in hours) since its creation. |
| open_in_days | NUMBER(38,2) | The duration that the contact note was open for (in days) since its creation. |
| completed_in_hours | NUMBER(38,2) | The time to completion of the contact note in hours. |
| completed_in_days | NUMBER(38,2) | The time to completion of the contact note in days. |
| overdue_in_hours | NUMBER(38,2) | Time the contact note is overdue by, in hours. |
| overdue_in_days | NUMBER(38,2) | Time the contact note is overdue by, in days. |
| _person_id | VARCHAR(256) | The identifier of the person associated with the contact note. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the contact note. |
| _parent_contact_note_id | NUMBER(38,0) | The identifier of the parent contact note associated with the contact note. |
| _parent_job_note_id | NUMBER(38,0) | The identifier of the parent job note associated with the contact note. |
| _parent_stock_item_note_id | NUMBER(38,0) | The identifier of the parent stock item note associated with the contact note. |
| _parent_resource_note_id | NUMBER(38,0) | The identifier of the parent resource note associated with the contact note. |
| _parent_vehicle_note_id | NUMBER(38,0) | The identifier of the parent vehicle note associated with the contact note. |
| _parent_sales_opportunity_note_id | NUMBER(38,0) | The identifier of the parent sales opportunity note associated with the contact note. |
| _parent_contract_note_id | NUMBER(38,0) | The identifier of the parent contract note associated with the contact note. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the contact note record was last refreshed. |