JDBC Driver for QuickBooks Time

Build 24.0.9062

ProjectEstimateDetailReport

Retrieves a project estimate detail report.

Table Specific Information

Select

Query the ProjectEstimateDetailReport 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 supports the '='
  • SupplementalData supports the '='
  • ResultsAsArray supports the '='

For example, the following queries are processed server side:

SELECT * FROM ProjectEstimateDetailReport
SELECT * FROM ProjectEstimateDetailReport WHERE Id = 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.

使用できる値は次のとおりです。in_progress, complete

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.
EstimateItems String Estimate items.
CustomFieldItemId Int Custom field item id.
assigned_to_all Boolean Assigned to all.
PreviewAssignedUserIds Int Preview assigned user ids.
TotalAssignedUsers Int Total assigned users.
TrackedTimeUsers Int Tracked time users.
TrackedTimeGroups Int Tracked time groups.
TrackedTimeJobcodes Int Tracked time jobcodes.
TrackedTimeCustomFields Int Tracked time customfields.

Pseudo-Columns

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

Name Type Description
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.

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