The Item Dimensions table provides Walmart item attribute information, including hierarchy, descriptions, and status.
This table is the latest snapshot and contains only the attributes related to the items supplied to Walmart as of the current Date. If there are items that were historically supplied to Walmart that are no longer being supplied as of the current Date, then the attributes related to those items will not be present in the table.
The following provides Omni 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 |
©️Walmart | All Rights Reserved | Confidential
