DC Item Columns

The Distribution Center (DC) Item Measures table provides information about the DC items related metrics.

The following provides DC Item Measures column details, in alphabetical order.

Technical Name	Business Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
cncl_when_out_dt	Cancel When Out Date	Date	-	-	-
cncl_when_out_ind	Cancel When Out Indicator	Integer	-	-	-
crncy_cd	Currency Code	String	-	-	-
dc_nbr	Distribution Center Number	Integer	Y	-	-
geo_region_cd	Geographic Region Code	String	Y	-	-
invt_dt	Inventory Date	Date	Y	-	-
invt_reqd_ind	Inventory Required Indicator	Integer	-	-	-
ly_on_hand_whpk_qty	On Hand Warehouse Packs in Inventory - Last Year	Integer	-	-	-
ly_order_whpk_qty	Ordered Warehouse Quantity - Last Year	Integer	-	-	-
ly_rcv_whpk_qty	Warehouse Packs Eaches Received - Last Year	Integer	-	-	-
ly_ship_whpk_qty	Warehouse Packs Shipped to Store - Last Year	Integer	-	-	-
ly_ss_order_whpk_qty	Warehouse Packs Staple Stock on Order - Last Year	Integer	-	-	-
op_cmpny_cd	Operational Company Code	String	Y	-	-
ty_on_hand_whpk_qty	On Hand Warehouse Packs in Inventory - This Year	Integer	-	-	-
ty_order_whpk_qty	Ordered Warehouse Quantity - This Year	Integer	-	-	-
ty_rcv_whpk_qty	Warehouse Packs Eaches Received - This Year	Integer	-	-	-
ty_ship_whpk_qty	Warehouse Packs Shipped to Store - This Year	Integer	-	-	-
ty_ss_order_whpk_cost_amt	Staple Stock Warehouse Pack Cost Amount - This Year	Numeric	-	Y	-
vendor_nbr	Vendor Number	Integer	-	-	-
vendor_nm	Vendor Name	String	-	-	-
vnpk_cost_amt	Vendor Pack Cost Amount	Numeric	-	Y	-
wm_item_nbr	Walmart Item Number	Integer	Y	-	-
wm_yr_wk_nbr	Walmart Year Week Number	Integer	-	-	-