contacts_v1
Contacts are entities with whom a business maintains a relationship. These contacts can include customers, clients, partners, suppliers, or any other stakeholders that the business interacts with regularly.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the contact. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of contact creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of contact deletion. |
| expires_at | DATE | The date of contact expiry. |
| name | VARCHAR(256) | The name of the contact. |
| parent_contact_name | VARCHAR(256) | The name of the parent contact. |
| group_name | VARCHAR(100) | The name of the contact group. |
| person | VARCHAR(256) | The primary person of the contact. |
| VARCHAR(200) | The email of the primary person of the contact. | |
| phone | VARCHAR(60) | The phone number of the primary person of the contact. |
| address_street | VARCHAR(200) | The address street of the contact. |
| address_town | VARCHAR(200) | The address town of the contact. |
| address_postal_code | VARCHAR(20) | The postal code of the contact. |
| address_country | VARCHAR(100) | The address country of the contact. |
| address_country_code | VARCHAR(2) | The ISO 3166-1 alpha-2 code based on the 'address_country' column. |
| reference | VARCHAR(80) | The internal reference of the contact. |
| account_reference | VARCHAR(256) | The account reference of the contact. |
| additional_information | VARCHAR(1200) | Additional information associated with the contact. |
| is_contact_flagged | VARCHAR(3) | Indicates if the contact is flagged to provide additional information about the contact when displayed elsewhere in the platform. Possible values: 'Yes', 'No'. |
| flagged_reason | VARCHAR(500) | Flagged reason. |
| is_contact_on_stop | VARCHAR(3) | Indicates if the contact is on stop. Possible values: 'Yes', 'No'. |
| on_stop_reason | VARCHAR(500) | On stop reason. |
| is_on_stop_applied_to_sub_contacts | VARCHAR(3) | Indicates if on stop indicator is applied to sub-contacts. Possible values: 'Yes', 'No'. |
| geolocation_latitude | FLOAT | The geolocation latitude of the contact. This is the latitude of the centroid of the shape describing contact location on the map. |
| geolocation_longitude | FLOAT | The geolocation longitude of the contact. This is the longitude of the centroid of the shape describing contact location on the map. |
| geolocation | VARCHAR(64) | The geolocation latitude and longitude of the contact. |
| _parent_contact_id | NUMBER(38,0) | The identifier of the parent contact. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the contact record was last refreshed. |