JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all retainer invoices.

Table Specific Information


The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • Status supports the '=' comparison.
For example:
    SELECT * FROM RetainerInvoices WHERE Status = 'All'


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


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


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

使用できる値は次のとおりです。All, Sent, Draft, OverDue, Paid, Void, Unpaid, PartiallyPaid, Viewed, Date.PaymentExpectedDate

Total Decimal Total of retainer invoices.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479