# Harvest (v1)
Information note **Harvest (v1) end of life**
This version of Harvest reached end of life on **December 1, 2019** and is no longer functioning.
[Upgrade to the latest version (v3) to continue replicating data.](https://help.qlik.com/en-US/stitch/integrations/saas/harvest)
## Harvest integration summary
Stitch’s Harvest integration replicates data using the [Harvest REST API V1](https://help.getharvest.com/api-v1/). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/harvest/v1#schema) section for a list of objects available for replication.
## Harvest feature snapshot
A high-level look at Stitch's Harvest (v1) integration, including release status, useful links, and the features supported in Stitch.
| **STITCH** | | | |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Sunset on December 1, 2019 | **Supported by**
the Info icon
Indicates if the integration is supported by Stitch or the Singer community. | [Singer Community](https://www.singer.io/) |
| **Stitch plan**
the Info icon
The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**
the Info icon
Indicates if the integration is available as a source in Stitch Connect. | the Remove icon
This version of the integration isn't available via the API.
Not available |
| **Singer GitHub repository** | [singer-io/tap-harvest](https://github.com/singer-io/tap-harvest) | | |
| **REPLICATION SETTINGS** | | | |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**
the Info icon
A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon
This feature is supported for this version of the integration.
Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**
the Info icon
A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Remove icon
Advanced Scheduling is not supported for this integration.
Unsupported |
| **Table-level reset**
the Info icon
Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon
Table-level resets are not supported for this integration. Resets are only supported at the integration level.
Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**
the Info icon
Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
Unsupported |
| **DATA SELECTION** | | | |
| **Table selection**
the Info icon
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Remove icon
Table selection is not supported for this integration. All available table and fields will be automatically selected for replication.
Unsupported | **Column selection**
the Info icon
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Remove icon
Column selection is not supported for this integration. All available columns in tables set to replicate will be selected.
Unsupported |
| **Select all**
the Info icon
Indicates if the integration supports selecting all available tables and columns. | the Remove icon
As this integration doesn't support table or column selection, all available tables and columns are automatically replicated.
Unsupported | | |
| **TRANSPARENCY** | | | |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**
the Info icon
Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**
the Info icon
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported |
## Harvest table reference
Information note
**Schemas and versioning**
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for **version 1** of this integration.
Information note
**Table and column names in your destination**
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info.
### clients
The `clients` table contains info about the clients in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/clients-api/clients/using-the-clients-api/ "Opens in new tab: Harvest documentation")
[clients schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/clients.json "Opens in new tab: clients schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/clients-api/clients/using-the-clients-api/#get-all-clients "Opens in new tab: Harvest API method") |
clients table schema
| **active**
BOOLEAN |
| --- |
| **cache\_version**
INTEGER |
| **created\_at**
DATE-TIME |
| **currency**
STRING |
| **currency\_symbol**
STRING |
| **default\_invoice\_timeframe**
STRING |
| **details**
STRING |
| **highrise\_id**
BOOLEAN |
| **id**
INTEGER |
| **last\_invoice\_kind**
STRING |
| **name**
STRING |
| **updated\_at**
DATE-TIME |
### contacts
The `contacts` table contains info about the client contacts in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/clients-api/clients/using-the-client-contacts-api/ "Opens in new tab: Harvest documentation")
[contacts schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/contacts.json "Opens in new tab: contacts schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/clients-api/clients/using-the-client-contacts-api/#get-all-contacts "Opens in new tab: Harvest API method") |
contacts table schema
| **client\_id**
INTEGER |
| --- |
| **created\_at**
DATE-TIME |
| **email**
STRING |
| **fax**
STRING |
| **first\_name**
STRING |
| **id**
INTEGER |
| **last\_name**
STRING |
| **phone\_mobile**
STRING |
| **phone\_office**
STRING |
| **title**
STRING |
| **updated\_at**
DATE-TIME |
### expense\_categories
The `expense_categories` table contains info about the expense categories in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/expenses-api/expenses/expense-categories/ "Opens in new tab: Harvest documentation")
[expense_categories schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/expense_categories.json "Opens in new tab: expense_categories schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/expenses-api/expenses/expense-categories/#show-all-categories "Opens in new tab: Harvest API method") |
expense\_categories table schema
| **created\_at**
DATE-TIME |
| --- |
| **deactivated**
BOOLEAN |
| **id**
INTEGER |
| **name**
STRING |
| **unit\_name**
STRING |
| **unit\_price**
NUMBER |
| **updated\_at**
DATE-TIME |
### expenses
The `expenses` table contains info about the expenses recorded in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/expenses-api/expenses/add-update-expenses/ "Opens in new tab: Harvest documentation")
[expenses schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/expenses.json "Opens in new tab: expenses schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/expenses-api/expenses/add-update-expenses/#show-an-expense "Opens in new tab: Harvest API method") |
expenses table schema
| **billable**
BOOLEAN |
| --- |
| **company\_id**
INTEGER |
| **created\_at**
DATE-TIME |
| **expense\_category\_id**
INTEGER |
| **has\_receipt**
BOOLEAN |
| **id**
INTEGER |
| **invoice\_id**
INTEGER |
| **is\_closed**
BOOLEAN |
| **is\_locked**
BOOLEAN |
| **locked\_reason**
STRING |
| **notes**
STRING |
| **project\_id**
INTEGER |
| **receipt\_url**
STRING |
| **spent\_at**
STRING |
| **total\_cost**
NUMBER |
| **units**
NUMBER |
| **updated\_at**
DATE-TIME |
| **user\_id**
INTEGER |
### invoice\_item\_categories
The `invoice_item_categories` table contains info about the various categories that can be applied to invoice line items.
Note: Harvest includes two non-removable categories by default for the hours and expenses you bill.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/invoices-api/invoices/invoice-messages-payments#invoice-categories "Opens in new tab: Harvest documentation")
[invoice_item_categories schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/invoice_item_categories.json "Opens in new tab: invoice_item_categories schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/invoices-api/invoices/invoice-messages-payments/#show-all-categories "Opens in new tab: Harvest API method") |
invoice\_item\_categories table schema
| **created\_at**
DATE-TIME |
| --- |
| **id**
INTEGER |
| **name**
STRING |
| **updated\_at**
DATE-TIME |
| **use\_as\_expense**
BOOLEAN |
| **use\_as\_service**
BOOLEAN |
### invoice\_messages
The `invoice_messages` table contains info about invoice messages, or emails sent to clients about invoices.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/invoices-api/invoices/invoice-messages-payments/ "Opens in new tab: Harvest documentation")
[invoice_messages schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/invoice_messages.json "Opens in new tab: invoice_messages schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/invoices-api/invoices/invoice-messages-payments/#show-invoice-messages "Opens in new tab: Harvest API method") |
invoice\_messages table schema
| **body**
STRING |
| --- |
| **created\_at**
DATE-TIME |
| **full\_recipient\_list**
STRING |
| **id**
INTEGER |
| **include\_pay\_pal\_link**
BOOLEAN |
| **invoice\_id**
INTEGER |
| **send\_me\_a\_copy**
BOOLEAN |
| **send\_reminder\_on**
DATE-TIME |
| **sent\_by**
STRING |
| **sent\_by\_email**
STRING |
| **sent\_from**
STRING |
| **sent\_from\_email**
STRING |
| **subject**
STRING |
| **thank\_you**
BOOLEAN |
| **updated\_at**
DATE-TIME |
### invoice\_payments
The `invoice_payments` table contains info about the payments applied to invoices in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/invoices-api/invoices/invoice-messages-payments#show-payments-for-an-invoice "Opens in new tab: Harvest documentation")
[invoice_payments schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/invoice_payments.json "Opens in new tab: invoice_payments schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/invoices-api/invoices/invoice-messages-payments/#show-payments-for-an-invoice "Opens in new tab: Harvest API method") |
invoice\_payments table schema
| **amount**
NUMBER |
| --- |
| **authorization**
STRING |
| **created\_at**
DATE-TIME |
| **id**
INTEGER |
| **invoice\_id**
INTEGER |
| **notes**
STRING |
| **paid\_at**
DATE-TIME |
| **payment\_gateway\_id**
INTEGER |
| **paypal\_transaction\_id**
INTEGER |
| **recorded\_by**
STRING |
| **recorded\_by\_email**
STRING |
| **updated\_at**
DATE-TIME |
### invoices
The `invoices` table contains info about the invoices in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/invoices-api/invoices/show-invoices#show-a-single-invoice "Opens in new tab: Harvest documentation")
[invoices schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/invoices.json "Opens in new tab: invoices schema on GitHub") |
invoices table schema
| **amount**
NUMBER |
| --- |
| **client\_id**
INTEGER |
| **client\_key**
STRING |
| **client\_name**
STRING |
| **created\_at**
DATE-TIME |
| **created\_by\_id**
INTEGER |
| **currency**
STRING |
| **discount**
STRING, NUMBER |
| **discount\_amount**
NUMBER |
| **due\_amount**
NUMBER |
| **due\_at**
STRING |
| **due\_at\_human\_format**
STRING |
| **estimate\_id**
INTEGER |
| **id**
INTEGER |
| **issued\_at**
STRING |
| **notes**
STRING |
| **number**
STRING |
| **period\_end**
STRING |
| **period\_start**
STRING |
| **purchase\_order**
STRING |
| **recurring\_invoice\_id**
INTEGER |
| **retainer\_id**
INTEGER |
| **state**
STRING |
| **subject**
STRING |
| **tax**
STRING, NUMBER |
| **tax2**
STRING, NUMBER |
| **tax2\_amount**
NUMBER |
| **tax\_amount**
NUMBER |
| **updated\_at**
DATE-TIME |
### people
The `people` table contains info about the people - or users - in your Harvest account.
**Note**: These are **internal** users. Info about external users, or clients, is in the `clients` table.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/users-api/users/managing-users/ "Opens in new tab: Harvest documentation")
[people schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/people.json "Opens in new tab: people schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/users-api/users/managing-users/#show-all-users "Opens in new tab: Harvest API method") |
people table schema
| **cost\_rate**
NUMBER |
| --- |
| **created\_at**
DATE-TIME |
| **default\_hourly\_rate**
NUMBER |
| **department**
STRING |
| **email**
STRING |
| **first\_name**
STRING |
| **has\_access\_to\_all\_future\_projects**
BOOLEAN |
| **id**
INTEGER |
| **identity\_account\_id**
INTEGER |
| **indentity\_user\_id**
INTEGER |
| **is\_active**
BOOLEAN |
| **is\_admin**
BOOLEAN |
| **is\_contractor**
BOOLEAN |
| **last\_name**
STRING |
| **telephone**
STRING |
| **timezone**
STRING |
| **updated\_at**
DATE-TIME |
| **wants\_newsletter**
BOOLEAN |
### project\_tasks
The `project_tasks` table contains info about the tasks assigned to projects.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/tasks-api/tasks/task-assignments#all-assigned-tasks-to-project "Opens in new tab: Harvest documentation")
[project_tasks schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/project_tasks.json "Opens in new tab: project_tasks schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/tasks-api/tasks/task-assignments/#all-assigned-tasks-to-project "Opens in new tab: Harvest API method") |
project\_tasks table schema
| **billable**
BOOLEAN |
| --- |
| **budget**
NUMBER |
| **created\_at**
DATE-TIME |
| **deactivated**
BOOLEAN |
| **estimate**
NUMBER |
| **hourly\_rate**
NUMBER |
| **id**
INTEGER |
| **project\_id**
INTEGER |
| **task\_id**
INTEGER |
| **updated\_at**
DATE-TIME |
### project\_users
The `project_users` table contains info about the users assigned to projects.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/users-api/users/user-assignments#get-users-assigned-to-projects "Opens in new tab: Harvest documentation")
[project_users schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/project_users.json "Opens in new tab: project_users schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/users-api/users/user-assignments/#get-users-assigned-to-projects "Opens in new tab: Harvest API method") |
project\_users table schema
| **budget**
NUMBER |
| --- |
| **created\_at**
DATE-TIME |
| **deactivated**
BOOLEAN |
| **estimate**
NUMBER |
| **hourly\_rate**
NUMBER |
| **id**
INTEGER |
| **is\_project\_manager**
BOOLEAN |
| **project\_id**
INTEGER |
| **updated\_at**
DATE-TIME |
| **user\_id**
INTEGER |
### projects
The `projects` table contains info about the projects in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/projects-api/projects/create-and-show-projects#projects-parameters "Opens in new tab: Harvest documentation")
[projects schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/projects.json "Opens in new tab: projects schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/projects-api/projects/create-and-show-projects/#show-all-projects "Opens in new tab: Harvest API method") |
projects table schema
| **active**
BOOLEAN |
| --- |
| **bill\_by**
STRING |
| **billable**
BOOLEAN |
| **budget**
NUMBER |
| **budget\_by**
STRING |
| **client\_id**
INTEGER |
| **code**
STRING |
| **cost\_budget**
NUMBER |
| **cost\_budget\_include\_expenses**
BOOLEAN |
| **created\_at**
DATE-TIME |
| **ends\_on**
STRING |
| **estimate**
NUMBER |
| **estimate\_by**
STRING |
| **hint\_earliest\_record\_at**
STRING |
| **hint\_latest\_record\_at**
STRING |
| **hourly\_rate**
NUMBER |
| **id**
INTEGER |
| **name**
STRING |
| **notes**
STRING |
| **notify\_when\_over\_budget**
BOOLEAN |
| **over\_budget\_notification\_percetange**
INTEGER |
| **over\_budget\_notified\_at**
STRING |
| **show\_budget\_to\_all**
BOOLEAN |
| **starts\_on**
STRING |
| **updated\_at**
DATE-TIME |
### tasks
The `tasks` table contains info about the tasks in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/tasks-api/tasks/create-show-tasks/ "Opens in new tab: Harvest documentation")
[tasks schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/tasks.json "Opens in new tab: tasks schema on GitHub")
[Harvest API method](http://help.getharvest.com/api-v1/tasks-api/tasks/create-show-tasks/#show-all-tasks "Opens in new tab: Harvest API method") |
tasks table schema
| **billable\_by\_default**
BOOLEAN |
| --- |
| **created\_at**
DATE-TIME |
| **deactivated**
BOOLEAN |
| **default\_hourly\_rate**
NUMBER |
| **id**
INTEGER |
| **is\_default**
BOOLEAN |
| **name**
STRING |
| **updated\_at**
DATE-TIME |
### time\_entries
The `time_entries` table contains info about the time entries in your Harvest account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [Harvest documentation](http://help.getharvest.com/api-v1/timesheets-api/timesheets/retrieving-time-entries#retrieving-a-single-entry "Opens in new tab: Harvest documentation")
[time_entries schema on GitHub](https://github.com/singer-io/tap-harvest/blob/master/tap_harvest/schemas/time_entries.json "Opens in new tab: time_entries schema on GitHub") |
time\_entries table schema
| **adjustment\_record**
BOOLEAN |
| --- |
| **created\_at**
DATE-TIME |
| **hours**
NUMBER |
| **hours\_with\_timer**
NUMBER |
| **id**
INTEGER |
| **is\_billed**
BOOLEAN |
| **is\_closed**
BOOLEAN |
| **notes**
STRING |
| **project\_id**
INTEGER |
| **spent\_at**
STRING |
| **task\_id**
INTEGER |
| **timer\_started\_at**
DATE-TIME |
| **updated\_at**
DATE-TIME |
| **user\_id**
INTEGER |