JDBC Driver for QuickBooks Time

Build 24.0.9062

TimesheetsDeleted

Query the Project Notes in TSheets.

Table Specific Information

Select

Query the TimesheetsDeleted table. The driver will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id supports the '=,IN'
  • UserId supports the '=,IN'
  • JobcodeId supports the '=,IN'
  • StartDate supports the '='
  • EndDate supports the '='
  • Type supports the '='
  • LastModified supports the '<,<=,>,>='
  • GroupId supports the '=,IN'
  • Username supports the '='
  • JobcodeType supports the '='
  • SupplementalData supports the '='

Either StartDate and EndDate or Id is required to query the TimesheetsDeleted view. For example, the following queries are processed server side:

SELECT * FROM TimesheetsDeleted WHERE StartDate = '2023-02-01' AND EndDate = '2024-07-01'
SELECT * FROM TimesheetsDeleted WHERE Id = 8375474

Columns

Name Type Description
Id [KEY] String Id of the Project Note.
UserId Integer Id of the associated user.
JobcodeId Integer JobCode id.
StartDate Datetime Start date.
EndDate Datetime End date.
Duration Int Duration.
Date Datetime Date.
Tz Int Time zone.
TzStr String Time zone str.
Type String Type.
Location String Location.
Active Boolean Active.
Locked String Locked.
Notes String Notes.
LastModified Datetime Last modified date.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
GroupId Integer Id of the associated groups.
Username String User name.
JobcodeType String Job code type.
SupplementalData Boolean Default value is 'yes'. Indicates whether supplemental data should be specified.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062