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