List, Insert and Delete Comments from CreditNotes.

Table Specific Information

Select

The add-in will use 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 add-in.

• Id supports the '=' comparison.
• CreditNoteId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CreditNotesComments WHERE Id = '3350895000000089001'

SELECT * FROM CreditNotesComments WHERE CreditnoteId = '837872'

Insert

Insert can be executed by specifying the CustomerId, CreditnoteNumber and LineItems column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO CreditNotesComments (Description, Date) VALUES ('av', '11'-11-20')

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM CreditNotesComments WHERE Id = '3350895000000089001'

Columns