Share via


OrderDiscount

The OrderDiscount class represents discounted sale items. The class contains data members describing the items and conditions of the sale.

Data Members

Data member name

Data type

Default value

Description

DiscAwardExpr

int

null

None.

DiscAwardMax

int

null

Stores the maximum amount of discount awarded.

DiscClickRequired

smallint

null

Indicates whether a click is required to enable the discount.

DiscCondBasis

int

null

Stores the base condition code for the discount.

DiscCondExpr

int

null

None.

DiscCondMin

float

null

Stores the minimum amount that must be spent before applying the discount.

DiscDescription

nvarchar(255)

null

Stores a description of the order discount item.

DiscDisjointCondAward

smallint

null

Indicates whether a disjoint condition exists governing the award of the discount.

DiscExprUsedForDisplay

smallint

null

Indicates whether the discount item is used only for display.

DiscLimit

int

null

Stores the limit on discount item orders.

DiscNum

int

0

Stores the unique key for the object. Key member.

DiscOfferType

int

null

Stores a code that indicates the type of discount offer:

1 - Flat amount

2 - Percentage

DiscOfferValue

float

null

Stores the value of the discount offer.

DiscOrderLevelDiscount

smallint

null

None.

DiscQtyCondMin

int

null

Stores the minimum quantity required before the discount can be applied.

DiscRank

int

null

Stores the relative rank for the discount item.

DiscSpecialOfferType

nvarchar(255)

null

Stores a code that indicates the type of special offer associated with the discount.

DiscTemplate

int

null

Stores the code for the template that was used for the discount item.

SiteName

nvarchar(255)

Unknown

Stores the name of the site associated with the object. Key member.

CampaignItemID

binary

1

None.

Class Key

OrderDiscountKey is composed of the following data members:

   DiscNum + SiteName.Relations

For a description of the relation type, see Data Warehouse Classes.

Relation name

Parent

Child

Type

OrderDiscountCampaignItem

CampaignItem

OrderDiscount

2

See Also

Other Resources

Data Warehouse Classes