JDBC Driver for Zoho Inventory

Build 22.0.8462

SalesReturnsCreditNotes

List Credit Notes of Sales Returns.

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.

  • SalesReturnId supports the '=' comparison.
  • CreditNoteId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM SalesReturnsCreditNotes WHERE SalesReturnId = '3350895000000089001'

SELECT * FROM SalesReturnsCreditNotes WHERE CreditNoteId = '3350895000000089001'

Columns

Name Type References Description
CreditnoteId [KEY] Long Credit note Id.
SalesReturnId Long

SalesReturns.Id

Sales Return Id.
CreditnoteNumber String Credit Note number.
Date Date Date of Credit note.
Status String Status of Credit note.
Total Integer Total in credit note.

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