C Appendix: Regular - Manage Recommendations
The following table uses the official Manage Recommendations appendix column-heading format and keeps the Rules Based Regular Pricing columns that are relevant to recommendation review and action.
Table C-1 C-1 Column Details
| Column Heading | Default | Definition | DB Reference / Calculation |
|---|---|---|---|
| Flag | Y | Users can flag the recommendation for further review. | PRO_RUN_RECOM_OPT_RESULT.FCST_REVIEW_CODE |
| Notes | Y | Users can enter comments for the recommendation. | PRO_RUN_RECOM_OPT_RESULT.FCST_NOTE |
| Ovrd Status | Y | Shows whether the item has any pending recalculation and which user requested it. | PRO_RUN_RECOM_OPT_RESULT.CHANGED_BY_USER |
| Item / Product Hierarchy | Y | External code, name, and description for the item and product hierarchy levels. | CONCAT(RSE_PROD_HIER.PROD_EXT_CODE, '-', RSE_PROD_HIER.NAME) |
| Item Descr | Y | Item description, external code, and name shown in separate columns. | RSE_PROD_HIER.DESCR |
| Brand Name | Y | Brand name for the item. | RSE_PROD_GRP.NAME |
| Price Zone | Y | Price zone of the item recommendation. Corresponds to the run setup level. | RSE_PRICE_ZONE and RSE_PRICE_ZONE_GRP |
| Location Hierarchy | Y | Chain, area, region, district, or location hierarchy values. Not applicable when price zones are used. | RSE_LOC_HIER_DH |
| Rec Status | Y | Recommendation status of the item, such as Ready for Review, Reviewed, Approved, Submitted, or Export Failed. | PRO_RUN_RECOM_OPT_RESULT.RECOMMENDATION_STATUS_ID joined with PRO_RECOMMENDATION_STATUS |
| Season | Y | Season, such as Fall 2024 Merchandise. | PRO_SEASON.NAME |
| Rec Price | Y | Recommended price of the item. | PRO_RUN_RECOM_OPT_RESULT.RECOM_PRICE |
| Rec Type | Y | Recommendation type of the item, such as Regular or No Recommendation. | PRO_RUN_RECOM_OPT_RESULT.PRICE_RECOM_TYPE_ID joined with PRO_PRICE_RECOM_TYPE |
| Run Id and Name | Y | ID and name of the optimization run that generated the recommendation. | CONCAT(PRO_RUN_HDR.ID, '-', PRO_RUN_HDR.NAME) |
| Optimization Date | Y | Date of optimization run. | PRO_RUN_HDR.LAST_EXECUTION_DATE |
| Recalculation Date | Y | Date when the item was recalculated. | PRO_RUN_RECOM_OPT_RESULT.RECALCULATE_DT |
| Recalculation User | Y | User who last requested the recalculation. | PRO_RUN_RECOM_OPT_RESULT.RECALCULATE_BY_USER |
| Exported On Date | Y | Date when the item was exported after approval. | PRO_RUN_RECOM_OPT_RESULT.EXPORTED_ON_DT |
| Approved By User | Y | User who approved the recommendation. | PRO_RUN_RECOM_OPT_RESULT.EXPORTED_BY_USER |
| Ovrd Price | N | Overridden price for the item. | PRO_RUN_RECOM_OPT_RESULT.USR_OVRD_RECOM_PRICE |
| Ovrd Price Type | N | Override price type for the item. | PRO_RUN_RECOM_OPT_RESULT.USR_OVRD_PRICE_RECOM_TYPE_ID joined with PRO_PRICE_RECOM_TYPE |
| Max Competitor Price | N | Maximum competitor price for the item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.MAX_COMPETITOR_PRICE |
| Min Competitor Price | N | Minimum competitor price for the item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.MIN_COMPETITOR_PRICE |
| Avg Competitor Price | N | Average competitor price for the item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.AVG_COMPETITOR_PRICE |
| Most Common Competitor Price | N | Most common competitor price for the item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.MCV_COMPETITOR_PRICE |
| Product Attribute 1 - 5 | N | Product attributes selected by the user in the filter, such as Brand. | RSE_PROD_ATTR |
| Currency Attribute 1 - 30 | Y | User-defined attribute of currency type. | Flex Fact (W_RTL_FLEX_FACT) |
| Date Attribute 1 - 15 | Y | User-defined attribute of date type. | Flex Fact (W_RTL_FLEX_FACT) |
| Number Attribute 1 - 40 | Y | User-defined attribute of number type. | Flex Fact (W_RTL_FLEX_FACT) |
| Percentage Attribute 1 - 15 | Y | User-defined attribute of percentage type. | Flex Fact (W_RTL_FLEX_FACT) |