Retrieves a project estimate detail report.

Table Specific Information

Select

The add-in 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 add-in.

• Id supports the = operator.
• SupplementalData supports the = operator.
• ResultsAsArray supports the = operator.

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. The allowed values are 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	String	Preview assigned user ids.
TotalAssignedUsers	Int	Total assigned users.
TrackedTimeUsers	String	Tracked time users.
TrackedTimeGroups	String	Tracked time groups.
TrackedTimeJobcodes	String	Tracked time jobcodes.
TrackedTimeCustomFields	String	Tracked time customfields.
OnTheClock	Boolean	On The Clock.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.