| dc_nbr | Distribution Center Number | A unique numerical identifier assigned to each Walmart Distribution Center Location. | DC Dimensions | Whse Nbr | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian '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 | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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 | This is 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 | The name of the city where the Distribution Center or store is located. | DC Dimensions | City | Available | 2026.4.2 Release |
| st_addr_line_1 | Street Address Line 1 | 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, PacificValues 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:HypermarketSupermarketMembershipAuctionClick and CollectConvenience with FuelDistributioneCommerce | 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. This is also known as Replenishment Type in ELM system. For example: • 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/MSTNote: Canada has stores that are 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 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 |
| 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 | This is 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 | A Walmart Item Number (WIN) is an internal number assigned to a supplier's item configuration of a GTIN (Global Trade Item Number). It represents how the supplier will sell, ship, and replenish their merchandise at Walmart. Multiple Walmart Item Numbers (WINs) may be associated with a single GTIN to support different agreements or configurations between the supplier and Walmart merchant. The WIN is unique to each item configuration and is used for tracking, ordering, and replenishment within Walmart’s systems. | Item Attributes | Walmart Item Number | Available | 2026.4.2 Release |
| mds_fam_id | Store Item ID | The unique numeric identifier for the item number (supply nbr). | Item Attributes | Item Nbr | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID/ eComm Prod ID | The primary SKU for eCommerce products. It is pack specific (i.e., each pack size will have different identification numbers).It is also known as eCommerce Item Number. Note : As 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 | Item Attributes | Item ID | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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 | The unique, random 6 digit Walmart-generated number assigned to a supplier or vendor. | Item Attributes | Vendor Nbr | Available | 2026.4.2 Release |
| acctg_dept_nbr | Accounting Department Number | This is the department number used for general accounting and the department number that sales and purchased are booked to. | 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 | Name of the L50 level within the Walmart Merchandising Hierarchy. This is below Subcategory and is the lowest level of the hierarchy. It is a store-only hierarchy, not used in ecomm. Category Advisors are permissioned at the Fineline Level.Name of the L50 level within the Walmart Merchandising Hierarchy. This is below Subcategory and is the lowest level of the hierarchy. It is a store-only hierarchy, not used in ecom. Category Advisors are permissioned at the Fineline Level | 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 description of the item attached to a particular Universal Product Code (UPC) and prints on the customers receipt at store level for hardline items. | 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 | The official product name or title used to identify an item in Walmart’s catalog and systems. This field is Item Desc 1 in Item 360 / iSam which are used for item creation. The All Links Item is used to link item configurations together for financial roll up across all channels. | Item Attributes | Prime Item Desc | Available | 2026.4.2 Release |
| all_links_item_nbr | All Links Item Number | Unique numeric identifier created during item setup, it links item configurations (one or multiple Walmart Item Numbers) together for financial roll up across all channels | 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 foundational retail price for an item, before any discounts, markdowns, promotional, or regional pricing. | 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 | The number of units in a warehouse pack shipping unit. This quantity is shown in eaches. | Item Attributes | Warehouse Pack Qty (Owned Only) | Available | 2026.4.2 Release |
| whse_algn_type_desc | Warehouse Alignment Type Description | This 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 BulkAC - AIDCO ConversionAS - AssemblyCI - CircularCW - CollectableDG - Dry GoodDI - Distribution FreightDS - Distribution ShoesGB - BakeryFC - Freezer/CoolerGB - BakeryGC - DairyGD - Dry GroceryGF - Frozen FoodsGM - Meats and SeafoodGP - ProductGV - Private Label and PromotionGY - DeliHA - Hearing AidsHW - HypermartIN - InternationalJW - JewelryMT - MeatOC - Over the CounterOP - Optical LabPD - ProducePH - PharmacySB - Staple Stock BulkSH - Special HypermartSP - Special DivisionsSS - Staple Stock ShoesTD - TiresTS - Tires DistributionWH - WarehouseWP - WPM MerchandiseAP - WPM CENTER, APPAREL NETWORKF0 - GROCERY NETWORK, HVDC Phase IF1 - GROCERY NETWORK, HVDC Phase IIF2 - GROCERY NETWORKF3 - GROCERY NETWORKF4 - GROCERY NETWORKF5 - GROCERY NETWORK, HVDC Phase VIF8 - GROCERY NETWORKF9 - GROCERY NETWORKG0 - SPECIAL REALIGNMENTG1 - SPECIAL REALIGNMENTG2 - SPECIAL REALIGNMENTG3 - SPECIAL REALIGNMENTG4 - SPECIAL REALIGNMENTG5 - SPECIAL REALIGNMENTG6 - SPECIAL REALIGNMENTG7 - SPECIAL REALIGNMENTG8 - SPECIAL REALIGNMENTG9 - SPECIAL REALIGNMENTGZ - GROCERY EMERGENCYPR - SLOW DRY PHASE IIIPX - PRESCRIPTION REPLENISHMENTR0 - REGIONAL NETWORKR1 - REGIONAL NETWORKR2 - REGIONAL NETWORKR3 - REGIONAL NETWORKR4 - REGIONAL NETWORKR5 - REGIONAL NETWORKR6 - REGIONAL NETWORKR7 - REGIONAL NETWORKR8 - REGIONAL NETWORKR9 - REGIONAL NETWORKRX - 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 | Stores = financial segment number and eComm = division number.The unique numeric identifier assigned to each Omni Segment (L5) within the Walmart Merchandising Hierarchy. Used for organizing, tracking, and reporting at the segment level. For stores: the financial segment number For eCommerce (eComm): the division number | Item Attributes | - | Available | 2026.4.2 Release |
| omni_seg_desc | Omni Segment Description | Stores = financial segment name and eComm = division name.The name of the L5 level within the Walmart Merchandising Hierarchy. This is the highest level in the hierarchy and is positioned above the Omni Department (L10). It represents the broadest grouping of merchandise. For Stores = financial segment name For eComm = division name. | Item Attributes | MDSE Segment Description | Available | 2026.4.2 Release |
| omni_dept_nbr | Omni Department Number | Stores = department number and eComm = super department number.The unique numeric identifier assigned to each Omni Department (L10) within the Walmart Merchandising Hierarchy. Used for organizing, tracking, and reporting at the department level. For Stores = department number For eComm = super department number. | Item Attributes | Acct Dept Nbr | Available | 2026.4.2 Release |
| omni_dept_desc | Omni Department Description | Stores = department name and eComm = super department name.The name of the L10 level within the Walmart Merchandising Hierarchy. This level is positioned above the Omni Category Group (L20) and below the Omni Segment (L5). It represents a broad grouping of related merchandise categories. For Stores = department name For 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.The unique numeric identifier assigned to each Omni Category (L30) within the Walmart Merchandising Hierarchy. This is below Category Group and above Subcategory. | Item Attributes | Category Nbr | Available | 2026.4.2 Release |
| omni_catg_desc | Omni Category Description | Name of the L30 level within the Walmart Merchandising Hierarchy. This is below Category Group and above Subcategory. | Item Attributes | Dept Category Description | Available | 2026.4.2 Release |
| omni_catg_grp_nbr | Omni Category Group Number | The department category group number.The unique numeric identifier assigned to each Omni Category Group (L20) within the Walmart Merchandising Hierarchy. Used for reporting, tracking, and organizing merchandise at the group level. | Item Attributes | - | Available | 2026.4.2 Release |
| omni_catg_grp_desc | Omni Category Group Description | The department category group description.The name of the L20 level within the Walmart Merchandising Hierarchy. This level is positioned above the Omni Category (L30) and below the Division level. It groups together related categories for higher-level merchandising organization. | Item Attributes | Dept Category Group Description Subcategory Description | Available | 2026.4.2 Release |
| omni_subcatg_nbr | Omni Subcategory Number | The department sub-category group 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 | Vendor Stock ID (sometimes called Supplier Stock Number or Vendor Stock Number) in Walmart merchandising is the supplier's own internal identifier for a unique item. Often times this can be a model number (e.g. XG-150) or it can be another alphanumeric identifier used internally by the supplier. It is provided by the supplier during item setup and maintenance and can be used for reporting purposes and also oftne times appears on primary and secondary packaging and labels for the product. | Item Attributes | Vendor Stock ID | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | The official name of the supplier or company that provides goods or services to Walmart. It identifies the party in the supply chain that Walmart pays for the goods provided. The vendor name is sourced directly from the supplier during onboarding and is used in Walmart’s systems for contracts, item setup, ordering, and 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. | Item Attributes | Brand Owner Name | Available | 2026.4.2 Release |
| brand_nm | Brand Name | The name provided by the brand owner that is intended to be recognized by the consumer as represented on the product. | 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. | 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. | Item Attributes | Brand Owner ID | Available | 2026.4.2 Release |
| vnpk_cost_amt | 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 |
| 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 dimension 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 (UOM) 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 | Numerical field representing the L50 level within the Walmart Merchandising Hierarchy. This is below Subcategory and is the lowest level of the hierarchy. It is a store-only hierarchy, not used in ecom. Category Advisors are permissioned at the Fineline Level.Numerical field representing the L50 level within the Walmart Merchandising Hierarchy. This is below Subcategory and is the lowest level of the hierarchy. It is a store-only hierarchy, not used in ecom. Category Advisors are permissioned at the Fineline Level | Item Attributes | Fineline Number | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian '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 | It provides details about the department responsible for the financial management of a merchandise ordering group. It describes a collection of related items that are grouped together for accounting and reporting purposes. | 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 BulkAC - AIDCO ConversionAS - AssemblyCI - CircularCW - CollectableDG - Dry GoodDI - Distribution FreightDS - Distribution ShoesGB - BakeryFC - Freezer/CoolerGB - BakeryGC - DairyGD - Dry GroceryGF - Frozen FoodsGM - Meats and SeafoodGP - ProductGV - Private Label and PromotionGY - DeliHA - Hearing AidsHW - HypermartIN - InternationalJW - JewelryMT - MeatOC - Over the CounterOP - Optical LabPD - ProducePH - PharmacySB - Staple Stock BulkSH - Special HypermartSP - Special DivisionsSS - Staple Stock ShoesTD - TiresTS - Tires DistributionWH - WarehouseWP - WPM MerchandiseAP - WPM CENTER, APPAREL NETWORKF0 - GROCERY NETWORK, HVDC Phase IF1 - GROCERY NETWORK, HVDC Phase IIF2 - GROCERY NETWORKF3 - GROCERY NETWORKF4 - GROCERY NETWORKF5 - GROCERY NETWORK, HVDC Phase VIF8 - GROCERY NETWORKF9 - GROCERY NETWORKG0 - SPECIAL REALIGNMENTG1 - SPECIAL REALIGNMENTG2 - SPECIAL REALIGNMENTG3 - SPECIAL REALIGNMENTG4 - SPECIAL REALIGNMENTG5 - SPECIAL REALIGNMENTG6 - SPECIAL REALIGNMENTG7 - SPECIAL REALIGNMENTG8 - SPECIAL REALIGNMENTG9 - SPECIAL REALIGNMENTGZ - GROCERY EMERGENCYPR - SLOW DRY PHASE IIIPX - PRESCRIPTION REPLENISHMENTR0 - REGIONAL NETWORKR1 - REGIONAL NETWORKR2 - REGIONAL NETWORKR3 - REGIONAL NETWORKR4 - REGIONAL NETWORKR5 - REGIONAL NETWORKR6 - REGIONAL NETWORKR7 - REGIONAL NETWORKR8 - REGIONAL NETWORKR9 - REGIONAL NETWORKRX - 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 – eachesFT - feetYD – yardsIN - inchesLB – pounds QT - quartGL - gallonsOZ - ouncesDZ – 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 – eachesFT - feetYD – yardsIN - inchesLB – pounds QT - quartGL - gallonsOZ - ouncesDZ – 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 | 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, also known as the SCC-14 (Shipping Container Code-14), which is a universal code used to identify shipping containers or vendor cases of merchandise. This code is especially important in the grocery sector.It is used by all Distribution Centers (DCs) when receiving merchandise, particularly when an Advance Ship Notice (ASN) is provided. | 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 | Cost amount charged to the store including whse handling, transportation, etc... per unit of the Item. It is calculated as whpk_sell_amt/whpk_qty. | Item Attributes | - | Available | 2026.4.2 Release |
| acct_nbr | Account Number | It is the General Ledger (GL) code used to record financial transactions for specific items. Typically, each item is assigned to an Accounting Department Number, which is then converted into an account number. The format is usually 8xx, where "xx" represents the accounting department number. | Item Attributes | - | Available | 2026.4.2 Release |
| acct_nbr_type_cd | Account Number Type Code | It indicates the category of journal account associated with a specific account number. For example, it can represent: Department Sales Account: Typically formatted as a 3 followed by the department number, used for tracking sales by department. Other Income Account: Used for recording income from sources like gift cards, savings stamps, or lottery tickets. Service Income Account: Used for revenue from services, such as cell phone plans. Consumable Account: The General Ledger Account Number for supplies or consumable items. Normally, items are assigned to their Accounting Department Number, which translates to an account number in the 8xx series (where 'xx' is the department). Specifying the Consumable Account Number during item setup allows for more detailed expense tracking and removes the need for manual Merchandise Transfer Requests (MTRs) at the store level. | Item Attributes | - | Available | 2026.4.2 Release |
| acct_nbr_type_desc | Account Number Type Description | It provides details about the kind of journal account associated with a specific account number. For example, it can represent: Department Sales Account: Identified by a 3 followed by the department number, used to track sales by department. Other Income Account: Used for recording revenue from sources like gift cards, savings stamps, or lottery tickets. Service Income Account: Used for income generated from services, such as cell phone plans. Consumable Account: The General Ledger Account Number assigned to consumable items (supplies). Typically, items are linked to their Accounting Department Number, which is converted to an 8xx account number (where 'xx' is the department). Entering the Consumable Account Number during item setup enables more detailed expense tracking and removes the need for manual Merchandise Transfer Requests (MTRs) at the store. | Item Attributes | - | Available | 2026.4.2 Release |
| actv_cd | Activity Code | An activity code is a Y/N indicator which is determined by whether or not an item has had activity over the last two years. Values: Y = Item has had activity over the last two years.N = No Activity. | Item Attributes | - | Available | 2026.4.2 Release |
| actv_desc | Activity Description | It provides details about the accounting department number, which is translated into an account number in the 8xx series (where 'xx' represents the specific accounting department). By entering the Consumable Account Number during item setup, expenses can be tracked in greater detail, eliminating the need for manual Merchandise Transfer Requests (MTRs) at the store level. | Item Attributes | - | Available | 2026.4.2 Release |
| alcohol_pct | Alcohol Percentage | This is the alcohol percentage of the product. | 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 | Indicates whether an item is weighed in the store's backroom, such as in the Deli, Bakery, Produce, or Meat departments. | 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 | 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 | It shows whether an associate is eligible to receive a discount at the register when buying a specific item. This indicator is automatically set to "Y" (Yes) or "N" (No) depending on the item's department and fineline. | 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 codeExample: 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 baffles2 - aerosol room - if possible3 - 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 -FIXED2 -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 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 |
| 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 | This is used to specify what type of order book this item will be printed on at the store. This is used for replenishable items that need special attention.Valid Promotional Order Book Codes are: e - Fall/Winter/holiday Seasonal f - Seasonal BTS i - Non-POS Replenished Items q - Spring/Summer Seasonal v - Snack Bar Items w - RDS Gun Program y - Dept 99 Basic Orderbook b - Buyers Best h - Just-in-Time Items l - Assembly Conversion Items z - Best of the Best (Sam's Choice Items) \# Indicates we may change name | 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 concerns2) Poor Production3) Not what was ordered but sellable4) 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 concerns2) Poor Production3) Not what was ordered but sellable4) 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 Handling2 – HBA Oral3 - Chemical4 - 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 Handling2 – HBA Oral3 - Chemical4 - 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 | 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 | - | 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 | This is the system assigned unique ID 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 identifier 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. It is pack specific (i.e., each pack size will have different identification numbers).It is also known as eCommerce Item Number. Note : As 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 | 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 | Universal Product Code (UPC) for the Stock Keeping Unit (SKU), if available or applicable | 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 | 1/0 flag denoting whether the SKU is replenishable from owned vendor(s). Replen means the items could be ordered on a regular basis to keep it in-stock. | 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 ItFind ItDisplay ItPrice ItDeliver ItAlso, 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. There are no restrictions on the start date; it could be before or after the offer create timestamp. | 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 | Description of the price type. For Walmart, values are base, clearance, rollback, etc. | 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 | Stores = financial segment number and eComm = division number.The unique numeric identifier assigned to each Omni Segment (L5) within the Walmart Merchandising Hierarchy. Used for organizing, tracking, and reporting at the segment level. For stores: the financial segment number For eCommerce (eComm): the division number | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_seg_desc | Omni Segment Description | Stores = financial segment name and eComm = division name.The name of the L5 level within the Walmart Merchandising Hierarchy. This is the highest level in the hierarchy and is positioned above the Omni Department (L10). It represents the broadest grouping of merchandise. For Stores = financial segment name For eComm = division name. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_dept_nbr | Omni Department Number | Stores = department number and eComm = super department number.The unique numeric identifier assigned to each Omni Department (L10) within the Walmart Merchandising Hierarchy. Used for organizing, tracking, and reporting at the department level. For Stores = department number For eComm = super department number. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_dept_desc | Omni Department Description | Stores = department name and eComm = super department name.The name of the L10 level within the Walmart Merchandising Hierarchy. This level is positioned above the Omni Category Group (L20) and below the Omni Segment (L5). It represents a broad grouping of related merchandise categories. For Stores = department name For eComm = super department name. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_nbr | Omni Category Number | The department category number for stores.The unique numeric identifier assigned to each Omni Category (L30) within the Walmart Merchandising Hierarchy. This is below Category Group and above Subcategory. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_desc | Omni Category Description | Name of the L30 level within the Walmart Merchandising Hierarchy. This is below Category Group and above Subcategory. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_grp_nbr | Omni Category Group Number | The department category group number.The unique numeric identifier assigned to each Omni Category Group (L20) within the Walmart Merchandising Hierarchy. Used for reporting, tracking, and organizing merchandise at the group level. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_catg_grp_desc | Omni Category Group Description | The department category group description.The name of the L20 level within the Walmart Merchandising Hierarchy. This level is positioned above the Omni Category (L30) and below the Division level. It groups together related categories for higher-level merchandising organization. | Product Dimensions | - | Available | 2026.4.2 Release |
| omni_subcatg_nbr | Omni Subcategory Number | The department sub-category group 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. | Product Dimensions | - | 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. | Product Dimensions | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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 name provided by the brand owner that is intended to be recognized by the consumer as represented on the product. | Product Dimensions | Brand Name | Available | 2026.4.2 Release |
| prod_cost_own_amt | Product Cost Own Amount | Current product cost from owned vendor (i.e., if new inventory ordered today)Prod_cost_amt is cost per unit. If avg_cost is close to supplier negotiated cost, then it gives supplier’s confidence they are able to sell products to Walmart at a competitive rate. | Product Dimensions | | Available | 2026.4.2 Release |
| prod_cost_dsv_amt | Product Cost Direct Store Vendor Amount | Current product cost from DSV (i.e., if order dealt to DSV (Direct Store Vendor) today)Prod_cost_amt is cost per unit. If avg_cost is close to supplier negotiated cost, then it gives supplier’s confidence they are able to sell products to Walmart at a competitive rate. | 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 | A unique numeric identifier for the primary description of the product, for example, 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. 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 |
| store_nbr | Store Number | Identifies whether the business unit is a store or DC. | Store Dimensions | Store Nbr | Available | 2026.4.2 Release |
| store_nm | Store Name | The official name assigned to a Walmart store location. It is used in Walmart’s systems and reports to identify and reference a specific store, alongside the store number. Store names are typically descriptive and may include the city or area where the store is located. | Store Dimensions | Store Name | Available | 2026.4.2 Release |
| geo_region_cd | Geographi c Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian 'IN' - India 'JP' - Japan 'K1' - Central America 'K2' - Chile 'K3' - Southern Africa 'MX' - Mexico 'US' - United States 'WW' - World Wide | 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. This is also known as Replenishment Type in ELM system. For example: • 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 | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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. | 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. | Store Dimensions | - | Available | 2026.4.2 Release |
| fin_rpt_cd | Financial Report Report | This is the code that allows 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. | 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, PacificValues 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/MSTNote: Canada has stores that are 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 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 |
| 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 | It is the daylight savings time zone that the store resides in (e.g., EDT, CDT, PDT). | 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 | Refers to the name of the Geographic Business Unit, which is the largest regional grouping of stores for operational management. For Walmart US, there are three main Geographic Business Units (GBUs): 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 | The name of the city where the Distribution Center or store is located. | 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 | Street address of the warehouse 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 Region_Nm: ALABAMA FL PANHANDLE Region_Nbr:2 Region_Nm: GA | Store Dimensions | - | Available | 2026.4.2 Release |
| postal_cd | Zip Code or Postal Code | This is an identifier for geographic area for the purpose of delivering mail. | Store Dimensions | Zip Code | Available | 2026.4.2 Release |
| store_nbr | Store Number | Identifies whether the business unit is a store or DC. | 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 | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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. It is pack specific (i.e., each pack size will have different identification numbers).It is also known as eCommerce Item Number. Note : As 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 | 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 | A Walmart Item Number (WIN) is an internal number assigned to a supplier's item configuration of a GTIN (Global Trade Item Number). It represents how the supplier will sell, ship, and replenish their merchandise at Walmart. Multiple Walmart Item Numbers (WINs) may be associated with a single GTIN to support different agreements or configurations between the supplier and Walmart merchant. The WIN is unique to each item configuration and is used for tracking, ordering, and replenishment within Walmart’s systems. | Digital Transactability | - | Available | 2026.4.2 Release |
| geo_region_cd | Geographic Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian '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 = Published1 = 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. It is pack specific (i.e., each pack size will have different identification numbers).It is also known as eCommerce Item Number. Note : As 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 | 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 which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian '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 | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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 retail amount that is available for a clearance item.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 | A Walmart Item Number (WIN) is an internal number assigned to a supplier's item configuration of a GTIN (Global Trade Item Number). It represents how the supplier will sell, ship, and replenish their merchandise at Walmart. Multiple Walmart Item Numbers (WINs) may be associated with a single GTIN to support different agreements or configurations between the supplier and Walmart merchant. The WIN is unique to each item configuration and is used for tracking, ordering, and replenishment within Walmart’s systems. | Omni Sales | - | Available | 2026.4.2 Release |
| catlg_item_id | Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products. It is pack specific (i.e., each pack size will have different identification numbers).It is also known as eCommerce Item Number. Note : As 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 | 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 | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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 which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian '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 | The unique, random 6 digit Walmart-generated number assigned to a supplier or vendor. | Omni Sales | - | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | The official name of the supplier or company that provides goods or services to Walmart. It identifies the party in the supply chain that Walmart pays for the goods provided. The vendor name is sourced directly from the supplier during onboarding and is used in Walmart’s systems for contracts, item setup, ordering, and 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.The Walmart Year Week Number is a six-digit numeric value that represents the full Walmart merchandising year and week, formatted as YYYYWW. The first four digits indicate the year, and the last two digits indicate the sequential week within that year. International will have same year as US in this column. For example: 200701 (200649 for Jan 1st week even though wmyearnbr 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. 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). This amount is shown in dollars. | 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) = or 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). | 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. | 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 ty_auth_based_gmv_amt ty_shpd_based_gmv_amt 123456789 30 24ty_auth_based_qty ty_shpd_based_qty ty_aur 5 4 6 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 ty_auth_based_net_sales_amt 123456789 50 ty_shpd_based_net_sales_amt ty_auth_based_qty 40 5 ty_shpd_based_qty ty_aur 4 10 | Omni Sales | - | Available | 2026.4.2 Release |
| aur | Average Unit Retail Amount | Average Unit Retail (AUR) is the average retail price per unit sold for an item or group of items. Calculation: AUR = $'s / Units | 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 | A Walmart Item Number (WIN) is an internal number assigned to a supplier's item configuration of a GTIN (Global Trade Item Number). It represents how the supplier will sell, ship, and replenish their merchandise at Walmart. Multiple Walmart Item Numbers (WINs) may be associated with a single GTIN to support different agreements or configurations between the supplier and Walmart merchant. The WIN is unique to each item configuration and is used for tracking, ordering, and replenishment within Walmart’s systems. | Store Inventory | Walmart Item Number | Available | 2026.4.2 Release |
| store_nbr | Store Number | Identifies whether the business unit is a store or DC. | 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 unique numeric identifier for the item number (supply nbr). | Store Inventory | Item Nbr | Available | 2026.4.2 Release |
| vendor_nbr | Vendor Number | The unique, random 6 digit Walmart-generated number assigned to a supplier or vendor. | Store Inventory | Vendor Nbr | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | The official name of the supplier or company that provides goods or services to Walmart. It identifies the party in the supply chain that Walmart pays for the goods provided. The vendor name is sourced directly from the supplier during onboarding and is used in Walmart’s systems for contracts, item setup, ordering, and 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 - Traited0 – 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 | It is the net profit percentage before markup/markdown is applied. It is calculated as the difference between the net cost and net retail value of shipments as a percentage of the total net retail value. | Store Inventory | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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.The Walmart Year Week Number is a six-digit numeric value that represents the full Walmart merchandising year and week, formatted as YYYYWW. The first four digits indicate the year, and the last two digits indicate the sequential week within that year. International will have same year as US in this column. For example: 200701 (200649 for Jan 1st week even though wmyearnbr 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](http://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 |
| store_specific_rtl_amt | Store Specific Retail Amount | The sell price of the item in the store as found on the Store Item Inquiry screen. This amount is shown in dollars.Store_Nbr 1 2Item store_specific_cost_amt store_specific_rtl_amt . 100 600 620 100 650 670 | Store Inventory | Store Specific Retail | Available | 2026.5.0 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 | The value of profit made on products before any price increases (markup) or decreases (markdowns) are applied. It shows how much profit is earned from the difference between what the company paid for the products (cost) and what the products are worth at their original selling price (retail value). Formula: Gross Initial Margin = (Total Gross Receipt Retail Amount - Total Gross Receipt Cost) / Total Gross Receipt Retail Amount. | 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 | Identifies whether the business unit is a store or DC. | Store Sales | - | Available | 2026.4.2 Release |
| wm_item_nbr | Walmart Item Number | A Walmart Item Number (WIN) is an internal number assigned to a supplier's item configuration of a GTIN (Global Trade Item Number). It represents how the supplier will sell, ship, and replenish their merchandise at Walmart. Multiple Walmart Item Numbers (WINs) may be associated with a single GTIN to support different agreements or configurations between the supplier and Walmart merchant. The WIN is unique to each item configuration and is used for tracking, ordering, and replenishment within Walmart’s systems. | 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 unique numeric identifier for the item number (supply nbr). | Store Sales | - | Available | 2026.4.2 Release |
| rpt_cd | Sales By Type | Sales Type Code is 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: REPORT_CODE - REPORT_TYPE_DESC 0 - Regular 1 - Store Tab 2 - Company Tab3 - New Item 4 - Competition 5 - Competition/Store Tab 6 - Competition/Company Tab7 - Rollback 8 - Clearance 9 - CVP - Customer Value Product | Store Sales | - | Available | 2026.4.2 Release |
| op_cmpny_cd | Operational Company Code | Operational Company Code (OP_CMPNY_CD) 0: WMT-US (The operational company Walmart in the US geo-region) 1: SAMS-US(The operational company SAMSClub in the US geo-region) 2: WMT(The operational company Walmart in the WorldWide region) 3: SAMS-MX(The operational company SAMSClub in the MX geo-region) 4: WMT-K1(The operational company Walmart in the K1 (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 which represents an operational geographic region. This can be a country, a group of countries or all countries. Values - 'AR' - Argentina 'BR' - Brazil 'CA' - Canada 'CN' - China 'GB' - Great Britian '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 | The unique, random 6 digit Walmart-generated number assigned to a supplier or vendor. | Store Sales | - | Available | 2026.4.2 Release |
| vendor_nm | Vendor Name | The official name of the supplier or company that provides goods or services to Walmart. It identifies the party in the supply chain that Walmart pays for the goods provided. The vendor name is sourced directly from the supplier during onboarding and is used in Walmart’s systems for contracts, item setup, ordering, and 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.The Walmart Year Week Number is a six-digit numeric value that represents the full Walmart merchandising year and week, formatted as YYYYWW. The first four digits indicate the year, and the last two digits indicate the sequential week within that year. International will have same year as US in this column. For example: 200701 (200649 for Jan 1st week even though wmyearnbr 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. | 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 | Average Unit Retail (AUR) is the average retail price per unit sold for an item or group of items. Calculation: AUR = $'s / Units | Store Sales | - | Available | 2026.4.2 Release |
| scan_cnt | Scan Count | Number of an item physically scanned in a register transaction. 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 |
