SalesInvoiceComments
SalesInvoiceComments is an auto generated table. The supported operations are Insert, and Querying data from this table.
Table Specific Information
Select
The connector uses the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the connector.
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. |