Column Description
channel channel to which store belongs
store_class class assigned to store in store master
store_cluster cluster mentioned for store in store master
store name of store
store_code unique code of store
city city in which store is located
region region of the store
ist_group group assigned to the store in store list input
style style code
parent_style parent code of style if any, otherwise same as style code
style_desc description details of style code
brand brand mentioned in style master
brand_segment style's brand segment mentioned in style master
gender gender of style
master_category master category to which style belongs
category category to which style belongs
subcategory subcategory of style
season season the style belongs to
size size of the style
size_group size group of style at store- pivotal/non-pivotal
ean_code ean code of style (unique)
pre_stock number of articles for style-size at the store before IST, this included goods-in-transit and open-orders quantity
post_stock number of articles for style-size at the store after IST, this included goods-in-transit and open-orders quantity
pull_back number of articles in the style-size suggested for pullback to warehouse
ros rate of sales of the style-size at the store
type type of action at store-style level
period_one_sales sales which happened for style-size at the store during last number of days specified for ROS period 1 in UI
period_two_sales sales which happened for style-size at the store during last number of days specified for ROS period 2 in UI
period_three_sales sales which happened for style-size at the store during last number of days specified for ROS period 3 in UI
period_one_ros rate of sale calculated for style-size at the store (for live days) during last number of days specified for ROS period 1 in UI
period_two_ros rate of sale calculated for style-size at the store (for live days) during last number of days specified for ROS period 2 in UI
period_three_ros rate of sale calculated for style-size at the store (for live days) during last number of days specified for ROS period 3 in UI
segment specifies whether style is a top/normal/ bottom seller at the store
pre_psa pivotal size availability of style at the store pre IST
post_psa pivotal size availability of style at the store post IST