CreditNoteInvoicesCredited

Get invoices credited related to credit notes

Table-Specific Information

Select

The component uses 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 component.

CreditNoteId supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM CreditNoteInvoicesCredited WHERE CreditNoteId = '3350895000000089001'

Insert

To insert into this table, specify the CreditNoteId and Invoices columns. Non-read-only columns can be inserted optionally. For example:

INSERT INTO CreditNoteInvoicesCredited (CreditNoteId, Invoices) VALUES ('3782369000000057103','[{"invoice_id":"3782369000000057070","amount_applied":4.82}]');

Delete

To delete from this table, specify the CreditNoteId and CreditNoteInvoiceId in the WHERE clause. For example:

DELETE FROM CreditNoteInvoicesCredited WHERE CreditNoteId = '3782369000000057103' AND CreditNoteInvoiceId = '3782369000000100174';

Columns


Name	Type	ReadOnly	References	Description
CreditedAmount	Double	True		CreditedAmount
CreditNoteId [KEY]	String	False	CreditNotes.Id	CreditNoteId
CreditNoteInvoiceId [KEY]	String	True		CreditNoteInvoiceId
CreditNoteNumber	String	True		CreditNoteNumber
Date	Date	True		Date
InvoiceId	String	True		InvoiceId
InvoiceNumber	String	True		InvoiceNumber

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Invoices	String	List of invoices for which the credit note has been raised. This contains invoice_id and amount_applied.