Post Depletion Store Stock
- Jaikirat Singh (Unlicensed)
- Saroj Nayak (Unlicensed)
Column Name | Explanation |
|---|---|
channel | Channel to which the store belongs as per the store master |
store | store name corresponding to the store_code |
store_code | store_code provided in the store master |
ean_code | barcode for corresponding style_code |
style | style_code from style master |
season | season corresponding to the style_code provided in style master |
brand | season corresponding to the style_code provided in style master |
master_category | master_category corresponding to the style_code provided in style master |
category | category corresponding to the style_code provided in style master |
subcategory | Subcategory corresponding to the style_code provided in style master |
gender | gender corresponding to the style_code provided in style master |
price_bucket | price bucket corresponding to the style_code provided in style master |
attribute 1 | attribute 1 corresponding to the style_code provided in style master |
attribute 2 | attribute 2 corresponding to the style_code provided in style master |
size | size to which ean code belongs to provided to ean_code |
size_group | If the size of the store+style combination is pivotal or not |
ros | rolled up rate of sales of Store+Style+Size Combination |
start_date | Start date of the depletion period |
opening_inventory | Inventory of Story+Style+Size on the opening inventory of starting week of the depletion period. |
end_date | End date of the depletion period |
sales | Total Sales of Store+Style+Size from depletion start date to depletion end date. |
store_inwards | Total Inwards happened to the store during from depletion start to end date |
warehouse_dispatch | Total Dispatch happened at a Store+SKU level from the warehouse during the depletion period. |
closing_inventory | Inventory of Story+Style+Size on the closing inventory of the depletion period or end week of depletion |
warehouse_inwards | Total Inwards happened to the Warehouse during from depletion start to end date which will be used for dispatching stock the store from the date it got inwarded |
remaining_warehouse_stock | Remaining WH Stock at the end of depletion period. |
online_reservation_required |
|
online_reservation_achieved |
|