CreditNoteInvoices
Retrieves details of invoices from an existing Credit Note.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- CreditnoteId supports the '=' and IN operators.
NOTE: CreditnoteId is required to query CreditNoteInvoices.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM CreditNoteInvoices WHERE CreditnoteId = '1895452000000083136'
SELECT * FROM CreditNoteInvoices WHERE CreditNoteId IN (SELECT CreditNoteID FROM CreditNotes)
SELECT * FROM CreditNoteInvoices WHERE CreditNoteId IN ('1895452000000083136','1895452000000083137')
Columns
| Name | Type | References | SupportedOperators | Description |
| CreditnoteInvoiceId [KEY] | String | Id of credit note invoice. | ||
| CreditnoteId | String |
CreditNotes.CreditnoteId | Id of a credit note. | |
| Credited_amount | Decimal | Amount which is credit in credit note invoice. | ||
| CreditnoteNumber | String | Number of a credit note. | ||
| Date | Date | Date of an credit note invoice. | ||
| InvoiceId | String |
Invoices.InvoiceId | Id of an invoice. | |
| InvoiceNumber | String | Number of an invoice. |