InvoiceAppliedCredits
Retrieves list of credits applied for an invoice.
Table Specific Information
Select
The connector 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 connector.
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. |