CreditNoteRefund
Get refund related to credit notes
Table Specific Information
Select
The provider will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
- CreditNoteId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM CreditNoteRefund WHERE CreditNoteId = '3350895000000089001'
Columns
| Name | Type | ReadOnly | References | Description |
| AmountBcy | Integer | True |
Refund Amount in Base Currency | |
| AmountFcy | Integer | True |
Refund Amount in Foreign Currency | |
| CreditNoteId [KEY] | String | False |
CreditNotes.Id |
CreditNote Id |
| CreditNoteNumber | String | True |
CreditNote Number | |
| CreditNoteRefundId [KEY] | String | True |
CreditNote RefundId | |
| CustomerName | String | True |
Customer Name | |
| Date | Date | False |
The date on which the credit note was raised. Format [yyyy-mm-dd] | |
| Description | String | False |
A brief description about the item. | |
| ReferenceNumber | String | False |
Reference number generated for the payment. A string of your choice can also be used as the reference number. Max-Length [100] | |
| RefundMode | String | False |
The method of refund. | |
| Amount | Double | False |
Amount. | |
| CreatedById | Long | True |
ID of the creator. | |
| CreatedDate | Date | True |
Created date. | |
| CreditNote | String | True |
Credit note details. | |
| CurrencyCode | String | True |
Currency code. | |
| CurrencySymbol | String | True |
Currency symbol. | |
| CustomerId | Long | True |
ID of the customer. | |
| ExchangeRate | Double | False |
Exchange rate. | |
| FromAccountId | Long | False |
ID of the source account. | |
| Status | String | True |
Status. | |
| String | True |
Email address. | ||
| FromAccountName | String | True |
Name of the source account. | |
| ImportedTransactions | String | True |
Imported transactions. | |
| LastModifiedById | Long | True |
ID of the last modifier. | |
| PricePrecision | Integer | True |
Price precision. | |
| RoundingMode | String | True |
Rounding mode. |