Power BI Connector for Adobe Commerce

Build 23.0.8839


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


Name Type ReadOnly Description
ActionCondition String False

This is an auto-generated column

ApplyToShipping Bool False

The rule applies to shipping

Condition String False

This is an auto-generated column

CouponType String False

Coupon type

CustomerGroupIds String False

Ids of customer groups that the rule applies to

Description String False


DiscountAmount Double False

Discount amount

DiscountQty Double False

Maximum qty discount is applied

DiscountStep Int False

Discount step

ExtensionAttributes String False

This is an auto-generated column

FromDate String False

The start date when the coupon is active

IsActive Bool False

The coupon is active

IsAdvanced Bool False

Is this field needed

IsRss Bool False

Whether the rule is in RSS

Name String False

Rule name

ProductIds String False

Product ids

RuleId [KEY] Int False

Rule id

SimpleAction String False

Simple action of the rule

SimpleFreeShipping String False

To grant free shipping

SortOrder Int False

Sort order

StopRulesProcessing Bool False

To stop rule processing

StoreLabels String False

Display label

TimesUsed Int False

How many times the rule has been used

ToDate String False

The end date when the coupon is active

UseAutoGeneration Bool False

To auto generate coupon

UsesPerCoupon Int False

Limit of uses per coupon

UsesPerCustomer Int False

Number of uses per customer

WebsiteIds String False

A list of websites the rule applies to

SearchCriteria String False

This is an auto-generated column

TotalCount Int False

Total count.

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