SalesRule
SalesRule is an auto generated table
Columns
| 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 |
Description |
| DiscountAmount | String | False |
Discount amount |
| DiscountQty | String | 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 |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| RuleId_p | Int |
This is an auto-generated column |