InvoiceAppliedCredits
Retrieves list of credits applied for an invoice.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- InvoiceId supports the '=' comparison.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM InvoiceAppliedCredits WHERE InvoiceId = '1864543000000078539'
Columns
Name | Type | References | SupportedOperators | Description |
CreditnotesInvoiceId [KEY] | String | Id of credit note invoice. | ||
InvoiceId | String |
Invoices.InvoiceId | Id of an invoice. | |
CreditnoteId | String |
CreditNotes.CreditnoteId | Id of a credit note. | |
AmountApplied | Decimal | Amount used for the credit note. | ||
CreditedDate | Date | Date when the credit was applied to the invoice. | ||
CreditnotesNumber | String | Total number of credit notes applied to the invoice. |