Replenishment style wise output-Final Store level output
- Jaikirat Singh (Unlicensed)
- Somya Gupta (Unlicensed)
Column | Description |
store | name of store |
store_code | unique code of store |
channel | channel to which store belongs |
store_class | class assigned to store in store master |
store_cluster | cluster mentioned for store in store master |
city | city in which store is located |
region | region of the store |
ean | ean |
style | style code |
parent_style | parent code of style if any, otherwise same as style code |
style_description | article name |
master_category | master category to which style belongs |
category | category to which style belongs |
subcategory | subcategory of style |
brand | brand mentioned in style master |
brand_segment | style brand segment mentioned in style master table |
season | season to which style belongs- AW/SS |
gender | gender of style |
size | size of style |
size_group | size group- pivotal/non-pivotal |
initial_qty_at_store | initial store stock |
ist_in_transfer | Inter Store Transfer qty if any |
goods_in_transit | GIT qty if any |
open_orders | Open Orders qty if any |
dispatch_suggested | Suggestion as per the ros, cover, max sku depth & other constraints. |
final_qty_at_store | Inclusive of IST, GIT, Open Order, Dispatch Suggested. |
pull_back | number of articles in the style suggested for pullback, if enabled |
type | type of iteration, (Pullback, Replenishment, Allocation) |
iteration_flag | TOP_SELLER_ITERATION, REPLENISHMENT_ITERATION |
segment | TOP_SELLER, NORMAL_SELLER, BOTTOM_SELLER |
remarks | Reason for dispatch suggested/not suggested |
suggested_allocation | As per the ros and cover |
period_one_sales | 7 days sales |
period_two_sales | 30 days sales |
period_three_sales | 60 days sales |
period_one_ros | Per day ros considering 7 days sales |
period_two_ros | Per day ros considering 30 days sales |
period_three_ros | Per day ros considering 60 days sales |
recent_sku_ros | (Period 1 ROS* period 1 Weightage + Period 2 ROS* Period 2 Weightage + Period 3 * Weightage3)/ (Weightage1+Weightage2+Weightage3) |
pre_psa | Pivotal Size Availability,before dispatch suggested |
post_psa | Pivotal Size Availability, after dispatch suggested |