ProjectEstimateDetailReport
Retrieves a project estimate detail report.
Table Specific Information
Select
Query the ProjectEstimateDetailReport table. The add-in 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 add-in.
- 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.
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 | 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
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. |