COUPON_SCOPE_RULE

Y

The scope of the coupon.

The following codes are delivered with base and cannot be changed:

·       SUBSYSTEM

·       PRODUCT

·       PRODUCT_TYPE

·       PARENT_PRODUCT

·       OPEN

The Coupon Scope Rule field displays on the Coupon Rules screen.

COUPON_STATUS

Y

The status of the coupon.

The following codes are delivered with base and cannot be changed:

·       Active Coupon

·       Inactive Coupon

·       Expired Coupon

The Coupon Status field displays on the Coupon Maintenance screen.

COUPON_TYPE

Y

The type of coupon.

The following codes are delivered with base and cannot be changed:

·       Generic Coupon

·       Customer Specified Coupon

The Coupon Type field displays on the Coupon Maintenance screen.

CUSRELATION

N

The relationship classification.

DISCOUNT_CATEGORY

N

This has not currently been implemented and should not be used.

EXPIRATION_RULE

N

This controls how long the coupon is valid for customer use. The Expiration Count field further defines the rule defined here. This is used only for customer-specific coupons. Generic coupons are controlled specifically by the Valid Thru date. It is used to set the CUS_Coupon table’s expiration date when a product is purchased or otherwise specifically granted to the customer.

The Expiration Rule field displays on the Coupon Rules screen.

LINK_STATUS

Y

The status of the coupon linked to a product.

The following codes are delivered with base and cannot be changed:

·       Active

·       Inactive

The Status field displays on the Product Coupon Link (CPN002) screen.

ORDER_SCOPE_RULE

Y

This indicates whether the coupon is applicable to the entire order or to an order line item.

The following codes are delivered with base and cannot be changed:

·       Order Line Item Coupon

·       Entire Order Coupon

The Order Scope Rule field displays on the Coupon Maintenance screen.

VALUE_RULE

Y

The method or rule by which the price reduction for the coupon is defined.

The following codes are delivered with base and cannot be changed:

·       Percentage

·       Amount

·       None

The Value Rule field displays on the Coupon Maintenance screen.