EstimateApprovers
Get the details of approvers for estimates.
Table Specific Information
Select
The connector 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 connector.
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. |