The Scintilla BI Link pre-joined SSI table delivers week-level aggregated data across nine source tables—Backroom AdjusteThe following provides SSI column details, in alphabetical order.users should carefully review aggregations and calculations to ensure analytical accuracy.
The following provides SSI column details, in alphabetical order.
| Technical Name | Business Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|
| bkrm_adj_qty | Total Store On Hand Adjustment Quantity | Int64 | - | - | - |
| carry_opt_cd | Carry Option Code | String | - | - | - |
| carry_status_cd | Carry Status Code | String | - | - | - |
| catlg_item_id | Catalog Item ID / eComm Prod ID | Int64 | Y | - | - |
| crncy_cd | Currency Code | String | - | - | - |
| invt_adj_each_qty | Backroom Adjustment Quantity | Int64 | - | - | - |
| invt_adj_type_cd | Inventory Adjustment Type Code | Int64 | - | - | - |
| invt_adj_type_desc | Inventory Adjustment Type Description | String | - | - | - |
| ly_adj_qty | Adjustment Quantity - Last Year | Int64 | - | - | - |
| ly_curr_clr_on_hand_amt | Current Clearance On Hand Amount - Last Year | Numeric | - | - | - |
| ly_curr_clr_on_hand_amt_eop | Current Clearance On Hand Amount End of Period - Last Year | Numeric | - | - | - |
| ly_curr_clr_on_hand_qty | Current Clearance On Hand Quantity - Last Year | Float64 | - | - | - |
| ly_curr_clr_on_hand_qty_eop | Current Clearance On Hand Quantity End of Period - Last Year | Int64 | - | - | - |
| ly_curr_roll_on_hand_amt | Current Rollback On Hand Amount - Last Year | Numeric | - | - | - |
| ly_curr_roll_on_hand_amt_eop | Current Rollback On Hand Amount End of Period - Last Year | Numeric | - | - | - |
| ly_curr_roll_on_hand_qty | Current Rollback On Hand Quantity - Last Year | Float64 | - | - | - |
| ly_curr_roll_on_hand_qty_eop | Current Rollback On Hand Quantity End of Period - Last Year | Int64 | - | - | - |
| ly_cust_sales_amt | Sales Amount - Last Year | Numeric | - | - | - |
| ly_dfctv_ovrstk_rtn_qty | Quantity - Defective (Customer Returns) - Last Year | Int64 | - | - | - |
| ly_dfctv_sales_amt | Sales Amount - Defective (Returns) - Last Year | Numeric | - | - | - |
| ly_dfctv_uom_qty | Unit of Measurent Quantity - Defective (Returns) - Last Year | Numeric | - | - | - |
| ly_gross_rcpt_qty | Gross Receipt Quantity - Last Year | Numeric | - | - | - |
| ly_in_trnst_qty | Store In Transit Quantity - Last Year | Float64 | - | - | - |
| ly_in_trnst_rtl_amt | Store In Transit Retail Amount - Last Year | Numeric | - | - | - |
| ly_in_whse_qty | Store In Warehouse Quantity - Last Year | Float64 | - | - | - |
| ly_in_whse_rtl_amt | Store In Warehouse Retail - Last Year | Numeric | - | - | - |
| ly_max_shelf_qty | Max Shelf Quantity - Last Year | Float64 | - | - | - |
| ly_mkdn_amt | SI Total MUMD $ - Last Year | Numeric | - | - | - |
| ly_mkdn_qty | SI MUMD Qty - Last Year | Int64 | - | - | - |
| ly_net_rcpt_qty | Net Receipt Quantity - Last year | Numeric | - | - | - |
| ly_nrt_rtn_qty | Return Quantity - No Retun Type (Returns) - Last Year | Int64 | - | - | - |
| ly_on_hand_qty | Store On Hand Quantity - Last Year | Float64 | - | - | - |
| ly_on_hand_qty_eop | Current Rollback On Hand Quantity End of Period Last Year | Int64 | - | - | - |
| ly_on_hand_rtl_amt | Store On Hand Retail - Last Year | Numeric | - | - | - |
| ly_on_order_qty | Store On Order Quantity - Last Year | Float64 | - | - | - |
| ly_on_order_rtl_amt | Store On Order Retail Amount - Last Year | Numeric | - | - | - |
| ly_other_rsn_rtn_qty | Return Quantity - Other Reason Type (Returns) - Last year | Int64 | - | - | - |
| ly_pos_store_cnt | POS Store Count | Int64 | - | - | - |
| ly_qty | POS Quantity - Last Year | Numeric | - | - | - |
| ly_recall_rtn_qty | Return Quantity - Recall (Returns) - Last Year | Int64 | - | - | - |
| ly_repl_store_item_cnt | Valid Store Item Count - Last Year | String | - | - | - |
| ly_rtn_qty | Return Quantity - Last Year | Int64 | - | - | - |
| ly_sales_amt | POS Sales-Last Year | Numeric | - | - | - |
| ly_scan_cnt | Scan Count - Last Year | Int64 | - | - | - |
| ly_st_dc_rtn_qty | Return Quantity - To DC (Returns) - Last Year | Int64 | - | - | - |
| ly_st_rtn_ctr_rtn_qty | Quantity - To Return Center - Last Year (Returns) | Int64 | - | - | - |
| ly_st_vndr_rtn_qty | Return Quantity - To Vendor via Return Center (Returns) - Last Year | Int64 | - | - | - |
| ly_store_mkdn_amt | Store Markdown Amount - Last Year | Numeric | - | - | - |
| ly_store_mkdn_qty | Store Markdown Quantity - Last Year | Int64 | - | - | - |
| ly_store_specific_cost_amt | Store Specific Cost Amount - Last Year | Numeric | - | Y | - |
| ly_store_specific_cost_amt_eop | Store Specific Cost Amount End of Period - Last Year | Numeric | - | Y | - |
| ly_store_specific_rtl_amt | Store Specific Retail Amount - Last Year | Numeric | - | - | - |
| ly_store_specific_rtl_amt_eop | Store Specific Retail Amount End of Period - Last Year | Numeric | - | - | - |
| ly_tab_rcv_qty | Tab Receiving Quantity - Last Year | Float64 | - | - | - |
| ly_tonnage_qty | Tonnage - Last Year | Numeric | - | - | - |
| ly_traited_cnt | Traited Store/Item Count - Last Year | String | - | - | - |
| ly_trgt_shelf_qty | Target Shelf Quantity - Last Year | Float64 | - | - | - |
| ly_uom_qty | Unit of Measure Quantity - Last Year | Numeric | - | - | - |
| rpt_cd | Sales By Type | String | Y | - | - |
| rtl_price_event_cd | Retail Price Event Code | Int64 | - | - | - |
| store_nbr | Store Number | Int64 | Y | - | - |
| ty_adj_qty | Adjustment Quantity - This Year | Int64 | - | - | - |
| ty_curr_clr_on_hand_amt | Current Clearance On Hand Amount - This Year | Numeric | - | - | - |
| ty_curr_clr_on_hand_amt_eop | Current Clearance On Hand Amount End of Period - This Year | Numeric | - | - | - |
| ty_curr_clr_on_hand_qty | Current Clearance On Hand Quantity - This Year | Float64 | - | - | - |
| ty_curr_clr_on_hand_qty_eop | Current Clearance On Hand Quantity End of Period - This Year | Int64 | - | - | - |
| ty_curr_roll_on_hand_amt | Current Rollback On Hand Amount - This Year | Numeric | - | - | - |
| ty_curr_roll_on_hand_amt_eop | Current Rollback On Hand Amount End of Period - This Year | Numeric | - | - | - |
| ty_curr_roll_on_hand_qty | Current Rollback On Hand Quantity - This Year | Float64 | - | - | - |
| ty_curr_roll_on_hand_qty_eop | Current Rollback On Hand Quantity End of Period - This Year | Int64 | - | - | - |
| ty_cust_sales_amt | Sales Amount - This Year | Numeric | - | - | - |
| ty_dfctv_ovrstk_rtn_qty | Quantity - Defective (Customer Returns) - This Year | Int64 | - | - | - |
| ty_dfctv_sales_amt | Sales Amount - Defective (Returns) - This Year | Numeric | - | - | - |
| ty_dfctv_uom_qty | Unit of Measurent Quantity - Defective (Returns) - This Year | Numeric | - | - | - |
| ty_gross_rcpt_qty | Gross Receipt Quantity - This Year | Numeric | - | - | - |
| ty_in_trnst_qty | Store In Transit Quantity - This Year | Float64 | - | - | - |
| ty_in_trnst_rtl_amt | Store In Transit Retail Amount - This Year | Numeric | - | - | - |
| ty_in_whse_qty | Store In Warehouse Quantity - This Year | Float64 | - | - | - |
| ty_in_whse_rtl_amt | Store In Warehouse Retail Amount End of Period - This Year | Numeric | - | - | - |
| ty_max_shelf_qty | Max Shelf Quantity - This Year | Float64 | - | - | - |
| ty_mkdn_amt | SI Total MUMD $ - This Year | Numeric | - | - | - |
| ty_mkdn_qty | SI MUMD Qty | Int64 | - | - | - |
| ty_net_rcpt_qty | Net Receipt Quantity - This Year | Numeric | - | - | - |
| ty_nrt_rtn_qty | Return Quantity - No Retun Type (Returns) - This Year | Int64 | - | - | - |
| ty_on_hand_qty | Store On Hand Quantity - This Year | Float64 | - | - | - |
| ty_on_hand_qty_eop | Store On Hand Quantity End of Period - This Year | Int64 | - | - | - |
| ty_on_hand_rtl_amt | Store On Hand Retail - This Year | Numeric | - | - | - |
| ty_on_order_qty | Store On Order Quantity - This Year | Float64 | - | - | - |
| ty_on_order_rtl_amt | Store On Order Retail Amount - This Year | Numeric | - | - | - |
| ty_other_rsn_rtn_qty | Return Quantity - Other Reason Type (Returns) - This Year | Int64 | - | - | - |
| ty_pos_store_cnt | POS Store Count | Int64 | - | - | - |
| ty_qty | POS Quantity - This Year | Numeric | - | - | - |
| ty_recall_rtn_qty | Return Quantity - Recall (Returns) - This Year | Int64 | - | - | - |
| ty_repl_store_item_cnt | Valid Store Item Count - This Year | String | - | - | - |
| ty_rtn_qty | Return Quantity - This Year | Int64 | - | - | - |
| ty_sales_amt | POS Sales-This Year | Numeric | - | - | - |
| ty_scan_cnt | Scan Count - This Year | Int64 | - | - | - |
| ty_st_dc_rtn_qty | Return Quantity - To DC (Returns) - This Year | Int64 | - | - | - |
| ty_st_rtn_ctr_rtn_qty | Quantity - To Return Center - This Year (Returns) | Int64 | - | - | - |
| ty_st_vndr_rtn_qty | Return Quantity - To Vendor via Return Center (Returns) - This Year | Int64 | - | - | - |
| ty_store_mkdn_amt | Store Markdown Amount - This Year | Numeric | - | - | - |
| ty_store_mkdn_qty | Store Markdown Quantity - This Year | Int64 | - | - | - |
| ty_store_specific_cost_amt | Store Specific Cost Amount - This Year | Numeric | - | Y | - |
| ty_store_specific_cost_amt_eop | Store Specific Cost Amount End of Period - This Year | Numeric | - | Y | - |
| ty_store_specific_rtl_amt | Store Specific Retail Amount - This Year | Numeric | - | - | - |
| ty_store_specific_rtl_amt_eop | Store Specific Retail Amount End of Period - This Year | Numeric | - | - | - |
| ty_tab_rcv_qty | Tab Receiving Quantity - This Year | Float64 | - | - | - |
| ty_tonnage_qty | Tonnage | Numeric | - | - | - |
| ty_traited_cnt | Traited Store/Item Count - This Year | String | - | - | - |
| ty_trgt_shelf_qty | Target Shelf Quantity - This Year | Float64 | - | - | - |
| ty_uom_qty | Unity of Measure Quantity - This Year | Numeric | - | - | - |
| wm_item_nbr | Walmart Item Number | Int64 | Y | - | - |
| wm_yr_wk_nbr | Walmart Year Week Number | Int64 | Y | - | - |
©️Walmart | All Rights Reserved | Confidential
