JDBC Driver for Zoho Books

Build 22.0.8479


To list, add, update and delete details of a bill.

Table Specific Information


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 本製品.

  • RecurringBillId supports the '=' comparison.
For example:
    SELECT * FROM RecurringBillDetails where RecurringBillId='3255827000000084031'


Insert can be executed by specifying StartDate, RecurrenceName, RecurrenceFrequency, VendorID, 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 RecurringBillLineItems#TEMP(Name,itemid) values('rubberband','3255827000000081058') 

INSERT INTO RecurringBillDetails (vendorid,startdate,recurrencename,lineitems,recurrencefrequency) VALUES ('3255827000000081003','2023-03-01','recurring7',RecurringBillLineItems#TEMP,'days')


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

UPDATE RecurringBillDetails SET RecurrenceName='recurrence3' WHERE RecurringBillId='3255827000000084031'


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

DELETE FROM RecurringBillDetails WHERE BillId = '3255827000000084031'


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

ID of a Recurring Bill.

Adjustment Integer True


AdjustmentDescription String True

Status of the bill.

CreatedById String True

Created By Id.

CreatedTime Datetime True

Created Time.

CurrencyId String False


Currency ID of the customer's currency.

CurrencyCode String True

Currency code of the customer's currency.

CustomFields String False

Custom fields of the items.

Discount String False

Discount of recurring bills.

DiscountAccountId String True

Account ID of discount.

DiscountAmount Integer True

Discount amount.

DiscountAppliedOnAmount String True

Discount applied on amount.

DiscountSetting String True

Discount setting.

DiscountType String True

Discount type.

EndDate Date False

Date when the payment is expected.

ExchangeRate Integer True

Exchange Rate.

IsDiscountBeforeTax Boolean False

Check if discount should be applied before tax.

IsInclusiveTax Boolean False

Check if the tax is inclusive in the bill.

IsItemLevelTax Boolean True

Item Level Tax.

IsPreGST Boolean True

Is Pre GST.

IsTDSAmountInPercent Boolean True

Is TDS Amount In Percent

LastModifiedById String True

Last Modified By Id.

LastModifiedTime Datetime True

The time of last modification of the bill.

LastSentDate Date True

Date when recurring bill was last sent.

LineItems String False

Line items of an recurring bill.

NextBillDate Date True

Date when bill will be sent next.

Notes String False

Notes of the bill.

PaymentTerms Integer False

Net payment term for the customer.

PaymentTermsLabel String False

Label for the paymet due details.

RecurrenceFrequency String False

Frequency at which recurring bill will be sent.

使用できる値は次のとおりです。days, weeks, months, years

RecurrenceName String False

Search recurring bills by recurrence number.

VendorId String False

ID of the vendor the bill has been made.

VendorName String True

Name of the vendor the bill has been made.

Total Integer True

Total of the bill.

ReferenceId String True

Reference Id.

RepeatEvery Integer False

Integer value denoting the frequency of bill.

StartDate Date False

Date when bill was created.

Status String True

Status of the bill.

使用できる値は次のとおりです。active, stopped, expired

SubTotal Integer True

Sub total of the bill.

TaxAccountId String True

Tax Account ID.

TaxRounding String True

Tax Rounding.

TaxTotal String True

Tax Total.

TdsTaxId String True

Tax ID of TDS.

TdsTaxName String True

Tds tax name.

TdsAmount Integer True

TDS Amount.

TdsPercent Decimal True

TDS Percent.

TrackDiscountInAccount Boolean True

Track Discount In Account.

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