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. |