Sales
The table containing information about sales quantity, discount and revenue at day + channel + store_code + SKU level
| Column | Description |
|---|---|
| CHANNEL | Channel to which the Sale belongs. Eg. Online, EBO etc. |
| STORE_CODE | Unique code of the store |
| SKU | SKU code of the product sold |
| DAY | Day on which the sales happened |
| ONLINE | Value should be 1 if sales is online, else 0 if offline |
| QTY | Quantity of the product sold |
| DISC_VALUE | Discount on the product |
| REVENUE | Revenue generated from the product |
Warehouse Stock
The table containing information regarding the SKU quantity at the day level in a warehouse
Store Stock (historical)
This contains historical data on the quantity of each EAN available on a given day at channel + store code level
Store Stock on hand
This contains data regarding the quantity of each EAN available on a given day at the channel + store code level
Warehouse to store goods in transit
This contains information regarding the SKUs which are in transit from warehouse to store on a given day at channel + store code level
Warehouse to warehouse goods in transit
This contains information regarding the SKUs which are in transit from one warehouse to another on a given day
Store to store goods in transit