Store Inventory Columns

The Store Inventory table provides information about inventory at the store level; several types of metrics across in-stock inventory; and markup, markdown, and margins on an item, store, and day grain.

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

Technical Name	Business Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
bus_dt	Business Date	Date	Y	-	-
crncy_cd	Currency Code	String	-	-	-
geo_region_cd	Geographic Region Code	String	-	-	-
ly_gross_rcpt_qty	Gross Receipt Quantity - Last Year	Decimal (9,2)	-	-	Gross Ship Qty
ly_in_trnst_qty	Store In Transit Quantity - Last Year	Integer	-	-	Curr Str in Transit Qty
ly_in_trnst_rtl_amt	Store In Transit Retail Amount - Last Year	Decimal (18,2)	-	-	Curr Str in Transit Retail
ly_in_whse_qty	Store In Warehouse Quantity - Last Year	Integer	-	-	Curr Str In Whse Qty,Received QTY at WH (Owned only)
ly_in_whse_rtl_amt	Store In Warehouse Retail - Last Year	Decimal (18,2)	-	-	Curr Whse Buyer Orders Sell
ly_max_shelf_qty	Max Shelf Quantity - Last Year	Integer	-	-	Max Shelf Qty
ly_net_rcpt_qty	Net Receipt Quantity - Last year	Decimal (11,2)	-	-	Net Ship Qty
ly_on_hand_qty	Store On Hand Quantity - Last Year	Integer	-	-	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
ly_on_hand_rtl_amt	Store On Hand Retail - Last Year	Decimal (18,2)	-	-	Curr Str on Hand Retail
ly_on_order_qty	Store On Order Quantity - Last Year	Integer	-	-	Curr Str On Order Qty
ly_on_order_rtl_amt	Store On Order Retail Amount - Last Year	Decimal (18,2)	-	-	Curr Str On Order Retail
ly_repl_store_item_cnt	Valid Store Item Count - Last Year	Integer	-	-	Curr Valid Store/Item Comb.
ly_traited_cnt	Traited Store/Item Count - Last Year	Integer	-	-	Curr Traited Store/Item Comb.
mds_fam_id	Store Item ID	Long	-	-	Item Nbr
op_cmpny_cd	Operational Company Code	String	Y	-	-
store_nbr	Store Number	Integer	Y	-	Store Nbr
ty_gross_rcpt_qty	Gross Receipt Quantity - This Year	Decimal (9,2)	-	-	Gross Ship Qty
ty_ho_recomd_rtl_price_amt	Home Office Recommended Retail Price Amount - This Year	Decimal (9,2)	-	-	Current HO Retail
ty_in_trnst_qty	Store In Transit Quantity - This Year	Integer	-	-	Curr Str in Transit Qty
ty_in_trnst_rtl_amt	Store In Transit Retail Amount - This Year	Decimal (18,2)	-	-	Curr Str in Transit Retail
ty_max_shelf_qty	Max Shelf Quantity - This Year	Integer	-	-	-
ty_on_hand_qty	Store On Hand Quantity - This Year	Integer	-	-	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
ty_on_hand_rtl_amt	Store On Hand Retail - This Year	Decimal (18,2)	-	-	Curr Str on Hand Retail
ty_on_order_qty	Store On Order Quantity - This Year	Integer	-	-	Curr Str On Order Retail
ty_on_order_rtl_amt	Store On Order Retail Amount - This Year	Decimal (18,2)	-	-	-
ty_repl_store_item_cnt	Valid Store Item Count - This Year	Integer	-	-	Curr Valid Store/Item Comb
ty_store_specific_rtl_amt	Store Specific Retail Amount - This Year	Decimal (9,2)	-	-	Curr Tab On Hand Qty
ty_traited_cnt	Traited Store/Item Count - This Year	Integer	-	-	TSS Qty
vendor_nbr	Vendor Number	Integer	-	-	Vendor Name
vendor_nm	Vendor Name	String	-	-	Walmart Item Number
wm_item_nbr	Walmart Item Number	Long	Y	-	Walmart Item Number
wm_yr_wk_nbr	Walmart Year Week Number	Integer	-	-	Sale WM Week