EstimateApprovers
Get the details of approvers for estimates.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- EstimateId supports the '=' comparison.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM EstimateApprovers WHERE EstimateId = '1894553000000077244'
Columns
| Name | Type | References | SupportedOperators | Description |
| EstimateId | String |
Estimates.EstimateId | Id of an estimate. | |
| ApproverUserId [KEY] | String |
Users.UserId | User Id of an approver. | |
| Order | String | Order number. | ||
| ApproverName | String | Name of the approver. | ||
| String | Email Id of the approver. | |||
| Has_approved | Boolean | Check if the User has approved the estimate. | ||
| ApprovalStatus | String | Status of an approval. | ||
| IsNextApprover | String | Check if it is a next approver. | ||
| SubmittedDate | Date | Date of submission. | ||
| ApprovedDate | Date | Date of approval. | ||
| PhotoUrl | String | Photo Url. | ||
| UserStatus | String | Status of a user. | ||
| IsFinalApprover | Boolean | Check if this is a final approver. |