Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

COLUMN HEADER

EXPLANATION

period

 The input period defined for analysis of historical data

store_code

Distinct store code given to each store

store_name

Name of the Store

store_class

Grade or class of the store

store_cluster

Cluster of which the particular store is a part of 

city

City in which the store is located

region

Region in which the store is located

ean

 Barcode or European article number

size

 Size of the product/ean

style

 Style to which the ean belongs

style_description

 Brief description of the styles

master_category

 Overall master category to which this style belongs to

category

 Category of the article. A category can only be associated to a single Master category

subcategory

 subcat to which the article belongs

brand

 brand to which the article belongs

brand_segment

 brand segment to which the article belongs

gender

 gender for which the article is made for

season

 season to which the article belongs

price_bucket

 A price bucket is a range or category of prices that products or services are grouped into for pricing and marketing purposes

target_cover

 The No. of days for which would like to maintain qty in this given ean for

opening_store_inv

 Store inventory at the time of starting the algo run

sales_in_lead_time

 Estimated sales in the Given Lead time

store_style_ros

 Combined Average ROS of the stores belonging to the given store group for a particular style

store_sku_ros

 Combined Average ROS of the stores belonging to the given store group for a particular ean

iss_contri

 The contribution of that size to the ideal size set of the style at store group level.

ros_flag_at_store

 Defined at which level the ROS for the store group was resolved and calculated.

reorder_style_theme

 Suggestion if an ean should or should not be reordered, and its priority.

target_sales

 Predicted sales for the ean in the given cover days period considering ean ROS

closing_store_stock

 Expected store stock at the end of Lead time+ cover days

period_duration

 The lead time defined

closing_date

 Date which mark the end of the lead time

cover_end_date

 Date which marks the end of the cover defined