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 |