Item Dim Columns

The Item Dimensions table provides Walmart item attribute information, including hierarchy, descriptions, and status.

The following provides Item Dimensions column details, in alphabetical order.

Technical Name	Business Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
acctg_dept_desc	Accounting Department Description	String	-	-	Acct Dept Nbr
acctg_dept_nbr	Accounting Department Number	Integer	-	-	Acct Dept Nbr
actv_cd	Activity Code	String	-	-	-
actv_desc	Activity Description	String	-	-	-
all_links_item_desc_1	All Links Item Description	String	-	-	Prime Item Desc
all_links_item_nbr	All Links Item Number	Integer	-	-	-
all_links_mds_fam_id	All Links Store Item Id	Integer	-	-	-
backrm_scale_ind	Backroom Scale Indicator	Integer	-	-	-
base_div_nbr	Base Division Number	Integer	-	-	-
base_rtl_uom_cd	Base Retail UOM Code	String	-	-	-
base_rtl_uom_desc	Base Retail UOM Description	String	-	-	-
base_unit_rtl_amt	Base Unit Retail Amount	Decimal (11,2)	-	-	Unit Retail
brand_fam_id	Brand Family ID	Integer	-	-	Brand Family ID
brand_fam_nm	Brand Family Name	String	-	-	Brand Family Name
brand_id	Brand ID	Integer	-	-	Brand ID
brand_nm	Brand Name	String	-	-	Brand Name
brand_ownr_id	Brand Owner ID	Integer	-	-	Brand Owner ID
brand_ownr_nm	Brand Owner Name	String	-	-	Brand Owner Name
buyg_region_cd	Buying Region Code	Integer	-	-	Buying Region Code
buyg_region_desc	Buying Region Description	String	-	-	Buying Region Desc
case_upc_nbr	Case UPC Number	Decimal (15,0)	-	-	-
catlg_item_id	Catalog Item ID / eComm Prod ID	Integer	-	-	Item ID
cncl_when_out_ind	Cancel When Out Indicator	Integer	-	-	Cancel When Out Flag
cntrl_substance_ind	Controlled Substance Indicator	Integer	-	-	-
color_desc	Color Description	String	-	-	Color Desc
cons_item_desc	Consumer Item Description	String	-	-	-
cons_item_nbr	Consumer Item Number	Integer	-	-	-
dc_dea_rpt_ind	DC Drug Enforcement Agency Indicator	Integer	-	-	-
est_out_of_stock_dt	Estimated Out of Stock Date	Date	-	-	-
fineline_desc	Fineline Description	String	-	-	Fineline Description
fineline_nbr	Fineline Number	Integer	-	-	Fineline Number
geo_region_cd	Geographic Region Code	String	-	-	-
item_create_dt	Item Create Date	Date	-	-	Item Start Date
item_cube_qty	Item Cube Quantity	Decimal (9,3)	-	-	-
item_cube_uom_desc	Item Cube Unit of Measure Description	String	-	-	-
item_desc_2	Item Description 2	String	-	-	Item Desc 2
item_dim_uom_cd	Item Dimension Unit of Measure Code	String	-	-	UOM Code
item_dim_uom_desc	Item Dimension Unit of Measure Description	String	-	-	-
item_expire_dt	Item Expiry Date	Date	-	-	-
item_ht_qty	Item Height Quantity	Decimal (9,3)	-	-	Item Height
item_import_ind	Item Import Indicator	Integer	-	-	-
item_len_qty	Item Length Quantity	Decimal (9,3)	-	-	Item Length
item_name	Item Name	String	-	-	Item Name
item_order_eff_dt	Item Order Effective Date	Date	-	-	Effective Date
item_repl_ind	Item Replenishment Indicator	Integer	-	-	-
item_status_cd	Item Status Code	String	-	-	Item Status
item_status_chng_dt	Item Status Change Date	Date	-	-	-
item_type_cd	Item Type Code	Integer	-	-	Item Type Code
item_type_desc	Item Type Description	String	-	-	-
item_wdth_qty	Item Width Quantity	Decimal (9,3)	-	-	Item Width
item_wt_qty	Item Weight Quantity	Decimal (11,4)	-	-	Item Weight
lic_cd	License Code	Integer	-	-	License Code
lic_desc	License Description	String	-	-	-
mds_fam_id	Store Item ID	Integer	-	-	Item Nbr
modlr_base_mdse_cd	Modular Based Merchandising Code	String	-	-	-
modlr_base_mdse_desc	Modular Based Merchandising Description	String	-	-	-
never_out_ind	Never Out Indicator	Integer	-	-	Never Out Flag
obsolete_dt	Item End Date	Date	-	-	Item End Date
omni_catg_desc	Omni Category Description	String	-	-	Dept Category Description
omni_catg_grp_desc	Omni Category Group Description	String	-	-	Dept Category Group Description
omni_catg_grp_nbr	Omni Category Group Number	Integer	-	-	-
omni_catg_nbr	Omni Category Number	Integer	-	-	Category Nbr
omni_dept_desc	Omni Department Description	String	-	-	Dept Desc
omni_dept_nbr	Omni Department Number	Integer	-	-	Acct Dept Nbr
omni_seg_desc	Omni Segment Description	String	-	-	MDSE Segment Description
omni_seg_nbr	Omni Segment Number	Integer	-	-	-
omni_subcatg_desc	Omni Subcategory Description	String	-	-	Dept Subcategory Description
omni_subcatg_nbr	Omni Subcategory Number	Integer	-	-	-
op_cmpny_cd	Operational Company Code	String	Y	-	-
order_sizng_fctr_qty	Order Sizing Factory Quantity	Decimal (9,3)	-	-	Cubic Order Sizing Factor
pallet_hi_qty	Pallet HI Quantity	Integer	-	-	Pallet Hi Qty
pallet_ti_qty	Pallet Ti Quantity	Integer	-	-	Pallet Ti Qty
pallet_upc_nbr	Pallet UPC Number	Decimal (15,0)	-	-	Pallet UPC
perfm_ratg_desc	Performance Rating Description	String	-	-	-
plu_nbr	Price Look Up Number	Integer	-	-	-
prime_xref_item_nbr	Prime Item Number	Integer	-	-	-
prod_desc	Product Description	String	-	-	Product Description
pvt_lbl_ind	Private Label Indicator	Integer	-	-	-
repl_group_nbr	Replenishment Group Number	Decimal (18,0)	-	-	Consumer ID
repl_subtype_cd	Replenishment Subtype Code	Integer	-	-	Item Sub Type
repl_subtype_desc	Replenishment Subtype Description	String	-	-	-
repl_unit_ind	Replenishment Unit Indicator	Integer	-	-	Replenish Unit Ind
rfid_ind	RFID Indicator	Integer	-	-	-
rppc_ind	RPPC Indicator	Integer	-	-	RPPC Indicator
seasn_cd	Season Code	Integer	-	-	Season Code
seasn_desc	Season Description	String	-	-	-
seasn_yr	Season Year	Integer	-	-	Season Year
secur_tag_ind	Electronic Security Tag Indicator	Integer	-	-	-
sell_qty	Sell Quantity	Decimal (9,4)	-	-	-
sell_uom_cd	Sell Unit of Measure Code	String	-	-	UOM Code
sell_uom_desc	Sell Unit of Measure Description	String	-	-	-
shelf_lbl_reqmt_ind	Shelf Label Requirement Indicator	Integer	-	-	Shelf Label Flag
signing_desc	Signing Description	String	-	-	Signing Desc
size_desc	Size Description	String	-	-	Size Desc
var_wt_ind	Variable Weight Indicator	Integer	-	-	-
vendor_dept_nbr	Vendor Department Number	Integer	-	-	Vendor Nbr Dept
vendor_nbr	Vendor Number	Integer	-	-	Vendor Nbr
vendor_nm	Vendor Name	String	-	-	Vendor Name
vendor_seq_nbr	Vendor Sequence Number	Integer	-	-	Vendor Sequence Nbr
vendor_stock_id	Vendor Stock ID	String	-	-	Vendor Stock ID
vnpk_cost_amt	Vendor Pack Cost Amount	Decimal (13,4)	-	Y	Reg VNPK Cost
vnpk_cspk_cd	Vendor Case Pack Code	String	-	-	-
vnpk_cspk_desc	Vendor Case Pack Description	String	-	-	-
vnpk_cube_qty	Vendor Pack Cube Quantity	Decimal (9,3)	-	-	VNPK Cubic Ft
vnpk_cube_uom_desc	Vendor Pack Cube Unit of Measure Description	String	-	-	-
vnpk_ht_qty	Vendor Pack Height Quantity	Decimal (9,3)	-	-	VNPK Height
vnpk_len_qty	Vendor Pack Length Quantity	Decimal (9,3)	-	-	VNPK Length
vnpk_qty	Vendor Pack Quantity	Integer	-	-	VNPK Qty
vnpk_wdth_qty	Vendor Pack Width Quantity	Decimal (9,3)	-	-	VNPK Width
vnpk_wt_fmt_cd	Vendor Pack Weight Format Code	String	-	-	Pack Weight Fmt
vnpk_wt_fmt_desc	Vendor Pack Weight Format Description	String	-	-	-
vnpk_wt_qty	Vendor Pack Weight Quantity	Decimal (18,4)	-	-	Vendor Pack Weight
whpk_cube_qty	Warehouse Pack Cubic Quantity	Decimal (9,3)	-	-	WHPK Cubic Ft
whpk_cube_uom_cd	Warehouse Pack Cube UOM Code	String	-	-	-
whpk_cube_uom_desc	Warehouse Pack Cube UOM Desc	String	-	-	-
whpk_ht_qty	Warehouse Pack Height Quantity	Decimal (9,3)	-	-	WHPK Height
whpk_len_qty	Warehouse Pack Length Quantity	Decimal (9,3)	-	-	WHPK Length
whpk_qty	Warehouse Pack Quantity	Integer	-	-	Warehouse Pack Qty (Owned Only)
whpk_sell_amt	Warehouse Pack Sell Amount	Decimal (13,4)	-	-	-
whpk_upc_fmt_cd	Warehouse Pack UPC Format Code	Short	-	-	-
whpk_upc_fmt_desc	Warehouse Pack UPC Format Description	String	-	-	-
whpk_upc_nbr	Warehouse Pack UPC Number	Decimal (15,0)	-	-	WHPK UPC
whpk_wdth_qty	Warehouse Pack Width Quantity	Decimal (9,3)	-	-	-
whpk_wt_qty	Warehouse Pack Weight Quantity	Decimal (11,4)	-	-	Whse Pack Weight
whpk_wt_uom_cd	Warehouse Pack Weight Unit of Measure Code	String	-	-	UOM Code
whpk_wt_uom_desc	Warehouse Pack Weight Unit of Measure Description	String	-	-	-
whse_algn_type_cd	Warehouse Alignment Type Code	String	-	-	Whse Align
whse_algn_type_desc	Warehouse Alignment Type Description	String	-	-	-
wm_item_nbr	Walmart Item Number	Integer	Y	-	Walmart Item Number
wm_upc_desc	Walmart UPC Description	String	-	-	UPC Desc
wm_upc_nbr	Universal Product Code Number	Decimal (18,0)	-	-	UPC