Timesheet entry

Name	DataType	Import
acct_date	DATE
category_1id	ID
category_2id	ID
category_3id	ID
category_4id	ID
category_5id	ID
category_externalid	NOT_SET
category_id (Export) categoryid (Import)	ID
category_<field_name>	See Category
cost_center_externalid	NOT_SET
cost_center_id (Export) cost_centerid (Import)	ID
cost_center_<field_name>	See Cost Center	—
created	DATE
customer_id (Export) customerid (Import)	ID
customer_<field_name>	See Customer	—
date	DATE
decimal_hours	NOT_SET
description	NOT_SET
end_time	DATE
hour (Export) hours (Import)	NOT_SET
id	ID
invoice_layoutid	ID	—
invoice_prefix	TEXT	—
invoice_text	TEXT	—
job_codeid	ID
loaded_cost	NUMBER	—
loaded_cost_2	NUMBER	—
loaded_cost_3	NUMBER	—
minute (Export) minutes (Import)	NOT_SET
notes	NOT_SET
payroll_type_id (Export) payroll_typeid (Import)	ID
payroll_type_<field_name>	See Payroll Type	—
project_id (Export) projectid (Import)	ID
project_externalid	NOT_SET
project_<field_name>	See Project	—
projecttask_id (Export) projecttaskid (Import)	ID
projecttask_external_id (Export) project_task_externalid (Import)	NOT_SET
projecttask_typeid	ID
projecttask_<field_name>	See Project Task	—
slip_id (Export) slipid (Import)	ID
slip_<field_name>	See TimeBill	—
start_time	DATE
thin_clientid	NOT_SET	—
timesheet_id (Export) timesheetid (Import)	ID
timesheet_<field_name>	See Timesheet	—
timetype_id (Export) timetypeid (Import)	ID
timetype_externalid	NOT_SET
timetype_<field_name>	See Time Type	—
updated	DATE
user_id (Export) userid (Import)	ID
user_externalid	NOT_SET
user_<field_name>	See User	—

Name

DataType

Export

Import

acct_date

DATE

Check mark

category_1id

Check mark

category_2id

Check mark

category_3id

Check mark

category_4id

Check mark

category_5id

Check mark

category_externalid

NOT_SET

Check mark

category_id (Export)
categoryid (Import)

Check mark

category_<field_name>

See Category

Check mark

cost_center_externalid

NOT_SET

Check mark

cost_center_id (Export)
cost_centerid (Import)

Check mark

cost_center_<field_name>

See Cost Center

Check mark

—

created

DATE

Check mark

customer_id (Export)
customerid (Import)

Check mark

customer_<field_name>

See Customer

Check mark

—

date

DATE

Check mark

decimal_hours

NOT_SET

Check mark

description

NOT_SET

Check mark

end_time

DATE

Check mark

hour (Export)
hours (Import)

NOT_SET

Check mark

invoice_layoutid

Check mark

—

invoice_prefix

TEXT

Check mark

—

invoice_text

TEXT

Check mark

—

job_codeid

Check mark

loaded_cost

NUMBER

Check mark

—

loaded_cost_2

NUMBER

Check mark

—

loaded_cost_3

NUMBER

Check mark

—

minute (Export)
minutes (Import)

NOT_SET

Check mark

notes

NOT_SET

Check mark

payroll_type_id (Export)
payroll_typeid (Import)

Check mark

payroll_type_<field_name>

See Payroll Type

Check mark

—

project_id (Export)
projectid (Import)

Check mark

project_externalid

NOT_SET

Check mark

project_<field_name>

See Project

Check mark

—

projecttask_id (Export)
projecttaskid (Import)

Check mark

projecttask_external_id (Export)
project_task_externalid (Import)

NOT_SET

Check mark

projecttask_typeid

Check mark

projecttask_<field_name>

See Project Task

Check mark

—

slip_id (Export)
slipid (Import)

Check mark

slip_<field_name>

See TimeBill

Check mark

—

start_time

DATE

Check mark

thin_clientid

NOT_SET

Check mark

—

timesheet_id (Export)
timesheetid (Import)

Check mark

timesheet_<field_name>

See Timesheet

Check mark

—

timetype_id (Export)
timetypeid (Import)

Check mark

timetype_externalid

NOT_SET

Check mark

timetype_<field_name>

See Time Type

Check mark

—

updated

DATE

Check mark

user_id (Export)
userid (Import)

Check mark

user_externalid

NOT_SET

Check mark

user_<field_name>

See User

Check mark

—

Guidelines

Review the following guidelines:

By default, it is not possible to modify time entries from a timesheet when:
- The timesheet is submitted for approval, approved, or archived (status value is S, A, or X) in OpenAir. To be able to update approved and archived time entries when importing time entries from a CSV file, the Modify Approved and Archived Timesheets feature must be enabled for your account. To enable the Modify Approved and Archived Timesheets feature, contact OpenAir Customer Support.
- The timesheet has already been exported. To be able to update exported time entries when importing time entries from a CSV file, contact OpenAir Customer Support.
In both cases, the Integration Manager user must be an account administrator or have the necessary role permission to perform the update.

The Integration Manager log shows "Error code 821: The timesheet cannot be modified because it is no longer Open or has been exported" if time entries in a timesheet cannot be updated because the timesheet was approved or exported, and the authenticated user does not have sufficient privileges.
The ability to capture a start time and end time on time entries must be enabled in OpenAir at an account level (Administration > Application Settings > Timesheets > Other Settings) and user level (Administration > Global Settings > Users > Employees > [Select an employee] > Demographic) to import a start_time and end_time.