Store Fulfillment Columns

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 NameBusiness NameData TypePrimary KeySensitive MetricsDSS Mapping
bus_dtBusiness DateDateY--
catlg_item_idCatalog Item ID / eComm Prod IDInteger---
cust_order_amtPlaced SalesFloat---
cust_order_qtyCustomer Order QuantityInteger---
ftprFirst Time Pick RateFloat---
ftpr_dnmntrFirst Time Pick Rate DenominatorFloat---
ftpr_nmrtrFirst Time Pick Rate NumeratorFloat---
ftpr_qtyFirst Time Pick Rate QuantityFloat---
nil_pick_qtyNil PicksFloat---
postsub_ratePost Substitute RateFloat---
postsub_rate_dnmntrPost Substitute Rate DenominatorFloat---
postsub_rate_nmrtrPost Substitute Rate NumeratorFloat---
presub_qtyPre Substitute QuantityFloat---
presub_ratePre Substitute RateFloat---
presub_rate_dnmntrPre Substitute Rate DenominatorFloat---
presub_rate_nmrtrPre Substitute Rate NumeratorFloat---
schdl_nil_pick_qtyScheduled Nil Pick QuantityFloat---
schdl_nil_pick_rateScheduled Nil Pick RateFloat---
schdl_nil_pick_rate_dnmntrScheduled Nil Pick Rate DenominatorFloat---
schdl_nil_pick_rate_nmrtrScheduled Nil Pick Rate NumeratorFloat---
store_nbrStore NumberIntegerY--
unschdl_nil_pick_qtyUnscheduled Nil Pick QuantityFloat---
unschdl_nil_pick_rateUnscheduled Nil Pick RateFloat---
unschdl_nil_pick_rate_dnmtrUnscheduled Nil Pick Rate DenominatorFloat---
unschdl_nil_pick_rate_nmtrUnscheduled Nil Pick Rate NumeratorFloat---
wm_item_nbrWalmart Item NumberIntegerY--


©️Walmart | All Rights Reserved | Confidential