RecurringInvoiceDetails

Get the details of a recurring invoice.

Table Specific Information

Select

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'

Columns


Name	Type	References	SupportedOperators	Description
RecurringInvoiceId [KEY]	String	RecurringInvoices.RecurringInvoiceId		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	Users.UserId		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	Currencies.CurrencyId		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	Contacts.ContactId		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	Users.UserId		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.

SSIS Components for Zoho Books

RecurringInvoiceDetails

Table Specific Information

Select

Columns