The Store Inventory table provides information about inventory at the store level at an NDC number, store, day grain.
The following provides Store Inventory column details, in alphabetical order.
| Technical Name | Business Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|
| geo_region_cd | Geographic Region Code | String | Y | - | - |
| invt_dt | Inventory Date | Date | Y | - | - |
| ly_on_hand_qty | Store On Hand Quantity - Last Year | Numeric | Y | - | Curr On Hand Qty,Curr Str On Hand Qty,Sat On Hand Qty,Hist On Hand Qty,Fri On Hand Qty,Sun On Hand Qty,Mon On Hand Qty,Tue On Hand Qty,Wed On Hand Qty,Thu On Hand Qty,Store Weeks Supply,Est Retail Turns |
| ndc_nbr | National Drug Code Number | String | Y | - | - |
| op_cmpny_cd | Operational Company Code | String | Y | - | - |
| store_nbr | Store Number | Int64 | - | - | Store Nbr |
| ty_on_hand_qty | Store On Hand Quantity - This Year | Numeric | - | - | Curr On Hand Qty,Curr Str On Hand Qty,Sat On Hand Qty,Hist On Hand Qty,Fri On Hand Qty,Sun On Hand Qty,Mon On Hand Qty,Tue On Hand Qty,Wed On Hand Qty,Thu On Hand Qty,Store Weeks Supply,Est Retail Turns |
| wm_yr_wk_nbr | Walmart Year Week Number | Int64 | - | - | Sale WM Week |
©️Walmart | All Rights Reserved | Confidential
