CreditNotesComments
List, Insert and Delete Comments from CreditNotes.
Table Specific Information
Select
The driver 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 driver.
- 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
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Id of the comment. | |
CommentType | String | False |
Type of the comment. | |
CommentedBy | String | False |
Name of the commenter. | |
CommentedById | String | True |
Id of the commenter. | |
CreditNoteId [KEY] | String | False |
CreditNotes.Id |
Id of the credit note. |
Date | Date | False |
Date of the comment published. | |
DateDescription | String | False |
Description of the date of the comment. | |
Description | String | False |
A brief description about the item. | |
OperationType | String | False |
Operation type of the comment. | |
Time | Datetime | False |
Time of the comment published. | |
TransactionId | String | True |
Transaction Id of the comment. | |
TransactionType | String | False |
Transaction Type of the comment. |