The Store Sales table provides information about all store sales at item, store, or date level.
| Technical Name | Business Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|
| bus_dt | Business Date | Date | Y | - | Store Weeks Supply |
| geo_region_cd | Geographic Region Code | String | Y | - | - |
| ly_sales_amt | POS Sales - Last Year | Numeric | - | - | POS Sales,Sat Sales,Sun Sales,Mon Sales,Fri Sales,Wed Sales,Thu Sales,Tue Sales |
| ly_sales_qty | POS Sales Quantity - Last Year | Numeric | - | - | - |
| ndc_nbr | National Drug Code Number | String | Y | - | - |
| op_cmpny_cd | Company Code | String | Y | - | Op cmpny cd |
| store_nbr | Walmart Store Number | Int64 | Y | - | Store Nbr,POS Store Count |
| ty_sales_amt | POS Sales-This Year | Numeric | - | - | POS Sales, Sat Sales, Sun Sales, Mon Sales, Fri Sales, Wed Sales, Thu Sales, Tue Sales, COMP Store Sales, Sales $ per Store per Week (w/o zeros), Sales$ per Store per Week (w/zeros), Avg Price, MUMD as % of Sales, Sales Type, Est Unit Turns, Alternate Selling Unit POS Sales, Alternate Selling Unit POS Avg Price |
| ty_sales_qty | POS Sales Quantity - This Year | Numeric | - | - | - |
| wm_yr_wk_nbr | Walmart Year Week Number | Int64 | - | - | WM Week |
©️Walmart | All Rights Reserved | Confidential
