| dc_nbr | Distribution Center Number | The number that is assigned to a specific Distribution Center (DC). For definition of DC, see DC (Distribution Center). | DC Dimensions | Whse Nbr | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | DC Dimensions | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | DC Dimensions | - | Available | 2026.4.2 Release |
| st_prov_cd | State/Province Code | The state or province code in which the Distribution Center(DC) or store resides. | DC Dimensions | Whse State | Available | 2026.4.2 Release |
| dc_nm | Distribution Center Name | The name of the Distribution Center (DC). DCs are massive warehouses that receive shipments from thousands of supplier ship points, process them, and load the merchandise onto trucks so it can be delivered to stores. They are designed to ensure our supply chain moves with speed and efficiency and is responsive to customer demands. Most are open seven days a week, 24 hours a day and are strategically located near our stores and major suppliers. | DC Dimensions | IDC Desc | Available | 2026.4.2 Release |
| city_nm | City Name | This is the name of the city in which the Distribution Center/store resides. | DC Dimensions | City | Available | 2026.4.2 Release |
| st_addr_line_1 | Street Address Line 1 | Warehouse street address of the warehouse location. | DC Dimensions | Street Address | Available | 2026.4.2 Release |
| tz_nm | Time Zone Name | The time zone name that the store resides in. E.g., Eastern, Central, Mountain, Pacific Values of codes: EST, CST, MST, PST, CST/MST | DC Dimensions | - | Available | 2026.4.2 Release |
| bu_fmt_nm | Business Unit Format Name | This is the detailed description used to group stores into categories. It signifies the type of business performed at the store, at a high level. Examples: Hypermarket, Supermarket, Membership, Auction, Click and Collect, Convenience with Fuel, Distribution, eCommerce | DC Dimensions | - | Available | 2026.4.2 Release |
| base_div_nbr | Base Division Number | Base Division Number represents the base division of the item. E.g., 01 - Walmart | DC Dimensions | - | Available | 2026.4.2 Release |
| store_type_desc | Store Type Description | The descriptive text of the code identifying the type of physical building. Examples: G - General Office R - Regular (Walmart), W – Warehouse
| DC Dimensions | - | Available | 2026.4.2 Release |
| cnty_nm | County Name | This is the textual identifier for a county. | DC Dimensions | - | Available | 2026.4.2 Release |
| bu_gross_size_qty | Business Gross Size Quantity | Square footage of the store. The size of the physical building(s) of the store in square feet. | DC Dimensions | - | Available | 2026.4.2 Release |
| bu_size_uom_cd | Business Size Unit of Measure Code | The unit of measure in which store size is measured. Measured in square feet or square meters. | DC Dimensions | - | Available | 2026.4.2 Release |
| banner_desc | Banner Description | The description of the sign or banner on the outside of the store. E.g., Walmart Supercenter
| DC Dimensions | - | Available | 2026.4.2 Release |
| public_close_dt | Public Close Date | The date the store was closed to the public. | DC Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line_2 | Street Address Line 2 | The street address of the store location. | DC Dimensions | - | Available | 2026.4.2 Release |
| tz_cd | Time Zone Code | The time zone that the store resides in. Values: EST, CST, MST, PST, CST/MST | DC Dimensions | - | Available | 2026.4.2 Release |
| grand_open_dt | Grand Open Date | The date the store is officially open for business. | DC Dimensions | - | Available | 2026.4.2 Release |
| open_status_cd | Open Status Code | It gives information for opening stores. Values: 0 - scheduled to open, 1 - new, open less than 13 months, 2 - new, open 13 months or more, 3 - scheduled to re-grand open, 4 - old, less than 13 months since re-grand, 5 - old, more than 13 months since re-grand, 6 - scheduled to close, 7 - closed | DC Dimensions | - | Available | 2026.4.2 Release |
| addr_cntry_cd | Address Country Code | It is the International Organization for Standardization (ISO) standard code for the country. E.g., US, CA, CN, JP, etc.
| DC Dimensions | - | Available | 2026.4.2 Release |
| open_status_desc | Open Status Description | This is the description of the Open Status Code. Values:0 - scheduled to open1 - new, open less than 13 months2 - new, open 13 months or more3 - scheduled to re-grand open4 - old, less than 13 months since re-grand5 - old, more than 13 months since re-grand6 - scheduled to close7 - closed | DC Dimensions | - | Available | 2026.4.2 Release |
| lat_dgr | Latitude Degree | This indicates the Latitude degree of the store's physical location. | DC Dimensions | - | Available | 2026.4.2 Release |
| banner_cd | Banner Code | A code which represents the sign or banner on the outside of the store. | DC Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line_3 | Street Address Line 3 | The street address of the store location. | DC Dimensions | - | Available | 2026.4.2 Release |
| daylight_sav_tz_ind | Daylight Savings Time Zone Indicator | Time Zone that follows daylight savings rules.
| DC Dimensions | - | Available | 2026.4.2 Release |
| store_type_cd | Store Type Code | A code which identifies a type of physical building. Values: 'D' - DOT'S Drug, 'G'- General Office, 'H' - Helen's Crafts, 'M' - Most Outlet, 'R' - Regular (Wal-Mart) 'S' - SAM'S Wholesale Club 'T' - Test or Control 'W - Warehouse 'Y' - WalMart Owned Hypermart 'J' - Joint Owned Hypermart 'U' - SuperCenter, 'X' - International SuperCenter, 'F' - Fuel | DC Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line_4 | Street Address Line 4 | The street address of the store location. | DC Dimensions | - | Available | 2026.4.2 Release |
| dst_tz_nm | Daylight Savings Time Zone Name | The daylight savings time zone that the store resides in. E.g., Eastern, Central, Mountain, Pacific | DC Dimensions | - | Available | 2026.4.2 Release |
| long_dgr | Longitude Degree | This indicates the Longitude degree of the store's physical location. | DC Dimensions | - | Available | 2026.4.2 Release |
| postal_cd | Zip Code Or Postal Code | An identifier for geographic area for the purpose of delivering mail. | DC Dimensions | Whse Zip Code | Available | 2026.4.2 Release |
| wm_item_nbr | Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Item Attributes | Walmart Item Number | Available | 2026.4.2 Release |
| mds_fam_id | Store Item ID | The 6-, 7-, or 9-character number assigned to an item of merchandise that Walmart buys from a supplier, to sell in the stores. Items that are 9 digits are REACT numbers and are considered Softlines. The first two digits of a 9-digit softline (REACT) item number is the order department, positions 3-4 are the subclass. Items that are 6-7 digits are hardline items. For items that are 6 digits, the first digit is the order department number. For items that are 7 digits, the first two digits are the department number. | Item Attributes | Item Nbr | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID/ eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics. It is also known as eCommerce Item Number. | Item Attributes | Item ID | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Item Attributes | - | Available | 2026.4.2 Release |
| vendor_nbr | Vendor Number | A unique number identifying the vendor or supplier of this item. It is an essential product attribute for reporting. | Item Attributes | Vendor Nbr | Available | 2026.4.2 Release |
| acctg_dept_nbr | Accounting Department Number | The department number used for general accounting. This is the department number that sales and purchased are booked to. Accounting departments can have order departments aligned under, but all the order departments under the Accounting department will be rolled up. | Item Attributes | Acct Dept Nbr | Available | 2026.4.2 Release |
| item_status_cd | Item Status Code | The status of an item. Valid values are A=Active, I=Inactive, or D=Delete. | Item Attributes | Item Status | Available | 2026.4.2 Release |
| item_name | Item Name | The product long name, if available. If not, it takes the default short desc1. Also, it is the essential product attribute for reporting. | Item Attributes | Item Name | Available | 2026.4.2 Release |
| fineline_desc | Fineline Description | Grouping of similar items that have the same forecast profile. In the item hierarchy, fineline is the next level beneath sub-category. Not used for DotCom items | Item Attributes | Fineline Description | Available | 2026.4.2 Release |
| item_create_dt | Item Create Date | The date when the item is created. Since it is usually the supplier who creates the item, it is the least sensitive attribute. | Item Attributes | Item Start Date | Available | 2026.4.2 Release |
| obsolete_dt | Item End Date | Date an item no longer scans at store level. "O" in the item flag column indicates the item is obsolete. Obsolete means it does not scan in any store and Home Office associates cannot access it on HOST system. | Item Attributes | Item End Date | Available | 2026.4.2 Release |
| item_type_cd | Item Type Code | The type of replenishment the item will typically use. NON-REPLENISHABLE Item Types can only be ordered through the following: buyer, vendor managed and sales representative. Non-Replenishable item types cannot be ordered by the store. Event Types Codes: 3: "Promotional, 7: "DSD Direct Store Delivery", 20: "Warehouse", 22: "Seasonal Warehouse", 33: "Assembly Distribution", 37: "Assembly Ship and Bill", 40: "Import Warehouse", 42: "Import Seasonal Warehouse", 43: "Import". Type Definitions: 03 - GENERAL DISTRIBUTION merchandise is ordered by the buyer then shipped from vendor, flows through the warehouse, to the store, 07 - DSD Direct Store Delivery: merchandise is stocked on the shelves by the vendor, 10 - REACT: REACT items are used in soft lines & footwear, 43 - IMPORT ITEM- is ordered by the buyer then shipped from an overseas vendor, to a storage warehouse, to a Walmart warehouse, to a store, 33 - ASSEMBLY DISTRIBUTION merchandise is ordered from suppliers who process the orders and ship the merchandise, for all stores, to a Walmart Distribution Center (WMDC). The WMDC separates and delivers the individual store orders via Walmart truck, 37 - ASSEMBLY SHIP & BILL merchandise is not processed through a distribution center. Merchandise is delivered directly from the vendor to the store, 11 - AFAD replenishable apparel WPM (Walmart Pre-Marked) warehouse, 20 - REGULAR - ordered by the stores system, ships from warehouse, to store, 22 - SEASONAL - ordered by the stores system, ships from warehouse, to store, 40 - REGULAR IMPORT - ordered by the stores system, ships from warehouse, to store, 42 - SEASONAL IMPORT - ordered by the stores system, ships from warehouse, to store, 50 - JUST IN TIME 24 hour turn around in the warehouse, ordered by the stores system, ships from warehouse, to store | Item Attributes | Item Type Code | Available | 2026.4.2 Release |
| wm_upc_nbr | Universal Product Code Number | The Universal Product Code (UPC) number that is used to create a base item, and the base item is used to group all variant items. If the item is a base, then UPC and Base UPC will be the same. If the item is a variant, then UPC will be different from Base UPC. | Item Attributes | UPC | Available | 2026.4.2 Release |
| wm_upc_desc | Walmart UPC Description | The Universal Product Code (UPC) description that is used to create a base item, and the base item that is used to group all variant items. If the item is a base, then UPC and Base UPC will be the same. If the item is a variant, then UPC will be different from Base UPC. | Item Attributes | UPC Desc | Available | 2026.4.2 Release |
| item_type_desc | Item Type Description | Item Type determines the type of replenishment: Non-Replenishable Item Types can only be ordered through the following: buyer, vendor manager and sales representative. Non-Replenishable item types cannot be ordered by the store. | Item Attributes | - | Available | 2026.4.2 Release |
| all_links_item_desc_1 | All Links Item Description | Item description for the prime item number that is top of all the item linkage chains. | Item Attributes | Prime Item Desc | Available | 2026.4.2 Release |
| all_links_item_nbr | All Links Item Number | The item number that act as an item linkage to simplify certain operational activities or is used for reporting purposes; similar items are linked/ mapped together.For example: In Financial Reporting, All Link Item Number (all_links_item_nbr) is used for Sales Reporting. It doesn't differ between suppliers. The same product that is produced by different suppliers could share the same all_links_item_nbr. Also see: Prime Item Number. | Item Attributes | - | Available | 2026.4.2 Release |
| all_links_mds_fam_id | All Links Store Item Id | ALL LINKS ITEM1 DESC is the 'item description 1' for the prime item_nbr that is the top of all the item linkage chains. | Item Attributes | - | Available | 2026.4.2 Release |
| base_unit_rtl_amt | Base Unit Retail Amount | The default selling price of an item and not the actual selling price. | Item Attributes | Unit Retail | Available | 2026.4.2 Release |
| never_out_ind | Never Out Indicator | Indicates if an item is designated for the stores to never be out–of-stock. | Item Attributes | Never Out Flag | Available | 2026.4.2 Release |
| whse_min_order_qty | Warehouse Min Order Quantity | The minimum quantity that a store can order from the warehouse for this item of merchandise. | Item Attributes | Min Order Qty | Available | 2026.4.2 Release |
| pallet_hi_qty | Pallet HI Quantity | The supplier pallet information, such as the number of layers on a pallet. TI and HI are used for traffic planning (shipping) and slotting merchandise in the warehouse. Note: In grocery, both the TI and HI can vary by Distribution Center (DC). | Item Attributes | Pallet Hi Qty | Available | 2026.4.2 Release |
| pallet_upc_nbr | Pallet UPC Number | The standardized shipping container code for pallets. | Item Attributes | Pallet UPC | Available | 2026.4.2 Release |
| whpk_qty | Warehouse Pack Quantity | Number of units or eaches in a warehouse pack case.Note: Currently the number of warehouse packs is a derived figure. For example, an item with a Vendor Pack Quantity of 24 and Warehouse Pack Quantity of 4 would really have 6 warehouse packs in each vendor pack. This is also the minimum quantity of eaches that a store can order from the warehouse. Once created, this field cannot be changed. This is a restriction of DC processing. If they had the same item number with different warehouse pack quantities, they could not determine what to bill the stores for shipments. Warehouse Pack Quantity must ALWAYS be evenly divisible into the Vendor Pack Quantity. There are also rules established for Warehouse and Vendor Pack Quantities based on the Case Pack Type. Only items with a Case Pack Type of B (Break pack) can have a Warehouse Pack Quantity different than the Vendor Pack Quantity. This value can be overridden from the Item for a given purchase order. | Item Attributes | Warehouse Pack Qty (Owned Only) | Available | 2026.4.2 Release |
| whse_algn_type_desc | Warehouse Alignment Type Description | The description for warehouse alignment type. Valid values include:AB - Assembly Bulk, AC - AIDCO Conversion, AS - Assembly, CI - Circular, CW - Collectable, DG - Dry Good, DI - Distribution Freight, DS - Distribution Shoes, GB - Bakery, FC - Freezer/Cooler, GB - Bakery, GC - Dairy, GD - Dry Grocery, GF - Frozen Foods, GM - Meats and Seafood, GP - Product, GV - Private Label and Promotion, GY - Deli, HA - Hearing Aids, HW - Hypermart IN - International, JW - Jewelry, MT - Meat, OC - Over the Counter, OP - Optical Lab, PD - Produce, PH - Pharmacy, SB - Staple Stock BulkSH - Special Hypermart, SP - Special Divisions, SS - Staple Stock Shoes, TD - Tires, TS - Tires Distribution, WH - Warehouse, WP - WPM Merchandise, AP - WPM CENTER, APPAREL NETWORK, F0 - GROCERY NETWORK, HVDC Phase I, F1 - GROCERY NETWORK, HVDC Phase II, F2 - GROCERY NETWORK, F3 - GROCERY NETWORK, F4 - GROCERY NETWORK, F5 - GROCERY NETWORK, HVDC Phase VI, F8 - GROCERY NETWORK, F9 - GROCERY NETWORK, G0 - SPECIAL REALIGNMENT, G1 - SPECIAL REALIGNMENT, G2 - SPECIAL REALIGNMENT, G3 - SPECIAL REALIGNMENT, G4 - SPECIAL REALIGNMENT, G5 - SPECIAL REALIGNMENT, G6 - SPECIAL REALIGNMENT, G7 - SPECIAL REALIGNMENT, G8 - SPECIAL REALIGNMENT, G9 - SPECIAL REALIGNMENT, GZ - GROCERY EMERGENCY, PR - SLOW DRY PHASE III, PX - PRESCRIPTION REPLENISHMENT, R0 - REGIONAL NETWORK, R1 - REGIONAL NETWORK, R2 - REGIONAL NETWORK, R3 - REGIONAL NETWORK, R4 - REGIONAL NETWORK, R5 - REGIONAL NETWORK, R6 - REGIONAL NETWORK, R8 - REGIONAL NETWORK, RX - PHARMACY | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_len_qty | Warehouse Pack Length Quantity | The measured length of a warehouse case pack. | Item Attributes | WHPK Length | Available | 2026.4.2 Release |
| whpk_wdth_qty | Warehouse Pack Width Quantity | The measured width of a warehouse case pack. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_cube_qty | Warehouse Pack Cubic Quantity | The warehouse pack cubic feet. The size in cubic feet of a warehouse pack. | Item Attributes | WHPK Cubic Ft | Available | 2026.4.2 Release |
| whpk_ht_qty | Warehouse Pack Height Quantity | The measured height of a warehouse case pack. | Item Attributes | WHPK Height | Available | 2026.4.2 Release |
| vendor_dept_nbr | Vendor Department Number | The department number of the supplier agreement. | Item Attributes | Vendor Nbr Dept | Available | 2026.4.2 Release |
| vndr_min_order_qty | Vendor Minimum Order Quantity | The minimum amount the warehouse or store can order from a vendor. In Hardlines, Minimum Order Qty must be a multiple of Wise Pack Qty. The value is in cases for Grocery and eaches for Hardlines. | Item Attributes | Vndr Min Ord Qty | Available | 2026.4.2 Release |
| vnpk_qty | Vendor Pack Quantity | The vendor pack quantity amount of vendor packs. | Item Attributes | VNPK Qty | Available | 2026.4.2 Release |
| vnpk_wt_qty | Vendor Pack Weight Quantity | The weight of the vendor pack case. This includes the weight of the case packaging. | Item Attributes | Vendor Pack Weight | Available | 2026.4.2 Release |
| vnpk_len_qty | Vendor Pack Length Quantity | The measured length of a vendor case pack. | Item Attributes | VNPK Length | Available | 2026.4.2 Release |
| vnpk_wdth_qty | Vendor Pack Width Quantity | The measured width of a vendor case pack. | Item Attributes | VNPK Width | Available | 2026.4.2 Release |
| vnpk_ht_qty | Vendor Pack Height Quantity | The measured height of a vendor case pack. | Item Attributes | VNPK Height | Available | 2026.4.2 Release |
| vendor_seq_nbr | Vendor Sequence Number | The ninth digit of a 9-digit vendor number. | Item Attributes | Vendor Sequence Nbr | Available | 2026.4.2 Release |
| omni_seg_nbr | Omni Segment Number | This is the number for the Omni segment. Stores - financial segment number and eComm - division number. | Item Attributes | - | Available | 2026.4.2 Release |
| omni_seg_desc | Omni Segment Description | This is the description for the Omni segment. Stores - financial segment name and eComm - division name. | Item Attributes | MDSE Segment Description | Available | 2026.4.2 Release |
| omni_dept_nbr | Omni Department Number | This is the number for the Omni department. Stores - department number and eComm - super department number. | Item Attributes | Acct Dept Nbr | Available | 2026.4.2 Release |
| omni_dept_desc | Omni Department Description | This is the description for the Omni department. Stores - department name and eComm - super department name. | Item Attributes | Dept Desc | Available | 2026.4.2 Release |
| omni_catg_nbr | Omni Category Number | The department category number for stores. | Item Attributes | Category Nbr | Available | 2026.4.2 Release |
| omni_catg_desc | Omni Category Description | The department category group description. | Item Attributes | Dept Category Description | Available | 2026.4.2 Release |
| omni_catg_grp_nbr | Omni Category Group Number | The department category group number. | Item Attributes | - | Available | 2026.4.2 Release |
| omni_catg_grp_desc | Omni Category Group Description | The department category group description. | Item Attributes | Dept Category Group Description Subcategory Description | Available | 2026.4.2 Release |
| omni_subcatg_nbr | Omni Subcategory Number | An unique identifier of the L40 level within the Walmart Merchandising Hierarchy. This is below Category and the lowest level of the Omni Hierarchy. | Item Attributes | - | Available | 2026.4.2 Release |
| omni_subcatg_desc | Omni Subcategory Description | Name of the L40 level within the Walmart Merchandising Hierarchy. This is below Category and the lowest level of the Omni Hierarchy. | Item Attributes | - | Available | 2026.4.2 Release |
| vendor_stock_id | Vendor Stock ID | The vendor's item number or a Walmart generated Vendor Stock ID. Vendor Managed Items: A vendor abbreviation is added to the Vendor's item number to uniquely identify an item of merchandise.Items supplied from a third party grocery warehouse: A vendor abbreviation and vendor warehouse number is added to the vendor's item number to uniquely identify an item of merchandise.Note: we are not using using third party grocery warehouses. | Item Attributes | Vendor Stock ID | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | Name of the supplier. It is an important product attribute for reporting. | Item Attributes | Vendor Name | Available | 2026.4.2 Release |
| brand_ownr_nm | Brand Owner Name | The name of the company that owns the Brand or Trademark for the product as indicated on the product's packaging. This may also be the Manufacturer, Distiller, Brewer, Distributor, Retailer or Bottler. | Item Attributes | Brand Owner Name | Available | 2026.4.2 Release |
| brand_nm | Brand Name | The brand name of an item supplied by the supplier during the item setup process. It is the name that the product is known, is displayed on the walmart.com website and is a necessary component of the search functionality. It is not the same as the Brand code/name that Walmart Stores use. | Item Attributes | Brand Name | Available | 2026.4.2 Release |
| brand_id | Brand ID | A unique numeric identifier for the primary description of the product, for example, a patent or trademark. The brand refers to the largest text found on the front of the pack, in a prominent position but may require some additional information to make it a meaningful and unique identifier. | Item Attributes | Brand ID | Available | 2026.4.2 Release |
| brand_fam_nm | Brand Family Name | The name of a brand family that provides additional grouping of products across product areas | Item Attributes | Brand Family Name | Available | 2026.4.2 Release |
| brand_fam_id | Brand Family ID | A unique identifier for Brand Family that is used to provide additional grouping of products across product areas. | Item Attributes | Brand Family ID | Available | 2026.4.2 Release |
| brand_ownr_id | Brand Owner ID | A unique identifier for the company that owns the Brand or Trademark for the product as indicated on the product's packaging. This may also be the Manufacturer, Distiller, Brewer, Distributor, Retailer, or Bottler. | Item Attributes | Brand Owner ID | Available | 2026.4.2 Release |
| vnpk_cost_amt | Vendor Pack Cost Amount | The base cost of the vendor pack case of an item. This does not reflect deals and discounts which are stored separately. This is not the net cost on a Purchase Order. Note: The value in this field may or may not reflect the latest actual cost used on a Purchase Order since the cost for any item can be changed on the PO. This amount is shown in dollars. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_unit_cost | Warehouse Pack Unit Cost | The cost of a warehouse pack. | Item Attributes | - | Available | 2026.4.2 Release |
| item_desc_2 | Item Description 2 | Secondary written description of an item for internal use only (may show content count or have a comment). Item Desc 2 prints on the customers receipt at store level for Softline items. UPC Desc prints on the customers receipt at store level for Hardline items. | Item Attributes | Item Desc 2 | Available | 2026.4.2 Release |
| color_desc | Color Description | Color Description also called as Shelf Label 1 Desc is a 6-character description that is transmitted to the store and printed on the shelf label. | Item Attributes | Color Desc | Available | 2026.4.2 Release |
| size_desc | Size Description | A 6-character description that is transmitted to the store and printed on the shelf label. But depending on the department, it could have a different meaning. Hardlines - It is another six-character description of the merchandise. Softlines - It is selected in the BIF system from the variants available and should have true size meaning for apparel and shoes.Also transmitted to a third party for the preparation of merchandise price tags. This is called Shelf Label 2 description in MIM. | Item Attributes | Size Desc | Available | 2026.4.2 Release |
| repl_subtype_cd | Replenishment Subtype Code | In other terms: When repl_instock_denominator=1 THEN SUM(repl_instock_numerator)/SUM(repl_instock_denominator) * 100 | Item Attributes | Item Sub Type | Available | 2026.4.2 Release |
| repl_subtype_desc | Replenishment Subtype Description | This determines the Shelf Label design description and informs the store how the product is ordered. | Item Attributes | - | Available | 2026.4.2 Release |
| item_len_qty | Item Length Quantity | With the item on its natural base and the graphics reading from left to right, from the front the item length quantity represents the measurement from left to right. | Item Attributes | Item Length | Available | 2026.4.2 Release |
| item_ht_qty | Item Height Quantity | This is the measured height of the actual item. | Item Attributes | Item Height | Available | 2026.4.2 Release |
| item_wdth_qty | Item Width Quantity | This is the measured width of the actual item. | Item Attributes | Item Width | Available | 2026.4.2 Release |
| item_cube_qty | Item Cube Quantity | This represents the measurement of the cube of an item based on the item dimension Unit of Measure (UOM). (Cube is measured as the length X width X height and as such is derivable data. For some items, however, the various dimension measurements will not be available and the only measurement we have is cube.) | Item Attributes | - | Available | 2026.4.2 Release |
| item_cube_uom_cd | Item Cube Unit of Measure Code | This represents the Unit of Measure (UOM) for the cube. | Item Attributes | - | Available | 2026.4.2 Release |
| item_cube_uom_desc | Item Cube Unit of Measure Description | This is the Unit of Measure (UOM) description for item length, height, and width. | Item Attributes | - | Available | 2026.4.2 Release |
| item_order_eff_dt | Item Order Effective Date | This is the Date that an item becomes orderable at the store. | Item Attributes | Effective Date | Available | 2026.4.2 Release |
| sell_qty | Sell Quantity | Short for Selling Quantity of an item. This is used in unit price calculations for Price Comparisons. Example: The Retail Price of Peter Pan Crunchy Peanut Butter is $1.68. The Sell Qty is 17.6 OZ. The calculated price per oz is 9.60 cents. | Item Attributes | UOM Sell Qty | Available | 2026.4.2 Release |
| sell_uom_cd | Sell Unit of Measure Code | The Unit of Measure (UOM) of the Sell Qty. Note: This is not the UOM Sale Type. At this time, UOM Sale Type is not available in Report Builder. | Item Attributes | UOM Code | Available | 2026.4.2 Release |
| sell_uom_desc | Sell Unit of Measure Description | The Unit of Measure (UOM) description of the Sell Qty. Note: This is not the UOM Sale Type. At this time, UOM Sale Type is not available in Report Builder. | Item Attributes | - | Available | 2026.4.2 Release |
| pallet_ti_qty | Pallet Ti Quantity | This is vendor pallet information. The number of vendor cases per layer on a pallet (tier on a pallet). Ti and Hi are used for traffic planning (shipping) and slotting merchandise in the warehouse. This tells the unloader how to stack each item on a pallet. | Item Attributes | Pallet Ti Qty | Available | 2026.4.2 Release |
| vnpk_cube_qty | Vendor Pack Cube Quantity | The cube dimensions of the vendor pack case. | Item Attributes | VNPK Cubic Ft | Available | 2026.4.2 Release |
| vnpk_cube_uom_cd | Vendor Pack Cube Unit of Measure Code | The unit of measure for the vendor pack cube. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_cube_uom_desc | Vendor Pack Cube Unit of Measure Description | The unit of measure description for the vendor pack cube. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_cspk_cd | Vendor Case Pack Code | Case pack type. C - Case: Vendor Pack is equal to the Warehouse Pack. B - Breakpack: Multiple Warehouse Packs within a Vendor Pack. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_cspk_desc | Vendor Case Pack Description | Description of Case pack type. C - Case: Vendor Pack is equal to the Warehouse Pack. B - Breakpack: Multiple Warehouse Packs within a vendor pack. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_upc_nbr | Warehouse Pack UPC Number | The standardized shipping container code (SCC-14 universal code for shipping containers); identifies the warehouse pack (inner case UPC). | Item Attributes | WHPK UPC | Available | 2026.4.2 Release |
| whpk_wt_qty | Warehouse Pack Weight Quantity | Weight of the warehouse pack case. | Item Attributes | Whse Pack Weight | Available | 2026.4.2 Release |
| whpk_wt_uom_cd | Warehouse Pack Weight Unit of Measure Code | Unit of Measure (UOM) for the warehouse pack weight. | Item Attributes | UOM Code | Available | 2026.4.2 Release |
| whpk_wt_uom_desc | Warehouse Pack Weight Unit of Measure Description | Unit of Measure (UOM) description for the warehouse pack weight. | Item Attributes | - | Available | 2026.4.2 Release |
| order_sizng_fctr_qty | Order Sizing Factory Quantity | A trade item specification other than gross, net weight, or cubic feet for a line trade item or a transaction, used for order sizing and pricing purposes | Item Attributes | Cubic Order Sizing Factor | Available | 2026.4.2 Release |
| repl_unit_ind | Replenishment Unit Indicator | Replenish by Units Indicator - Denotes that an item is replenished in eaches and not by weight, reflecting when an item is purchased by unit and sold by weight. | Item Attributes | Replenish Unit Ind | Available | 2026.4.2 Release |
| repl_group_nbr | Replenishmen t Group Number | A unique identifier that allows systems to recognize items having different item numbers, as one product. Otherwise called CID. All sellable items will have a Consumer ID (CID) assigned. Items that could share a common Consumer ID are items purchased through several import and domestic channels, items sourced from multiple suppliers, products delivered to stores from multiple (DSD) suppliers, and items transitioning to new packaging. | Item Attributes | Consumer Number ID | Available | 2026.4.2 Release |
| fineline_nbr | Fineline Number | A unique number for a hierarchical grouping of Items. Fineline is the first merchandise grouping directly under Subclass. An item can only be in one Department, Subclass and Fineline. | Item Attributes | Fineline Number | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries.The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Item Attributes | - | Available | 2026.4.2 Release |
| base_div_nbr | Base Division Number | Base Division Number represents the base division of the item. E.g., 01 - Walmart | Item Attributes | - | Available | 2026.4.2 Release |
| buyr_rpt_postn_id | Buyer Reporting Position ID | Represents the Walmart buyer position reporting structure.
| Item Attributes | - | Available | 2026.4.2 Release |
| whpk_calc_mthd_desc | Warehouse Pack Calculation Method Description | The description for the one-character code that represents the method by which the warehouse pack sell is calculated from the vendor pack cost (or warehouse pack cost which is calculated from vendor pack cost). Examples: R - revalue, M - manual, A - Corporate Average (averaged across all DCs). L - Local Average means that the value in warehouse pack sell amount is averaged across all DC's but the actual amount that is charged to the Stores in the average of all receiving's at each DC and is on the Item Dimension table. Note: R - revalue will likely be phased out. | Item Attributes | - | Available | 2026.4.2 Release |
| plnr_rpt_postn_id | Planner Reporting Position ID | Represents a planner reporting job position. | Item Attributes | - | Available | 2026.4.2 Release |
| acctg_dept_desc | Accounting Department Description | The description for the department number used for general accounting. This is the department number that sales and purchased are booked to. Accounting departments can have order departments aligned under, but all the order departments under the Accounting department will be rolled up. | Item Attributes | Acct Dept Nbr | Available | 2026.4.2 Release |
| cntry_nm | Country Name | This is the textual identifier for a country. | Item Attributes | - | Available | 2026.4.2 Release |
| item_status_desc | Item Status Description | Description for the status of an item. Valid values are A=Active, I=Inactive, or D=Delete. | Item Attributes | Item Status | Available | 2026.4.2 Release |
| prime_xref_item_nbr | Prime Item Number | This is the item number that acts as an item linkage to simplify certain operational activities or is used for reporting purposes; similar items are linked/mapped together. For example: for replenishment purposes, the Prime Item Number (prime_xref_item_nbr) is used for Supply Chain Reporting. The same product that is produced by different suppliers will not have the same prime_xref_item_nbr. Also see: All Links Item Number. | Item Attributes | - | Available | 2026.4.2 Release |
| prime_xref_mds_fam_id | Prime MDS Fam ID | This is the system assigned item identifier for the prime xref item nbr. | Item Attributes | - | Available | 2026.4.2 Release |
| prime_lia_item_nbr | Prime Lia Item Number | The system assigned item based on the primary item in this item's like-item assortment. If this item is not part of an assortment then it's the item's system assigned item. | Item Attributes | - | Available | 2026.4.2 Release |
| prime_lia_mds_ fam_id | Prime Lia MDS Fam ID | This is the system assigned item identifier for the prime lia item nbr. | Item Attributes | - | Available | 2026.4.2 Release |
| whse_algn_type_cd | Warehouse Alignment Type Code | Groups items together for warehouse alignment. An alignment of a warehouse to a store for shipment of products. This alignment is based on the type of product. Valid values include: AB - Assembly Bulk, AC - AIDCO Conversion, AS - Assembly, CI - Circular, CW - Collectable, DG - Dry Good, DI - Distribution Freight, DS - Distribution Shoes, GB - Bakery, FC - Freezer/Cooler, GB - Bakery, GC - Dairy, GD - Dry Grocery, GF - Frozen Foods, GM - Meats and Seafood, GP - Product, GV - Private Label and Promotion, GY - Deli, HA - Hearing Aids, HW - Hypermart, IN - International, JW - Jewelry, MT - Meat, OC - Over the Counter, OP - Optical Lab, PD - Produce, PH - Pharmacy, SB - Staple Stock Bulk, SH - Special Hypermart, SP - Special Divisions, SS - Staple Stock Shoes, TD - Tires, TS - Tires Distribution, WH - Warehouse, WP - WPM Merchandise, AP - WPM CENTER, APPAREL NETWORK, F0 - GROCERY NETWORK, HVDC Phase I, F1 - GROCERY NETWORK, HVDC Phase II, F2 - GROCERY NETWORK, F3 - GROCERY NETWORK, F4 - GROCERY NETWORK, F5 - GROCERY NETWORK, HVDC Phase VI, F8 - GROCERY NETWORK, F9 - GROCERY NETWORK, G0 - SPECIAL REALIGNMENT, G1 - SPECIAL REALIGNMENT, G2 - SPECIAL REALIGNMENT, G3 - SPECIAL REALIGNMENT, G4 - SPECIAL REALIGNMENT, G5 - SPECIAL REALIGNMENT, G6 - SPECIAL REALIGNMENT, G7 - SPECIAL REALIGNMENT, G8 - SPECIAL REALIGNMENT, G9 - SPECIAL REALIGNMENT, GZ - GROCERY EMERGENCY, PR - SLOW DRY PHASE III, PX - PRESCRIPTION REPLENISHMENT, R0 - REGIONAL NETWORK, R1 - REGIONAL NETWORK, R2 - REGIONAL NETWORK, R3 - REGIONAL NETWORK, R4 - REGIONAL NETWORK, R5 - REGIONAL NETWORK, R6 - REGIONAL NETWORK, R7 - REGIONAL NETWORK, R8 - REGIONAL NETWORK, R9 - REGIONAL NETWORK, RX - PHARMACY | Item Attributes | Whse Align | Available | 2026.4.2 Release |
| whse_area_cd | Warehouse Area Code | This is the numerical representation of the 2 characters identifying the section of warehouse to receive product. Examples: , 1A – HVDC , 1C – Sam's Perishable , 1P – Walmart Perishable , 5C – Holiday OSS , 6C – OSS for Turn , 4C – Bananas that are ripened at Colton, then transferred to 7025 , 9C – Was for a test of the banana rooms when Hunter Park opened up | Item Attributes | - | Available | 2026.4.2 Release |
| whse_area_desc | Warehouse Area Description | Describes the section of warehouse to receive product from the DCS2000 system. Examples: 1A – HVDC , 1C – Sam’s Perishable , 1P – Walmart Perishable , 5C – Holiday OSS , 6C – OSS for Turn , 4C – Bananas that are ripened at Colton, then transferred to 7025 , 9C – Was for a test of the banana rooms when Hunter Park opened up | Item Attributes | - | Available | 2026.4.2 Release |
| whse_rotation_cd | Warehouse Rotation Code | This indicates how an item is rotated in a warehouse (grocery or regional); Values: N - Normal, R - Strict rotation based on receiving dates, C - Strict rotation based on code date, S - Strict rotation based on sequence number of pallet. | Item Attributes | - | Available | 2026.4.2 Release |
| whse_rotation_desc | Warehouse Rotation Description | This indicates how an item is rotated in a warehouse (grocery or regional); Values: N - Normal, R - Strict rotation based on receiving dates, C - Strict rotation based on code date, S - Strict rotation based on sequence number of pallet. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_calc_mthd_cd | Warehouse Pack Calculation Method Code | A one-character code that represents the method by which the warehouse pack sell is calculated from the vendor pack cost (or warehouse pack cost which is calculated from vendor pack cost). Examples: R - revalue, M - manual, A - Corporate Average (averaged across all DCs). L - Local Average means that the value in warehouse pack sell amount is averaged across all DC's but the actual amount that is charged to the Stores in the average of all receiving's at each DC and is on the Item Dimension table. Note: R - revalue will likely be phased out. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_sell_amt | Warehouse Pack Sell Amount | The amount a store pays the DC to purchase a warehouse pack of this item. This does not include inbound freight cost and any additional DC charges. This amount is shown in dollars ($). | Item Attributes | - | Available | 2026.4.2 Release |
| plu_nbr | Price Look Up Number | This is utilized through the weighing system either through the scales at the back or at the front registers. The price is set by the weight of the item. | Item Attributes | - | Available | 2026.4.2 Release |
| cons_item_nbr | Consumer Item Number | A Consumer Item is an item that can be sold at the retail level as a single unit to the consumer. It specifically addresses those instances where there are multiple item numbers created for a single Consumer Item. This occurs when there are different replenishment methods, vendors, costs and when the same merchandise is sold in multiple departments. Any one of the item numbers may be used to replenish the Consumer Item. Once it is sent to the store it will become the number that will always serve as the store reference. This is the new number that will be printed on shelf labels. This column is optional and not part of any hierarchy. | Item Attributes | - | Available | 2026.4.2 Release |
| cons_item_desc | Consumer Item Description | This is the description provided for a consumer item number. | Item Attributes | - | Available | 2026.4.2 Release |
| prod_nbr | Product Number | This uniquely identifies the products. Products represent a grouping of similar merchandise, further defining a merchandise category and subcategory. | Item Attributes | - | Available | 2026.4.2 Release |
| prod_desc | Product Description | Internationalized text descriptions of the product. | Item Attributes | Product Description | Available | 2026.4.2 Release |
| cust_base_rtl_amt | Customer Base Unit Retail Amount | This is the base unit retail amount plus the value added tax. This may be calculated but is entered to get the correct price point. This is used for international markets and only in countries that display the tax inclusive retail to the customer on the shelf label. | Item Attributes | - | Available | 2026.4.2 Release |
| base_rtl_uom_cd | Base Retail UOM Code | The Unit of Measurement that an item is sold in. Valid values include: EA – eaches, FT - feet, YD – yards, IN - inches, LB – pounds , QT - quart, GL - gallons, OZ - ounces, DZ – dozen | Item Attributes | - | Available | 2026.4.2 Release |
| base_rtl_uom_desc | Base Retail UOM Description | Description for the Unit of Measurement that an item is sold in. Valid values include: EA – eaches, FT - feet, YD – yards, IN - inches, LB – pounds , QT - quart, GL - gallons, OZ - ounces, DZ – dozen | Item Attributes | - | Available | 2026.4.2 Release |
| cncl_when_out_ind | Cancel When Out Indicator | The merchandise is being phased out at the Store or the Distribution Center. When on-hand falls to zero, cancel the store order for this item. Examples: 0,1 (where 1 means item is deleted) | Item Attributes | Cancel When Out Flag | Available | 2026.4.2 Release |
| item_import_ind | Item Import Indicator | This indicates the merchandise shipped from an overseas vendor (Item Types 40, 42 and 43). | Item Attributes | - | Available | 2026.4.2 Release |
| item_repl_ind | Item Replenishment Indicator | An item is replenishable if the item type is replenishable (33, 37, 11, 20, 22, 40 42 and 50) and the ITEM REPLENISHMENT IND is a “Y”. If the indicator is set to a “N”, the stores will not be able to order this item. There are many reasons for this. Some examples are: The item is being discontinued. It is a new item, and the vendor is not ready to ship yet. Converting from this item number to a new item number. This is also known as Order Book Code. | Item Attributes | - | Available | 2026.4.2 Release |
| guar_sales_ind | Guaranteed Sales Indicator | This indicates that if the item does not sell it may be returned to the Vendor. This is to keep the stores from marking down these items. | Item Attributes | - | Available | 2026.4.2 Release |
| master_carton_ind | Master Carton Indicator | A master carton indicator shows when the Vendor ships a carton that contains multiple Vendor Packs. Example: If an item has a vendor pack and warehouse pack of 12, Then the shipping carton contains 12 vendor packs i.e., 144 items. This is not used in MIM. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_wt_uom_cd | Vendor Pack Weight UOM Code | The unit of measure (UOM) for the vendor pack weight. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_wt_uom_desc | Vendor Pack Weight Description | Description for the unit of measure used for the net weight of the vendor pack. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_dim_uom _cd | Vendor Pack Dimension UOM Code | The unit of measure for the vendor pack dimension. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_dim_uom _desc | Vendor Pack Dimension UOM Description | Unit of Measure description for the vendor pack dimensions. | Item Attributes | - | Available | 2026.4.2 Release |
| whse_max_order_qty | Warehouse Max Order Qty | Maximum quantity that a store can order from the warehouse. Value is in cases for Grocery and eaches for Hardlines. In Hardlines, Maximum Order Quantity must be a multiple of the Wholesale Pack Quantity. | Item Attributes | Max Order Qty | Available | 2026.4.2 Release |
| whpk_cube_uom_cd | Warehouse Pack Cube UOM Code | Unit of Measure for the warehouse pack cube. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_cube_uom_desc | Warehouse Pack Cube UOM Description | Unit of measure description for the warehouse pack cube. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_dim_uom_cd | Warehouse Pack Dimension UOM Code | Unit of measure for the warehouse pack dimensions. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_dim_uom_desc | Warehouse Pack Dimension UOM Description | Unit of measure description for the warehouse pack dimensions. | Item Attributes | - | Available | 2026.4.2 Release |
| buyg_region_cd | Buying Region Code | Used for items that belong in one Buying Region. Examples: 1 - Puerto Rico, 2 - Hawaii, or 3 - Alaska. This is mainly used to differentiate between Continental US items and Puerto Rico, Hawaii or Alaska items that have the same UPC. | Item Attributes | Buying Region Code | Available | 2026.4.2 Release |
| buyg_region_desc | Buying Region Description | Used for items that belong in one Buying Region. Examples: 1 - Puerto Rico, 2 - Hawaii, or 3 - Alaska. This is mainly used to differentiate between Continental US items and Puerto Rico, Hawaii or Alaska items that have the same UPC. | Item Attributes | Buying Region Desc | Available | 2026.4.2 Release |
| shop_desc | Shop Description | Used only in Softlines or the Shoes category and is a description for various groupings of clothing, i.e., Sportswear, Casual, etc. The Ticket description is created by combining the Fineline Number with the Shop Description. | Item Attributes | - | Available | 2026.4.2 Release |
| signing_desc | Signing Description | Displayed on shelf signs or flags at the store. It is used for all lines of the business (Hardlines, Grocery, etc.). It could be the same as Item description. | Item Attributes | Signing Desc | Available | 2026.4.2 Release |
| asort_type_cd | Assortment Type Code | Assortments are created when different items with different UPC numbers are shipped together in one carton. There are two types of assortments: Like or Different. Each type of assortment consists of an Assortment Item Number (Parent) and Item Numbers (Children). | Item Attributes | - | Available | 2026.4.2 Release |
| asort_type_desc | Assortment Type Description | This is the text description of the Assortment Type Code | Item Attributes | - | Available | 2026.4.2 Release |
| seasn_cd | Season Code | The textual description of the season code. Examples: Spring, Summer, Winter, Fall | Item Attributes | Season Code | Available | 2026.4.2 Release |
| seasn_desc | Season Description | The textual description of the season code. Examples: Spring, Summer, Winter, Fall | Item Attributes | - | Available | 2026.4.2 Release |
| seasn_yr | Season Year | This is used with the season code to help identify items that are for a yearly season. Examples: Fall of 2004, Winter of 2003 or Spring of 2005. | Item Attributes | Season Year | Available | 2026.4.2 Release |
| item_dim_uom_cd | Item Dimension Unit of Measure Code | The Unit of Measure code for item length, height and width. | Item Attributes | UOM Code | Available | 2026.4.2 Release |
| item_dim_uom_desc | Item Dimension Unit of Measure Description | The Unit of Measure description for item length, height and width. | Item Attributes | - | Available | 2026.4.2 Release |
| item_wt_qty | Item Weight Quantity | This represents the measurement of the weight of an item. | Item Attributes | Item Weight | Available | 2026.4.2 Release |
| item_wt_uom_cd | Item Weight Unit of Measure Code | This represents the Unit of Measure of an item's weight, height or width. Example: lbs or oz. | Item Attributes | - | Available | 2026.4.2 Release |
| item_wt_uom_desc | Item Weight Unit of Measure Description | The description for the Unit of Measure of an item's weight, height or width. Example: lbs or oz. | Item Attributes | - | Available | 2026.4.2 Release |
| item_expire_dt | Item Expiry Date | The date this item number will go into "Inactive" status and begin the purge process. Non-replenishable item types should be set with a reasonable expiration date allowing time for the product to sell through. | Item Attributes | - | Available | 2026.4.2 Release |
| est_out_of_stock_dt | Estimated Out of Stock Date | An estimated out of stock date is an estimated date when the warehouse will be out of stock of the deleted item. When the Cancel When Out (CWO) Ind is changed to Y, the Out-of-Stock Date is set based on the following merchandise types: -Perishable: TODAY + 2 weeks, -Import Item: TODAY + 90 days, -Domestic: TODAY + 4 weeks. Note: This is not used as such in Division 1 (hardlines or softlines). When an item has the CWO flag set to “Y” a date may be entered in the rightmost portion of Description 2, but this is not required. | Item Attributes | - | Available | 2026.4.2 Release |
| pallet_size_cd | Pallet Size Code | Indicates if vendor pallet is large or small. Valid values: L - Large, S - Small (size Large is 4' X 4' and Small is 3' X 3') | Item Attributes | - | Available | 2026.4.2 Release |
| pallet_rnd_pct | Pallet Rounding Percent | The Vendor Order Rounding Percent represents the percentage of a full warehouse pallet that will trigger a full pallet pull. Example: If Rounding % is 75% and the store order is 80%, the store will receive a full pallet of merchandise. If the store order is 60% then the store will receive only 60% of the pallet. The valid range is 1 to 100%. The Default for Grocery items in a Grocery DC is 100% | Item Attributes | - | Available | 2026.4.2 Release |
| case_upc_nbr | Case UPC Number | This is the standardized shipping container code (SCC-14 universal code for shipping containers). It identifies vendor cases of merchandise; used by grocery. This is used for all DC's in receiving merchandise with an Advance Ship Notice (ASN). | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_wt_fmt_cd | Vendor Pack Weight Format Code | This represents if the Vendor Pack Weight is fixed or variable; Values: 'F' (fixed), 'V' (variable). Fixed means the weight of the vendor case is consistently the same. Variable means the weight of the vendor case entered is an average case weight and the actual weight of each vendor case may be higher or lower. | Item Attributes | Pack Weight Fmt | Available | 2026.4.2 Release |
| vnpk_wt_fmt_desc | Vendor Pack Weight Format Description | Contextual description for the Vendor Pack Weight. | Item Attributes | - | Available | 2026.4.2 Release |
| vnpk_net_wt_qty | Vendor Pack Net Weight Quantity | The weight of the products contained within the vendor pack. This weight would be for product only without the packing and container weight. | Item Attributes | Vendor Pack Weight | Available | 2026.4.2 Release |
| vnpk_net_wt_uom_cd | Vendor Pack Net Weight UOM Code | Unit of measure used for the net weight of the vendor pack. | Item Attributes | - | Available | 2026.4.2 Release |
| modlr_base_mdse_cd | Modular Based Merchandising Code | Holds the Modular Based Merchandising Code: -M (Modular) indicates that the item is modular driven, sent to stores based upon modular traits and item traits., - I (Item) indicates that the item is item driven, sent to stores based upon item traits and classes., - H (Hold) indicates that the item is on hold, not going to any stores until the item is traited or the UPC of the item is put on a modular., - P (Pend) indicates that the item is in pending status. The UPC of the item was Modular driven and then taken off the MBM modular. It will remain in pending status until the item is traited and updated to item driven, or the UPC of the item is put on another MBM modular. | Item Attributes | - | Available | 2026.4.2 Release |
| modlr_base_mdse_desc | Modular Based Merchandising Description | Description for the Merchandising Code: M (Modular) indicates that the item is modular driven, sent to stores based upon modular traits and item traits. I (Item) indicates that the item is item driven, sent to stores based upon item traits and classes. H (Hold) indicates that the item is on hold, not going to any stores until the item is traited or the UPC of the item is put on a modular. P (Pend) indicates that the item is in pending status. The UPC of the item was Modular driven and then taken off the MBM modular. It will remain in pending status until the item is traited and updated to item driven, or the UPC of the item is put on another MBM modular. | Item Attributes | - | Available | 2026.4.2 Release |
| item_status_chng_dt | Item Status Change Date | This is the date the item’s status changed. | Item Attributes | - | Available | 2026.4.2 Release |
| item_cost_amt | Item Cost Amount | This is an item cost calculated as Warehouse Pack Unit Cost / Warehouse Pack Qty. | Item Attributes | - | Available | 2026.4.2 Release |
| acct_nbr | Account Number | Account Number is the General Ledger account number that the items are booked to. Usually, an item is booked to its Accounting Dept Number which is translated to an account number (8xx where xx is the accounting department number). | Item Attributes | - | Available | 2026.4.2 Release |
| acct_nbr_type_cd | Account Number Type Code | Denotes what type of journal account the account number represents. Examples: Department sales account 3 followed by department number, Other Income account, Service Income account, Consumable account. Consumable Account Number is the General Ledger Account Number that consumable items (supplies) may be charged to. Usually, an item is booked to its Accounting Dept Number which is translated to an account number 8xx (where xx is the Accounting Department). Entering the Consumable Account Number at item creation will allow a more detailed breakout of expenses while eliminating the need for a manual MTR (Merchandise Transfer Request) at the store. Other Income Account Number is the General Ledger Account Number that may be used for crediting sales for items that are considered "Other Income" such as gift cards, saving stamps, and scratch off lottery tickets. Service Income Account Number is the General Ledger Account Number that may be used for Services. For example, cell phone plans. | Item Attributes | - | Available | 2026.4.2 Release |
| acct_nbr_type_desc | Account Number Type Description | Description for the type of journal account the account number represents. Examples: Department sales account 3 followed by department number, Other Income account, Service Income account, Consumable account. Consumable Account Number is the General Ledger Account Number that consumable items (supplies) may be charged to. Usually, an item is booked to its Accounting Dept Number which is translated to an account number 8xx (where xx is the Accounting Department). Entering the Consumable Account Number at item creation will allow a more detailed breakout of expenses while eliminating the need for a manual MTR (Merchandise Transfer Request) at the store. Other Income Account Number is the General Ledger Account Number that may be used for crediting sales for items that are considered "Other Income" such as gift cards, saving stamps, and scratch off lottery tickets. Service Income Account Number is the General Ledger Account Number that may be used for Services. For example, cell phone plans. | Item Attributes | - | Available | 2026.4.2 Release |
| actv_cd | Activity Code | The accounting Dept Number which is translated to an account number 8xx (where xx is the Accounting Department). Entering the Consumable Account Number at item creation will allow a more detailed breakout of expenses while eliminating the need for a manual MTR (Merchandise Transfer Request) at the store. | Item Attributes | - | Available | 2026.4.2 Release |
| actv_desc | Activity Description | Description for the accounting Dept Number which is translated to an account number 8xx (where xx is the Accounting Department). Entering the Consumable Account Number at item creation will allow a more detailed breakout of expenses while eliminating the need for a manual MTR (Merchandise Transfer Request) at the store. | Item Attributes | - | Available | 2026.4.2 Release |
| alcohol_pct | Alcohol Percentage | The percentage of alcohol in an item.
| Item Attributes | - | Available | 2026.4.2 Release |
| alt_chnl_src_ind | Alternate Channel Source Indicator | An Alternate Channel Sourcing (ACS) is an item acquired from a third-party source other than the brand owner such as from established dealers, distributors, or suppliers who do not have a direct relationship with the brand owner in accordance with standard business practices in the retail and warehouse club industry. The ACS will default to ‘No’ if no value is selected in the application. | Item Attributes | - | Available | 2026.4.2 Release |
| backrm_scale_ind | Backroom Scale Indicator | This indicates that an item is weighed in the backroom (Deli, Bakery, Produce and Meat). Note: This is used at the stores to determine which items must have pricing data sent from the SMART system to the scales that generate barcode labels that include the price. | Item Attributes | - | Available | 2026.4.2 Release |
| canned_order_ind | Canned Order Indicator | This indicates that a specified item quantity, varying by store department size, will be sent to all new store openings. Note: The item must still be valid for a new store. This can also be used in disaster recovery to restock a store. | Item Attributes | - | Available | 2026.4.2 Release |
| case_upc_fmt_cd | Case UPC Format Code | The Universal Product Code format code. Examples: 1 - EAN-8 2 - UPC-12 3 - EAN-13 4 - UPC-13 5 - EAN-14" | Item Attributes | - | Available | 2026.4.2 Release |
| case_upc_fmt_desc | Case UPC Format Description | The textual description of the UPC format code. Examples: 1 - EAN-8 2 - UPC-12 3 - EAN-13 4 - UPC-13 5 - EAN-14" | Item Attributes | - | Available | 2026.4.2 Release |
| catch_wt_ind | Catch Weight Indicator | This is used for variable weight merchandise. “Y” indicates that the store is charged for the actual weight of the merchandise. “N” indicates that the store is charged for the average weight of the merchandise. | Item Attributes | - | Available | 2026.4.2 Release |
| cnsumable_div_nbr | Consumable Division Number | The consumable division number of the item. In Wal-Mart, U.S., Division 1, consumable items (supplies) are created in Division 1 and charged to Division 1. In ASDA supplies are created in Division 68 and charged to the division that they are used in: CONSUMABLE DIVISION NBR. If multiple divisions use this item it will be charged to Division 68. | Item Attributes | - | Available | 2026.4.2 Release |
| cntrl_substance_ind | Controlled Substance Indicator | Indicates if an item is made up of a controlled substance. A controlled substance is a drug or chemical whose manufacture, possession and use are regulated by a government. For example, this may include prescription medications and precursor chemicals used for the production of illegal drugs. | Item Attributes | - | Available | 2026.4.2 Release |
| commodity_id | Commodity ID | This is a number that uniquely identifies a perishable good transported by Walmart. Examples include Apples, Melons, Nuts, Floral, Leafy Greens, etc. | Item Attributes | - | Available | 2026.4.2 Release |
| convey_ind | Conveyable Indicator | This indicates (Y/N) if the warehouse pack of an item may be put on a conveyor in the warehouse. | Item Attributes | - | Available | 2026.4.2 Release |
| crush_fctr_cd | Crush Factor Code | This is a one-character alpha code that represents how prone an item is to being crushed. Examples: 1 - strongest case (stack on bottom) , 2 - less strong (do not stack on bottom) , 3 - least strong (stack on top) | Item Attributes | - | Available | 2026.4.2 Release |
| crush_fctr_desc | Crush Factor Description | Description for the a one-character alpha code that represents how prone an item is to being crushed. Examples: 1 - strongest case (stack on bottom) , 2 - less strong (do not stack on bottom) , 3 - least strong (stack on top) | Item Attributes | - | Available | 2026.4.2 Release |
| dc_dea_rpt_ind | DC Drug Enforcement Agency Indicator | Indicates if this item needs to be reported to the Drug Enforcement Agency (DEA) when received at the DC. | Item Attributes | - | Available | 2026.4.2 Release |
| dest_cd | Grocery Item Destination Code | This indicates where the item is destined to, either a Walmart, a Supercenter, or Both. 0 - Walmart Only, 1 - Supercenter Only, 2 - Walmart and Supercenter. Note: This is matched to the store file to determine the type of store. It is used in the Item File Cut process for new and relocated stores. | Item Attributes | - | Available | 2026.4.2 Release |
| dest_desc | Grocery Item Destination Description | Description for the code that indicates where the item is destined to, either a Walmart, a Supercenter, or Both. 0 - Walmart Only, 1 - Supercenter Only, 2 - Walmart and Supercenter. Note: This is matched to the store file to determine the type of store. It is used in the Item File Cut process for new and relocated stores. | Item Attributes | - | Available | 2026.4.2 Release |
| diet_type_cd | Diet Type Code | This represents a food item that is within a particular diet. Example: Vegetarian or Low Fat | Item Attributes | - | Available | 2026.4.2 Release |
| diet_type_desc | Diet Type Description | Description for a food item that is within a particular diet. Example: Vegetarian or Low Fat | Item Attributes | - | Available | 2026.4.2 Release |
| assoc_disc_ind | Associate Discount Indicator | Indicates if an associate will receive a discount at the register when purchasing an item. Will default to Y or N based on the department and fineline of the item. | Item Attributes | - | Available | 2026.4.2 Release |
| fhs_dc_slot_cd | Fire Health and Safety Distribution Center Slot | The Fire Health and Safety Distribution Center Slot code. Example: 1 - storage under baffles, 2 - aerosol room - if possible, 3 - aerosol room - mandatory. | Item Attributes | - | Available | 2026.4.2 Release |
| fhs_dc_slot_desc | Fire Health and Safety Distribution Center Description | Textual description for fire health and safety distribution center slot. Example: 1 - storage under baffles, 2 - aerosol room - if possible, 3 - aerosol room - mandatory | Item Attributes | - | Available | 2026.4.2 Release |
| fsa_ind | FSA Indicator | Indicates that the item is valid for flexible spending accounts. These are the individual health savings accounts that are governed for use by the IRS. | Item Attributes | - | Available | 2026.4.2 Release |
| gift_card_face_ amt | Gift Card Face Amount | Face value monetary amount (excluding fees) of a gift card. | Item Attributes | - | Available | 2026.4.2 Release |
| gift_card_fee_amt | Gift Card Fee Amount | The monetary fee charged for a gift card. | Item Attributes | - | Available | 2026.4.2 Release |
| gift_card_fee_pct | Gift Card Fee Percentage | The percentage charged as a fee for a gift card. | Item Attributes | - | Available | 2026.4.2 Release |
| gift_card_type_cd | Gift Card Type Code | The type of the gift card. Examples: 1 -FIXED, 2 -VARIABLE | Item Attributes | - | Available | 2026.4.2 Release |
| gift_card_type_desc | Gift Card Type Description | Textual description of the gift card type.
| Item Attributes | - | Available | 2026.4.2 Release |
| ideal_tempr_hi _qty | Ideal Temperature HI Qty | The highest ideal temperature for this merchandise. | Item Attributes | - | Available | 2026.4.2 Release |
| ideal_tempr_low_qty | Ideal Temperature LOW Qty | The lowest ideal temperature for this merchandise. | Item Attributes | - | Available | 2026.4.2 Release |
| infrm_reord_type_cd | Inforem Reorder Type Code | Inforem is an application that recommends order quantities of staple stock merchandise for selected vendors. The Item Inforem Reorder Type is a code that tells the Inforem application how to process this item. The code is set at the vendor level and then updates all items for that vendor. Valid codes are: I (Independent): order quantity for each item is derived independently, J (Allocation): order quantity for an item is initially derived independently and then adjusted based on all items grouped together to meet order constraints set within the INFOREM product, such as a truck load. | Item Attributes | - | Available | 2026.4.2 Release |
| infrm_reord_type_desc | Inforem Reorder Type Description | Inforem is an application that recommends order quantities of staple stock merchandise for selected vendors. The Item Inforem Reorder Type is a code that tells the Inforem application how to process this item. The code is set at the vendor level and then updates all items for that vendor. Valid codes are: I (Independent): order quantity for each item is derived independently. J (Allocation): order quantity for an item is initially derived independently and then adjusted based on all items grouped together to meet order constraints set within the INFOREM product, such as a truck load. | Item Attributes | - | Available | 2026.4.2 Release |
| item_scannable_ind | Item Scannable Indicator | Indicates items as sold through the Point-of-Sale register. | Item Attributes | - | Available | 2026.4.2 Release |
| item_sync_status_cd | Item Synchronized Status Code | Refers to the Trade Item Sync Status Code which defines the state of the Trade Item being synched from System. The valid values will be Synchronized, Not Synchronized. | Item Attributes | - | Available | 2026.4.2 Release |
| item_sync_status_desc | Item Synchronized Status Description | The textual description of the item sync status | Item Attributes | - | Available | 2026.4.2 Release |
| itemfile_src_nm | Item File Source Name | The source of original update. Examples: MIM, BIF, GOLD, I2. | Item Attributes | - | Available | 2026.4.2 Release |
| last_order_dt | Last Order Date | The latest date the product will be available for the Store, Club or Distribution Center to order the product. | Item Attributes | - | Available | 2026.4.2 Release |
| lic_cd | License Code | This is used to show that the item has a license fee and the franchise for which the fee is for. Examples: Mickey Mouse, Levi’s, Dallas Cowboys, or Winnie the Pooh. | Item Attributes | License Code | Available | 2026.4.2 Release |
| lic_desc | License Description | Description for the code used to show that the item has a license fee and the franchise for which the fee is for. Examples: Mickey Mouse, Levi’s, Dallas Cowboys, or Winnie the Pooh. | Item Attributes | - | Available | 2026.4.2 Release |
| mdse_pgm_id | Merchandise Program ID | A program where merchandise is grouped and displayed in a particular way. This grouping will allow merchandisers to track and measure sales performance. | Item Attributes | Space ID | Available | 2026.4.2 Release |
| mfgr_pre_price _amt | Manufacturer Pre-Price Amount | The selling price printed on the sellable product by the manufacturer. | Item Attributes | - | Available | 2026.4.2 Release |
| mfgr_sugd_rtl_ amt | Manufacturer Suggested Retail Amount | The selling price suggested by the Manufacturer for the product. | Item Attributes | - | Available | 2026.4.2 Release |
| min_price_ind | Minimum Price Indicator | Identifies if an item holds a minimum retail price. | Item Attributes | - | Available | 2026.4.2 Release |
| min_rcvng_days_qty | Minimum Receiving Days | This is the minimum allowable days between the DC receiving date and the Sell By Date. This is used for perishable grocery merchandise. An agreement has been made with the Supplier and the merchandise may be rejected by the DC if there are less than the guaranteed number of days remaining in the life of the product. This is known as Variance Days. | Item Attributes | - | Available | 2026.4.2 Release |
| min_whse_life_qty | Minimum Wholesale Life Quantity | Also known as WAREHOUSE LIFE. The expected life (in days) of the product once it is received at the warehouse. Difference between Warehouse Life and Shelf Life indicates the number of days that the warehouse has to get the merchandise to the store. This is input in the MIM system but it is not used anywhere. This is the number of days that the merchandise is allowed to sit in the warehouse. | Item Attributes | - | Available | 2026.4.2 Release |
| non_mbr_upchrg_ind | NonMember Upcharge Indicator | Indicates if this item will have an upcharge applied when sold to a Non-Member using a one day promotion pass | Item Attributes | - | Available | 2026.4.2 Release |
| osa_supplier_id | OSA Supplier ID | Unique number assigned to each Walmart Vendor. | Item Attributes | - | Available | 2026.4.2 Release |
| pallet_upc_fmt_cd | Pallet UPC Format Code | Identifies which type of UPC format is used for the pallet UPC. Examples:, 1 - EAN-8 , 2 - UPC-12 , 3 - EAN-13 , 4 - UPC-13 , 5 - EAN-14 | Item Attributes | - | Available | 2026.4.2 Release |
| pallet_upc_fmt_desc | Pallet UPC Format Description | Textual description of the UPC format. | Item Attributes | - | Available | 2026.4.2 Release |
| perfm_ratg_cd | Performance Rating Code | The Performance Rating, also known as Order Book Stars, assigns a "star" ranking from 1 to 3 on replenishable merchandise that reflects the desired service level for an item. A higher ranking will bring focus to critical image items. If an item has a performance level of 3, the system will not allow the store to drop it from a modular. A performance level of 0 indicates no rating. | Item Attributes | - | Available | 2026.4.2 Release |
| perfm_ratg_desc | Performance Rating Description | Textual description of the Performance Rating. | Item Attributes | - | Available | 2026.4.2 Release |
| price_comp_qty | Price Comparison Qty | This is where the law requires that the price comparison that is printed on the shelf label follows a legally mandated quantity and unit of measure instead of the quantity and unit of measure that the item is packaged in. The Price Comparison calculation eeds sell_qty, sell_uom_code, price_comp_qty, and price_comp_uom_cd. Example: Item (Flour) - 10 LBS for $1.00 sell_qty: 10, sell_uom_cd: LB, price_comp_qty: 1, price_comp_uom_cd: OZ. The Price Comparison for this item is $.01 per OZ. | Item Attributes | - | Available | 2026.4.2 Release |
| price_comp_uom_cd | Price Comparison UOM Code | The quantity where law requires the price comparison that is printed on the shelf label to comply with a legally mandated quantity and unit of measure, instead of the quantity and unit of measure that the item is packaged in. The Price Comparison calculation needs sell_qty, sell_uom_code, price_comp_qty and price_comp_uom_cd. Example: Item (Flour) - 10 LBS for $1.00 sell_qty: 10 sell_uom_cd: LB price_comp_qty: 1 price_comp_uom_cd: OZ The Price Comparison for this item is $.01 per OZ." | Item Attributes | - | Available | 2026.4.2 Release |
| prime_upc_item_nbr | Prime UPC Item Number | The system assigned item of the prime item_nbr that is the top of the like UPC chain. | Item Attributes | - | Available | 2026.4.2 Release |
| prime_upc_mds_fam_id | Prime UPC MDS Fam ID | The system assigned item of the prime MDS_FAM_ID that is the top of the like UPC chain. | Item Attributes | - | Available | 2026.4.2 Release |
| promo_order_book_cd | Promotion Order Book Code | The projected number of units sold annually. | Item Attributes | Order Book Flag | Available | 2026.4.2 Release |
| promo_order_book_desc | Promotion Order Book Description | Textual description of the promotion order book. | Item Attributes | - | Available | 2026.4.2 Release |
| prmpt_price_ind | Prompt Price Indicator | Prompts the cashier to enter a price for the Item. | Item Attributes | - | Available | 2026.4.2 Release |
| qlty_cntrl_cd | QC Code | This code alerts concerning the quality control issues for an item. The OMS system will place all the POs on hold when this code shows the product is of poor production or a safety hazard. Examples: 1) Safety hazard concerns, 2) Poor Production, 3) Not what was ordered but sellable, 4) Quality of the product not good | Item Attributes | - | Available | 2026.4.2 Release |
| qlty_cntrl_desc | QC Description | Description for the code alerts concerning the quality control issues for an item. The OMS system will place all the POs on hold when this code shows the product is of poor production or a safety hazard. Examples: 1) Safety hazard concerns, 2) Poor Production, 3) Not what was ordered but sellable, 4) Quality of the product not good | Item Attributes | - | Available | 2026.4.2 Release |
| rsrv_mdse_cd | Reserve Merchandise Code | This is used to block orders at the Distribution Center. Examples: 5 - Cuts off all manual store orders but allows POS to replenish. This is used for fine jewelry and guns. 9 - Special orders - POS is shut off. Only buyers or replenishment manager can order. | Item Attributes | - | Available | 2026.4.2 Release |
| rsrv_mdse_desc | Reserve Merchandise Description | Description for the code used to block orders at the Distribution Center. Examples: 5 - Cuts off all manual store orders but allows POS to replenish. This is used for fine jewelry and guns. 9 - Special orders - POS is shut off. Only buyers or replenishment manager can order. | Item Attributes | - | Available | 2026.4.2 Release |
| rsrv_mdse_ind | Reserve MDSE Indicator | Indicates if merchandise has to be saved in warehouse for promotions, etc. | Item Attributes | - | Available | 2026.4.2 Release |
| rtl_incl_vat_ind | Retail VAT Indicator | Indicates if the VAT (Value Added Tax) is included in the retail price that is displayed on the shelf label. Some items will have VAT included on the retail price and others will have the VAT added at the register. This attribute was added specifically for Japan as part of government regulations. | Item Attributes | - | Available | 2026.4.2 Release |
| rtn_resale_ind | Return Resale Indicator | Indicates if the item is sellable after it is returned. Sellable means the product can be returned to the shelf to be resold after the return. Not sellable means the product cannot be returned to the shelf for resale. The Return Sale Indicator is used to prevent a non-authentic item from being returned and resold as the authentic item. | Item Attributes | - | Available | 2026.4.2 Release |
| rfid_ind | RFID Indicator | This item is tagged with a Radio Frequency Identifier (RFID) chip. | Item Attributes | - | Available | 2026.4.2 Release |
| rppc_ind | RPPC Indicator | Indicates if this item is transported using a Rigid Plastic Packaging Container (RPPC). The Rigid Plastic Packaging Container law was enacted as part of an effort to increase the use of recycled plastic and reduce the amount of plastic waste disposed. | Item Attributes | RPPC Indicator | Available | 2026.4.2 Release |
| rtl_notif_store_ind | Retail Notify Store Indicator | Indicates if the store is notified of the retail change. | Item Attributes | - | Available | 2026.4.2 Release |
| secur_tag_ind | Electronic Security Tag Indicator | Indicates whether or not an item is secured via an electronic tag (in our case, an Electronic Author Surveillance tag in the form of an electronic barcode) supplied by the merchandise vendor. If the electronic tag is not deactivated at a point-of-sale register, the tag will be sensed by security equipment at a store entrance/exit and result in an alarm. The use of the electronic tag is intended to reduce theft of merchandise from the stores. This is a "Y"/"N" indicator with a default value of "N" which means a specific item is not electronically secured. | Item Attributes | - | Available | 2026.4.2 Release |
| segregation_cd | Segregation Code | Used to classify items for slotting requirements to allow segregation of merchandise. Example: Human consumable items and should not be slotted below bleach. 1 - General Handling, 2 – HBA Oral, 3 - Chemical, 4 - Contacts Food | Item Attributes | - | Available | 2026.4.2 Release |
| segregation_desc | Segregation Description | Description for the code used to classify items for slotting requirements to allow segregation of merchandise. Example: Human consumable items and should not be slotted below bleach. 1 - General Handling, 2 – HBA Oral, 3 - Chemical, 4 - Contacts Food | Item Attributes | - | Available | 2026.4.2 Release |
| send_store_dt | Send to Store Date | The date the item information is sent to the store. The item will be loaded into the store's item file after the evening batch process. At item creation the Send Store Date must be <= Item Effective Date. The item is sent to the store before it can be reordered. In Hardlines and Grocery the default is Today + 1 to allow review. In Softlines the default is Today (no review is needed since Softline Items are not traited and classed). At item maintenance, for active items, the Send to Store Date can be changed only if the current value is in the future. No past dates are allowed. The Send to Store date is updated when the Item Status has changed from Delete or Inactive to Active. Note: If an item has not reached a send to store date, it will not go into a stores file to scan. It is one of the tools that "can" be used to control an item when necessary. | Item Attributes | - | Available | 2026.4.2 Release |
| shelf_lbl_reqmt_ind | Shelf Label Requirement Indicator | The Shelf Label Requirement Indicator (i.e., Shelf Label Print flag) was used to determine if labels were produced for an item. It is currently being used by Modulars to determine if the item is to be sequenced (associated with a modular). | Item Attributes | Shelf Label Flag | Available | 2026.4.2 Release |
| shelf_rotation_ ind | Shelf Rotation Indicator | Indicates that this item should be stocked at the store with the older merchandise toward the front of the shelf and the newer merchandise toward the back of the shelf. This is used for products that have a "Best if Used by" date. Examples include Milk, Batteries, Medicated Shampoo and Cosmetics. An indicator of 'Y' will cause a symbol to be printed on the Shelf Label notifying the store associates to rotate the merchandise appropriately. | Item Attributes | - | Available | 2026.4.2 Release |
| shelf_life_dys_qty | Shelf Life Days Qty | The minimum number of days that must remain in the life of the product in order to receive it at the store. Note: This data is critical in Grocery distribution centers (DC) for both the receiving and picking functions. | Item Attributes | - | Available | 2026.4.2 Release |
| supplier_disp_ind | Supplier Display Indicator | Indicates if a Supplier Display is available. Y - Supplier display is available, and "SD" will show on the sign. | Item Attributes | - | Available | 2026.4.2 Release |
| tempr_sensitive_ind | Temperature Sensitive Indicator | Used for the ideal and acceptable temperatures of merchandise. Examples: CE - Celsius and FA - Fahrenheit. | Item Attributes | - | Available | 2026.4.2 Release |
| tempr_uom_cd | Temperature UOM Code | Used for the ideal and acceptable temperatures of merchandise. Examples: CE - Celsius and FA - Fahrenheit. | Item Attributes | - | Available | 2026.4.2 Release |
| upc_fmt_cd | UPC Format Code | The Universal Product Code format code. Examples: 1 - EAN-8 2 - UPC-12 3 - EAN-13 4 - UPC-13 5 - EAN-14" | Item Attributes | - | Available | 2026.4.2 Release |
| upc_fmt_desc | UPC Format Description | Textual description of the UPC format. Example: 1 - EAN-8 , 2 - UPC-12 , 3 - EAN-13 , 4 - UPC-13 , 5 - EAN-14 | Item Attributes | - | Available | 2026.4.2 Release |
| var_comp_ind | Variable Comp Indicator | Indicates the item can be competitive comp priced either by the price per weight or the item price. Used on items that are sold by the competition with a different pricing structure than Walmart. | Item Attributes | - | Available | 2026.4.2 Release |
| var_wt_ind | Variable Weight Indicator | Y/N whether item is weighable at front register. This field is mutually exclusive to backroom scale indicator. NOTE: This works in conjunction with the PLU number of an item and is also used for merchandise that is sold by count. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_first_order_dt | Vendor First Order Date | The first date that product may be ordered from the Vendor/Supplier by the Store, Club or Distribution Center. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_first_ship _dt | Vendor First Ship Date | The earliest date the product may be shipped by the Vendor/Supplier to a Store, Club or Distribution Center. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_first_avlbl _dt | Vendor First Available Date | The first day that the Vendor/Supplier will have the merchandise ready for shipping. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_incrm_order_qty | Vendor Incremental Order Qty | Incremental quantity in cases that a warehouse or store can order from a supplier. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_last_ship_dt | Vendor Last Ship Date | The last date that this product can be shipped from the Vendor (Supplier) to a Store, Club or Distribution Center. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_ld_tm_qty | Vendor Lead Time | Designates the number of days it takes to receive the merchandise from an order to the vendor. It is calculated by determining the amount of time it takes to manufacture the goods plus the shipping time to either the Distribution Center or Store. Valid range is 1 to 365. | Item Attributes | - | Available | 2026.4.2 Release |
| vndr_min_order_uom_cd | Vendor Minimum Order UOM | The Unit of Measure of the vendor minimum order quantity. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_net_wt_qty | Warehouse Pack Net Weight Quantity | The weight of the products contained within the warehouse pack. This weight would be for the product only without the packing and container weight. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_upc_fmt_cd | Warehouse Pack UPC Format Code | Textual description of the UPC format codes. | Item Attributes | - | Available | 2026.4.2 Release |
| whpk_upc_fmt_desc | Warehouse Pack UPC Format Description | Textual description of the UPC format codes. Examples: 1 - EAN-8, 2 - UPC-12, 3 - EAN-13, 4 - UPC-13, 5 - EAN-14 | Item Attributes | - | Available | 2026.4.2 Release |
| pvt_lbl_ind | Private Label Indicator | Indicates if the item is from a private label brand. A private label brand is a brand that is owned and sold exclusively by Walmart. Examples include Great Value and Faded Glory. | Item Attributes | - | Available | 2026.4.2 Release |
| gtin | GTIN | The Global Trade Item Number associated with the item. | Item Attributes | - | Available | 2026.4.2 Release |
| buyer_userid | Buyer User ID | The system assigned userid of the Buyer who is responsible for buying most of the items in a Fineline. | Item Attributes | - | Available | 2026.4.2 Release |
| buyer_full_nm | Buyer Full Name | The Name of the Buyer who is responsible for buying most of the items in a Fineline. | Item Attributes | - | Available | 2026.4.2 Release |
| item_share_ind | Item Share Indicator | An indicator used to identify items visible through Retail Link Item Share access. | Item Attributes | - | Available | 2026.4.2 Release |
| item_share_cost_ind | Item Share Cost Indicator | An indicator used to identify item costs visible through Retail Link Item Share access. | Item Attributes | - | Available | 2026.4.2 Release |
| future_vnpk_cost_amt | Future Vendor Pack Cost Amount | The future cost of an item's vendor pack. It tells us what the item will cost from the future effective date. In other words, if the effective date is greater than the current date, the cost of the item at that time is referred to as the Future Vendor Pack Cost Amount. | Item Attributes | | Available | 2026.4.2 Release |
| mfg_cmpny_id | Manufacturer Company ID | A unique idenifier for a company that manufactures merchandise that is sold in a Store or Club. While a purchase order can be manufactured in several factories, this identifies the primary factory for the orders merchandise. | Item Attributes | - | Available | 2026.4.2 Release |
| future_effective_date | Future Effective Date | The date from which upcoming changes to the vendor pack cost amount will take into effect. The effective date is greater than the current date. | Item Attributes | - | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics. It is also known as eCommerce Item Number. | Product Dimensions | - | Available | 2026.4.2 Release |
| prod_nm | Product Name | Name or title of the product that appears on Walmart.com. | Product Dimensions | Item Name | Available | 2026.4.2 Release |
| ecomm_upc_nbr | Universal Product Code Number | The Universal Product Code (UPC) number that is used to create a base item, and the base item is used to group all variant items. If the item is a base, then UPC and Base UPC will be the same. If the item is a variant, then UPC will be different from Base UPC. | Product Dimensions | - | Available | 2026.4.2 Release |
| kit_comp_ind | Part of Bundle (Y/N) | Informs the supplier if an item is also sold as part of a kit. | Product Dimensions | Part of Bundle (Y/N) | Available | 2026.4.2 Release |
| street_dt | Street Date | The date that tells the supplier the promised day from when Walmart must start fulfilling the item. Walmart should have all inventory prior to the street date. | Product Dimensions | Street Date | Available | 2026.4.2 Release |
| cust_ratg_avg_val | Customer Average Rating Value | Customer ratings for the product. Customer ratings are refreshed daily and are on a scale of 1 to 5. If the column is blank, then either the item does not have any ratings or is ineligible for customer ratings. | Product Dimensions | Curr Avg Customer Reviews | Available | 2026.4.2 Release |
| cust_ratg_cnt | Customer Rating Count | From the eComm perspective, this represents the number of customer ratings / reviews. | Product Dimensions | Curr Avg Customer Rating | Available | 2026.4.2 Release |
| elig_put_ind | Put Eligibility Indicator | Used to inform the supplier if we are fulfilling from the store and gives pick up as an option for that item. It suggests a population’s broader reach and flexibility for ordering. Note: '0' means No and '1' means Yes. | Product Dimensions | PUT indicator | Available | 2026.4.2 Release |
| elig_s2h_ind | S2H Eligibility Indicator | Indicates whether or not an item meets the eligibility criteria to have Site to Home (S2H) available as a fulfillment method when customers purchase the item online. Note: '0' means No and '1' means Yes. | Product Dimensions | S2H Eligibility Indicator | Available | 2026.4.2 Release |
| own_repl_ind | Current Replenishment Flag | The replenishable indicator suggests either continuous inventory flow or continuous revenue for the supplier. | Product Dimensions | Curr Replenishable Flag | Available | 2026.4.2 Release |
| cvi_have_it_ind | CVI Have It Indicator | The Customer Value Index (CVI) is a metric used to monitor business performance. It measures the 5 "Its" - the fundamental elements of the eCommerce experience needed to win with customers: Have It, Find It, Display It, Price It, Deliver It. Also, CVI is calculated by multiplying the 5 It scores, meaning that if one score is low, the CVI score will be low. | Product Dimensions | - | Available | 2026.4.2 Release |
| lifecyc_status_nm | Current Display Status | The status of an item that tells suppliers if the item is active on the Walmart website and visible to the customer. An item can be unpublished for multiple reasons and can be Walmart or supplier driven. | Product Dimensions | Curr Display Status | Available | 2026.4.2 Release |
| offr_start_dt | Offer Start Date | The date from when the item is recorded as a sellable offering for eCommerce. The gap between the offer start date and first sales registering for the item gives an estimate of how long it took the item to register sale and if it can be improved. | Product Dimensions | Offer Start Date | Available | 2026.4.2 Release |
| offr_end_dt | Offer End Date | The date by when Walmart must sell the existing On Hand or has to liquidate/return. | Product Dimensions | Offer End Date | Available | 2026.4.2 Release |
| shpg_mthd_chrg_array | Current Lowest Ship Method | The minimum amount that Walmart is charging the customer for shipping. This gives the supplier an estimate of how much total money the customer must pay for that item or Walmart is investing in that item. Free shipping means Walmart is bearing the shipping cost and making a lower margin. All these factors are considered in cost negotiation.
| Product Dimensions | Curr Lowest Ship Method | Available | 2026.4.2 Release |
| price_type_nm | Current Price Display Code | A status code on the item that tells suppliers if the item is active on the Walmart website and visible to the customer. An item can be unpublished on site for multiple reasons and can be Walmart or supplier driven. | Product Dimensions | Curr Price Display Code | Available | 2026.4.2 Release |
| shpg_chrg_amt | Current S2H Ship Charge | The current Ship to Home (S2H) charge is the amount Walmart is charging the customer for shipping for various shipping speeds. It gives the supplier an estimate of how much total money the customer must pay for that item or Walmart is investing in that item. Free shipping means Walmart is bearing the shipping cost and making a lower margin. All these factors are considered in cost negotiation. | Product Dimensions | Curr S2H Ship Charge | Available | 2026.4.2 Release |
| rpt_hrchy_lvl1_id | Walmart Order Department Number | The Walmart order department number that is used to order and replenish items of merchandise. The order department may or may not be the same as the accounting department. Some departments have more than one order department per accounting department.
| Product Dimensions | Acct Dept Nbr | Available | 2026.4.2 Release |
| omni_seg_nbr | Omni Segment Number | This is the number for the Omni segment. Stores - financial segment number and eComm - division number. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_seg_desc | Omni Segment Description | This is the description for the Omni segment. Stores - financial segment name and eComm - division name. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_dept_nbr | Omni Department Number | This is the number for the Omni department. Stores - department number and eComm - super department number. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_dept_desc | Omni Department Description | This is the description for the Omni department. Stores - department name and eComm - super department name. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_nbr | Omni Category Number | The department category number for stores. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_desc | Omni Category Description | The department category group description. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_grp_nbr | Omni Category Group Number | The department category group number. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_grp_desc | Omni Category Group Description | The department category group description. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_subcatg_nbr | Omni Subcategory Number | The department sub-category group number. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_subcatg_desc | Omni Subcategory Description | The department sub-category group description. | Product Dimensions | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Product Dimensions | - | Available | 2026.4.2 Release |
| brand_nm | Brand Name | The brand name of an item supplied by the supplier during the item setup process. It is the name that the product is known, is displayed on the walmart.com website and is a necessary component of the search functionality. It is not the same as the Brand code/name that Walmart Stores use. | Product Dimensions | Brand Name | Available | 2026.4.2 Release |
| prod_cost_own_amt | Product Cost Own Amount | The current product cost from an owned vendor, representing the cost per unit if new inventory were ordered today. The prod_cost_amt field reflects the cost per unit. If the average cost (avg_cost) is close to the supplier-negotiated cost, it indicates that the supplier is able to offer products to Walmart at a competitive rate, which builds confidence in their pricing. | Product Dimensions | | Available | 2026.4.2 Release |
| prod_cost_dsv_amt | Product Cost Direct Store Vendor Amount | The current product cost from a Direct Store Vendor (DSV), representing the cost per unit if an order were placed with the DSV today. The prod_cost_amt field indicates the cost per unit. If the average cost (avg_cost) closely matches the supplier-negotiated cost, it suggests that the supplier is able to offer products to Walmart at a competitive rate, providing confidence in their pricing. | Product Dimensions | | Available | 2026.4.2 Release |
| cmpnt_cntry_of_orign_nm | Components Country of Origin Name | The name of the country where the product originated. | Product Dimensions | Country of Origin | Available | 2026.4.2 Release |
| prmry_shelf_id | Primary Shelf ID | Unique identifier for a shelf in a store. | Product Dimensions | Shelf Number | Available | 2026.4.2 Release |
| aerosol_ind | Aerosol Indicator | This is an indicator which Identifies if an item contains compressed gas or propellant. Used to determine if the item is a Hazardous Waste. | Product Dimensions | Aerosol Indicator | Available | 2026.4.2 Release |
| chem_ind | Chemical Indicator | Identifies if an item is made up of a liquid or powder not intended for human consumption. Used to determine if an Item is a Hazardous Waste if disposed of. | Product Dimensions | Chemical indicator | Available | 2026.4.2 Release |
| cntrl_substance_ind | Controlled Substance Indicator | Indicates if an item is made up of a controlled substance. A controlled substance is a drug or chemical whose manufacture, possession and use are regulated by a government. For example, this may include prescription medications and precursor chemicals used for the production of illegal drugs. | Product Dimensions | Controlled Substance Indicator | Available | 2026.4.2 Release |
| cpsc_cert_ind | CPSC Certificate Indicator | Indicates if the item has been certified by the consumer product safety commission.
| Product Dimensions | CPSC Indicator | Available | 2026.4.2 Release |
| mercury_ind | Mercury Indicator | Mercury Indicator indicated with a value = "Y"(yes) or "N"(no) identifying if the item contains mercury. | Product Dimensions | Mercury Indicator | Available | 2026.4.2 Release |
| paper_wood_ind | Paper Wood Indicator | Paper/Wood Indicator displays a value = "Y"(yes) or "N"(no) identifying if the item or its packaging is made from wood or paper. | Product Dimensions | Paper/Wood Indicator | Available | 2026.4.2 Release |
| pesticide_ind | Pesticide Indicator | Pesticide Indicator displays a value = ""Y""(yes) or ""N""(no) identifying if the item does contain advertising or labeling that the item will kill, repel, or prevent the growth of any living organism. Used to determine if an Item is a Hazardous Waste if disposed.
| Product Dimensions | Pesticide Indicator | Available | 2026.4.2 Release |
| brand_id | Brand ID | The brand identification of a product associated with a brand name and brand family. A brand is a name, term, design, or symbol associated with a product identifiable by the customer. It usually includes a patent or trademark. | Product Dimensions | - | Available | 2026.4.2 Release |
| brand_class_desc | Brand Class Description | Contains the value "Owned" if Walmart owns the brand. This does not necessarily correspond to the private label indicator. A brand is a name, term, design, or symbol associated to a product identifiable by the customer. It usually includes a patent or trademark. | Product Dimensions | - | Available | 2026.4.2 Release |
| battery_ind | Battery Indicator | Indicates if the Item has a battery. Examples: 0 - no battery, 1 - has battery | Product Dimensions | - | Available | 2026.4.2 Release |
| battery_type_cd | Battery Type Code | Identifies the kind of battery power that an item has. Examples: 1-DOES NOT CONTAIN A BATTERY, 7-LITHIUM ION, 12-SILVER, 6-LITHIUM PRIMARY, 4-LEAD ACID, 14-OTHER, 5-LEAD ACID (NON-SPILLABLE), 2-ALKALINE, 3-CARBON ZINC, 15-MULTIPLE TYPES, 10-NICKEL CADMIUM, null, 11-NICKEL METAL HYDRIDE, 9-MERCURY, 8-MAGNESIUM, 13-THERMAL | Product Dimensions | - | Available | 2026.4.2 Release |
| battery_type_desc | Battery Type Description | Describes the kind of battery power that an item has. Example values are: - Draft: A PO is saved but not submitted, - Waiting for Approval: PO line was not within threshold limits and requires another level of approval before the PO can be transmitted for external acknowledgement, - Approved: If PO is submitted and within threshold then PO line will be in "Approved" status, or, if the Approval Field is = Y, - Cancelled: A line(s) on the PO are cancelled, Walmart does not want to receive the goods. Shipping has not yet occurred, - Partial Received: Item was not fully received in Walmart inventory at the first receiving node. Supplier indicated no more shipment on the truck. PO has been checked in and finalized by distribution center (DC) receiving, - Received: All item quantity is received in full and put into Walmart inventory. PO has been checked in and finalized by DC receiving or store receiving, - Settle: PO line has been invoiced and Accounts Payable (AP) system process is complete. No other edits, exceptions or updates can occur. This will allow PO line to go to Settled status. | Product Dimensions | - | Available | 2026.4.2 Release |
| store_nbr | Store Number | The most used store identifier. It is an essential store attribute for reporting. | Store Dimensions | Store Nbr | Available | 2026.4.2 Release |
| store_nm | Store Name | The most used store identifier. It is an essential store attribute for reporting. | Store Dimensions | Store Name | Available | 2026.4.2 Release |
| geo_region_cd | Geographi c Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. | Store Dimensions | - | Available | 2026.4.2 Release |
| store_mgr_nm | Manager Name | The first and last name of the store manager. | Store Dimensions | | Available | 2026.4.2 Release |
| ph_nbr | Phone Number | The main contact phone number for the store. | Store Dimensions | Phone Nbr | Available | 2026.4.2 Release |
| store_type_desc | Store Type Description | The descriptive text of the code identifying the type of physical building. Examples: G - General Office, R - Regular (Walmart), W – Warehouse
| Store Dimensions | Store Type Descr | Available | 2026.4.2 Release |
| op_cmpny_cd | Operationa l Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region.Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Dimensions | - | Available | 2026.4.2 Release |
| fin_open_dt | Financial Open Date | This is the date that the store opened for business. | Store Dimensions | Open Date | Available | 2026.4.2 Release |
| bu_gross_size_qty | Business Gross Size Quantity | Square footage of the store. The size of the physical building(s) of the store in square feet.
| Store Dimensions | - | Available | 2026.4.2 Release |
| expnd_size_qty | Expand Size Quantity | Square footage of a store, after its expansion. Before the expansion date this column contains the store's original square footage. After the expansion date this column displays the store's square footage after the expansion. | Store Dimensions | Expansion Size SQFT | Available | 2026.4.2 Release |
| open_sun_ind | Open Sunday Indicator | Identifies a Walmart store as being open for business on Sunday.
| Store Dimensions | Open Sunday Flag | Available | 2026.4.2 Release |
| bu_comp_cd | Business Company Code | Designates the status of the store as related to comparable sales calculation. | Store Dimensions | - | Available | 2026.4.2 Release |
| bu_comp_desc | Business Company Description | This is a detailed description of the status of the store as related to comparable sales calculation. Sample values: R - Relocated this year, S - Enlarged last year, T- Opened this year | Store Dimensions | - | Available | 2026.4.2 Release |
| fin_rpt_cd | Financial Report Report | This is the code used to allow users to easily identify the type of store. For example: SC is Supercenter, SS is Small Store, etc. | Store Dimensions | Financial | Available | 2026.4.2 Release |
| mdse_maj_zone_nbr | Merchandise Major Zone Number | Merchandise zones that horizontally divide the country. Major zones are numbered in multiples of 10. | Store Dimensions | MDSE Major Zone | Available | 2026.4.2 Release |
| mdse_sub_zone_nbr | Merchandise Sub Zone | A finer, narrower breakdown of the major zones (i.e., 71 and 72 are sub zones of Major Zone 70). | Store Dimensions | MDSE Sub Zone | Available | 2026.4.2 Release |
| subdivision_nbr | Subdivision Number | An identifier for a subdivision. Today a division may have "A" or "B" as the subdivision. | Store Dimensions | - | Available | 2026.4.2 Release |
| subdivision_nm | Subdivision Name | Walmart US segmentation of the business both from an operating business unit and geographical locations. | Store Dimensions | Subdiv | Available | 2026.4.2 Release |
| market_nbr | Market Number | This is the lowest level of the operational alignment. It is a geographical grouping of clubs used by operations to manage. | Store Dimensions | - | Available | 2026.4.2 Release |
| market_nm | Market Name | A market is a grouping of business units in a region for operational or administrative management and oversight. This is the lowest level of alignment. | Store Dimensions | District | Available | 2026.4.2 Release |
| relo_flip_dt | Relocation Flip Date | The date of a store relocation when processing at the existing location flips to the temporary store number. Transactions from the store are sent under the temporary store number. | Store Dimensions | Expansion Open Date | Available | 2026.4.2 Release |
| daylight_sav_tz_ind | Daylight Saving Timezone Indicator | Time Zone that follows daylight savings rules | Store Dimensions | Timezone Daylight Savings | Available | 2026.4.2 Release |
| state_prov_cd | State Province Code | The state or province code in which the Distribution Center(DC) or store resides. | Store Dimensions | Whse State | Available | 2026.4.2 Release |
| lat_dgr | Latitude Degree | This indicates the Latitude degree of the store's physical location. | Store Dimensions | - | Available | 2026.4.2 Release |
| long_dgr | Longitude Degree | This indicates the Longitude degree of the store's physical location. | Store Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line _2 | Street Address Line 2 | The street address of the store location. | Store Dimensions | Street Address | Available | 2026.4.2 Release |
| drv_thru_pharm_ind | Drive Through Pharmacy Indicator | This indicates if the location has a drive thru pharmacy or not. | Store Dimensions | - | Available | 2026.4.2 Release |
| prmry_lang_cd | Primary Language Code | This is the language of the place where the store resides. | Store Dimensions | - | Available | 2026.4.2 Release |
| soft_open_dt | Soft Open Date | The date that the store had their soft opening to test out the system with customers. | Store Dimensions | Dry Run Date | Available | 2026.4.2 Release |
| addr_cntry_cd | Address Country Code | It is the International Organization for Standardization (ISO) standard code for the country. E.g., US, CA, CN, JP, etc. | Store Dimensions | Country | Available | 2026.4.2 Release |
| buo_area_nbr | Business Unit Area Number | Geographic Business Unit is the highest geographical grouping of stores. This is an operational alignment used to manage stores. | Store Dimensions | - | Available | 2026.4.2 Release |
| st_prov_nm | State Province Name | The name of the state or province where the business unit is located. | Store Dimensions | State | Available | 2026.4.2 Release |
| bu_size_uom_cd | Business Size Unit of Measure Code | The unit of measure in which store size is measured. Measured in square feet or square meters. | Store Dimensions | - | Available | 2026.4.2 Release |
| tz_nm | Time Zone Name | The time zone name that the store resides in. E.g., Eastern, Central, Mountain, Pacific Values of codes: EST, CST, MST, PST, CST/MST | Store Dimensions | Time Zone Standard | Available | 2026.4.2 Release |
| op_close_dt | Operation Close Date | The date the store closed for business. | Store Dimensions | - | Available | 2026.4.2 Release |
| temp_close _dt | Temporary Close Date | In the event that a store needs to be closed for a temporary period, this is the date of that closing. This can be for things such as fires, tornados, and flooding. | Store Dimensions | - | Available | 2026.4.2 Release |
| proto_nbr | Prototype Number | The size of a store in a range of square feet or square meters. At the time of implementation, this was needed for reporting on a Supercenter because size_class for Supercenters were all the same. | Store Dimensions | Store Prototype Nbr | Available | 2026.4.2 Release |
| tz_cd | Time Zone Code | The time zone that the store resides in. Values: EST, CST, MST, PST, CST/MST | Store Dimensions | Time Zone Standard | Available | 2026.4.2 Release |
| dst_tz_nm | Daylight Savings Time Zone Name | The daylight savings time zone that the store resides in. E.g., Eastern, Central, Mountain, Pacific | Store Dimensions | Time Zone Daylight Savings | Available | 2026.4.2 Release |
| open_status_cd | Open Status Code | It gives information for opening stores. Values: 0 - scheduled to open, 1 - new, open less than 13 months, 2 - new, open 13 months or more, 3 - scheduled to re-grand open, 4 - old, less than 13 months since re-grand, 5 - old, more than 13 months since re-grand, 6 - scheduled to close, 7 - closed | Store Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line _3 | Street Address Line 3 | The street address of the store location. | Store Dimensions | Street Address | Available | 2026.4.2 Release |
| dst_tz_cd | Daylight Savings Time Zone Code | This is the daylight savings time zone that the store resides in. E.g., EDT, CDT, PDT, etc. | Store Dimensions | Time Zone Daylight Savings | Available | 2026.4.2 Release |
| bu_public_close_tm | Business Unit Public Close Time | This is the time when the business unit (Store, Warehouse, etc.) is closed for the public. | Store Dimensions | - | Available | 2026.4.2 Release |
| fin_close_dt | Close Date | The date the store closed for business. | Store Dimensions | - | Available | 2026.4.2 Release |
| fips_cnty_cd | Federal Information Processing Standard County Code | This is the Federal Information Processing Standard (FIPS) code used to identify the county or county equivalent for this store. County equivalents are Parishes and Boroughs. This number is assigned by the government. | Store Dimensions | - | Available | 2026.4.2 Release |
| store_type_cd | Store Type Code | A code which identifies a type of physical building. Values: 'D' - DOT'S Drug, 'G'- General Office, 'H' - Helen's Crafts, 'M' - Most Outlet, 'R' - Regular (Wal-Mart) 'S' - SAM'S Wholesale Club 'T' - Test or Control 'W - Warehouse 'Y' - WalMart Owned Hypermart 'J' - Joint Owned Hypermart 'U' - SuperCenter, 'X' - International SuperCenter, 'F' - Fuel | Store Dimensions | - | Available | 2026.4.2 Release |
| open_status_desc | Open Status Description | This is the description of the Open Status Code. Values:0 - scheduled to open1 - new, open less than 13 months2 - new, open 13 months or more3 - scheduled to re-grand open4 - old, less than 13 months since re-grand5 - old, more than 13 months since re-grand6 - scheduled to close7 - closed | Store Dimensions | - | Available | 2026.4.2 Release |
| banner_cd | Banner Code | A code which represents the sign or banner on the outside of the store. | Store Dimensions | - | Available | 2026.4.2 Release |
| buo_area_nm | BUO Area Name | Name of the Geographic Business Unit which is the highest geographical grouping of stores. This is an operational alignment used to manage stores. There are three distinctive geographic business units (GBUs) defined for Walmart US: West, South, and North. | Store Dimensions | - | Available | 2026.4.2 Release |
| temp_reopn_dt | Temporary Reopen Date | In the event that a store needs to be closed for a temporary period, this is the date of that closing. This can be for things such as fires, tornados, and flooding. | Store Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line _4 | Street Address Line 4 | The street address of the store location. | Store Dimensions | Street Address | Available | 2026.4.2 Release |
| base_div_nbr | Base Division Number | Base Division Number represents the base division of the item. E.g., 01 - Walmart | Store Dimensions | Subdiv | Available | 2026.4.2 Release |
| banner_desc | Banner Description | The description of the sign or banner on the outside of the store. E.g., Walmart Supercenter
| Store Dimensions | - | Available | 2026.4.2 Release |
| bu_public_open_tm | Business Unit Public Open Time | This is the time when the business unit (Store,Warehouse, etc.) is open for the public. | Store Dimensions | - | Available | 2026.4.2 Release |
| wea_zone_cd | Planting Zone Code | This is a code that indicates planting zones for plants or seeds sold in the Garden Center. This is a standard code that is applied to all stores. | Store Dimensions | - | Available | 2026.4.2 Release |
| grand_open | Grand Open Date | The date the store is officially open for business. | Store Dimensions | Open Date | Available | 2026.4.2 Release |
| open_24_hr_ind | Open 24 HR Indicator | Indicates if the store is open 24 hours. The values should be 1 or 0. 'Y' - Open 24 = 1, 'N' - Not Open 24 = 0 | Store Dimensions | - | Available | 2026.4.2 Release |
| real_estat_proto_cd | Real Estate Prototype Code | This is used by construction to identify the general layout of the store. | Store Dimensions | - | Available | 2026.4.2 Release |
| seg_nbr | Segment Number | The number associated with the segment. A segment is the highest level of alignment for stores and clubs.e.g., 13 - Walmart US | Store Dimensions | - | Available | 2026.4.2 Release |
| cnty_nm | County Name | This is the textual identifier for a county.
| Store Dimensions | Physical County Name | Available | 2026.4.2 Release |
| public_close_dt | Public Close Date | The date the store was closed to the public. | Store Dimensions | - | Available | 2026.4.2 Release |
| seg_nm | Segment Name | The name associated with the segment. A segment is the highest level of alignment for stores and clubs. | Store Dimensions | - | Available | 2026.4.2 Release |
| city_nm | City Name | This is the name of the city in which the Distribution Center/store resides. | Store Dimensions | City | Available | 2026.4.2 Release |
| region_nbr | Region Number | The operational alignment level to which markets and sub_regions report. | Store Dimensions | - | Available | 2026.4.2 Release |
| st_addr_line_1 | Street Address Line 1 | The street address of the store location. | Store Dimensions | Building Address | Available | 2026.4.2 Release |
| region_nm | Region Name | This is the name of the region for reporting. Examples: Region_Nbr 1, 2 Region_Nm ALABAMA FL PANHANDLE, TN, GA – Atlanta | Store Dimensions | - | Available | 2026.4.2 Release |
| postal_cd | Zip Code or Postal Code | An identifier for geographic area for the purpose of delivering mail. | Store Dimensions | Zip Code | Available | 2026.4.2 Release |
| store_nbr | Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Digital Transactability | - | Available | 2026.4.2 Release |
| missing_aisle_not_elig_ind | Missing Aisle Not Eligible Indicator | Indicates that the item is not eligible due to missing aisle location. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| other_rsn_not_pub_ind | Other Reason Not Publish Indicator | Indicates that the item is not published due to other publishing reasons. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| clearance_not_elig_ind | Clearance Not Eligible Indicator | Indicates that the item is not eligible due to clearance. For example, when item has been removed from the mod but is still on the shelf until the item sells out. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| store_capability_not_elig_ind | Store Capability Not Eligible Indicator | Indicates that the item is not eligible for store fulfillment because the store lacks the capability, and a process needs to be developed to make that possible. For example, airing up helium balloons, mixing paint, cutting fabric, etc. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| avlbl_ind | Available Indicator | Indicates whether an Item is available (the store has sufficient on-hands). This is a real-time calculation that determines the sufficiency of item on-hands in a specific store, ensuring the personal shopper will be able to find the purchased quantity on the shelf at time of pick. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Digital Transactability | - | Available | 2026.4.2 Release |
| compliance_not_elig_ind | Compliance Not Eligible Indicator | Indicates that the item is not eligible due to legal regulations/compliance. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| omni_trnsctbl_ind | Omni Transactability Indicator | Indicates if customers can add the item to a cart for purchase through the Walmart App or Website. Omni-transactable items are in the sellable universe and are visible, transactable, eligible, and available. Values are 0 (unavailable) and 1 (available). | Digital Transactability | - | Available | 2026.4.2 Release |
| seasonal_not_elig_ind | Seasonal Not Eligible Indicator | Indicates that the item is not eligible due to seasonal reasons. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| item_elig_ind | Item Eligible Indicator | Indicates whether an item is eligible for pick. Items must pass an eligibility-rules engine that blocks store items not located or that shouldn’t be picked due to legal or compliance reasons. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| rpt_dt | Report Date | This is the Date of Eligibility Snapshot of the transactable data. | Digital Transactability | - | Available | 2026.4.2 Release |
| delta_flag | Delta Flag | The engineering delta flag indicator. This flag is to identify the incremental changes to the data from the previous snapshots. Values of the delta flag can be: -I (Initial data), -U (Updated data), or -D (Deleted data) | Digital Transactability | - | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics. It is also known as eCommerce Item Number. | Digital Transactability | - | Available | 2026.4.2 Release |
| other_rsn_not_elig_ind | Other Reason Not Eligible Indicator | Indicates that the item is not published due to other eligibility reasons. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| item_setup_not_pub_ind | Item Setup Not Published Indicator | Indicates that the item is not published due to an item setup issue. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| prohibited_not_pub_ind | Prohibited Not Published Indicator | Indicates that the item is not published because it is prohibited due to compliance. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| item_pub_ind | Item Publish Indicator | Indicates if an item is published (visible to customers on the website) with all item content, images, shelf assignment, etc. that are needed to successfully create a digital representation of the item. Values are 0 and 1. | Digital Transactability | - | Available | 2026.4.2 Release |
| wm_item_nbr | Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Digital Transactability | - | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Digital Transactability | - | Available | 2026.4.2 Release |
| dt_range_not_pub_ind | Date Range Not Published Indicator | Indicates that the Item is not published because it is outside of the item Start/End date. 0 = Published, 1 = Not Published | Digital Transactability | - | Available | 2026.4.2 Release |
| do_not_disp_not_pub_ind | Do Not Dispose Not Published Indicator | Indicates that the Item is not published because these items should be removed from the sellable universe. | Digital Transactability | - | Available | 2026.4.2 Release |
| missing_dim_not_pub_ind | Missing Dimension Not Published Indicator | Indicates that the Item is not published due to Offer Missing Dimension. | Digital Transactability | - | Available | 2026.4.2 Release |
| invt_reltd_not_pub_ind | Inventory Related Not Published Indicator | Indicates that the Item is not published due to inventory-related issues. | Digital Transactability | - | Available | 2026.4.2 Release |
| no_actv_distr_not_pub_ind | No Active Distributor Not Published Indicator | Indicates that the Item is not published as it has no active distributor listed. | Digital Transactability | - | Available | 2026.4.2 Release |
| force_unpubl_not_pub_ind | Forcibly Unpublished Not Published Indicator | Indicates that the Item is not published due to it being forcibly unpublished. | Digital Transactability | - | Available | 2026.4.2 Release |
| on_hand_unavlbl_score_val | On Hand Unavailable Score Value | Indicates that the item not available due to demand exceeding on hand quantity. | Digital Transactability | - | Available | 2026.4.2 Release |
| rsrv_unavlbl_score_val | Reserve Unavailable Score Value | Indicates that the item is not available due to demand exceeding reserve on hand quantity. | Digital Transactability | - | Available | 2026.4.2 Release |
| nil_pick_unavlbl_score_val | Nil Pick Unavailable Score Value | Indicates that the item is not available because it is blocked due to Nil picks. | Digital Transactability | - | Available | 2026.4.2 Release |
| sales_fcst_unavlbl_score_val | Sales Forecast Unavailable Score Value | The percent of the current day that the item was unavailable to sell due to sales forecast setting ats (available to sale) to zero. | Digital Transactability | - | Available | 2026.4.2 Release |
| wtrmark_buf_unavlbl_score_val | Watermark Buffer Unavailable Score Value | The percent of the current day that the item was unavailable to sell due to watermark setting ats (available to sale) to zero. | Digital Transactability | - | Available | 2026.4.2 Release |
| other_rsn_unavlbl_score_val | Other Reasons Unavailable Score Value | The percent of the current day that the item was unavailable to sell due to undefined cases setting ATS (Available to Sale) equal to zero. | Digital Transactability | - | Available | 2026.4.2 Release |
| ats_score_val | Availability Score Value | The percent of the current day that the item was available to sell. | Digital Transactability | - | Available | 2026.4.2 Release |
| missing_image_not_pub_ind | Missing Image Not Published Indicator | Indicates that the item not published due to missing information, like an item image. | Digital Transactability | - | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics. It is also known as eCommerce Item Number. | eComm Inventory | - | Available | 2026.4.2 Release |
| trbl_qty | Trouble Quantity | Applies to all units that are flagged by Walmart.com or via the DC as being not Available to Sell (due to damages, recalls, quality control issues, etc) and are said to be in the “Trouble” bucket. | eComm Inventory | Curr Trouble Bucket (Owned only) | Available | 2026.4.2 Release |
| rip_qty | Receipt In Progress Quantity | The RIP bucket occurs when a carton/pallet is first scanned into the WMS system and the first induction label is printed until the carton (merchandise) is Available to Sell. [From RIP, inventory could also move to other states like Work in Progress (WIP), Trouble Bucket (TRBL) depending on item requirement]. | eComm Inventory | - | Available | 2026.4.2 Release |
| wip_qty | Work In Progress Quantity | Sometimes a carton is not ready to be put away into an active or reserve location right after being received and requires some additional work to be done. In this case the Work in Progress inventory bucket begins after the carton has been put in a designated work location till the work is completed and the carton is put away in an active or reserve location where it becomes Available to Sell (ATS). | eComm Inventory | - | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | eComm Inventory | - | Available | 2026.4.2 Release |
| rpt_dt | Report Date | This is the Date of Eligibility Snapshot of the transactable data. | eComm Inventory | - | Available | 2026.4.2 Release |
| on_hand_cost_amt | Store On Hand Cost Amount | This is the on hand cost amount that is available for an item at a Fulfillment Center (FC). This amount is in Dollars. | eComm Inventory | | Available | 2026.4.2 Release |
| wpid | Walmart Product ID | A unique identifier for a product in Walmart. It is assigned by Product Genome. Also known as “Walmart UPC”. | eComm Inventory | - | Available | 2026.4.2 Release |
| ship_node_org _cd | Ship Node Organization Code | A unique code for identifying the organization (DC, store) that is shipping the product. | eComm Inventory | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | eComm Inventory | - | Available | 2026.4.2 Release |
| on_hand_rtl_amt | On Hand Retail Amount | This is the on hand cost amount that is available for an item at a Fulfillment Center (FC). This amount is in Dollars. | eComm Inventory | - | Available | 2026.4.2 Release |
| on_hand_unit _qty | On Hand Unit Quantity | This is the number of units available for an item at a Fulfillment Center (FC). | eComm Inventory | Curr On Hand QTY (Owned only), Hist QTY in Stock (DSV only), Curr QTY in Stock (DSV only), Hist On Hand QTY (Owned only) | Available | 2026.4.2 Release |
| delta_flag | Delta Flag | The engineering delta flag indicator. This flag is to identify the incremental changes to the data from the previous snapshots. Values of the delta flag can be: -I (Initial data), -U (Updated data), or -D (Deleted data) | eComm Inventory | - | Available | 2026.4.2 Release |
| hld_qty | Hold Quantity | All units that are flagged as Not Available to Sell that could be in work in progress quantity or could have damages, recalls, quality control issues, etc | eComm Inventory | - | Available | 2026.4.2 Release |
| wm_item_nbr | Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Omni Sales | - | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics. It is also known as eCommerce Item Number. | Omni Sales | - | Available | 2026.4.2 Release |
| svc_chnl_nm | Service Channel | The channel through which the order is fulfilled. If the order is placed online and fulfilled in the store, then it would have one of these values - DELIVERY, PICKUP, or SFS (Ship From Store). If it is not fulfilled in the store then it would have one of these values - S2H (Ship to Home) or S2S (Ship to Store). If the purchase was done in store and fulfilled by the store then it will have BIS (Buy in Store) as a service channel. Please see each channel (DELIVERY, PICKUP, SFS, S2H AND S2S) for more information. | Omni Sales | - | Available | 2026.4.2 Release |
| bus_dt | Business Date | Date when snapshot was taken. | Omni Sales | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Omni Sales | - | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Omni Sales | - | Available | 2026.4.2 Release |
| vendor_nbr | Vendor Number | A unique number identifying the vendor or supplier of this item. It is an essential product attribute for reporting. | Omni Sales | - | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | Name of the supplier. It is an important product attribute for reporting. | Omni Sales | - | Available | 2026.4.2 Release |
| wm_yr_wk_nbr | Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Omni Sales | - | Available | 2026.4.2 Release |
| order_chnl_nm | Order Channel Name | The channel through which the order is placed, or sale is initiated. Examples: Store or eComm. | Omni Sales | - | Available | 2026.4.2 Release |
| auth_based_gmv_amt | AUTH Based GMV Amount | GMV (Gross Merchandise Value) is the actual amount collected from the customers. The revenue collected from the customer for transactions. It's the price of items after deducting savings/discounts, and adding shipping revenue. AUTH GMV is Placed GMV excluding GMV for items cancelled because they didn't pass fraud check. This is the GMV amount based on auth based date. This amount is shown in dollars. Note: For store channels, AUTH Based GMV, AUTH Based Net Sales, Shipped Based GMV, and Shipped Based Net Sales will all have the same value (i.e., the Net Sales amount). Examples: For Store Channels (SFS, Delivery, Pickup & BIS): wm_item_nbr 123456789, svc_chnl_nm BIS, auth_based_gmv_amt 10, auth_based_net_sales_amt 10. For Ecomm Channels (only for MP and Service Sales): m_item_nbr 123456789, svc_chnl_nm S2H, S2S, auth_based_gmv_amt 10. auth_based_net_sales_amt 10. Also see AUTH Based Net Sales | Omni Sales | - | Available | 2026.4.2 Release |
| auth_based_net_sales_amt | AUTH Based Net Sales Amount | This is the revenue recorded financially (sometimes AUTH Based Net Sales is labeled as revenue in reporting). AUTH Based Net Sales is Auth GMV except for MP (Marketplace) and services sales (In Home Services, Warranties etc.) where AUTH Based Net Sales is the commission received by Walmart. AUTH Based Net Sales is what goes on the books as actual revenue. This amount is shown in dollars.If Walmart "subsidizes" Walmart's MP prices to match the Competitor, the subsidy is also deducted from the AUTH Based Net Sales. For example, if the MP item price is $100, Walmart matches the Competitor at $90 and collects a $15 commission. Then, AUTH Based Net Sales would equal $15 (commission) - $10 (subsidy) = in this case, $5. Note: For store channels, AUTH Based GMV, AUTH Based Net Sales, Shipped Based GMV, and Shipped Based Net Sales will all have the same value (i.e., the Net sales amount). Examples: For Store Channels (SFS, Delivery, Pickup & BIS): wm_item_nbr 123456789, svc_chnl_nm BIS, auth_based_gmv_amt 10, auth_based_net_sales_amt 10. For Ecomm Channels (only for MP and Service Sales): wm_item_nbr 123456789, svc_chnl_nm S2H, S2S, auth_based_gmv_amt 10 auth_based_net_sales_amt 10. Also see AUTH Based Net Sales | Omni Sales | - | Available | 2026.4.2 Release |
| auth_based_qty | AUTH Based Item Quantity | The quantity of items placed in an authorized order. It excludes the number of units sold that were cancelled and/or returned. Example: wm_item_nbr 123456789, auth_based_qty 5 | Omni Sales | - | Available | 2026.4.2 Release |
| shpd_based_gmv_amt | Shipped Based GMV Amount | GMV (Gross Merchandise Value) is the actual amount collected from the customers. The revenue collected from the customer for transactions. It's the price of items after deducting savings/discounts, and adding shipping revenue. Shipped GMV is Authorized GMV excluding GMV for items cancelled by the seller or by the customer. This is the GMV amount based on the shipped based date. This amount is in shown in dollars. Note: For store channels (Delivery, Pickup, SFS, BIS), AUTH Based GMV, AUTH Based Net Sales, Shipped Based GMV, and Shipped Based Net Sales will all have the same value (i.e., the Net Sales amount). For Ecomm Channels (S2H , S2S) E.g. wm_item_nbr 123456789, ty_auth_based_gmv_amt 30, ty_shpd_based_gmv_amt 24. Also see AUTH Based GMV Amount | Omni Sales | - | Available | 2026.4.2 Release |
| shpd_based_net_sales_amt | Shipped Based Net Sales Amount | The net sales amount for all orders of an item shipped. Shipped Based Net Sales Amount is AUTH Based Net Sales Amount excluding Net Sales amount for items cancelled by the seller or by the customer. For warranties and in-house services, the Net Sales is Shipped Based GMV except for Product Cost, which essentially is the commission. This amount is shown in dollars. Note: For store channels (Delivery, Pickup, SFS, BIS), Authorized Based GMV, Authrorized Based Net Sales, Shipped Based GMV, and Shipped Based Net Sales will all have the same value (i.e., the Net Sales Amount). For Ecomm Channels (S2H , S2S) E.g. wm_item_nbr 123456789, ty_auth_based_net_sales_amt 50, ty_shpd_based_qty 4, ty_aur 10 | Omni Sales | - | Available | 2026.4.2 Release |
| aur | Average Unit Retail Amount | It is the average unit retail value. This amount is in Dollars. This value is derived by dividing the total sales amount by the total UOM quantity of Units of Measure. | Omni Sales | - | Available | 2026.4.2 Release |
| cost_sales | Cost Sales | Owned, DSV (Drop Ship Vendor) or store product cost net of cancellations. This is for eComm only, store is Null | Omni Sales | - | Available | 2026.4.2 Release |
| cncl_cost | Cancel Cost | Refers to the product cost associated with units that have been cancelled. This cost applies to Owned and DSV (Drop Ship Vendor) products. For store products, the Cancel Cost is recorded as Null (i.e., not applicable or not recorded). | Omni Sales | - | Available | 2026.4.2 Release |
| cntra_cost | Contract Cost | Product cost recouped from vendors (owned or DSV) for returns, refunds or replacements. For Walmart, assumed 100% recovery for returns to return centers. For store this is Null. | Omni Sales | - | Available | 2026.4.2 Release |
| prod_margin | Product Margin | Current year's product margin using GMV (Gross Merchandise Value), (i.e., revenue collected from the customer, net of cancellations and all refunds). This includes replacements where GMV is generally $0 and product cost > $0 (can be shipping charges and refunds on replacements so GMV is not exactly $0). This is used to understand what is collected from customers vs. product costs for sales, including the negative impact of returns/refunds/replacements (and corresponding contra product cost). The product margin is only calculated for owned & DSV sales. This amount is shown in dollars. | Omni Sales | - | Available | 2026.4.2 Release |
| delta_flag | Delta Flag | The engineering delta flag indicator. This flag is to identify the incremental changes to the data from the previous snapshots. Values of the delta flag can be: -I (Initial data), -U (Updated data), or -D (Deleted data) | Omni Sales | - | Available | 2026.4.2 Release |
| wm_item_nbr | Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Store Inventory | Walmart Item Number | Available | 2026.4.2 Release |
| store_nbr | Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Store Inventory | Store Nbr | Available | 2026.4.2 Release |
| bus_dt | Business Date | The authorized, cancelled, or refunded date depending on the event type. Use this report date for authorization-based reporting. | Store Inventory | - | Available | 2026.4.2 Release |
| mds_fam_id | Store Item ID | The 6-, 7-, or 9-character number assigned to an item of merchandise that Walmart buys from a supplier, to sell in the stores. Items that are 9 digits are REACT numbers and are considered Softlines. The first two digits of a 9-digit softline (REACT) item number is the order department, positions 3-4 are the subclass. Items that are 6-7 digits are hardline items. For items that are 6 digits, the first digit is the order department number. For items that are 7 digits, the first two digits are the department number. | Store Inventory | Item Nbr | Available | 2026.4.2 Release |
| vendor_nbr | Vendor Number | A unique number identifying the vendor or supplier of this item. It is an essential product attribute for reporting. | Store Inventory | Vendor Nbr | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | Name of the supplier. It is an important product attribute for reporting. | Store Inventory | Vendor Name | Available | 2026.4.2 Release |
| ty_in_trnst_ qty | Store In Transit Quantity - This Year | The number of units invoiced by the DC to the store but not yet received and finalized. | Store Inventory | Curr Str in Transit Qty | Available | 2026.4.2 Release |
| ty_in_trnst_ rtl_amt | Store In Transit Retail Amount - This Year | The Retail value of the units invoiced by the DC to the store but not yet received and finalized. | Store Inventory | Curr Str in Transit Retail | Available | 2026.4.2 Release |
| ty_in_whse_ qty | Store In Warehouse Quantity - This Year | The number of units received by the DC which are allocated specifically to a store but not yet shipped (invoiced). | Store Inventory | Received QTY at WH (Owned only) | Available | 2026.4.2 Release |
| ty_in_whse_ rtl_amt | Store In Warehouse Retail - This Year | The Retail value of units received by the DC which are allocated specifically to a store but not yet shipped (invoiced). | Store Inventory | Curr Whse Buyer Orders Sell | Available | 2026.4.2 Release |
| ty_on_hand _qty | Store On Hand Quantity - This Year | The quantity of an item which is on hand at this store. | Store Inventory | Curr Str on Hand Qty | Available | 2026.4.2 Release |
| ty_on_hand _rtl_amt | Store On Hand Retail - This Year | The total positive on-hand for that item in Retail Dollars $ | Store Inventory | Curr Str on Hand Retail | Available | 2026.4.2 Release |
| ty_on_order _qty | Store On Order Quantity - This Year | The number of units on a purchase order allocated specifically to the store. | Store Inventory | Curr Str on Order Qty | Available | 2026.4.2 Release |
| ty_on_order _rtl_amt | Store On Order Retail Amount - This Year | The retail value of units on a purchase order allocated specifically to the store | Store Inventory | Curr Str on Order Retail | Available | 2026.4.2 Release |
| ty_pipeline_ qty | Store Pipeline Quantity - This Year | This is a calculation: sum of (On hand Qty + On Order Qty + In Transit Qty + In Warehouse Qty). | Store Inventory | - | Available | 2026.4.2 Release |
| ty_repl_instock_numerator | Replenishment Instock Numerator - This Year | This is the aggregation of when this year’s replenishable indicator = 1. | Store Inventory | Repl Instock % | Available | 2026.4.2 Release |
| ty_repl_instock_denominator | Replenishment Instock Denominator - This Year | This is the indicator for store/item combinations that are eligible for replenishment Instock reporting. ty_repl_instock_denominator(repl_ind) = 1 is the indicator for store item combinations that are eligible to report in stock and the ty_repl_instock_denominator (repl_ind) doesn’t mean the item is replenishable. Additional Information: A store item combination could be eligible for replenishment or restock, but still excluded from Instock reporting for multiple reasons, a few examples of these would include: the item is too new or the store item combination is about to expire. This metric makes sure that vendors don’t get blamed for out of stock issues that are out of their control. | Store Inventory | Repl Instock % | Available | 2026.4.2 Release |
| ty_traited_cnt | Traited Store/Item Count - This year | Store count of all the items with the replenishment status as Active, Inactive and New. Values: 1 - Traited, 0 – Not Traited. Note : The Traited Store/Item Count is aggregated at the item level to get the distinct store count at each item level. | Store Inventory | Curr Traited Store/Item Comb | Available | 2026.4.2 Release |
| ty_net_rcpt _rtl_amt | Net Receipt Retail Amount- This Year | Retail value of the receipt. Gross Receipts $ - Store Return $. | Store Inventory | Net Ship Retail | Available | 2026.4.2 Release |
| ty_net_rcpt_cost_amt | Net Receipt Cost Amount - This Year | The net cost of received goods, calculated as gross receipts cost minus store return cost. | Store Inventory | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Inventory | - | Available | 2026.4.2 Release |
| delta_flag | Delta Flag | The engineering delta flag indicator. This flag is to identify the incremental changes to the data from the previous snapshots. Values of the delta flag can be: -I (Initial data), -U (Updated data), or -D (Deleted data) | Store Inventory | - | Available | 2026.4.2 Release |
| ty_gross_rc pt_qty | Gross Receipt Quantity - This year | The number of sellable units received at the store. These can also be weighable units and can hold decimal values. | Store Inventory | Gross Ship Qty | Available | 2026.4.2 Release |
| ty_net_rcpt _qty | Net Receipt Quantity- This Year | Difference between Ships and Store Returns. Calculated as Gross Receipts # - Store Return #. | Store Inventory | Net Ship Qty | Available | 2026.4.2 Release |
| ty_repl_store_item_cnt | Valid Store Item Count - This Year | Current Year Valid count of Store/Items combinations that are Replenishable items. | Store Inventory | Curr Valid Store/Item Comb | Available | 2026.4.2 Release |
| on_order_cost_amt | Store On Order Cost Amount | The cost amount of units on a purchase order allocated specifically to the store. This amount is shown in dollars. | Store Inventory | | Available | 2026.4.2 Release |
| on_hand_cost_amt | Store On Hand Cost Amount | This is the on hand cost amount that is available for an item at a Fulfillment Center (FC). This amount is in Dollars. | Store Inventory | | Available | 2026.4.2 Release |
| in_whse_cost_amt | Store In Warehouse Cost Amount | The cost amount of units received by the distribution center (DC) which are allocated specifically to a store but not yet shipped (invoiced). This amount is shown in dollars. Note: This metric is AVG(), and not SUM(), for selected time period if pulled at Walmart weekly level. | Store Inventory | | Available | 2026.4.2 Release |
| in_trnst_cost_amt | Store In Transit Cost Amount | This is the cost amount of the items that are invoiced by the distribution center (DC) to the store but not yet received and finalized. This amount is shown in dollars. Note: This metric is AVG(), and not SUM(), for selected time period if pulled at Walmart weekly level. | Store Inventory | | Available | 2026.4.2 Release |
| wm_yr_wk_nbr | Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Store Inventory | Est Unit Turns, Est Retail Turns | Available | 2026.4.2 Release |
| tab_rcv_qty | Tab Receiving Quantity | The number of tab item eaches that has been received at the store on a tab invoice since the last tab date. It is also called the Tab. Additional information: Tab is a type of promotion where Walmart puts a multi-page flyer in the newspaper/digital version (top of specific store’s page in walmart.com/app) that features products to customers. It runs for certain duration. When an item is “put on Tab” there is an increase in demand at the store for that item. To accommodate for that temporary increase in demand, suppliers are often asked to ship in a special shipment of merchandise into the stores (via the distribution centers (DC)) that the store holds in the backroom and can replenish the shelves with as the item sells more quickly. To separate the normal flow of inventory into the store from the inventory marked for the Tab promotion, this field is used. | Store Inventory | Curr Tab On Hand Qty | Available | 2026.4.2 Release |
| max_shelf_qty | Max Shelf Quantity | The maximum number of eaches that can be held in the shelf on the sales floor. | Store Inventory | Max Shelf Qty | Available | 2026.4.2 Release |
| geo_region_ cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Store Inventory | - | Available | 2026.4.2 Release |
| crncy_cd | Currency Code | ISO 4217 ALPHA3 CODE for the identification of currency. Hardcode "USD". | Store Inventory | - | Available | 2026.4.2 Release |
| gross_rcpt_cost_amt | Gross Receipt Cost Amount | This is the cost amount of the receipt at the store. Receipt refers to inventory receivings (inventory received). Receivings/receipts can be from supplier to the distribution center (DC) or from DCs to store. This amount is shown in dollars. | Store Inventory | | Available | 2026.4.2 Release |
| gross_rcpt_ rtl_amt | Gross Receipt Retail Amount | It is the retail value of the receipt at the store. Receipt refers to inventory receivings (inventory received). This amount is shown in dollars. | Store Inventory | - | Available | 2026.4.2 Release |
| trgt_shelf_q ty | Target Shelf Quantity | This is the targeted number of eaches that should be stocked on the shelf. A shelf should be stocked based upon the sales volume. | Store Inventory | TSS Qty | Available | 2026.4.2 Release |
| rtl_price_ev ent_cd | Retail Price Event Code | The event associated with Retail Price Amount. | Store Inventory | - | Available | 2026.4.2 Release |
| store_nbr | Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Store Sales | - | Available | 2026.4.2 Release |
| wm_item_nbr | Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Store Sales | - | Available | 2026.4.2 Release |
| svc_chnl_nm | Service Channel | The channel through which the order is fulfilled. If the order is placed online and fulfilled in the store, then it would have one of these values - DELIVERY, PICKUP, or SFS (Ship From Store). If it is not fulfilled in the store then it would have one of these values - S2H (Ship to Home) or S2S (Ship to Store). If the purchase was done in store and fulfilled by the store then it will have BIS (Buy in Store) as a service channel. Please see each channel (DELIVERY, PICKUP, SFS, S2H AND S2S) for more information. | Store Sales | - | Available | 2026.4.2 Release |
| bus_dt | Business Date | The calendar date per store local time that the register transaction took place. | Store Sales | - | Available | 2026.4.2 Release |
| mds_fam_id | Store Item ID | The 6-, 7-, or 9-character number assigned to an item of merchandise that Walmart buys from a supplier, to sell in the stores. Items that are 9 digits are REACT numbers and are considered Softlines. The first two digits of a 9-digit softline (REACT) item number is the order department, positions 3-4 are the subclass. Items that are 6-7 digits are hardline items. For items that are 6 digits, the first digit is the order department number. For items that are 7 digits, the first two digits are the department number. | Store Sales | - | Available | 2026.4.2 Release |
| rpt_cd | Sales By Type | A unique identifier for the sell status of an item according to the Store's Item File at the time the item was sold. Values: 0 - Regular, 1 - Store Tab, 2 - Company Tab, 3 - New Item, 4 - Competition, 5 - Competition/Store Tab, 6 - Competition/Company Tab, 7 - Rollback, 8 - Clearance, 9 - CVP - Customer Value Product | Store Sales | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region, 1 SAMS-US The operational company Sam’s Club in the US geo-region, 2 WMT The operational company Walmart in the worldwide region, 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region, 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Sales | - | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Store Sales | - | Available | 2026.4.2 Release |
| vendor_nbr | Vendor Number | A unique number identifying the vendor or supplier of this item. It is an essential product attribute for reporting. | Store Sales | - | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | Name of the supplier. It is an important product attribute for reporting. | Store Sales | - | Available | 2026.4.2 Release |
| wm_yr_wk_nbr | Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Store Sales | - | Available | 2026.4.2 Release |
| sales_amt | Sales Amount | The total retail amount charged of each distinct item in a register transaction. This amount is in Dollars. | Store Sales | - | Available | 2026.4.2 Release |
| qty | Quantity | The available on-hand quantity for the particular hour of the day when the snapshot was taken. | Store Sales | - | Available | 2026.4.2 Release |
| aur | Average Unit Retail Amount | It is the average unit retail value. This amount is in Dollars. This value is derived by dividing the total sales amount by the total UOM quantity of Units of Measure. | Store Sales | - | Available | 2026.4.2 Release |
| scan_cnt | Scan Count | Depending on the Service Channel this Scan_cnt will be populated with either: - BIS : Bought in Store. Indicates the number of items scanned at the store's POS point of sale., - Delivery: indicates the number of items ordered on-line and fulfilled via delivery., - Pickup: indicates the number of items ordered online and picked up at store., - SFS: indicates the number of items ordered online and shipped from store. Note that this does not always reflect the number sold of that item because if a cashier uses the register's quantity key to enter the number of a given item being bought and then just scans one of them, scan_cnt will equal 1 on that item. Use unit_qty to get actual number of items sold. | Store Sales | - | Available | 2026.4.2 Release |
| delta_flag | Delta Flag | The engineering delta flag indicator. This flag is to identify the incremental changes to the data from the previous snapshots. Values of the delta flag can be: -I (Initial data), -U (Updated data), or -D (Deleted data) | Store Sales | - | Available | 2026.4.2 Release |
