JDBC Driver for Zoho Books

Build 22.0.8479


To list, add, update and delete details of a Vendor Payment.

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 本製品.
Note: PaymentId is required in order to query VendorPaymentDetails.

  • PaymentId supports the '=' comparison.
For example:
    SELECT * FROM VendorPaymentDetails WHERE PaymentId = '1894553000000085277'


Insert can be executed by specifying the VendorId,Amount column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO VendorPaymentDetails (VendorId,Amount) VALUES ('3285934000000104023','500')


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

Update VendorPaymentDetails VendorId='3285934000000104023',Amount='1000' WHERE PaymentId = '3350895000000089005'


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

DELETE FROM VendorPaymentDetails WHERE PaymentId = '3350895000000089001'


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


Id of a payment.

VendorId String False


ID of the vendor the vendor payment has been made.

VendorName String True

Name of the vendor the vendor payment has been made.

VendorpaymentRefunds String True

Refunds of a vendor payment.

AchPaymentStatus String True

Status of ACH Payment.

Amount Decimal False

Amount of the vendor payments.

Balance Decimal True

Total amount of a vendor payment.

Bills String False

Individual bill payment details as array.

BillingAddress String True

Billing address of a vendor payment.

BillingAddressAttention String True

Name of a person in billing address.

BillingAddressCity String True

City of a billing address.

BillingAddressCountry String True

Country of a billing address.

BillingAddressFax String True

Fax of a billing address.

BillingAddressPhone String True

Phone number of a billing address.

BillingAddressState String True

State of a billing address.

BillingAddressStreet2 String True

Street two of a billing address.

BillingAddressZip String True

ZIP code of a billing address.

CheckDetailsAmountInWords String False

Checking details with amount in words.

CheckDetailsCheckId String False

Id of check.

CheckDetailsCheckNumber String False

Number if check.

CheckDetailsCheckStatus String False

Status of check.

CheckDetailsMemo String False

Memo of check details.

CheckDetailsTemplateId String False

Template Id of a vendor payment in check.

CreatedTime Datetime True

Time at which the vendor payment was created.

CurrencyId String True


Currency ID of the customer's currency.

CurrencySymbol String True

Currency symbol of the customer's currency.

CustomFields String False

Custom Fields.

Date Date False

Date of a vendor payment.

Description String False

Description of the vendor payment.

ExchangeRate Decimal False

Exchange rate of a vendor payment.

IsAchPayment Boolean True

Check if the payment if done with ACH payment.

IsPaidViaPrintCheck Boolean False

Check if vendor payment paid via print check.

IsPreGst Boolean True

Check if vendor payment includes pre GST.

IsTdsAmountInPercent Boolean True

Check if the TDS amount is in percent.

LastModifiedTime Datetime True

The time of last modification of the vendor payment.

OffsetAccountId String True


Id of an offset account.

OffsetAccountName String True

Name of an offset account.

PaidThroughAccountId String False


Account Id from which vendor payment has been made.

PaidThroughAccountName String True

Account name from which vendor payment has been made.

PaidThroughAccountType String True

Account type from which vendor payment has been made.

PaymentMode String False

Mode through which payment is made.

PaymentNumber Integer True

Number through which payment is made.

ProductDescription String True

Description of the product.

PurposeCode String True

Purpose code of vendor payment.

ReferenceNumber String False

Reference number of a vendor payment.

TaxAccountId String True


ID of a tax account.

TaxAccountName String True

Name of a tax account.

TaxAmountWithheld Decimal True

Amount withheld for tax.

TdsTaxId String True

ID of a TDS tax.

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