CreditNoteInvoices
Retrieves details of invoices from an existing Credit Note.
Table Specific Information
Select
The connector 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 connector.
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. |