E Appendix: Regular Run Overview
This table provides information about table columns and calculations for Regular Optimization runs.
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation Table Name: PRO_REG_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 |
Y |
User provided description for the run. |
RUN_DESCR |
|
Pricing Objective |
N |
The goal selected for the run, outlining the desired pricing strategy or target to be achieved. |
PRICING_OBJECTIVE_DESCR |
|
Season |
N |
A description of the Season. |
SEASON_NAME |
|
Department |
Y |
A description of the Department. |
CONCAT(PROD_HIER_EXT_CODE,"-",PROD_HIER_NAME) |
|
Price Zone Group |
Y |
Price zone group of the item recommendation. Corresponds to the run setup level. |
CONCAT(PRICE_ZONE_GRP_EXT_CODE,"-",PRICE_ZONE_GRP_NAME) |
|
Price Zone |
Y |
Price zone of the item recommendation. Corresponds to the run setup level. |
CONCAT(PRICE_ZONE_EXT_CODE,"+",PRICE_ZONE_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(LOC_HIER_EXT_CODE,"+",LOC_HIER_NAME) |
|
Opt Start Dt |
Y |
The start date of optimization. |
START_CAL_FROM_DT |
|
Opt End Dt |
Y |
The end date of optimization. |
END_CAL_TO_DT |
|
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 |
|
Volume |
Y |
Projected Volume for the run is the number of items to be sold generated by optimization. |
OPTIMAL_FORECASTED_SALES |
|
Volume %CHG |
Y |
Projected Volume (CHG) is the% volume gain compared to the current price policy. |
OPTIMAL_FORCASTED_SALES_CHANGE |
|
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 |
|
Reg Item Cnt |
Y |
Regular items count. |
ITEM_REGULAR_COUNT |
|
User Ovrd Item Cnt |
Y |
Total items that are overridden by user |
ITEM_USR_OVRD_COUNT |
|
Run Status |
Y |
Status of the run. |
RUN_STATUS_DESCR |
|
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 |