TimeActivities
Create, update, delete, and query QuickBooks Time Activities.
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 Id of the time activity. | |
| SyncToken | String | True | False | False |
Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online. | |
| MetaData_CreateTime | Datetime | True | True | True |
The time the record was created. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The time the record was last updated. | |
| TxnDate | Date | False | True | True |
The date of the time activity. | |
| NameOf | String | False | False | False |
The type of the person who performs the task. 使用できる値は次のとおりです。Employee, Vendor | |
| EmployeeRef | String | False |
Employees.Id | False | False |
The Id of the employee. Either the EmployeeId or EmployeeName is required for the create operation. EmployeeId is preferred. |
| EmployeeRef_Name | String | True |
Employees.DisplayName | False | False |
The fully qualified name for an employee. A fully qualified name starts with the employee name followed by a colon and the employee subentry name. Up to 5 additional subemployees can be declared by appending a colon and subentry name. For example: Store54:Shane Hamby. |
| VendorRef | String | False |
Vendors.Id | False | False |
The Id vendor associated with the transaction. A reference either the VendorId or VendorName is required for the create operation, although VendorId is preferred. |
| VendorRef_Name | String | True |
Vendors.DisplayName | False | False |
The fully qualified name for a vendor. A fully qualified name starts with the name followed by a colon and the subentry name. Up to five levels of subentries can be defined by appending a colon and name for the subentry. For example: Rock Construction:Building Materials. |
| CustomerRef | String | False |
Customers.Id | False | False |
The Id of the customer receiving the goods or services. For example, if the transaction is associated with a job or project, such as John Doe:Kitchen, this Id must reference John Doe. |
| CustomerRef_Name | String | True |
Customers.DisplayName | False | False |
The fully qualified name for a customer or organization. A fully qualified name starts with the customer name followed by a colon and the subcustomer name. Up to five additional subcustomers can be defined by appending a colon and the name of the subcustomer. For example: Rock Construction:Sammuels. |
| DepartmentRef | String | False |
Departments.Id | False | False |
The Id of the department. |
| DepartmentRef_Name | String | True |
Departments.Name | False | False |
The name of the department. |
| ItemRef | String | False |
Items.Id | False | False |
The Id of the item. This field is required in create commands. |
| ItemRef_Name | String | True |
Items.Name | False | False |
The name of item. This field is required in create commands. |
| ClassRef | String | False |
Class.Id | False | False |
Reference type of all Ids that are taken as input or output. |
| ClassRef_Name | String | True |
Class.FullyQualifiedName | False | False |
Reference type of all Ids that are taken as input or output. |
| PayrollItemRef | String | False | False | False |
Specifies how much the employee should be paid for doing the work specified by the Compensation Id. | |
| BillableStatus | String | False | False | False |
Billable status of the time activity. 使用できる値は次のとおりです。Billable, NotBillable, HasBeenBilled | |
| Taxable | Boolean | False | False | False |
This value is true if the time activity recorded is both billable and taxable. | |
| HourlyRate | Decimal | False | False | False |
Hourly bill rate of the employee or vendor for this time activity. | |
| Hours | Integer | False | False | False |
Hours worked. | |
| Minutes | Integer | False | False | False |
Minutes worked. Valid values are 0 - 59. | |
| StartTime | Datetime | False | False | False |
Time work started. | |
| EndTime | Datetime | False | False | False |
Time work ended. | |
| Description | String | False | False | False |
Description of work completed during the time activity. | |
| TransactionLocationType | String | False | False | False |
The account location. This field is valid in only the FR editions. 使用できる値は次のとおりです。WithinFrance, FranceOverseas, OutsideFranceWithEU, OutsideEU | |
| CostRate | Decimal | False | False | False |
Pay rate of the employee or vendor for this time activity. |