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. |