JDBC Driver for Zoho Books

Build 22.0.8479

CreditNoteInvoices

Retrieves details of invoices from an existing Credit Note.

Table Specific Information

Select

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: CreditnoteId is required in order to query CreditNoteInvoices.

  • CreditnoteId supports the '=' comparison.
For example:
    SELECT * FROM CreditNoteInvoices WHERE CreditnoteId = '1895452000000083136'

Columns

Name Type References SupportedOperators Description
CreditnoteInvoiceId [KEY] String ID of credit note invoice.
CreditnoteId String

CreditNotes.CreditnoteId

ID of a credit note.
Credited_amount Decimal Amount which is credit in credit note invoice.
CreditnoteNumber String Number of a credit note.
Date Date Date of an credit note invoice.
InvoiceId String

Invoices.InvoiceId

ID of an invoice.
InvoiceNumber String Number of an invoice.

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