SSIS Components for Zoho Books

Build 22.0.8389


Get the details of a recurring 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: RecurringInvoiceId is required in order to query RecurringInvoiceDetails.

  • RecurringInvoiceId supports the '=' comparison.
For example:
    SELECT * FROM RecurringInvoiceDetails WHERE RecurringInvoiceId = '1895453000000042244'


Name Type References SupportedOperators Description
RecurringInvoiceId [KEY] String


Id of a recurring invoice.
ActualChildInvoicesCount Integer Count total number of actual child invoices.
Adjustment Decimal Adjustments made to the recurring invoices.
AdjustmentDescription String Description of adjustments made to the recurring invoices.
AllowPartialPayments Boolean Check if the recuuring invoice can allow partial payments.
BcyAdjustment Decimal Adjustment of base currency.
BcyDiscountTotal Decimal Total discount applied in base currency.
BcyShippingCharge Decimal Shipping charge applied in base currency.
BcySubTotal Decimal Sub total of base currency.
BcyTaxTotal Decimal Tax total of base currency.
BcyTotal Decimal Total Base Currency.
BillingAddress String Billing address of a recurring 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.
ChildEntityType String Entity type of a child in recurring invoice.
CompanyName String Name of the company.
ContactCategory String Category of the contact.
CreatedById String


Id of a user who has created recurring invoice.
CreatedTime Datetime Time at which the recurring 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 the currency.
CustomerEmail String Email address of the customer.
CustomerMobilePhone String Mobile phone number of customer.
CustomerId String


ID of the customer or vendor.
CustomerName String Name of the customer or vendor.
CustomerPhone String Phone number of a customer.
Discount String Discount given to specific item in recurring invoice.
DiscountAmount Decimal Total amount which was discounted.
DiscountAppliedOnAmount Decimal Amount from which discount was applied.
DiscountPercent Double Percentage of discount applied.
DiscountTotal Decimal Total amount get on discount.
DiscountType String Type to get discount in recurring invoice.
EndDate Date End date for the statement.
ExchangeRate Decimal Exchange rate of the currency.
IsDiscountBeforeTax Boolean Check if the recurring invoice is discounted before tax.
IsInclusiveTax Boolean Check if the expense is inclusive tax.
IsPreGst Boolean Check if pre GST is applied.
LastModifiedById String


Id of the user last modified.
LastModifiedTime Datetime The time of last modification of the recurring invoice
LastSentDate Date The date at which the last recurring invoice was sent.
ManualChildInvoicesCount Integer Count of manual child invoices.
NextInvoiceDate Date Date of a next invoice.
Notes String Notes for this recurring invoice.
Orientation String Orientation of a page.
PageHeight String Height of the page.
PageWidth String Width of the page.
PaidInvoicesTotal Decimal Total number of paid invoices.
PaymentTerms Integer Net payment term for the customer.
PaymentTermsLabel String Label for the paymet due details.
PhotoUrl String Photo URL for recurring invoices.
PricePrecision Integer The precision for the price.
ProjectDetails String Details of project.
RecurrenceFrequency String Type of recurrence frequency the invoice is recurring.
RecurrenceName String Name of the recurrence.
ReferenceNumber String Reference number of a recurring invoice.
RepeatEvery Integer Recurrence time of the invoice.
RoundoffValue Decimal Rounding off the values to precise number.
SalespersonId String ID of a sales person.
SalespersonName String Name of a sales person.
ShipmentCharges String Shipment charges of recurring invoice.
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.
ShippingCharge Decimal Shipping charge.
StartDate Date Starting date of recurring invoice.
Status String Status of the recurring invoice.
SubTotal Decimal Sub total of recurring invoices.
SubTotalInclusiveOfTax Decimal Subtotal amount which are inclusive of tax.
TaxTotal Decimal Total amount for tax.
TemplateId String ID of a template.
TemplateName String Name of a template.
Terms String Terms and Conditions apply of a recurring invoice.
Total Decimal Total of recurring invoices.
TransactionRoundingType String Type of round off used for transaction.
UnpaidChildInvoicesCount String Count of total number of unpaid child invoices.
UnpaidInvoicesBalance Decimal Total amount of unpaid invoices.

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