...
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
...
| Child pages (Children Display) |
|---|