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