The Store Fulfillment (OPD) table provides information about all scheduled store fulfillment orders at Walmart item and store level.
The following provides Store Fulfillment (OPD) column details, in alphabetical order.
| Technical Name | Business Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|
| bus_dt | Business Date | Date | Y | - | - |
| catlg_item_id | Catalog Item ID / eComm Prod ID | Int64 | Y | - | - |
| geo_region_cd | Geographic Region Code | String | Y | - | - |
| ly_cust_order_amt | Placed Sales - Last Year | Numeric | - | - | - |
| ly_cust_order_qty | Customer Order Quantity - Last Year | Int64 | - | - | - |
| ly_ftpr | First Time Pick Rate - Last Year | Numeric | - | - | - |
| ly_ftpr_dnmntr | First Time Pick Rate Denominator - Last Year | Numeric | - | - | - |
| ly_ftpr_nmrtr | First Time Pick Rate Numerator - Last Year | Numeric | - | - | - |
| ly_ftpr_qty | First Time Pick Rate Quantity - Last Year | Numeric | - | - | - |
| ly_nil_pick_qty | Nil Picks - Last Year | Numeric | - | - | - |
| ly_postsub_rate | Post Substitute Rate - Last Year | Numeric | - | - | - |
| ly_postsub_rate_dnmntr | Post Substitute Rate Denominator - Last Year | Numeric | - | - | - |
| ly_postsub_rate_nmrtr | Post Substitute Rate Numerator - Last Year | Numeric | - | - | - |
| ly_presub_qty | Pre Substitute Quantity - Last Year | Numeric | - | - | - |
| ly_presub_rate | Pre Substitute Rate - Last Year | Numeric | - | - | - |
| ly_presub_rate_dnmntr | Pre Substitute Rate Denominator - Last Year | Numeric | - | - | - |
| ly_presub_rate_nmrtr | Pre Substitute Rate Numerator - Last Year | Numeric | - | - | - |
| ly_schdl_nil_pick_qty | Scheduled Nil Pick Quantity - Last Year | Numeric | - | - | - |
| ly_schdl_nil_pick_rate | Scheduled Nil Pick Rate - Last Year | Numeric | - | - | - |
| ly_schdl_nil_pick_rate_dnmntr | Scheduled Nil Pick Rate Denominator - Last Year | Numeric | - | - | - |
| ly_schdl_nil_pick_rate_nmrtr | Scheduled Nil Pick Rate Numerator - Last Year | Numeric | - | - | - |
| ly_unschdl_nil_pick_qty | Unscheduled Nil Pick Quantity - Last Year | Numeric | - | - | - |
| ly_unschdl_nil_pick_rate | Unscheduled Nil Pick Rate - Last Year | Numeric | - | - | - |
| ly_unschdl_nil_pick_rate_dnmtr | Unscheduled Nil Pick Rate Denominator - Last Year | Numeric | - | - | - |
| ly_unschdl_nil_pick_rate_nmtr | Unscheduled Nil Pick Rate Numerator - Last Year | Numeric | - | - | - |
| op_cmpny_cd | Operational Company Code | String | Y | - | - |
| store_nbr | Store Number | Int64 | Y | - | - |
| ty_cust_order_amt | Placed Sales - This Year | Numeric | - | - | - |
| ty_cust_order_qty | Customer Order Quantity - This Year | Int64 | - | - | - |
| ty_ftpr | First Time Pick Rate - This Year | Numeric | - | - | - |
| ty_ftpr_dnmntr | First Time Pick Rate Denominator - This Year | Numeric | - | - | - |
| ty_ftpr_nmrtr | First Time Pick Rate Numerator - This Year | Numeric | - | - | - |
| ty_ftpr_qty | First Time Pick Rate Quantity - This Year | Numeric | - | - | - |
| ty_nil_pick_qty | Nil Picks - This Year | Numeric | - | - | - |
| ty_postsub_rate | Post Substitute Rate - This Year | Numeric | - | - | - |
| ty_postsub_rate_dnmntr | Post Substitute Rate Denominator - This Year | Numeric | - | - | - |
| ty_postsub_rate_nmrtr | Post Substitute Rate Numerator - This Year | Numeric | - | - | - |
| ty_presub_qty | Pre Substitute Quantity - This Year | Numeric | - | - | - |
| ty_presub_rate | Pre Substitute Rate - This Year | Numeric | - | - | - |
| ty_presub_rate_dnmntr | Pre Substitute Rate Denominator - This Year | Numeric | - | - | - |
| ty_presub_rate_nmrtr | Pre Substitute Rate Numerator - This Year | Numeric | - | - | - |
| ty_schdl_nil_pick_qty | Scheduled Nil Pick Quantity - This Year | Numeric | - | - | - |
| ty_schdl_nil_pick_rate | Scheduled Nil Pick Rate - This Year | Numeric | - | - | - |
| ty_schdl_nil_pick_rate_dnmntr | Scheduled Nil Pick Rate Denominator - This Year | Numeric | - | - | - |
| ty_schdl_nil_pick_rate_nmrtr | Scheduled Nil Pick Rate Numerator - This Year | Numeric | - | - | - |
| ty_unschdl_nil_pick_qty | Unscheduled Nil Pick Quantity - This Year | Numeric | - | - | - |
| ty_unschdl_nil_pick_rate | Unscheduled Nil Pick Rate - This Year | Numeric | - | - | - |
| ty_unschdl_nil_pick_rate_dnmtr | Unscheduled Nil Pick Rate Denominator - This Year | Numeric | - | - | - |
| ty_unschdl_nil_pick_rate_nmtr | Unscheduled Nil Pick Rate Numerator - This Year | Numeric | - | - | - |
| wm_item_nbr | Walmart Item Number | Int64 | Y | - | - |
©️Walmart | All Rights Reserved | Confidential