JDBC Driver for QuickBooks Time

Build 24.0.9062

Timesheets

This table contains a list of file objects.

Table Specific Information

Select

Query the Timesheets table. The 本製品 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 本製品.

  • Id, UserId, JobcodeId, PayrollIds, GroupIds fields support the '=' and IN operators.
  • OnTheClock and JobCodeType fields support the '=' operator.
  • LastModified and Date fields support the <=,<=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM Timesheets WHERE OnTheClock = false

SELECT * FROM Timesheets WHERE LastModified > '2019-01-01 18:30' AND GroupIds IN (1, 2, 3)

SELECT * FROM Timesheets WHERE JobcodeId IN (1, 2, 3)

Insert

Insert can be executed by specifying UserId, JobcodeId, Type and StartTime, EndTime columns in case of Type = regular or UserId, JobcodeId, Type and Duration, Date in case of Type = manual. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO Timesheets (UserId, JobcodeId, Type, StartTime, EndTime) VALUES ('1242123', '17288283', 'regular', '2019-12-05', '2019-12-05')

INSERT INTO Timesheets (UserId, JobcodeId, Type, Date, Duration) VALUES ('1242123', '17288283', 'manual', '2019-12-05', 600)

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Timesheets SET Date = '2018-08-08', EndTime = '2018-08-08T14:00:00-07:00'  WHERE Id = '1242123'  

Delete

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Timesheets WHERE Id = '41321421'

Columns

Name Type ReadOnly Description
Id [KEY] String True

Id of the timesheet.

UserId String False

User id for the user that this timesheet belongs to.

JobcodeId Int False

Jobcode id for the jobcode that this timesheet is recorded against.

Locked Boolean True

If greater than 0, the timesheet is locked for editing. A timesheet could be locked for various reasons.

Notes String False

Notes associated with this timesheet.

LastModified Datetime True

Date/time when this timesheet was last modified.

Type String False

Either 'regular' or 'manual'.

OnTheClock Boolean True

If true, the user is currently on the clock . If false the user is not currently working on this timesheet. Manual timesheets will always have this property set as false.

CreatedByUserId String False

User id for the user that initially created this timesheet.

StartTime Datetime False

Date/time that represents the start time of this timesheet. Will always be an empty string for manual timesheets.

EndTime Datetime False

Date/time that represents the end time of this timesheet. Will always be an empty string for manual timesheets.

Date Date False

The timesheet's date

Duration Int False

The total number of seconds recorded for this timesheet.

OriginHint String False

A string that will be logged as part of the timesheet history when someone is clocked in, clocked out, or a timesheet is created (with both in/out). Will always be an empty string for manual timesheets.

JobCodeType String True

The type of the jobcode linked with this timesheet. Any of the 'regular', 'pto', 'paid_break', 'unpaid_break'

Pseudo-Columns

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

Name Type Description
PayrollIds Int

A comma-separated string of payroll ids. Only time recorded against users with these payroll ids will be returned.

GroupIds Int

A comma-separated list of group ids. Only timesheets linked to users from these groups will be returned.

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