RetainerInvoices
Retrieves list of all retainer invoices.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- Status supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM RetainerInvoices WHERE Status = 'All'
Columns
| Name | Type | References | SupportedOperators | Description |
| RetainerInvoiceId [KEY] | String | Id of a retainer invoice. | ||
| Balance | Decimal | Total balance of a retainer invoice. | ||
| ClientViewedTime | Datetime | Time when client viewed the retainer invoice. | ||
| ColorCode | String | Color code of retainer invoice. | ||
| CreatedTime | Datetime | Time at which the retainer invoice was created. | ||
| CurrencyCode | String | Currency code of the customer's currency. | ||
| CurrencyId | String |
Currencies.CurrencyId | Currency Id of the customer's currency. | |
| CurrentSubStatus | String | Current sub status of a retainer invoice. | ||
| CurrentSubStatusId | String | Current sub status Id of a retainer invoice. | ||
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| Date | Date | Date of a retainer invoice. | ||
| EstimateNumber | String | Estimate number of retainer invoice. | ||
| HasAttachment | Boolean | Check if the retainer invoice has attachment. | ||
| IsEmailed | Boolean | Check if the retainer invoice is emailed. | ||
| IsViewedByClient | Boolean | Check if the retainer invoice is viewed by client. | ||
| LastModifiedTime | Datetime | The time of last modification of the retainer invoices. | ||
| LastPaymentDate | Date | Date of last payment made to retainer invoice. | ||
| ProjectName | String | Name of the project. | ||
| ProjectOrEstimateName | String | Name of project or estimate. | ||
| ReferenceNumber | String | Reference number of a retainer invoice. | ||
| RetainerinvoiceNumber | String | Total number of retainer invoice. | ||
| Status | String | Status of the retainer invoice.
The allowed values are All, Sent, Draft, OverDue, Paid, Void, Unpaid, PartiallyPaid, Viewed, Date.PaymentExpectedDate. | ||
| Total | Decimal | Total of retainer invoices. |