Store Sales Columns

The Store Sales table provides information about all store sales at item, channel, store, or Date level.

The following provides Store Sales column details, in alphabetical order.

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_aur	Last Year AUR	Decimal (11,2)	-	-
ly_qty	POS Quantity - Last Year	Decimal (11,2)	-	-	POS Qty,Fri Qty,Sat Qty,Sun Qty,Mon Qty,Tue Qty,Wed Qty,Thu Qty
ly_sales_amt	POS Sales - Last Year	Decimal (11,2)	-	-	POS Sales,Sat Sales,Sun Sales,Mon Sales,Fri Sales,Wed Sales,Thu Sales,Tue Sales
ly_scan_cnt	Scan Count - Last Year	Integer	-	-
mds_fam_id	Store Item ID	Long	-	-	Item Nbr
op_cmpny_cd	Operational Company Code	String	-	-	Op cmpny cd
rpt_cd	Sales By Type	String	Y	-	-
store_nbr	Store Number	Integer	Y	-	Store Nbr,POS Store Count
svc_chnl_nm	Service Channel	String	Y	-
ty_aur	This Year AUR	Decimal (11,2)	-	-
ty_qty	POS Quantity - This Year	Decimal (11,2)	-	-	POS Qty, Fri Qty, Sat Qty, Sun Qty, Mon Qty, Tue Qty, Wed Qty, Thu Qty, COMP Store Qty, Units per Store per Week (w/o zeros), Units per Store per Week (w/zeros), Store Weeks Supply, Avg Price, Sales Type, Est Retail Turns, Alternate Selling Unit POS Qty, Sell Thru, Alternate Selling Unit POS Avg Price
ty_sales_amt	POS Sales - This Year	Decimal (11,2)	-	-	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_scan_cnt	Scan Count - This Year	Integer	-	-
vendor_nbr	Vendor Number	Integer	-	-	Vendor Nbr
vendor_nm	Vendor Name	String	-	-	Vendor Name
wm_item_nbr	Walmart Item Number	Long	Y	-	Walmart Item Number
wm_yr_wk_nbr	Walmart Year Week Number	Integer	-	-	WM Week