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 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	Integer	-	-	-
cust_order_amt	Placed Sales	Float	-	-	-
cust_order_qty	Customer Order Quantity	Integer	-	-	-
ftpr	First Time Pick Rate	Float	-	-	-
ftpr_dnmntr	First Time Pick Rate Denominator	Float	-	-	-
ftpr_nmrtr	First Time Pick Rate Numerator	Float	-	-	-
ftpr_qty	First Time Pick Rate Quantity	Float	-	-	-
nil_pick_qty	Nil Picks	Float	-	-	-
postsub_rate	Post Substitute Rate	Float	-	-	-
postsub_rate_dnmntr	Post Substitute Rate Denominator	Float	-	-	-
postsub_rate_nmrtr	Post Substitute Rate Numerator	Float	-	-	-
presub_qty	Pre Substitute Quantity	Float	-	-	-
presub_rate	Pre Substitute Rate	Float	-	-	-
presub_rate_dnmntr	Pre Substitute Rate Denominator	Float	-	-	-
presub_rate_nmrtr	Pre Substitute Rate Numerator	Float	-	-	-
schdl_nil_pick_qty	Scheduled Nil Pick Quantity	Float	-	-	-
schdl_nil_pick_rate	Scheduled Nil Pick Rate	Float	-	-	-
schdl_nil_pick_rate_dnmntr	Scheduled Nil Pick Rate Denominator	Float	-	-	-
schdl_nil_pick_rate_nmrtr	Scheduled Nil Pick Rate Numerator	Float	-	-	-
store_nbr	Store Number	Integer	Y	-	-
unschdl_nil_pick_qty	Unscheduled Nil Pick Quantity	Float	-	-	-
unschdl_nil_pick_rate	Unscheduled Nil Pick Rate	Float	-	-	-
unschdl_nil_pick_rate_dnmtr	Unscheduled Nil Pick Rate Denominator	Float	-	-	-
unschdl_nil_pick_rate_nmtr	Unscheduled Nil Pick Rate Numerator	Float	-	-	-
wm_item_nbr	Walmart Item Number	Integer	Y	-	-