# Harvest datasets and fields

> The 4 datasets Maven lands from Harvest, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/harvest

Maven lands 4 datasets from Harvest in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Harvest integration page](https://mavendata.ai/integrations/harvest).

## Connection and sync

You connect Harvest by signing in to it and approving access, so nobody shares a password.

The first Harvest sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

## Datasets

### Time entries

Time tracking entries — hours, rates, billing per user per project.

| Field | Type |
| --- | --- |
| entry ID | Integer |
| date | Text |
| hours | Number |
| project ID | Integer |
| project name | Text |
| task ID | Integer |
| task name | Text |
| client ID | Integer |
| client name | Text |
| user ID | Integer |
| user name | Text |
| is billed | True/false |
| is running | True/false |
| billable | True/false |
| billable rate | Number |
| cost rate | Number |
| billable amount | Number |
| cost amount | Number |
| notes | Text |
| updated at | Timestamp |

### Invoices

Invoice records — amounts, due dates, payment status.

| Field | Type |
| --- | --- |
| invoice ID | Integer |
| client ID | Integer |
| client name | Text |
| number | Text |
| amount | Number |
| due amount | Number |
| tax | Number |
| tax amount | Number |
| state | Text |
| issue date | Text |
| due date | Text |
| sent at | Text |
| paid at | Text |
| currency | Text |
| date | Date |
| updated at | Timestamp |

### Projects

Project snapshot with client linkage and billing configuration.

| Field | Type |
| --- | --- |
| project ID | Integer |
| name | Text |
| client ID | Integer |
| client name | Text |
| code | Text |
| is active | True/false |
| is billable | True/false |
| budget | Number |
| budget by | Text |
| hourly rate | Number |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |

### Clients

Client snapshot used to attach authoritative billing currency to time-entry value.

| Field | Type |
| --- | --- |
| client ID | Integer |
| name | Text |
| is active | True/false |
| currency | Text |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |
