Campaigns

campaign is marked as a key column in the RELEX interface definition. This value is carried on the RELEX campaigns interface and must remain semantically intact during migration.

name is marked as Must have in the RELEX interface definition. This value is carried on the RELEX campaigns interface and must remain semantically intact during migration.

start_date is marked as Must have in the RELEX interface definition. This value is carried on the RELEX campaigns interface and must remain semantically intact during migration.

end_date is marked as Must have in the RELEX interface definition. This value is carried on the RELEX campaigns interface and must remain semantically intact during migration.

Distinguishes the class of the campaign - PROMOTION = planned promotional activity - EVENT = Event affecting forecast e.g. Christmas or local concert - MARKDOWN = planned markdown campaign with reduced price - CANNIBALIZATION, HALO = Campaigns to take cannibalization and halo into account - TEMPORARY_STORE_CLOSURE = Location closed due to e.g. renovation naturally changes sales in that location to 0 - OTHER = any other class that is needed

Category of the campaign. This is a non-functional field, but can be used to contain useful information about the campaign. NOTE: Campaign classification requirements need to be discussed in the early phase of the project.

ID of promotion group if promotion belongs to a group

The minimum quantity required for the consumer to purchase to redeem the promotion.

The upper limit on number of purchased items for the promotion in a consumer basket.

The reward quantity consumer gets when redeeming the promotion.

The number of products required to trigger the promotion each time. The same promotion can be redeemed multiple times.

Price modification method corresponding to the definition of the consumer offer. Possible values: AMT_OFF = Amount off PCT_OFF = Percentage off NEW_VALUE = New price NO_DISCOUNT = No discount

Numeric value of the consumer offer, including tax. The value depends on price_modification_method_code. If price_modification_method_code = PCT_OFF, and the percentage off is 25%, price_modification_value = 0.25 If price_modification_method_code = NO_DISCOUNT, price_modification_value should be zero (0)

Set to DELETE to delete the campaign. Otherwise empty.