RetainerInvoices
Retrieves list of all retainer invoices.
Table Specific Information
Select
The adapter 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 adapter.
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. |