SSIS Components for Zoho Books

Build 22.0.8389


Get the details of a retainer invoice.

Table Specific Information


The component 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 component.
Note: RetainerInvoiceId is required in order to query RetainerInvoiceDetails.

  • RetainerInvoiceId supports the '=' comparison.
For example:
    SELECT * FROM RetainerInvoiceDetails WHERE RetainerInvoiceId = '1894663000000085023'


Name Type References SupportedOperators Description
RetainerInvoiceId [KEY] String


Id of retainer invoice.
RetainerinvoiceNumber String Number of a retainer invoice.
AllowPartialPayments Boolean Check if the retainer invoice allows partial payments.
AttachmentName String Name of the attachment.
Balance Decimal Total amount left.
BillingAddress String Billing address of a retainer invoice.
BillingAddressAttention String Name of a person in billing address.
BillingAddressCity String City of a billing address.
BillingAddressCountry String Country of a billing address.
BillingAddressFax String Fax of a billing address.
BillingAddressPhone String Phone number of a billing address.
BillingAddressState String State of a billing address.
BillingAddressStreet2 String Street two of a billing address.
BillingAddressZip String ZIP code of a billing address.
CanSendInMail Boolean Check if retainer invoice can be send in mail.
ClientViewedTime Datetime Last time when client viewed retainer invoice.
ColorCode String Color code of retainer invoice.
CreatedById String


Id of a user who has created 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.
CurrencySymbol String Symbol of currency used for retainer invoice.
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.
ExchangeRate Decimal Exchange rate of the currency.
InvoiceUrl String URL of invoice.
IsEmailed Boolean Check if the retainer invoice is emailed.
IsInclusiveTax Boolean Check if the retainer invoice is inclusive of tax.
IsPreGst Boolean Check if the retainer invoice is applied by pre GST.
IsViewedByClient Boolean Check if retainer invoice is viewed by client.
LastModifiedById String


Id of a user who has last modified the retainer invoice.
LastModifiedTime Datetime The time of last modification of the retainer invoice.
LastPaymentDate Date Date of payment which was last paid.
Notes String Notes of retainer invoice.
Orientation String Orientation of a page.
PageHeight String Height of a page.
PageWidth String Width of a page.
PaymentDrawn Decimal The payment which was drawn for retainer invoice.
PaymentMade Decimal Payment which was made for the invoice.
PricePrecision Integer The precision for the price.
ReferenceNumber String Reference number of a retainer invoice.
RoundoffValue Decimal Round Off value.
ShippingAddress String Shipment Address.
ShippingAddressAttention String Name of a person of shipping address.
ShippingAddressCity String City of a shipping address.
ShippingAddressCountry String Country of a shipping address.
ShippingAddressFax String Fax of a shipping address.
ShippingAddressPhone String Phone number of a shipping address.
ShippingAddressState String State of a shipping address.
ShippingAddressStreet2 String Street two details of a shipping address.
ShippingAddressZip String Zip code of a shipping address.
Status String Status of the retainer invoice.
SubTotal Decimal Sub total of retainer invoices.
SubmittedBy String Detail of the user who has submitted the retainer invoice.
SubmittedDate Date Date of submission of retainer invoice.
TemplateId String ID of a template.
TemplateName String Name of a template.
TemplateType String Type of a template.
Terms String Terms and Conditions apply of a retainer invoice.
Total Decimal Total of retainer invoices.
TransactionRoundingType String Type of round off used for transaction.
VatTreatment String VAT treatment for the retainer invoice.
PlaceOfSupply String The place of supply is where a transaction is considered to have occurred for VAT purposes.
TaxSpecification String Working of tax when specifying special tax options and tax methods for earnings codes.
UnusedRetainerPayments Decimal Payment of the retainer invoice which is unused.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389