G Appendix: Regular Manage LPO Recommendation
This table provides information about table columns and calculations for Regular Optimization recommendations.
| Column Heading | Default (Y/N) | Definition | DB Reference / Calculation |
|---|---|---|---|
|
Image |
Y |
#N/A |
N/A |
|
Flag |
Y |
Users can flag the recommendation for further review. |
PRO_REG_RUN_RECOM_OPT_RESULT.FCST_REVIEW_CODE |
|
Notes |
Y |
Users can enter any comment for the recommendation. For example, Additional Budget received so overriding to a deeper markdown. |
PRO_REG_RUN_RECOM_OPT_RESULT.FCST_NOTE |
|
Ovrd Status |
Y |
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 |
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) |
RSE_LOC_HIER |
|
Item Descr |
Y |
Item description, external code, and name separated in different columns. |
RSE_PROD_HIER.DESCRRSE_PROD_HIER.HIER_LEVEL_ID=8 |
|
Brand Name |
Y |
Name of the brand. |
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 |
|
Rec Status |
Y |
Recommendation status of the item, which says Ready for Review > Reviewed > Approved/Submitted/Taken > Export Failed |
PRO_REG_RUN_RECOM_OPT_RESULT.RECOMMENDATION_STATUS_IDJoin With PRO_RECOMMENDATION_STATUS on ID to get UI_NAME. |
|
Tkt Price |
Y |
Ticket Price of the item. Reflects TRAN TYPE 0, 4, 8. Rolled up from leaf node levels. (For example, SKU-STORE) using Most Common Value.) |
PRO_REG_RUN_RECOM_OPT_RESULT.CURRENT_PRICE |
|
Reg Price |
Y |
Regular Price of the item. Reflects TRAN TYPE 0, 4. Rolled up from leaf node levels (For example, SKU-STORE) using Most Common Value. |
PRO_REG_RUN_RECOM_OPT_RESULT.LAST_REGULAR_PRICE |
|
Orig Price |
Y |
Original Price of the item. Reflects TRAN TYPE 0. Rolled up from leaf node levels (For example, SKU-STORE) using Most Common Value. |
PRO_REG_RUN_RECOM_OPT_RESULT.REGULAR_PRICE |
|
Eff Price |
Y |
Effective Price of the item - it will reflect either the recommended or the overridden/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 |
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 |
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 |
Effective % Change of Average Ticket Value, compared to a previous period (like LFY, LFQ, and so on). |
Calculated during optimization and displayed in the UI. |
|
Eff %Chg of Orig |
Y |
Effective percentage Change of Original Price, compared to a previous period (like LFY, LFQ, and so on). |
Calculated during optimization and displayed in the UI. |
|
Eff %Chg of Reg |
Y |
Effective percentage Change of Regular Price, compared to a previous period (like LFY, LFQ, and so on). |
Calculated during optimization and displayed in the UI. |
|
Rec Price |
Y |
Recommended Price of the Item. |
PRO_REG_RUN_RECOM_OPT_RESULT.RECOM_PRICE |
|
Rec Type |
Y |
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 |
Recommended percentage Change of Ticket. |
Calculated during optimization and displayed in the UI. |
|
Rec %Chg of Orig |
Y |
Recommended percentage Change of Original Price. |
Calculated during optimization and displayed in the UI. |
|
Proj Sls Units |
Y |
Projected Sales Units for the Effective Week, including any applied overrides. |
PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_FORECASTED_SALES |
|
Proj Sls Rev |
Y |
Projected Sales Revenue for the Effective Week, including any applied overrides. |
PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_REVENUE |
|
Proj GM |
Y |
Projected Gross Margin $ for the Effective Week, including any applied overrides. |
PRO_REG_RUN_RECOM_OPT_RESULT.OPTIMAL_GROSS_MARGIN |
|
Last Act Inv |
Y |
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 |
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 |
ID of optimization run generating rec. |
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 is recalculated. |
PRO_REG_RUN_RECOM_OPT_RESULT.RECALCULATE_DT |
|
Recalculation User |
Y |
User who last requested the recalculate. |
PRO_REG_RUN_RECOM_OPT_RESULT.RECALCULATE_BY_USER |
|
Exported On Date |
Y |
Date when the item is Approved |
PRO_REG_RUN_RECOM_OPT_RESULT.EXPORTED_ON_DT |
|
Approved By User |
Y |
User who approved the recommendation. |
PRO_REG_RUN_RECOM_OPT_RESULT.EXPORTED_BY_USER |
|
LFY Rev |
Y |
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 |
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 |
Last Fiscal Year Quarter Revenue - Revenue from a specific quarter of the last fiscal year (such as Q1, Q2, and so on.) |
PRO_REG_RUN_RECOM_DENORMALIZE.LFYQ_REVENUE |
|
LFH Rev |
Y |
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 |
Revenue from the Last Fiscal Quarter (For example, Q4). |
PRO_REG_RUN_RECOM_DENORMALIZE.LFQ_REVENUE |
|
LF2Q Rev |
Y |
Revenue from the 2nd Last Fiscal Quarter (that is, the quarter before LFQ - so if LFQ is Q4, this is Q3). |
PRO_REG_RUN_RECOM_DENORMALIZE.LF2Q_REVENUE |
|
LFY Sls Units |
Y |
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 |
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 |
Last Fiscal Year Quarter Sales Units - for example, Q4 of last fiscal year. |
PRO_REG_RUN_RECOM_DENORMALIZE.LFYQ_SALES |
|
LFH Sls Units |
Y |
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 |
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 |
2nd Last Fiscal Quarter Sales Units, The units sold in the quarter before the last one. |
PRO_REG_RUN_RECOM_DENORMALIZE.LF2Q_SALES |
|
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) |
|
Text Attribute 1 - 30 |
Y |
User Defined Attribute of Text Type. |
Flex Fact (W_RTL_FLEX_FACT) |
|
Ext Code, Name, Descr of - Item / Division / Group / Department / Class / Sub Class / Style / Style Color |
N |
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 |
Location Hierarchy. N/A with Price Zones. |
RSE_LOC_HIER_DH |
|
Ovrd Price |
N |
Overridden price for the item |
PRO_REG_RUN_RECOM_OPT_RESULT.USR_OVRD_RECOM_PRICE |
|
Ovrd Price Type |
N |
Override price type for the item. |
PRO_REG_RUN_RECOM_OPT_RESULT.USR_OVRD_PRICE_RECOM_TYPE_ID JOIN WITHPRO_PRICE_RECOM_TYPE ON ID to get DESCR |
|
Ovrd Price %Chg of Tkt |
N |
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 |
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 |
Start date of the Item. For example, 2% ST or 3 weeks from first receipt date. |
PRO_REG_RUN_RECOM_OPT_RESULT.MODEL_START_DT |
|
Text Attribute 1 - 30 |
Y |
User Defined Attribute of Text Type. |
Flex Fact (W_RTL_FLEX_FACT) |
|
Ext Code, Name, Descr of - Item / Division / Group / Department / Class / Sub Class / Style / Style Color |
N |
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 |
Location Hierarchy. N/A with Price Zones. |
RSE_LOC_HIER_DH |
|
Ovrd Price |
N |
Overridden price for the item |
PRO_REG_RUN_RECOM_OPT_RESULT.USR_OVRD_RECOM_PRICE |
|
Ovrd Price Type |
N |
Override price type for the item |
PRO_REG_RUN_RECOM_OPT_RESULT.USR_OVRD_PRICE_RECOM_TYPE_ID JOIN WITHPRO_PRICE_RECOM_TYPE ON ID to get DESCR |
|
Ovrd Price %Chg of Tkt |
N |
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 |
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 |
Start date of the Item. For example, 2% ST or 3 weeks from first receipt date. |
PRO_REG_RUN_RECOM_OPT_RESULT.MODEL_START_DT |
|
Final Ship Dt |
N |
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 |
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 |
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 |
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 |
The predicted gross margin based on the system's pricing optimization. |
Calculated during optimization and displayed in the UI. |
|
Sys Opt Inv |
N |
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 |
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 |
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 |
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 |
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 |
Last Fiscal Quarter Gross Margin - The gross margin for the most recent quarter of the last fiscal year. |
PRO_REG_RUN_RECOM_DENORMALIZE.LFQ |
|
LF2Q GM |
N |
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 |
The amount of the markdown budget that has been used by the system to products. |
Calculated during optimization and displayed in the UI. |
|
Target ST EOL |
N |
Business rule - percentage of sell-through for each product at end of clearance season |
PRO_REG_RUN_RECOM_OPT_RESULT.TARGET_ST_PCT |
|
ProdAttrValue1 - Prod AttrValue 5 |
N |
Product attributes selected by the user in the user filter. For example, Brand. |
RSE_PROD_ATTR |