G Appendix: Regular - Manage LPO Recommendations
This table provides information about table columns and calculations for Regular Optimization recommendations.
| Column Heading | Default (Y/N) | Applicability (Forecast or Non-Forecast/Rules Based) | Definition | DB Reference / Calculation |
|---|---|---|---|---|
| Image | Y | Both | #N/A | N/A |
| Flag | Y | Both | Users can flag the recommendation for further review. | PRO_REG_RUN_RECOM_OPT_RESULT.FCST_REVIEW_CODE |
| Notes | Y | Both | Users can enter any comment for the recommendation. For e.g., Additional Budget received so overriding to a deeper markdown. | PRO_REG_RUN_RECOM_OPT_RESULT.FCST_NOTE |
| Ovrd Status | Y | Both | Shows whether the item has any pending recalculate. It shows which user requested it. | PRO_REG_RUN_RECOM_OPT_RESULT.CHANGED_BY_USER |
| Company | Y | Both |
Location of the item recommendation. (For e.g Region, Channel, etc). 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) |
RSE_LOC_HIER |
| Item Descr | Y | Both | Item description, external code, and name separated in different columns |
RSE_PROD_HIER.DESCR RSE_PROD_HIER.HIER_LEVEL_ID=8 |
| Brand Name | Y | Both | Name of the brand. | RSE_PROD_GRP.NAME |
| Price Zone | Y | Both | Price zone of the item recommendation. Corresponds to the run setup level. | RSE_PRICE_ZONE and RSE_PRICE_ZONE_GRP |
| Rec Status | Y | Both | Recommendation status of the item, which says Ready for Review-> Reviewed -> Approved/Submitted/Taken -> Export Failed |
PRO_REG_RUN_RECOM_OPT_RESULT.RECOMMENDATION_STATUS_ID Join With PRO_RECOMMENDATION_STATUS on ID to get UI_NAME. |
| Tkt Price | Y | Both | Ticket Price of the item. Reflects TRAN TYPE 0, 4, 8. Rolled up from leaf node levels (e.g. SKU-STORE) using Most Common Value | PRO_REG_RUN_RECOM_OPT_RESULT.CURRENT_PRICE |
| Reg Price | Y | Both | Regular Price of the item. Reflects TRAN TYPE 0, 4. Rolled up from leaf node levels (e.g. SKU-STORE) using Most Common Value | PRO_REG_RUN_RECOM_OPT_RESULT.LAST_REGULAR_PRICE |
| Orig Price | Y | Both | Original Price of the item. Reflects TRAN TYPE 0. Rolled up from leaf node levels (e.g. SKU-STORE) using Most Common Value | PRO_REG_RUN_RECOM_OPT_RESULT.REGULAR_PRICE |
| Eff Price | Y | Both | Effective Price of the item - it will reflect either the recommended or the overriden/user added price. If the recommendation is rejected, then it will reflect the ticket price of the item. | Calculated during optimization and displayed in the UI. |
| Eff Rec Type | Y | Both | Effective Recommendation Type of the item. It will be recommended, or the overridden/user added or rejected action. | Calculated during optimization and displayed in the UI. |
| Eff Start Dt | Y | Both | Effective start date of the recommendation. Reflect user date override as well. | PRO_REG_RUN_RECOM_OPT_RESULT.EFF_START_DT |
| Eff %Chg of Tkt | Y | Both | Effective % Change of Average Ticket Value, compared to a previous period (like LFY, LFQ, etc.). | Calculated during optimization and displayed in the UI. |
| Eff %Chg of Orig | Y | Both | Effective Percentage Change of Original Price, compared to a previous period (like LFY, LFQ, etc.). | Calculated during optimization and displayed in the UI. |
| Eff %Chg of Reg | Y | Both | Effective Percentage Change of Regular Price, compared to a previous period (like LFY, LFQ, etc.). | Calculated during optimization and displayed in the UI. |
| Rec Price | Y | Both | Recommended Price of the Item | PRO_REG_RUN_RECOM_OPT_RESULT.RECOM_PRICE |
| Rec Type | Y | Both | Recommendation Type of the Item. Markdown, Promotion, No Recommendation, Non-forecasted | PRO_REG_RUN_RECOM_OPT_RESULT.PRICE_RECOM_TYPE_ID Join with PRO_PRICE_RECOM_TYPE on ID to get DESCR |
| Rec %Chg of Tkt | Y | Both | Recommended Percentage Change of Ticket. | Calculated during optimization and displayed in the UI. |
| Rec %Chg of Orig | Y | Both | Recommended Percentage Change of Original Price. | Calculated during optimization and displayed in the UI. |
| Proj Sls Units | Y | Forecast Only | Projected Sales Units for the Effective Week, including any applied overrides. | PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_FORECASTED_SALES |
| Proj Sls Rev | Y | Forecast Only | Projected Sales Revenue for the Effective Week, including any applied overrides. | PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_REVENUE |
| Proj GM | Y | Forecast Only | Projected Gross Margin $ for the Effective Week, including any applied overrides. | PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_GROSS_MARGIN |
| Last Act Inv | Y | Forecast Only | Inventory for the Last Actual Week (or Processing Week). It is the sum of all inventory components that are configured to be used for optimization. | PRO_REG_RUN_RECOM_OPT_RESULT.INV_QTY_LAD |
| Total Buy | Y | Forecast Only | It is sum of Cumulative Sls Units and the Last Act Inv. Cumulative Sls Units is calculated from the first receipt date. | PRO_REG_RUN_RECOM_OPT_RESULT.INITIAL_INVENTORY |
| Run Id and Name | Y | Both | ID of optimization run generating rec | CONCAT(PRO_RUN_HDR.ID,'-',PRO_RUN_HDR.NAME) |
| Optimization Date | Y | Both | Date of optimization run | PRO_RUN_HDR.LAST_EXECUTION_DATE |
| Recalculation Date | Y | Both | Date when the item is recalculated | PRO_REG_RUN_RECOM_OPT_RESULT.RECALCULATE_DT |
| Recalculation User | Y | Both | User who last requested the recalculate | PRO_REG_RUN_RECOM_OPT_RESULT.RECALCULATE_BY_USER |
| Exported On Date | Y | Both | Date when the item is Approved | PRO_REG_RUN_RECOM_OPT_RESULT.EXPORTED_ON_DT |
| Approved By User | Y | Both | User who approved the recommendation. | PRO_REG_RUN_RECOM_OPT_RESULT.EXPORTED_BY_USER |
| LFY Rev | Y | Forecast Only | Last Fiscal Year Revenue - The total revenue a company made during its most recently completed fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFY_REVENUE |
| LFYH Rev | Y | Forecast Only | Last Fiscal Year Half Revenue - The revenue from the first or second half of the last fiscal year, depending on the context. | PRO_REG_RUN_RECOM_DENORMALIZE.LFYH_REVENUE |
| LFYQ Rev | Y | Forecast Only | Last Fiscal Year Quarter Revenue - Revenue from a specific quarter of the last fiscal year (like Q1, Q2, etc.) | PRO_REG_RUN_RECOM_DENORMALIZE.LFYQ_REVENUE |
| LFH Rev | Y | Forecast Only | Last Fiscal Half Revenue - Revenue from the most recent half-year period in the last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFH_REVENUE |
| LFQ Rev | Y | Forecast Only | Revenue from the Last Fiscal Quarter (e.g., Q4 ) | PRO_REG_RUN_RECOM_DENORMALIZE.LFQ_REVENUE |
| LF2Q Rev | Y | Forecast Only | Revenue from the 2nd Last Fiscal Quarter (i.e., the quarter before LFQ - so if LFQ is Q4, this is Q3). | PRO_REG_RUN_RECOM_DENORMALIZE.LF2Q_REVENUE |
| LFY Sls Units | Y | Forecast Only | Last Fiscal Year Total Sales Units - Total units sold across all quarters of the last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFY_SALES |
| LFYH Sls Units | Y | Forecast Only | Last Fiscal Year Half Sales Units - Units sold during half of the last fiscal year (H1 or H2) | PRO_REG_RUN_RECOM_DENORMALIZE.LFYH_SALES |
| LFYQ Sls Units | Y | Forecast Only | Last Fiscal Year Quarter Sales Units - E.g Q4 of last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFYQ_SALES |
| LFH Sls Units | Y | Forecast Only | Last Fiscal Half Sales Units, The most recent half-year from LFY (either H1 or H2). | PRO_REG_RUN_RECOM_DENORMALIZE.LFH_SALES |
| LFQ Sls Units | Y | Forecast Only | Last Fiscal Quarter Sales Units, The units sold in the most recent quarter of the last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFQ_SALES |
| LF2Q Sls Units | Y | Forecast Only | 2nd Last Fiscal Quarter Sales Units, The units sold in the quarter before the last one. | PRO_REG_RUN_RECOM_DENORMALIZE.LF2Q_SALES |
| Ext Code, Name, Descr of - Item / Division / Group / Department / Class / Sub Class / Style / Style Color | N | Both | Product Hierarchy |
CONCAT(RSE_PROD_HIER.PROD_EXT_CODE,'-',RSE_PROD_HIER.NAME) Based on RSE_PROD_HIER.HIER_LEVEL_ID |
| Chain Ext Code / Name / Descr > Area > Region > District >Location Ext Code / Name / Descr | N | Both | Location Hierarchy. N/A with Price Zones. | RSE_LOC_HIER_DH |
| Ovrd Price | N | Both | Overriden price for the item | PRO_REG_RUN_RECOM_OPT_RESULT.USR_OVRD_RECOM_PRICE |
| Ovrd Price Type | N | Both | Override price type for the item |
PRO_REG_RUN_RECOM_OPT_RESULT.USR_OVRD_PRICE_RECOM_TYPE_ID JOIN WITH PRO_PRICE_RECOM_TYPE ON ID to get DESCR |
| Ovrd Price %Chg of Tkt | N | Both | The percentage change in ticket price based on user-overridden prices, compared to a previous period or baseline. | Calculated during optimization and displayed in the UI. |
| Rec Accepted? | N | Both | Y or No flag to denote whether recommendation was accepted as is or not. | PRO_REG_RUN_RECOM_OPT_RESULT.ACCEPTED_FLG |
| Proj Inv End of EW | N | Projected inventory at the end of the effective week, including any applied overrides. | PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_REMAINING_INVENTORY | |
| Start Dt | N | Both | Start date of the Item. For e.g., 2% ST or 3 weeks from first receipt date. | PRO_REG_RUN_RECOM_OPT_RESULT.MODEL_START_DT |
| Final Ship Dt | N | Both | Denotes the calculated final ship date of the item. Last inventory change date that is older than x weeks (configuration) is assigned as the final ship date for the item | PRO_REG_RUN_RECOM_OPT_RESULT.FINAL_SHIP_DT |
| Sys Recom Price | N | Both | System Recommended Price - Suggested by the pricing optimization system based on the rules, strategies, and algorithms it uses. | Calculated during optimization and displayed in the UI. |
| Sys Opt Sales Units | N | Forecast Only | The number of units the system predicts will be sold at the system-recommended price. | Calculated during optimization and displayed in the UI. |
| Sys Opt Revenue | N | Forecast Only | The predicted revenue based on the system-recommended price and the corresponding system-optimized sales units. | Calculated during optimization and displayed in the UI. |
| Sys Opt Gross Margin | N | Forecast Only | The predicted gross margin based on the system's pricing optimization. | Calculated during optimization and displayed in the UI. |
| Sys Opt Inv | N | Forecast Only | The inventory levels the system forecasts to meet the sales units needed at the system-recommended price. | Calculated during optimization and displayed in the UI. |
| LFY GM | N | Forecast Only | Last Fiscal Year Gross Margin - The gross margin for the entire last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFY_GROSS_MARGIN |
| LFYH GM | N | Forecast Only | Last Fiscal Year Half Gross Margin - The gross margin for the first or second half of the last fiscal year | PRO_REG_RUN_RECOM_DENORMALIZE.LFYH_GROSS_MARGIN |
| LFYQ GM | N | Forecast Only | Last Fiscal Year Quarter Gross Margin - The gross margin for the last fiscal quarter of the previous year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFYQ_GROSS_MARGIN |
| LFH GM | N | Forecast Only | Last Fiscal Half Gross Margin - The gross margin for half of the last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFH_GROSS_MARGIN |
| LFQ GM | N | Forecast Only | Last Fiscal Quarter Gross Margin - The gross margin for the most recent quarter of the last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LFQ_GROSS_MARGIN |
| LF2Q GM | N | Forecast Only | Second Last Fiscal Quarter Gross Margin - The gross margin for the quarter before the most recent one in the last fiscal year. | PRO_REG_RUN_RECOM_DENORMALIZE.LF2Q_GROSS_MARGIN |
| Sys Mkdn Budget Used | N | Forecast Only | The amount of the markdown budget that has been used by the system to products. | Calculated during optimization and displayed in the UI. |
| Max Competitor Price | N | Both | Max competitor price of that item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.MAX_COMPETITOR_PRICE |
| Min Competitor Price | N | Both | Min competitor price of that item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.MIN_COMPETITOR_PRICE |
| Avg Competitor Price | N | Both | Average competitor price of that item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.AVG_COMPETITOR_PRICE |
| Most Common Competitor Price | N | Both | Most common competitor price of that item-location. | PRO_REG_RUN_RECOM_OPT_RESULT.MCV_COMPETITOR_PRICE |
| Target ST EOL | N | Forecast Only | Business rule - Percentage of sell-through for each product at end of clearance season | PRO_REG_RUN_RECOM_OPT_RESULT.TARGET_ST_PCT |
| Currency Attribute 1 - 30 | Y | Both | User Defined Attribute of Currency Type | Flex Fact (W_RTL_FLEX_FACT) |
| Date Attribute 1 - 15 | Y | Both | User Defined Attribute of Date type | Flex Fact (W_RTL_FLEX_FACT) |
| Number Attribute 1 - 40 | Y | Both | User Defined Attribute of Number Type | Flex Fact (W_RTL_FLEX_FACT) |
| Percentage Attribute 1 - 15 | Y | Both | User Defined Attribute of Percentage Type | Flex Fact (W_RTL_FLEX_FACT) |
| Text Attribute 1 - 30 | Y | Both | User Defined Attribute of Text Type | Flex Fact (W_RTL_FLEX_FACT) |
| ProdAttrValue1 - Prod AttrValue 5 | N | Both | Product attributes selected by the user in the user filter. For e.g., Brand | RSE_PROD_ATTR |