ODBC Driver for QuickBooks Online

Build 25.0.9434

TimeActivities

Contains time entry records for employees or vendors, capturing billable and non-billable hours linked to customers, projects, or payroll.

Note: The CostRate column will not return data unless MinorVersion is set to 65 or above.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True False

The unique identifier (Id) that is assigned by QuickBooks Online to this time activity record. It is used to retrieve or reference the time activity programmatically and is required for updates or deletions.

SyncToken String True False False

The version control token for this time activity record that is used to prevent conflicting updates. QuickBooks Online increments this sync token each time the record is modified, and only the latest sync token is accepted for edits.

MetaData_CreateTime Datetime True True True

The date and time stamp (Coordinated Universal Time) when QuickBooks Online created this time activity record.

MetaData_LastUpdatedTime Datetime True True True

The date and time stamp (Coordinated Universal Time) when this time activity record was last modified in QuickBooks Online.

TxnDate Date False True True

The transaction date of the time activity entry. This date determines which accounting period or payroll period the activity falls into.

NameOf String False False False

The type of person who performs the task. This field indicates whether the time entry was recorded for an employee, a vendor, or another party.

The allowed values are Employee, Vendor.

EmployeeRef String False

Employees.Id

False False

The unique Id of the employee that is associated with this time activity. Either the employee reference Id or the employee reference name must be provided when creating a time activity, and the Id is preferred.

EmployeeRef_Name String True

Employees.DisplayName

False False

The fully qualified name of the employee that is associated with this time activity. A fully qualified name starts with the employee name followed by a colon and any subentry names--up to five levels (for example, Store54:Shane Hamby).

VendorRef String False

Vendors.Id

False False

The unique Id of the vendor that is associated with this time activity. Either the vendor reference Id or the vendor reference name must be provided when creating a time activity, and the Id is preferred.

VendorRef_Name String True

Vendors.DisplayName

False False

The fully qualified name of the vendor that is associated with this time activity. A fully qualified name starts with the vendor name followed by a colon and any subentry names--up to five levels (for example, Rock Construction:Building Materials).

CustomerRef String False

Customers.Id

False False

The unique Id of the customer that is receiving the goods or services for this time activity. For example, if the time is recorded for a job or project such as John Doe:Kitchen, this Id references John Doe.

CustomerRef_Name String True

Customers.DisplayName

False False

The fully qualified name of the customer or organization that is associated with this time activity. A fully qualified name starts with the customer name followed by a colon and any subcustomer names--up to five levels (for example, Rock Construction:Sammuels).

DepartmentRef String False

Departments.Id

False False

The unique Id of the department that is associated with this time activity.

DepartmentRef_Name String True

Departments.Name

False False

The display name of the department that is associated with this time activity.

ItemRef String False

Items.Id

False False

The unique Id of the item that is associated with this time activity. This field is required when creating a time activity record.

ItemRef_Name String True

Items.Name

False False

The display name of the item that is associated with this time activity. This field is required when creating a time activity record.

ClassRef String False

Class.Id

False False

The unique Id of the class that is assigned to this time activity for class tracking and reporting.

ClassRef_Name String True

Class.FullyQualifiedName

False False

The display name of the class that is assigned to this time activity for class tracking and reporting.

PayrollItemRef String False False False

The unique Id of the payroll item that specifies how much the employee should be paid for the work recorded by this time activity. This field links time entries to payroll compensation rules.

BillableStatus String False False False

Indicates whether the time activity is billable to the customer (Billable), not billable (NotBillable), or has been billed (HasBeenBilled). This field controls invoicing and revenue recognition.

The allowed values are Billable, NotBillable, HasBeenBilled.

Taxable Boolean False False False

Indicates whether the time activity recorded is both billable and taxable (true) or not taxable (false).

HourlyRate Decimal False False False

The hourly billing rate of the employee or vendor for this time activity. This rate is used to calculate billable charges on invoices.

Hours Integer False False False

The number of whole hours worked in this time activity. This field, along with Minutes, specifies the total amount of time worked.

Minutes Integer False False False

The number of minutes worked in this time activity (valid values are 0–59). This field, along with Hours, specifies the total amount of time worked.

StartTime Datetime False False False

The date and time stamp when work started for this time activity. This field is used when recording start/end times rather than just total hours.

EndTime Datetime False False False

The date and time stamp when work ended for this time activity. This field is used when recording start and end times rather than just total hours.

Description String False False False

A detailed description of the work completed during this time activity. This description can appear on invoices if the time activity is billable.

TransactionLocationType String False False False

The account location type that is associated with this time activity. This field is valid only in the FR editions.

The allowed values are WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU.

CostRate Decimal False False False

The internal pay rate of the employee or vendor for this time activity. This rate is used for payroll and cost accounting rather than billing the customer.

BreakHours BreakMinutes Integer False False False

The number of hours and minutes of break time that was taken between the start time and end time for this time activity. Use this field when both the start time and end time are specified to record nonworking periods.

ProjectRef String False True False

The unique Id of the project that is associated with this time activity. This field links the time entry to a specific project for project accounting and reporting.

TimeChargeId Integer False True False

The unique Id of the time charge that is generated from this time activity if it is converted into a billable charge. This field links the time activity to its corresponding time charge record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434