Tableau Connector for Zoho Books

Build 22.0.8479

RecurringInvoiceDetails

To list, add, update and delete details of a recurring invoice.

Table Specific Information

Select

The connector 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 connector.
Note: RecurringInvoiceId is required in order to query RecurringInvoiceDetails.

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

Insert

Insert can be executed by specifying RecurrenceName,CustomerId,RecurrenceFrequency, LineItems columnS. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

Insert INTO RecurringInvoiceLineItems#TEMP(Name,itemid,rate,quantity) values('Cloth-Jeans','3285934000000104097','1700','1')

Insert INTO RecurringInvoiceDetails(RecurrenceName,CustomerId,RecurrenceFrequency, LineItems) values('MonthlyInvoice','3285934000000104002','weeks',RecurringInvoiceLineItems#TEMP) 

Update

Update can be executed by specifying the RECURRINGINVOICEID in the WHERE Clause. The columns that are not read-only can be Updated. For example:

Insert INTO RecurringInvoiceLineItems#TEMP(Name,itemid,rate,quantity) values('Cloth-Jeans','3285934000000104097','1700','1')

Update RecurringInvoiceDetails set RecurrenceName='MonthlyInvoice',CustomerId='3285934000000104002',RecurrenceFrequency='weeks', LineItems='RecurringInvoiceLineItems#TEMP' WHERE RECURRINGINVOICEID='3285934000000268005'

Delete

Delete can be executed by specifying the RECURRINGINVOICEID in the WHERE Clause For example:

DELETE FROM RecurringInvoiceDetails WHERE RECURRINGINVOICEID = '3285934000000268005'

Columns

Name Type ReadOnly References SupportedOperators Description
RecurringInvoiceId [KEY] String True

RecurringInvoices.RecurringInvoiceId

Id of a recurring invoice.

ActualChildInvoicesCount Integer True

Count total number of actual child invoices.

Adjustment Decimal False

Adjustments made to the recurring invoices.

AdjustmentDescription String False

Description of adjustments made to the recurring invoices.

AllowPartialPayments Boolean True

Check if the recuuring invoice can allow partial payments.

AvataxUseCode String False

Used to group like customers for exemption purposes. It is a custom value that links customers to a tax rule.

AvataxTaxCode String False

A tax code is a unique label used to group items together.

AvataxExemptNo String False

Exemption certificate number of the customer.

BcyAdjustment Decimal True

Adjustment of base currency.

BcyDiscountTotal Decimal True

Total discount applied in base currency.

BcyShippingCharge Decimal True

Shipping charge applied in base currency.

BcySubTotal Decimal True

Sub total of base currency.

BcyTaxTotal Decimal True

Tax total of base currency.

BcyTotal Decimal True

Total Base Currency.

BillingAddress String False

Billing address of a recurring invoice.

BillingAddressAttention String False

Name of a person in billing address.

BillingAddressCity String False

City of a billing address.

BillingAddressCountry String False

Country of a billing address.

BillingAddressFax String False

Fax of a billing address.

BillingAddressPhone String False

Phone number of a billing address.

BillingAddressState String False

State of a billing address.

BillingAddressStreet2 String False

Street two of a billing address.

BillingAddressZip String False

ZIP code of a billing address.

ChildEntityType String True

Entity type of a child in recurring invoice.

CompanyName String True

Name of the company.

ContactCategory String True

Category of the contact.

ContactPersons String False

Contact persons of a contact.

CreatedById String True

Users.UserId

Id of a user who has created recurring invoice.

CreatedTime Datetime True

Time at which the recurring invoice was created.

CurrencyCode String True

Currency code of the customer's currency.

CurrencyId String True

Currencies.CurrencyId

Currency ID of the customer's currency.

CurrencySymbol String True

Symbol of the currency.

CustomerEmail String True

Email address of the customer.

CustomerMobilePhone String True

Mobile phone number of customer.

CustomerId String False

Contacts.ContactId

ID of the customer or vendor.

CustomerName String True

Name of the customer or vendor.

CustomerPhone String True

Phone number of a customer.

Discount String False

Discount given to specific item in recurring invoice.

DiscountAmount Decimal True

Total amount which was discounted.

DiscountAppliedOnAmount Decimal True

Amount from which discount was applied.

DiscountPercent Double True

Percentage of discount applied.

DiscountTotal Decimal True

Total amount get on discount.

DiscountType String False

Type to get discount in recurring invoice.

Email String False

Email address of the customer.

EndDate Date False

End date for the statement.

ExchangeRate Decimal False

Exchange rate of the currency.

IsDiscountBeforeTax Boolean False

Check if the recurring invoice is discounted before tax.

IsInclusiveTax Boolean False

Check if the expense is inclusive tax.

IsPreGst Boolean True

Check if pre GST is applied.

ItemId String False

Items.ItemId

ID of the customer or vendor.

LastModifiedById String True

Users.UserId

Id of the user last modified.

LastModifiedTime Datetime True

The time of last modification of the recurring invoice

LastSentDate Date True

The date at which the last recurring invoice was sent.

LineItems String False

Line items of an estimate.

ManualChildInvoicesCount Integer True

Count of manual child invoices.

NextInvoiceDate Date True

Date of a next invoice.

Notes String True

Notes for this recurring invoice.

Orientation String True

Orientation of a page.

PlaceOfSupply String False

The place of supply is where a transaction is considered to have occurred for VAT purposes.

PageHeight String True

Height of the page.

PageWidth String True

Width of the page.

PaidInvoicesTotal Decimal True

Total number of paid invoices.

PaymentTerms Integer False

Net payment term for the customer.

PaymentTermsLabel String False

Label for the paymet due details.

PaymentOptionsPaymentGateways String False

Payment Gateway used for payment.

PhotoUrl String True

Photo URL for recurring invoices.

PricePrecision Integer True

The precision for the price.

ProjectDetails String True

Details of project.

RecurrenceFrequency String False

Type of recurrence frequency the invoice is recurring.

RecurrenceName String False

Name of the recurrence.

ReferenceNumber String True

Reference number of a recurring invoice.

RepeatEvery Integer False

Recurrence time of the invoice.

RoundoffValue Decimal True

Rounding off the values to precise number.

SalespersonId String True

ID of a sales person.

SalespersonName String False

Name of a sales person.

ShipmentCharges String True

Shipment charges of recurring invoice.

ShippingAddress String False

Shipment Address.

ShippingAddressAttention String False

Name of a person of shipping address.

ShippingAddressCity String False

City of a shipping address.

ShippingAddressCountry String False

Country of a shipping address.

ShippingAddressFax String False

Fax of a shipping address.

ShippingAddressPhone String False

Phone number of a shipping address.

ShippingAddressState String False

State of a shipping address.

ShippingAddressStreet2 String False

Street two details of a shipping address.

ShippingAddressZip String False

Zip code of a shipping address.

ShippingCharge Decimal True

Shipping charge.

StartDate Date False

Starting date of recurring invoice.

Status String True

Status of the recurring invoice.

SubTotal Decimal True

Sub total of recurring invoices.

SubTotalInclusiveOfTax Decimal True

Subtotal amount which are inclusive of tax.

TaxId String False

Taxes.TaxId

Id of the tax

TaxTotal Decimal True

Total amount for tax.

TemplateId String False

ID of a template.

TemplateName String True

Name of a template.

Terms String True

Terms and Conditions apply of a recurring invoice.

Total Decimal True

Total of recurring invoices.

TransactionRoundingType String True

Type of round off used for transaction.

UnpaidChildInvoicesCount String True

Count of total number of unpaid child invoices.

UnpaidInvoicesBalance Decimal True

Total amount of unpaid invoices.

VatTreatment String False

VAT treatment for the estimates.

GstNo String False

GST number.

GstTreatment String False

Choose whether the estimate is GST registered/unregistered/consumer/overseas. .

TaxTreatment String False

VAT treatment for the Estimate.

Name String False

The name of the line item.

Description String False

The description of the line items.

Rate Decimal False

Rate of the line item.

Quantity Integer False

The quantity of line item.

Unit String False

Unit of the line item e.g. kgs, Nos.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479