CData JDBC Driver for Magento 2019 - Online Help
Questions / Feedback?

SalesRule

CData JDBC Driver for Magento 2019 - Build 19.0.7354

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

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0