JDBC Driver for Zoho Inventory

Build 22.0.8462

CreditNoteRefund

Read, Insert,Update and Delete Refunds of CreditNotes.

Table Specific Information

Select

The driver will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

  • CreditNoteId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CreditNoteRefund WHERE CreditNoteId = '3350895000000089001'

Columns

Name Type ReadOnly References Description
AmountBcy Integer False

Refund Amount in Base Currency

AmountFcy Integer False

Refund Amount in Foreign Currency

CreditNoteId [KEY] String False

CreditNotes.Id

CreditNote Id

CreditNoteNumber String False

CreditNote Number

CreditNoteRefundId [KEY] String False

CreditNote RefundId

CustomerName String False

Customer Name

Date Date False

The date on which the credit note was raised. Format [yyyy-mm-dd]

Description String False

A brief description about the item.

ReferenceNumber String False

Reference number generated for the payment. A string of your choice can also be used as the reference number. Max-Length [100]

RefundMode String False

The method of refund.

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