TimeTracking
Manages QuickBooks Time Tracking events, supporting creation, updates, deletion, and queries for employee or job time entries.
Table Specific Information
This table has a Custom Fields column. See the Custom Fields page for more information.
Select
The following filters support server-side execution. Other filters are executed client-side.
QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for TimeTracking entries are Id, TimeModified, Date, EmployeeName, and EmployeeId. TimeModified and Date may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. ReferenceNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:
SELECT * FROM TimeTracking WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND ReferenceNumber LIKE '%12345%'
Insert
To insert a TimeTracking entry, specify the Employee and Duration columns.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier assigned by QuickBooks when the time-tracking entry is created. It is guaranteed to be unique across all time-tracking entries. | |
| BillableStatus | String | False | 15 |
The billing status of the time entry. If no billing status is set in QuickBooks, this value empty. Common statuses include Billable, NotBillable, or HasBeenBilled. 使用できる値は次のとおりです。Empty, Billable, NotBillable, HasBeenBilled | |
| Date | Date | False |
The date of the time-tracking entry in the format YYYY-MM-DD (for example, 2025-01-01). This field is required when adding a new time-tracking record. | ||
| CustomerName | String | False | 1000 |
The name of the customer associated with the time-tracking entry. This is required when BillableStatus is set to Billable and CustomerId is not provided. | |
| CustomerId | String | False |
Customers.ID | 255 |
The unique identifier for the customer associated with the time-tracking entry. This is required when BillableStatus is set to Billable and CustomerName is not provided. |
| Duration | String | False | 50 |
The duration of time being tracked, represented in the format HH:MM. For example, 2 hours and 30 minutes is represented as '2:30'. | |
| EmployeeName | String | False | 1000 |
The name of the employee, vendor, or subcontractor whose time is being tracked. This is required when EmployeeId is not provided. | |
| EmployeeId | String | False |
Employees.ID | 255 |
The unique identifier for the employee, vendor, or subcontractor whose time is being tracked. This is required when EmployeeName is not provided. |
| Notes | String | False | 5000 |
Optional notes or comments about the time-tracking entry. | |
| Class | String | False | 1000 |
The name of the class associated with the time-tracking entry, used for categorization. | |
| ClassId | String | False |
Class.ID | 255 |
The unique identifier for the class associated with the time-tracking entry. |
| PayrollWageItemName | String | False | 100 |
The name of the payroll wage item, such as Regular Pay or Overtime Pay. This can only be specified if the tracked entity is an employee (not a vendor or subcontractor) and the 'Use time data to create paychecks' option is enabled for the employee in QuickBooks. | |
| PayrollWageItemId | String | False | 255 |
The unique identifier for the payroll wage item, such as Regular Pay or Overtime Pay. This can only be specified if the tracked entity is an employee (not a vendor or subcontractor) and the 'Use time data to create paychecks' option is enabled for the employee in QuickBooks. | |
| ServiceItemName | String | False | 1000 |
The name of the service item representing the type of work performed. This is required if BillableStatus is set to Billable and ServiceItemId is not provided. | |
| ServiceItemId | String | False |
Items.ID | 255 |
The unique identifier for the service item representing the type of work performed. This is required if BillableStatus is set to Billable and ServiceItemName is not provided. |
| EditSequence | String | True | 16 |
A string used for version control to track updates to the time-tracking entry. | |
| TimeModified | Datetime | True |
The date and time when the time-tracking entry was last modified in QuickBooks. | ||
| TimeCreated | Datetime | True |
The date and time when the time-tracking entry was created in QuickBooks. |