ContactRefunds
Get refund details related to a contact.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- ContactId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the 本製品.
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 | Credit Note Refund Id | ||
| CreditNoteId | String |
CreditNotes.CreditNoteId | Credit Note Id | |
| ContactId | String |
Contacts.ContactId | = | Contact Id |
| AmountBcy | Double | Refund Amount in Base Currency | ||
| AmountFcy | Double | Refund Amount in Foreign Currency | ||
| CreditNoteNumber | String | Credit Note Number | ||
| CustomerName | String | Customer Name | ||
| Date | Date | Date of Refund | ||
| Description | String | Description | ||
| ReferenceNumber | Integer | Reference Number | ||
| RefundMode | String | Refund Mode |