TDV Adapter for Zoho Books

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060