CreditNoteRefund
Get refund related to credit notes
Table Specific Information
Select
The add-in 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 add-in.
- 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. |