JDBC Driver for QuickBooks Online

Build 22.0.8675

TimeActivities

Create, update, delete, and query QuickBooks Time Activities.

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.

The allowed values are 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.

The allowed values are 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.

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8675