Retrieves refund details related to a contact.

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with the ContactId column, which supports '=,IN' comparisons.

The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM ContactRefunds WHERE contactid = '3255827000000093001'

    SELECT * FROM BankTransactionImportedTransaction WHERE transactionid IN ('3255827000000101458', '3255827000000102354')

Columns

Name	Type	References	SupportedOperators	Description
CreditNoteRefundId [KEY]	Long			The Credit Note Refund Id.
CreditNoteId	String	CreditNotes.CreditNoteId		The Credit Note Id.
ContactId	String	Contacts.ContactId	=	The Contact Id.
AmountBcy	Double			The Refund Amount in Base Currency.
AmountFcy	Double			The Refund Amount in Foreign Currency.
CreditNoteNumber	String			The Credit Note Number.
CustomerName	String			The Customer Name.
Date	Date			The Date of Refund.
Description	String			A Description.
ReferenceNumber	Integer			Reference Number.
RefundMode	String			The Refund Mode.