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_cost_amt | Gross Receipt Cost Amount - Last Year | Decimal (11,2) | - | Y | Gross Ship Cost,Gross Ship Cost (MTR),Ships At Cost,Ship Cost |
| ly_gross_rcpt_qty | Gross Receipt Quantity - Last Year | Decimal (9,2) | - | - | Gross Ship Qty |
| ly_gross_rcpt_rtl_amt | Gross Receipt Retail Amount - Last Year | Decimal (11,2) | - | - | Gross Ship Retail,Ship Retail |
| ly_ho_recomd_rtl_price_amt | Home Office Recommended Retail Price Amount - Last Year | Decimal (9,2) | - | - | Current HO Retail |
| ly_in_trnst_cost_amt | Store In Transit Cost Amount - Last Year | Decimal (18,2) | - | Y | Curr Str In Transit Cost, Curr Corporate Inv Cost With On Orders,Curr Corporate Inv Cost Without On Orders |
| 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_cost_amt | Store In Warehouse Cost Amount - Last Year | Decimal (18,2) | - | Y | Curr Str In Whse Cost |
| 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_cost_amt | Net Receipt Cost Amount - Last Year | Decimal (11,4) | - | Y | Net Ships Cost |
| ly_net_rcpt_qty | Net Receipt Quantity - Last year | Decimal (11,2) | - | - | Net Ship Qty |
| ly_net_rcpt_rtl_amt | Net Receipt Retail Amount - Last Year | Decimal (11,2) | - | - | Net Ship Retail |
| ly_on_hand_cost_amt | Store On Hand Cost Amount - Last Year | Decimal (18,2) | - | Y | Curr Str On Hand Cost, Curr Corporate Inv Cost With On Orders,Curr Corporate Inv Cost Without On Orders |
| 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_cost_amt | Store On Order Cost Amount - Last year | Decimal (18,2) | - | Y | Curr Str On Order Cost, Curr Corporate Inv Cost With On Orders |
| 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_pipeline_qty | Store Pipeline Quantity - Last Year | Integer | - | - | - |
| ly_repl_instock_denominator | Replenishment Instock Denominator - Last Year | Integer | - | - | Repl Instock % |
| ly_repl_instock_numerator | Replenishment Instock Numerator - Last Year | Decimal (9,4) | - | - | Repl Instock % |
| ly_repl_store_item_cnt | Valid Store Item Count - Last Year | Integer | - | - | Curr Valid Store/Item Comb. |
| ly_store_specific_cost_amt | Store Specific Cost Amount - Last Year | Decimal (9,2) | - | Y | Store Specific Cost |
| ly_store_specific_rtl_amt | Store Specific Retail Amount - Last Year | Decimal (9,2) | - | - | Store Specific Retail |
| ly_tab_rcv_qty | Tab Receiving Quantity - Last Year | Integer | - | - | Curr Tab On Hand Qty |
| ly_traited_cnt | Traited Store/Item Count - Last Year | Integer | - | - | Curr Traited Store/Item Comb. |
| ly_trgt_shelf_qty | Target Shelf Quantity - Last Year | Integer | - | - | TSS Qty |
| mds_fam_id | Store Item ID | Long | - | - | Item Nbr |
| op_cmpny_cd | Operational Company Code | String | Y | - | - |
| rtl_price_event_cd | Retail Price Event Code | Integer | - | - | - |
| store_nbr | Store Number | Integer | Y | - | Store Nbr |
| ty_gross_rcpt_cost_amt | Gross Receipt Cost Amount - This Year | Decimal (11,2) | - | Y | Gross Ship Cost,Gross Ship Cost (MTR),Ships At Cost,Ship Cost |
| ty_gross_rcpt_qty | Gross Receipt Quantity - This Year | Decimal (9,2) | - | - | Gross Ship Qty |
| ty_gross_rcpt_rtl_amt | Gross Receipt Retail Amount - This Year | Decimal (11,2) | - | - | Gross Ship Retail,Ship Retail |
| ty_ho_recomd_rtl_price_amt | Home Office Recommended Retail Price Amount - This Year | Decimal (9,2) | - | - | Current HO Retail |
| ty_in_trnst_cost_amt | Store In Transit Cost Amount - This Year | Decimal (18,2) | - | Y | Curr Str In Transit Cost, Curr Corporate Inv Cost With On Orders,Curr Corporate Inv Cost Without On Orders |
| 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_in_whse_cost_amt | Store In Warehouse Cost Amount - This Year | Decimal (18,2) | - | Y | Curr Str In Whse Cost |
| ty_in_whse_qty | Store In Warehouse Quantity - This Year | Integer | - | - | Curr Str In Whse Qty,Received QTY at WH (Owned only) |
| ty_in_whse_rtl_amt | Store In Warehouse Retail - This Year | Decimal (18,2) | - | - | Curr Whse Buyer Orders Sell |
| ty_max_shelf_qty | Max Shelf Quantity - This Year | Integer | - | - | Max Shelf Qty |
| ty_net_rcpt_cost_amt | Net Receipt Cost Amount - This Year | Decimal (11,4) | - | Y | Net Ships Cost |
| ty_net_rcpt_qty | Net Receipt Quantity - This Year | Decimal (11,2) | - | - | Net Ship Qty |
| ty_net_rcpt_rtl_amt | Net Receipt Retail Amount - This Year | Decimal (11,2) | - | - | Net Ship Retail |
| ty_on_hand_cost_amt | Store On Hand Cost Amount - This Year | Decimal (18,2) | - | Y | Curr Str On Order Cost, Curr Corporate Inv Cost With On Orders |
| 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_cost_amt | Store On Order Cost Amount - This year | Decimal (18,2) | - | Y | Curr Str On Order Qty |
| 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_pipeline_qty | Store Pipeline Quantity - This Year | Integer | - | - | _ |
| ty_repl_instock_denominator | Replenishment Instock Denominator - This Year | Integer | - | - | Repl Instock % |
| ty_repl_instock_numerator | Replenishment Instock Numerator - This Year | Decimal (9,4) | - | - | Repl Instock % |
| ty_repl_store_item_cnt | Valid Store Item Count - This Year | Integer | - | - | Curr Valid Store/Item Comb |
| ty_store_specific_cost_amt | Store Specific Cost Amount - This Year | Decimal (9,2) | - | Y | Store Specific Retail |
| ty_store_specific_rtl_amt | Store Specific Retail Amount - This Year | Decimal (9,2) | - | - | Curr Tab On Hand Qty |
| ty_tab_rcv_qty | Tab Receiving Quantity - This Year | Integer | - | - | Curr Traited Store/Item Comb. |
| ty_traited_cnt | Traited Store/Item Count - This Year | Integer | - | - | TSS Qty |
| ty_trgt_shelf_qty | Target Shelf Quantity - This Year | Integer | - | - | - |
| 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 |
©️Walmart | All Rights Reserved | Confidential
