D Appendix: Promotion and Markdown Run Overview

This table provides information about table columns and calculations for Promotion and Markdown Optimization runs.

Column Heading Default (Y/N) Definition DB Reference / Calculation Table Name: PRO_RUN_HDR_VW

Run Id

Y

System-generated unique identifier for the run.

RUN_HDR_ID

Finalized

Y

This flag indicates that recommendations from this run are finalized and used in the Manage LPO Recommendation screen

FINALIZED_FLG

Run Name

Y

User provided name for the run.

RUN_NAME

Run Description

N

User provided description for the run.

RUN_DESCR

Pricing Objective

Y

A description of the objective used for the run. For example, Increase Gross Margin.

PRICING_OBJECTIVE_DESCR

Season

Y

A description of the Season.

SEASON_NAME

Department

Y

A description of the Department.

CONCAT(PROD_HIER_EXT_CODE,"-",PROD_HIER_NAME)

Price Zone

Y

Price zone of the item recommendation. Corresponds to the run setup level.

CONCAT(PRICE_ZONE_GRP_EXT_CODE,"-",PRICE_ZONE_GRP_NAME)

Company

Y

Location of the item recommendation. (For example, Region, Channel, and so on). Corresponds to the run location setup level. Will be chain when using price zones. PRO_DB_PARAMETER_VW; #PRO_LOC_HIER_PROCESSING_LVL = 1 (RSE_HIER_LVL)

CONCAT(PRICE_ZONE_EXT_CODE,"+",PRICE_ZONE_NAME)

Effective Week

Y

The week ending date for which the run was executed.

CONCAT(LOC_HIER_EXT_CODE,"+",LOC_HIER_NAME)

Strategy

Y

The strategy used for the optimization of the run. It can be either the DEFAULT STRATEGY or other custom strategy.

RULE_SET_NAME

Proj Rev

Y

Projected Revenue (AMT) for the run is the revenue generated by optimization in the run's currency.

REVENUE

Rev %CHG

Y

Projected Revenue (%CHG) is the% revenue gain compared to the current price policy.

PCT_REVENUE_CHG

Proj Gross Margin

Y

Projected Gross Margin (AMT) for the run is the gross margin generated by optimization in the run's currency.

GROSS_MARGIN

GM %CHG

Y

Projected Gross Margin (CHG) is the% gross margin gain compared to the current price policy.

PCT_GMARGIN_CHG

Proj Sell Thru

Y

Projected Sell Through (PCT) for the run is the sell-through generated by optimization.

SELLTHROUGH

Sell Thru %CHG

Y

Projected Sell Through (%CHG) is the% gain in sell-through over the current price policy.

PCT_SELLTHROUGH_CHG

Proj Sls Units

Y

Project sales unit generated by optimization.

OPTIMAL_FORECASTED_SALES

Proj Promo Budget (Life)

Y

Projected lifetime promotion budget by optimization.

PROMO_BUDGET_USED

Proj Mkdn Budget (Life)

Y

Projected lifetime markdown budget by optimization.

MKDN_BUDGET_USED

Total Item Cnt

Y

Total item count

ITEM_OPTIMIZED_COUNT

No Rec Item Cnt

Y

Total items that are in 'No Recommendation' status

ITEM_NOREC_COUNT

Non-fcst Item Cnt

Y

Total items not included in forecast.

ITEM_NONFCST_COUNT

Promo Item Cnt

Y

Total items included in promotion.

ITEM_PROMO_COUNT

Mkdn Item Cnt

Y

Total items included in markdown.

ITEM_MKDN_COUNT

Plan Event Item Cnt

Y

Total items included in planned events.

ITEM_PLAN_PROMOTION_COUNT

Usr Ovrd Item Cnt

Y

Total items that are overridden by user

ITEM_USR_OVRD_COUNT

Sell Thru Fcst

Y

Projected Sell Through Forecast (PCT) for the run is the sell-through generated by optimization.

SELL_THRU_FCST

Sell Thru Fcst %CHG

Y

Projected Sell Through Forecast (%CHG) is the% gain in sell-through over the current price policy.

PCT_SELL_THRU_FCST_CHG

Run Status

Y

Status of the run.

RUN_STATUS_DESCR

Status Update

Y

The date when the run status was updated.

CHANGED_ON_DT

Optimized On

Y

The date when the run was optimized.

LAST_EXECUTION_DATE

Modified By

Y

Login ID of the user who modified the run.

CHANGED_BY_USER

Created By

Y

Login ID of the user who created the run.

CREATED_BY_USER

Created Date

Y

The date when the run was first created.

CREATED_ON_DT