Timesheet

Name	DataType	Export (Related Object)	Import
acct_date	DATE	—
approved	DATE
created	DATE	—
dflt_category_id (Export) default_categoryid (Import)	ID
dflt_category_<field_name>	See Category	—
dflt_customer_id (Export) default_customerid (Import)	ID
dflt_customer_<field_name>	See Customer	—
dflt_invoice_layoutid	ID	—	—
dflt_invoice_prefix	TEXT	—	—
dflt_invoice_text	TEXT	—	—
dflt_payrolltype_id (Export) default_payrolltypeid (Import)	ID
dflt_payrolltype_<field_name>	See Payroll Type	—
dflt_project_id (Export) default_projectid (Import)	ID
dflt_project_<field_name> project_<field_name>	See Project	—	—
dflt_timetype_id (Export) default_timetypeid (Import)	ID
timetype_<field_name>	See Time Type		—
duration	NOT_SET
ends	DATE
errors	NOT_SET	—	—
log	NOT_SET	—	—
id	ID
name	NOT_SET
notes	NOT_SET
starts	DATE
status	NOT_SET
submitted	DATE
thin_clientid	NOT_SET	—
total	NUMBER
updated	DATE
userid	ID
user_<field_name>	See User	—	—
warnings	NOT_SET	—	—

Name

DataType

Export

Export (Related Object)

Import

acct_date

DATE

Check mark

—

Check mark

approved

DATE

Check mark

created

DATE

Check mark

—

Check mark

dflt_category_id (Export)
default_categoryid (Import)

Check mark

dflt_category_<field_name>

See Category

Check mark

—

Check mark

dflt_customer_id (Export)
default_customerid (Import)

Check mark

dflt_customer_<field_name>

See Customer

Check mark

—

Check mark

dflt_invoice_layoutid

Check mark

—

dflt_invoice_prefix

TEXT

Check mark

—

dflt_invoice_text

TEXT

Check mark

—

dflt_payrolltype_id (Export)
default_payrolltypeid (Import)

Check mark

dflt_payrolltype_<field_name>

See Payroll Type

Check mark

—

Check mark

dflt_project_id (Export)
default_projectid (Import)

Check mark

dflt_project_<field_name>
project_<field_name>

See Project

Check mark

—

dflt_timetype_id (Export)
default_timetypeid (Import)

Check mark

timetype_<field_name>

See Time Type

Check mark

—

duration

NOT_SET

Check mark

ends

DATE

Check mark

errors

NOT_SET

Check mark

—

log

NOT_SET

Check mark

—

Check mark

name

NOT_SET

Check mark

notes

NOT_SET

Check mark

starts

DATE

Check mark

status

NOT_SET

Check mark

submitted

DATE

Check mark

thin_clientid

NOT_SET

Check mark

—

Check mark

total

NUMBER

Check mark

updated

DATE

Check mark

userid

Check mark

user_<field_name>

See User

Check mark

—

warnings

NOT_SET

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.