marker_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the marker.

order_id

VARCHAR(40)

NOT NULL

The ID of the order for that has an order marker.

marker_key

VARCHAR(100)

NOT NULL

The name of the business process associated with the marker.

marker_value

VARCHAR(100)

NULL

The name of the business process stage associated with the marker.

marker_data

VARCHAR(100)

NULL

This column is not currently in use.

creation_date

timestamp

NULL

The date the business process stage is reached and the order marker is assigned to the order.

version

INTEGER

NOT NULL

The order marker repository version number. This information is managed and used internally by the repository.

marker_type

INTEGER

NULL

This column is not currently in use.

marker_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the marker.

gift_type

VARCHAR(100)

NOT NULL

The type of gift, which can be sku, product, category, or contentGroup.

gift_detail

VARCHAR(1024)

NOT NULL

String identifying the gift, usually the repository id of the gift type.

auto_remove

NUM

NOT NULL

Flag to indicate whether free gifts should be auto removed if the promotion no longer qualifies. This is configured by the merchandiser when the promotion is created.

quantity

INTEGER

NOT NULL

The total quantity of sku for this gift selection. It is the quantity from the PMDL multiplied by the number of times the offer applied (if it applied more than once due to a ‘for next’ or multiple grants).

targeted_quantity

INTEGER

NOT NULL

The quantity of free sku for this gift selection that has already been targeted and made free by the calculator in the order.

automatic_quantity

INTEGER

NOT NULL

The quantity of free sku for this gift selection that has already been auto added to the order.

selected_quantity

INTEGER

NULL

The quantity of free sku for this gift selection that has already been selected by the Shopper and added to the order.

removed_quantity

INTEGER

NULL

The amount of free quantity that has since been manually removed by a shopper. Keeping track of removed quantities prevents them from being automatically re-added in future pricing operations. The assumption is that the customer does not want the free item.

order_id

VARCHAR(40)

NOT NULL

Identifier of the order that contains the gift item.

marker_key

VARCHAR(100)

NOT NULL

Key identifying the type of the marker.

marker_value

VARC HAR(100)

NULL

Value of the marker.

marker_data

VARCHAR(100)

NOT NULL

Data for the marker.

marker_type

INT

NULL

The marker type.

failed_quantity

INT

NOT NULL

Quantity of gift with purchase items where an attempt was made to automatically add the item, but the attempt failed.

marker_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the marker.

targeted_quantity

INTEGER

NOT NULL

The quantity of the free gift that this commerce item is making free and was targeted by pricing.

automatic_quantity

INTEGER

NOT NULL

The quantity of the free gift that this commerce item is making free and was auto added by pricing.

selected_quantity

INTEGER

NULL

The quantity of the free gift that this commerce item is making free and was selected by the shopper.

commerce_item_id

VARCHAR(40)

NOT NULL

marker_key

VARCHAR(100)

NOT NULL

Key identifying the type of the marker.

marker_value

VARC HAR(100)

VARC HAR(100)

Value of the marker.

marker_type

VARCHAR(100)

VARCHAR(100)

Data for the marker.

remaining_quantity

INT

NOT NULL