Sales Inventory Data Help Section
- Abhist Srivastava
- Surya M
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
This contains information regarding the SKUs which are in transit from one store to another on a given day
Open purchase orders
This table contains the information about warehouse open orders at channel + Store Code + SKU level on a given day
Margin Inputs
This table is relevant for the brands who want to track the COGS and net revenue at channel + store code + SKU level on a given day
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 |
NET_REVENUE | Net Revenue generated from the product |
COGS | Cost of Goods Sold |