JDBC Driver for Zoho Books

Build 22.0.8479


Generated schema file.


Name Type References SupportedOperators Description
Accountid String Account id
Accountname String Account name
Amount Integer Amount
AppliedDate Date Applied Date
AppliedInvoiceAmount String Applied Invoice Amount
AppliedInvoiceBcyAmount String Applied Invoice BcyAmount
AppliedInvoices String Applied Invoices
BcyBankCharge Integer BcyBankCharge
BcytotalExcludingTdsDeduction Integer Bcytotal ExcludingTdsDeduction
ContactBillingAttention String Contact Billing Attention
ContactBillingCity String Contact Billing City
ContactBillingCountry String Contact Billing Country
ContactBillingFax String Contact Billing Fax
ContactBillingState String Contact Billing State
ContactBillingStreet1 String Contact Billing Street1
ContactBillingStreet2 String Contact Billing Street2
ContactBillingZipcode String Contact Billing Zipcode
ContactCompanyName String Contact Company Name
ContactCreatedBy String Contact Created By
ContactCreatedTime Datetime Contact Created Time
ContactcreditLimit Integer Contact credit Limit
ContactcustomerSubType String Contact customer SubType
ContactDepartment String Contact Department
ContactDesignation String Contact Designation
ContactEmail String Contact Email
ContactFacebook String Contact Facebook
ContactFirstName String Contact First Name
ContactLastModifiedTime Datetime Contact Last ModifiedTime
ContactLastName String Contact Last Name
ContactMobilePhone String Contact Mobile Phone
ContactNotes String Contact Notes
ContactOutstandingReceivableAmount Integer Contact Outstanding ReceivableAmount
ContactOutstandingReceivableAmountBcy Integer Contact Outstanding ReceivableAmountBcy
ContactPaymentTerms String Contact Payment Terms
ContactPhone String Contact Phone
ContactShippingAttention String Contact Shipping Attention
ContactShippingCity String Contact Shipping City
ContactShippingCountry String Contact Shipping Country
ContactShippingFax String Contact Shipping Fax
ContactShippingState String Contact Shipping State
ContactShippingStreet1 String Contact Shipping Street1
ContactShippingStreet2 String Contact Shipping Street2
ContactShippingZipcode String Contact Shipping Zipcode
ContactSkype String Contact Skype
ContactStatus String Contact Status
ContactTwitter String Contact Twitter
ContactUnusedCreditsReceivableAmount Integer Contact Unused Credits Receivable Amount
ContactUnusedCreditsReceivableAmountBcy Integer Contact Unused Credits Receivable Amount Bcy
ContactWebsite String Contact Website
CreatedBy String CreatedBy
CreatedTime Datetime CreatedTime
CurrencyCode String CurrencyCode
CustomFields String CustomFields
CustomerName String CustomerName
Description String Description
Documents String Documents
FcyBankCharge Integer Fcy Bank Charge
FcytotalExcludingTdsDeduction Integer Fcy total Excluding TdsDeduction
GatewayTransactionId String GatewayTransactionId
HasAttachment Boolean Has Attachment
InvoiceNumber String Invoice Number
InvoiceNumbers String Invoice Numbers
LastFourDigits String Last Four Digits
LastModifiedTime Datetime Last Modified Time
PaymentId String Payment Id
ProductDescription String Product Description
RefundedAmount Integer Refunded Amount
Retainerinvoiceid String Retainer invoiceid
TaxAccountId String Tax Account Id
TaxAccountName String Tax Account Name
TaxAmountWithheld Integer Tax Amount Withheld
Type String Type
UnusedAmount Integer UnusedAmount
CustomerId String IN, NOT IN Customer Id
Date Date =, >,< Date
PaymentMode String IN, NOT IN Payment Mode

使用できる値は次のとおりです。Bank Remittance, Bank Transfer, Cash, Check, Credit Card

PaymentNumber String =, !=, LIKE, CONTAINS, NOT LIKE, IS NULL, IS NOT NULL Payment Number
AccountIdFilter String IN, NOT IN AccountIdFilter
BcyUnusedAmount Integer =, !=,<,<=, >, >= Bcy Unused Amount
BcyAmount Integer =, !=,<,<=, >, >= Bcy Amount
BcyRefundedAmount Integer =, !=,<, >,<=, >= Bcy Refunded Amount
ReferenceNumber String =, !=, LIKE, NOT LIKE, CONTAINS Reference Number


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PaymentType String Transaction

使用できる値は次のとおりです。Retainers, Invoices, InvoicePayment, Advance

PaymentDate String Filter transaction by any transaction date.

使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate

ToDate Date To Date
FromDate Date From Date

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