ContactRefunds
Retrieves refund details related to a contact.
Table Specific Information
Select
The cmdlet 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 cmdlet.
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. |