Retrieves refund details related to a contact.

Table Specific Information

Select

The provider 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 provider.

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			Description
ReferenceNumber	Integer			A Reference Number
RefundMode	String			The Refund Mode