JDBC Driver for QuickBooks Time

Build 24.0.9062

ProjectEstimateReport

Retrieves a project estimate report.

Table Specific Information

Select

Query the ProjectEstimateReport 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 本製品.

  • JobcodeId supports the '=,IN'
  • ProjectId supports the '=,IN'
  • ParentJobcodeId supports the '='
  • Status supports the '='
  • Active supports the '='
  • SupplementalData supports the '='
  • ResultsAsArray supports the '='
  • HasTimeTracked supports the '='
  • TimeTrackedStartDate supports the '='
  • TimeTrackedEndDate supports the '='

For example, the following queries are processed server side:

SELECT * FROM ProjectEstimateReport
SELECT * FROM ProjectEstimateReport WHERE ProjectId = 8375474

Columns

Name Type Description
Id Int Id of the Project estimate report.
JobcodeId Int The JobCode Id.
ParentJobcodeId Int A JobCode Id. Only time for projects under this jobcode will be included.
Name String Name.
Status String Status.
Description String Description.
StartDate Datetime Start date.
DueDate Datetime Due date.
CompletedDate Datetime Completed date.
Active Boolean Boolean value which represents the active status.
LastModified Datetime Last modified date.
Created Datetime Created date.
EstimateId Int Estimate id.
EstimateBy String Estimate by.
EstimateById Int Estimate by id.
TotalClockedInSeconds Int Total clocked in seconds.
TotalClockedOutSeconds Int Total clocked out seconds.
TotalTrackedSeconds Int Total tracked seconds.
TotalEstimatedSeconds Int Total estimated seconds.
TotalNoteCount Int Total note count.
UnreadPostsCount Int Unread posts count.
UnreadRepliesCount Int Unread replies count.
BudgetProgress String Budget progress.
ClockedInUserIds String Clocked in User Ids.
QboMapped Boolean Boolean value.

Pseudo-Columns

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

Name Type Description
ProjectId Integer Array of one or more project ids. Only time for these projects will be included.
SupplementalData Boolean Default value is 'yes'. Indicates whether supplemental data should be specified.
ResultsAsArray Boolean Default value is 'yes'. Indicates whether results should be returned as an array instead of an object.
HasTimeTracked Boolean Default value is 'no'. Indicates whether to filter results on time tracked dates.

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