TimeActivities

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.