SSIS Components for Adobe Commerce

Build 24.0.9060

SalesCreditmemoComments

SalesCreditmemoComments is an auto generated table. The supported operations are Insert, and Querying data from this table.

Table Specific Information

Select

The component uses the AdobeCommerce API to filter the results by Id while the rest of the filter is executed client side within the component.

The Id column must be specified in the WHERE clause to retrieve results from SalesCreditmemoComments. Id can be used only with the equals (=) operator. For example:

SELECT * FROM [SalesCreditmemoComments] WHERE Id = '123'

INSERT

To create a new SalesCreditmemoComment, Id, Comment and ParentId are required.

INSERT INTO SalesCreditmemoComments(Comment,Id,ParentId) VALUES('ABdCdwawD',2,2)

Columns

Name Type ReadOnly Description
Comment String False

Comment.

Id String False

id

CreatedAt Datetime False

Created-at timestamp.

EntityId [KEY] Int False

Credit memo 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060