Versions Compared

Key

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

Column

Description

channel

channel to which the store belongs

store

name of store

store_code

unique code of store

region

region to which the store belongs

brand

name of the brand for which a particular article is belonged to in style master table , for e.g- a boys category white t-shirt belonged to Brand Blue Giraffe

master_category

master category to which style belongs

category

category to which style belongs

attribute

attribute of style

options_pre_total

number of options/styles in store before Replenishment/Replacement or IST

options_pre_healthy

number of healthy options/styles in store before Replenishment/Replacement or IST

quantity_pre_total

number of articles in store before Replenishment/Replacement or IST

quantity_pre_healthy

number of articles belonging to healthy set in store before Replenishment/Replacement or IST

dispatch

numbers of articles dispatched to the store

options_post_total

number of options/styles in store after Replenishment/Replacement or IST

options_post_healthy

number of healthy options/styles in store after Replenishment/Replacement or IST

quantity_post_total

number of articles in store after Replenishment/Replacement or IST

quantity_post_healthy

number of articles belonging to healthy set in store after Replenishment/Replacement or IST

planogram_options

number of options/styles store can display according to planogram

planogram_quantity

number of articles store can display according to planogram

options_fill_rate_pre

ratio of options_pre_total to planogram_options

qty_fill_rate_pre

ratio of quantity_pre_total to planogram_quantity

options_fill_rate_pre_healthy

ratio of options_pre_healthy to planogram_options

qty_fill_rate_pre_healthy

ratio of quantity_pre_healthy to planogram_quantity

option_fill_rate_post

ratio of options_post_total to planogram_options

qty_fill_rate_post

ratio of quantity_post_total to planogram_quantity

option_fill_rate_post_healthy

ratio of options_post_healthy to planogram_options

qty_fill_rate_post_healthy

ratio of quantity_post_healthy to planogram_quantity