JDBC Driver for QuickBooks Time

Build 24.0.9062

JobCodes

This table contains a list of jobcodes associated with your company

Table Specific Information

Select

Query the Jobcodes 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 and Name fields support the '=' and IN operators.
  • Type field and ActiveStatus filter support the '=' operator.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM Jobcodes WHERE Id IN (1242515, 1242515)

SELECT * FROM Jobcodes WHERE Type = 'unpaid_break'

Insert

Insert can be executed by specifying the Name and Type columns. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO Jobcodes (Name, Type) VALUES ('Group 1', 'pto')

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 Jobcodes SET Name = 'Group 2', Type = 'pto'  WHERE Id = '10055' 

Columns

Name Type ReadOnly Description
Id [KEY] Int True

Id of jobcode.

ParentId Int False

Id of this jobcode's parent. 0 if it's top-level.

Name String False

Id of this jobcode's parent. 0 if it's top-level.

ShortCode String False

This is a shortened code or alias that is associated with the jobcode. It may only consist of letters and numbers. Must be unique for all jobcodes that share the same parent id.

Type String False

Indicates jobcode type. One of 'regular', 'pto', 'paid_break', or 'unpaid_break'

Billable Boolean False

Indicates whether this jobcode is billable or not.

BillableRate Double False

Dollar amount associated with this jobcode for billing purposes. Only effective if billable is true.

HasChildren Boolean True

If true, there are jobcodes that exist underneath this one, so this jobcode should be treated as a container or folder with children jobcodes underneath it.

AssignedToAll Boolean False

Indicates whether this jobcode is assigned to all employees or not.

RequiredCustomFields String True

Ids of customfields that should be displayed when this jobcode is selected on a timecard.

Active Boolean True

If true, this jobcode is active. If false, this jobcode is archived. To archive a jobcode, set this field to false. When a jobcode is archived, any children underneath the jobcode are archived as well. Note that when you archive a jobcode, any jobcode assignments or customfield dependencies are removed. To restore a jobcode, set this field to true. When a jobcode is restored, any parents of that jobcode are also restored.

LastModified Datetime True

Date/time when this jobcode was last modified.

Created Datetime True

Date/time when this jobcode was created

FilteredCustomFiledsItems String True

Displays which customfielditems should be displayed when this jobcode is chosen for a timesheet. Each property of the object is a customfield id with its value being an array of customfielditem id. If none, an empty string is returned.

ConnectWithQuickBooks String True

If true and the beta feature for two-way sync is enabled, then changes made to the jobcode are immediately shared with QBO.

Pseudo-Columns

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

Name Type Description
ActiveStatus String

Filter column for whether to fetch only active records, only archived records, or both. By default, only active records are fetched. Possible values are: yes, no, both

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