SalesInvoiceComments
SalesInvoiceComments is an auto generated table. The supported operations are Insert, and Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the add-in.
The Id column must be specified in the WHERE clause to retrieve results from SalesInvoiceComments. Id can be used only with the equals (=) operator.
For example:
SELECT * FROM [SalesInvoiceComments] WHERE Id = '123'
INSERT
To create a new SalesInvoiceComments, Comment and ParentId are required.
INSERT INTO SalesInvoiceComments(Comment,ParentId) VALUES('ABdsCwD',1)
Columns
| Name | Type | ReadOnly | Description |
| Comment | String | False |
Comment. |
| Id | String | False |
id |
| CreatedAt | Datetime | False |
Created-at timestamp. |
| EntityId [KEY] | Int | False |
Invoice ID. |
| ExtensionAttributes | String | False |
This is an auto-generated column |
| IsCustomerNotified | Int | False |
Is-customer-notified flag value. |
| IsVisibleOnFront | Int | False |
Is-visible-on-storefront flag value. |
| ParentId | Int | False |
Parent ID. |
| SearchCriteria | String | False |
This is an auto-generated column |
| TotalCount | Int | False |
Total count. |