Query the Project Notes in QuickBooks Time.

Table Specific Information

Select

The connector uses 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 connector.

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

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 timesheet.
UserId	Integer	User id for the user that this timesheet belongs to.
JobcodeId	Integer	Jobcode id for the jobcode that this timesheet is recorded
StartDate	Datetime	Date/time that represents the start time of this timesheet, in ISO 8601 format.
EndDate	Datetime	Date/time that represents the end time of this timesheet, in ISO 8601 format.
Duration	Int	The total number of seconds recorded for this timesheet.
Date	Datetime	The timesheet's date, in YYYY-MM-DD format.
Tz	Int	Time zone.
TzStr	String	Time zone str.
Type	String	Either 'regular' or 'manual'. Regular timesheets have a start & end time (duration is calculated by TSheets). Manual timesheets have a date and a duration (in seconds). Unique properties for each timesheet type are below.
Location	String	Location.
Active	Boolean	Active.
Locked	String	If greater than 0, the timesheet is locked for editing. A timesheet could be locked for various reasons, such as being exported, invoiced, etc.
Notes	String	Notes associated with this timesheet.
LastModified	Datetime	Date/time when this timesheet was last modified, in ISO 8601 format.
Created	Datetime	Date/time when this timesheet was created, in ISO 8601 format.
CustomFields	String	A key/value map of customfield ids to the customfield items that are associated with the timesheet.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.