ADO.NET Provider for Zoho Books

Build 20.0.7654

RetainerInvoices

Retrieves list of all retainer invoices.

Table Specific Information

Select

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'

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

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

Total Decimal Total of retainer invoices.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654