PSP Glossary
| Element Business Name | Glossary Definition | Table Name | DSS Element Name | Sensitive Metric | PSP Release |
|---|---|---|---|---|---|
| Calendar Day Alpha Number | A number representing the calendar day of the month (zero padded for correct lexicographical order), as in 01, 02, 03, 04, ..., 31. This value is the same for fiscal and Walmart merchandising years. | Calendar Dimensions | Calendar Day Alpha Number | Available | 25.11.4 November Release |
| Calendar Date | The numeric calendar date. The calendar date is formatted for different types of calendars, such as Walmart merchandising (4/5/4), fiscal, and Gregorian calendar. Note: The 4/5/4 is a retail calendar format that ensures sales comparability between years by dividing the year into months based on 4 weeks – 5 weeks – 4 weeks format. This format ensures the same number of Saturdays and Sundays in comparable months. | Calendar Dimensions | Calendar Date | Available | 25.11.4 November Release |
| Calendar Date End Time | The end-of-day time for the calendar date. This date/time may be formatted for different types of calendars, such as Walmart Merchandising (4/5/4), fiscal, and calendar. Example: 2004-01-01 23:59:59:999999. | Calendar Dimensions | Calendar Date End Time | Available | 25.11.4 November Release |
| Calendar Date Start Time | The beginning-of-day time for the calendar date. This date/time may be formatted for different types of calendars, such as Walmart Merchandising (4/5/4), fiscal, and calendar. Example: 200401-01 00:00:00:000000. | Calendar Dimensions | Calendar Date Start Time | Available | 25.11.4 November Release |
| Calendar Full Year Number | A four-digit number representing the calendar year. This number is not based on the 4/5/4 format. Example: 2007. | Calendar Dimensions | Calendar Full Year Number | Available | 25.11.4 November Release |
| Calendar Half Year Count | A number based on the sequential order of the calendar half years up to the given date. For example, the 2nd half of 2007 would return: CAL_HALF_CNT = 915. This count will be used to calculate the difference between Calendar Half Years. | Calendar Dimensions | Calendar Half Year Count | Available | 25.11.4 November Release |
| Calendar Half Year Number | A numeric value indicating whether the date is in the first half of the year (indicated with a 1) or the second half of the year (indicated with a 2). This number is not based on the 4/5/4 calendar. The first half of the year starts January 1, and the second half of year starts July 1, for all countries. For example, if the month is April the returned value would be: 1. This value is affected by CAL_MONTH_NBR and not WM_YR_WK_NBR/WM_WEEK_NBR. | Calendar Dimensions | Calendar Half Year Number | Available | 25.11.4 November Release |
| Calendar Half Year Name | A name representing the calendar half year, in the country's native language and not based on the 4/5/4 calendar. The first half of the year starts January 1, and the second half of year starts July 1, for all countries. For example, if the month is April the returned calendar name could be: H1, 1st half, or 1° Semestre. | Calendar Dimensions | Calendar Half Year Name | Available | 25.11.4 November Release |
| Calendar Month Abbreviation | The abbreviation of the calendar month, in the country's native language, such as Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec. | Calendar Dimensions | Calendar Month Abbreviation | Available | 25.11.4 November Release |
| Calendar Month Alpha Number | A number representing the calendar month (zero padded for correct lexicographical order), where 01 is always January. For example, if it is April the returned value would be: 04. | Calendar Dimensions | Calendar Month Alpha Number | Available | 25.11.4 November Release |
| Calendar Month Count | A number based on the sequential order of the calendar months up to the given date. For example, December 2007 would return: CAL_MTH_CNT = 1295. This count will be used to calculate the difference between Calendar Months. | Calendar Dimensions | Calendar Month Count | Available | 25.11.4 November Release |
| Calendar Month Description | Calendar full month name for cal_month_nbr in the country's native language. For example, if the calendar month number is 04 the returned month name would be: April. | Calendar Dimensions | Calendar Month Description | Available | 25.11.4 November Release |
| Calendar Month Number | A number representing the calendar month, where 1 is always January. This value is not based on the 4/5/4 retail calendar. For example, if it is April the returned value would be: 4. | Calendar Dimensions | Calendar Month Number | Available | 25.11.4 November Release |
| Calculated Quarter Count | A number based on the sequential order of the calendar quarters up to the given date. For example, Q1 of the year 2007 would return: CAL_QTR_CNT = 428. This count will be used to calculate the difference between Calendar Quarters. | Calendar Dimensions | Calculated Quarter Count | Available | 25.11.4 November Release |
| Calendar Quarter Description | A name representing the calendar quarter, in the country's native language and not based on the 4/5/4 calendar. Example:Q1, Q2, Q3, Q4. | Calendar Dimensions | Calendar Quarter Description | Available | 25.11.4 November Release |
| Calculated Quarter Number | A number indicating the calendar quarter (1, 2, 3, or 4). This value is affected by CAL_MONTH_NBR.,It is not based on the 4/5/4 retail calendar or WM_YR_WK_NBR / WM_WEEK_NBR. | Calendar Dimensions | Calculated Quarter Number | Available | 25.11.4 November Release |
| Calendar Week Count | A number based on the sequential order of the calendar weeks up to the given date. For example, Week 01 of 2007 would return: CAL_WK_CNT = 5583. This count will be used to calculate the difference between Calendar Weeks. | Calendar Dimensions | Calendar Week Count | Available | 25.11.4 November Release |
| Calendar Weekday Abbreviated | An abbreviated calendar day of the week, in the country's native language (such as:Mon, Tue, Wed, etc.). For example, if the day of the week number is 1, the day of the week would be Sunday and the return would be: Sun. | Calendar Dimensions | Calendar Weekday Abbreviated | Available | 25.11.4 November Release |
| Calendar Weekday Number | A number indicating the calendar day of the week, beginning with Sunday (1) and ending with Saturday (7). For example, if the day of the week is Wednesday the return would be: 4. | Calendar Dimensions | Calendar Weekday Number | Available | 25.11.4 November Release |
| Calendar Day of the Week Name | The calendar day of the week name, in the country's native language. Such as: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday. | Calendar Dimensions | Calendar Day of the Week Name | Available | 25.11.4 November Release |
| Calendar Week Number | A number representing the calendar week for this date (as in 1, 2, 3, 12, ... 52, etc.). Week 1 starts on the first day of January. The week may not contain a full 7 days. For example, if it is the first week of February the return would be: 5. | Calendar Dimensions | Calendar Week Number | Available | 25.11.4 November Release |
| Calendar Week Name | The name for the calendar week, in the country's native language (such as: Week 1, Week 2, ...Week 52). Week 1 starts the first day of January. For example, if it is the first week of February the return could be: Week 5. | Calendar Dimensions | Calendar Week Name | Available | 25.11.4 November Release |
| Calendar Year Name | The calendar year name, in the country's native language and not based on the 4/5/4 calendar. Example: Year 2007. | Calendar Dimensions | Calendar Year Name | Available | 25.11.4 November Release |
| Date Description | The full date name in 'Day Name, Month Name plus Date Number, Four-Digit Year' format, in the country's native language. Example: Tuesday, May 10, 2007. The return will state "Unknown Date" for a NULL (unknown) date. | Calendar Dimensions | Date Description | Available | 25.11.4 November Release |
| Day Count | A number based on the sequential order of the calendar days up to the given date. For example, the date 01/01/2007 would return: DAY_CNT = 39084. It will be used to calculate a difference between Calendar Days. | Calendar Dimensions | Day Count | Available | 25.11.4 November Release |
| Fiscal Full Year Number | Four digit Walmart fiscal year which begins on February 1st for US and January 1st for International. Examples: Fiscal Year Ending 2000 ends on January 31, 2000. | Calendar Dimensions | Fiscal Full Year Number | Available | 25.11.4 November Release |
| Fiscal Half Count | A number based on the sequential order of the fiscal half years up to the given date. For example, the 2nd half of 2007 would return: FISCAL_HALF_CNT = 813. It will be used to calculate a difference between Fiscal Half Years. | Calendar Dimensions | Fiscal Half Count | Available | 25.11.4 November Release |
| Fiscal Half Year Number | A number representing the Fiscal Half Year in terms of the Walmart fiscal year. The Walmart fiscal year first half (1) starts February 1 in the US and CA and January 1 other international countries. The Walmart fiscal year second half (2) starts August 1 for US and CA and July 1 for other international countries. This value is affected by FISCAL_MONTH_NBR and not WM_YR_WK_NBR/WM_WEEK_NBR. | Calendar Dimensions | Fiscal Half Year Number | Available | 25.11.4 November Release |
| Fiscal Half Year Name | The fiscal half year name, in the country's native language and not based on the 4/5/4 retail calendar. For example, if the month is April the US name might be: H1, 1st Half, or 1° Semestre. | Calendar Dimensions | Fiscal Half Year Name | Available | 25.11.4 November Release |
| Fiscal Month Abbreviation | An abbreviation for the fiscal month, in the country's native language. Examples: Geo_region_code = US, CA, PR - Jan, Feb, Mar, Apr, May, June, July, Aug, Sept, Oct, Nov, Dec. Geo_region_code = MX - Enero, Febrero, Marzo, etc. | Calendar Dimensions | Fiscal Month Abbreviation | Available | 25.11.4 November Release |
| Fiscal Month Alpha Number | A number representing the fiscal calendar month (zero padded for correct lexicographical order), where 01 is February in the US, CA and PR and January for other international countries. For example, if it is April the US returned value would be: 03. | Calendar Dimensions | Fiscal Month Alpha Number | Available | 25.11.4 November Release |
| Fiscal Month Count | A number based on the sequential order of the fiscal months up to the given date. For example, January 2007 would return: FISCAL_MTH_CNT = 2584. It will be used to calculate a difference between Fiscal Months. | Calendar Dimensions | Fiscal Month Count | Available | 25.11.4 November Release |
| Fiscal Month Number | A number representing the Walmart fiscal month for this date, where 01 is February in the US and CA and January for other international countries. For example, if it is April the US return value would be: 3. | Calendar Dimensions | Fiscal Month Number | Available | 25.11.4 November Release |
| Fiscal Month Name | The Walmart fiscal month name for this date, in the country's native language. Examples: February, March, April, etc. | Calendar Dimensions | Fiscal Month Name | Available | 25.11.4 November Release |
| Fiscal Quarter Count | A number based on the sequential order of the fiscal quarters up to the given date. For example, January 2007 would return:FISCAL_QTR_CNT = 927. It will be used to calculate a difference between Fiscal Quarters. | Calendar Dimensions | Fiscal Quarter Count | Available | 25.11.4 November Release |
| Fiscal Quarter Number | A number representing the fiscal quarter number, in terms of the Walmart fiscal year, which starts in February for US and CA and in January for other international countries. Examples: Feb to April (1), May to July (2), Aug to Oct (3), Nov to Jan (4). | Calendar Dimensions | Fiscal Quarter Number | Available | 25.11.4 November Release |
| Fiscal Quarter Name | The fiscal quarter name, in the country's native language. Example: Q1, Q2, Q3, Q4. | Calendar Dimensions | Fiscal Quarter Name | Available | 25.11.4 November Release |
| Fiscal Year Name | The Walmart fiscal year ending name, in the country's native language. For example, for a fiscal year ending on January 31, 2000, the name could be: FYE 2000. | Calendar Dimensions | Fiscal Year Name | Available | 25.11.4 November Release |
| 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 | Calendar Dimensions | Geographic Region Code | Available | 25.11.4 November Release |
| Julian Date | The date, in the Julian Date Format of YYYYDDD, where DDD is the day count from 1 - 365 (or 366 as needed). For example, March 2, 2001, would show a date of 2001061. | Calendar Dimensions | Julian Date | Available | 25.11.4 November Release |
| Last Year Calendar Date | The current date minus one year. Any discrepancies resulting in the absence of February 29 (a Leap Year) will result in a NULL for that date. Examples: For Leap Year: CAL DT LY CAL DT,2020-02-28 2019-02-28,2020-02-29 NULL,2020-03-01 2019-03-01,For NON-Leap Year:,CAL DT LY CAL DT,2021-02-28 2020-02-28,2021-03-01 2020-03-01 | Calendar Dimensions | Last Year Calendar Date | Available | 25.11.4 November Release |
| Last Year Compare Visit Date | The current date minus approximately one year. This Gregorian date matches to the day of the week (instead of the day number) approximately 365 days ago. For example, if this date is Saturday, February 01, 2022, then the LY_COMP_VISIT_DT would be Saturday, February 02, 2021 (matching the day/week, not the date number). | Calendar Dimensions | Last Year Compare Visit Date | Available | 25.11.4 November Release |
| Last Year Compare Year Week Number | The current year and week number minus one year. Returns the four-digit Walmart year concatenated with the two-digit WM_WEEK_NBR. International will have same year as US in this column (200649 for Jan 1st week even though wm_year_nbr is 2007). Example: 200701. | Calendar Dimensions | Last Year Compare Year Week Number | Available | 25.11.4 November Release |
| Walmart EPOC Half Count | A number based on the sequential order of the Walmart Merchandising half years up to the given date. For example, February 2007 would return: WM_EPOC_HALF_CNT = 2233. It will be used to calculate a difference between Merchandising Half Years. | Calendar Dimensions | Walmart EPOC Half Count | Available | 25.11.4 November Release |
| Walmart Full Year Number | A four-digit number representing the Walmart Merchandising year. This date is based on the 4/5/4 calendar and is affected by WM_WEEK_NBR for the US, CA, and PR. For other international countries, it changes with the Fiscal Year. Example: In the US, February 2000 would return :2000. | Calendar Dimensions | Walmart Full Year Number | Available | 25.11.4 November Release |
| Walmart Half Year Number | A number representing the Walmart Merchandising half year for this date, based on 4/5/4 calendar. This value is affected by WM_MONTH_NBR and not WM_YR_WK_NBR/WM_WEEK_NBR. The Walmart fiscal year first half (1) starts February 1 in the US, CA, and PR and January 1 for other international countries. The Walmart fiscal year second half (2) starts August 1 for US, CA, and PR and July 1 for other international countries. | Calendar Dimensions | Walmart Half Year Number | Available | 25.11.4 November Release |
| Walmart Half Year Name | The Walmart Merchandising half year name, in the country's native language. For example, the name "WM H1" might indicate the first half of the 4/5/4 merchandise year, and the name "WM 2° Semestre" might indicate the second half of the 4/5/4 merchandise year. | Calendar Dimensions | Walmart Half Year Name | Available | 25.11.4 November Release |
| Walmart Month Abbreviation | The abbreviated Walmart Merchandising month, in the country's native language and based on the 4/5/4 calendar. Example: Feb, Mar, Apr, May, June, July, Aug, Sept, Oct, Nov, Dec, Jan. | Calendar Dimensions | Walmart Month Abbreviation | Available | 25.11.4 November Release |
| Walmart Month Alpha Number | A number representing the Walmart Merchandising month (zero padded for correct lexicographical order), based on 4/5/4 calendar, where 01 is February in the US, CA, and PR. For example, if it is April the US returned value would be: 03. | Calendar Dimensions | Walmart Month Alpha Number | Available | 25.11.4 November Release |
| Walmart Month Count | A number based on the sequential order of the Walmart Merchandising months up to the given date. For example, February 2007 would return: WM_MTH_CNT = 2094. It will be used to calculate a difference between Walmart Merchandising months. | Calendar Dimensions | Walmart Month Count | Available | 25.11.4 November Release |
| Walmart Month Number | A number representing the Walmart Merchandising sequential month, based on the fiscal WalMart month. Example:1 - February, 2 - March, 3 - April, 4 - May, 5. | Calendar Dimensions | Walmart Month Number | Available | 25.11.4 November Release |
| Walmart Month Name | The Walmart Merchandising full month name for this date, in the country's native language and based on 4/5/4 calendar. Examples: February - month 1, January - month 12. | Calendar Dimensions | Walmart Month Name | Available | 25.11.4 November Release |
| Walmart Quarter Number | A number representing the Walmart merchandise quarter for this date, based on 4/5/4 calendar. It changes with WM_MONTH_NBR and not WM_YR_WK_NBR/WM_WEEK_NBR. For example, a Quarter 2 date return: 2. | Calendar Dimensions | Walmart Quarter Number | Available | 25.11.4 November Release |
| Walmart Quarter Name | The Walmart Merchandising quarter name for this date, in the country's native language and based on 4/5/4 calendar. Examples:WM Q1, WM Q2, WM Q3, WM Q4. | Calendar Dimensions | Walmart Quarter Name | Available | 25.11.4 November Release |
| Walmart Refer Quarter Count | A number based on the sequential order of the Walmart quarters up to the given date. For example, February 2007 would return: WM_REFER_QTR_CNT = 866. It will be used to calculate a difference between Walmart Quarters. | Calendar Dimensions | Walmart Refer Quarter Count | Available | 25.11.4 November Release |
| Walmart Week Count | A number based on the sequential order of the Walmart weeks up to the given date. For example, February 2007 would return: WM_WK_CNT = 5587. It will be used to calculate a difference between Walmart Weeks. | Calendar Dimensions | Walmart Week Count | Available | 25.11.4 November Release |
| Walmart Weekday Number | A number representing the day of the week, based upon the Walmart week for this date. The WalMart week begins on Saturday. Examples: 1 - Saturday, 2 - Sunday, 3 - Monday, 4 - Tuesday, 5 - Wednesday, 6 - Thursday, 7 - Friday. | Calendar Dimensions | Walmart Weekday Number | Available | 25.11.4 November Release |
| Walmart Week Number | A number representing the Walmart week for this date (as in 1, 2, 3, 12, ... 52, etc.). Week 1 starts on the first day of February. For example, if it is the first week of March the return would be: 5. | Calendar Dimensions | Walmart Week Number | Available | 25.11.4 November Release |
| Walmart Week Name | The name for the Walmart Merchandising week, in the country's native language (such as:Week 1, Week 2, ...Week 52). Week 1 starts the first day of February. For example, if it is the first week of March the name could be: Week 5. | Calendar Dimensions | Walmart Week Name | Available | 25.11.4 November Release |
| Walmart Year Description | The Walmart Merchandising year name for this date, in the country's native language and based on 4/5/4 calendar. Examples: WM Year 2006, WM Year 2007. | Calendar Dimensions | Walmart Year Description | Available | 25.11.4 November Release |
| 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. | Calendar Dimensions | Walmart Year Week Number | Available | 25.11.4 November Release |
| Cancel When Out Date | The date that all of the warehouses are expected to be out of the item merchandise, so the item can then go to a deleted status. | DC Item Measures | - | Available | 25.11.4 November Release |
| 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)" | DC Item Measures | - | Available | 25.11.4 November Release |
| Currency Code | ISO 4217 ALPHA3 CODE for the identification of currency. Hardcode "USD". | DC Item Measures | - | Available | 25.11.4 November Release |
| Distribution Center Number | Distribution Center Number is a number that identifies a distribution center. | DC Item Measures | - | Available | 25.11.4 November Release |
| Geographic Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. | DC Item Measures | - | Available | 25.11.4 November Release |
| Inventory Date | The date to which the inventory quantity metrics apply. | DC Item Measures | - | Available | 25.11.4 November Release |
| Inventory Required Indicator | Indicates if the Inventory is required in the DC. Examples: 1 - Inventory is required in the DC. This is used for replenishable merchandise that is slotted. 0 - Inventory is not required in the DC. This is used for replenishable merchandise that flows through the DC. NULL - non-replenishable items in the DC. | DC Item Measures | - | Available | 25.11.4 November Release |
| On Hand Warehouse Packs in Inventory - Last Year | The current number of Warehouse packs in inventory (on-hand) at this DC. Note: This metric is AVG(), and not SUM(), for selected time period if pulled at Walmart weekly level. | DC Item Measures | - | Available | 25.11.4 November Release |
| Ordered Warehouse Quantity - Last Year | The number of warehouse packs ordered last year. | DC Item Measures | - | Available | 25.11.4 November Release |
| Warehouse Packs Eaches Received - Last Year | Warehouse quantity received, in eaches, last year. | DC Item Measures | - | Available | 25.11.4 November Release |
| Warehouse Packs Shipped to Store - Last Year | Current total of warehouse packs shipped by the DC (distribution center) to stores. DC also considers this as sales last year. | DC Item Measures | - | Available | 25.11.4 November Release |
| Warehouse Packs Staple Stock on Order - Last Year | The total amount of staple stock on order, in warehouse packs last year. | DC Item Measures | - | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note:Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | DC Item Measures | - | Available | 25.11.4 November Release |
| On Hand Warehouse Packs in Inventory - This Year | The current number of Warehouse packs in inventory (on-hand) at this DC. Note:This metric is AVG(), and not SUM(), for selected time period if pulled at Walmart weekly level. | DC Item Measures | - | Available | 25.11.4 November Release |
| Warehouse Packs Eaches Received - This Year | Warehouse quantity received, in eaches, this year. | DC Item Measures | - | Available | 25.11.4 November Release |
| Warehouse Packs Shipped to Store - This Year | Current total of warehouse packs shipped by the DC (distribution center) to stores. DC also considers this as sales this year. | DC Item Measures | - | Available | 25.11.4 November Release |
| Staple Stock Warehouse Pack Cost Amount - This Year | This year's Staple Stock warehouse pack cost of this item on outstanding (not received) purchase orders as of the current inventory date. This amount is shown in dollars ($). Calculated as: ty_ss_order_whpk_qty * whpk_cost_amt. | DC Item Measures | - | Sensitive - Not Category Advisor Available | 25.11.4 November Release |
| Vendor Number | The unique Walmart-generated number assigned to a supplier or vendor. | DC Item Measures | - | Available | 25.11.4 November Release |
| Vendor Name | Name of the supplier. It is an important product attribute for reporting. | DC Item Measures | - | Available | 25.11.4 November Release |
| Vendor Pack Cost Amount | The base cost of the vendor pack case of an item. This does not reflect deals and discounts which are stored separately. This is not the net cost on a Purchase Order. NOTE: The value in this field may or may not reflect the latest actual cost used on a Purchase Order since the cost for any item can be changed on the PO. This amount is shown in dollars. | DC Item Measures | - | Sensitive - Not Category Advisor Available | 25.11.4 November Release |
| Walmart Item Number | Walmart-assigned number to a specific merchandise. It is the number that will be used on any purchase orders because it's vendor specific. | DC Item Measures | - | Available | 25.11.4 November Release |
| 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. | DC Item Measures | - | Available | 25.11.4 November Release |
| Accounting Department Description | The description for the department number used for general accounting. This is the department number that sales and purchased are booked to. Accounting departments can have order departments aligned under, but all the order departments under the Accounting department will be rolled up. | Item Dimensions | Dept Desc | Available | 25.11.4 November Release |
| Accounting Department Number | The department number used for general accounting. This is the department number that sales and purchased are booked to. Accounting departments can have order departments aligned under, but all the order departments under the Accounting department will be rolled up. | Item Dimensions | Acct Dept Nbr | Available | 25.11.4 November Release |
| Activity Code | The accounting Dept Number which is translated to an account number 8xx (where xx is the Accounting Department). Entering the Consumable Account Number at item creation will allow a more detailed breakout of expenses while eliminating the need for a manual MTR (Merchandise Transfer Request) at the store. | Item Dimensions | Activity CD | Available | 25.11.4 November Release |
| Activity Description | Description for the accounting Dept Number which is translated to an account number 8xx (where xx is the Accounting Department). Entering the Consumable Account Number at item creation will allow a more detailed breakout of expenses while eliminating the need for a manual MTR (Merchandise Transfer Request) at the store. | Item Dimensions | Activity CD | Available | 25.11.4 November Release |
| All Links Item Description | Item description for the prime item number that is top of all the item linkage chains. | Item Dimensions | - | Available | 25.11.4 November Release |
| All Links Item Number | The item number that act as an item linkage to simplify certain operational activities or is used for reporting purposes; similar items are linked/ mapped together. For example: In Financial Reporting, All Link Item Number (all_links_item_nbr) is used for Sales Reporting. It doesn't differ between suppliers. The same product that is produced by different suppliers could share the same all_links_item_nbr. Also see:Prime Item Number. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Backroom Scale Indicator | This indicates that an item is weighed in the backroom (Deli, Bakery, Produce and Meat). Note: This is used at the stores to determine which items must have pricing data sent from the SMART system to the scales that generate barcode labels that include the price. | Item Dimensions | Scale Flag | Available | 25.11.4 November Release |
| Base Division Number | Base Division Number represents the base division of the item. E.g. 01 - Walmart | Item Dimensions | Division | Available | 25.11.4 November Release |
| Base Retail UOM Code | The Unit of Measurement that an item is sold in. Valid values include: EA – eaches, FT - feet, YD – yards, IN - inches, LB – pounds, QT - quart, GL - gallons, OZ - ounces, DZ – dozen | Item Dimensions | Uom cd | Available | 25.11.4 November Release |
| Base Retail UOM Description | Description for the Unit of Measurement that an item is sold in. Valid values include: EA – eaches, FT - feet, YD – yards, IN - inches, LB – pounds, QT - quart, GL - gallons, OZ - ounces, DZ – dozen | Item Dimensions | - | Available | 25.11.4 November Release |
| Base Unit Retail Amount | The default selling price of an item and not the actual selling price. | Item Dimensions | Unit Retail,MU %,Hist Book Ordered Retail,Active Ordered Book Retail,Hist Str Ordered Retail,Active Str Ordered Retail,Active Whse Ordered Retail,Active Str Ordered Retail (orig),Active Whse Ordered Retail (orig),Total Str Ordered Retail,Hist Whse Ordered Retail,Total Whse Ordered Retail,Active Book Ordered Retail,Curr Retail | Available | 25.11.4 November Release |
| Brand Family ID | A unique identifier for Brand Family that is used to provide additional grouping of products across product areas. | Item Dimensions | Brand Family ID | Available | 25.11.4 November Release |
| Brand Family Name | The name of a brand family that provides additional grouping of products across product areas | Item Dimensions | Brand Family Name | Available | 25.11.4 November Release |
| Brand ID | A unique numeric identifier for the primary description of the product, for example, a patent or trademark. The brand refers to the largest text found on the front of the pack, in a prominent position but may require some additional information to make it a meaningful and unique identifier. | Item Dimensions | Brand ID | Available | 25.11.4 November Release |
| Brand Name | The brand name of an item supplied by the supplier during the item setup process. It is the name that the product is known, is displayed on the walmart.com website and is a necessary component of the search functionality. It is not the same as the Brand code/name that Walmart Stores use. | Item Dimensions | Brand Desc | Available | 25.11.4 November Release |
| Brand Owner ID | A unique identifier for the company that owns the Brand or Trademark for the product as indicated on the product's packaging. This may also be the Manufacturer, Distiller, Brewer, Distributor, Retailer, or Bottler. | Item Dimensions | Brand Owner ID | Available | 25.11.4 November Release |
| Brand Owner Name | The name of the company that owns the Brand or Trademark for the product as indicated on the product's packaging. This may also be the Manufacturer, Distiller, Brewer, Distributor, Retailer or Bottler. | Item Dimensions | Brand Owner Name | Available | 25.11.4 November Release |
| 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 Dimensions | Buying Region Code | Available | 25.11.4 November Release |
| 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 Dimensions | Buying Region Desc | Available | 25.11.4 November Release |
| Case UPC Number | This is the standardized shipping container code (SCC-14 universal code for shipping containers). It identifies vendor cases of merchandise; used by grocery. This is used for all DC's in receiving merchandise with an Advance Ship Notice (ASN). | Item Dimensions | VNPK UPC | Available | 25.11.4 November Release |
| Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics.,It is also known as eCommerce Item Number. | Item Dimensions | Item ID,Walmart.com Category Nbr | Available | 25.11.4 November Release |
| 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 Dimensions | Cancel When Out Flag | Available | 25.11.4 November Release |
| 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 Dimensions | Controlled Substance Indicator | Available | 25.11.4 November Release |
| 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 Dimensions | Color Desc | Available | 25.11.4 November Release |
| Consumer Item Description | This is the description provided for a consumer item number. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | Report DEA Indicator | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Fineline Description | Grouping of similar items that have the same forecast profile. In the item hierarchy, fineline is the next level beneath sub-category. Not used for DotCom items | Item Dimensions | Fineline Desc,Fineline Description | Available | 25.11.4 November Release |
| Fineline Number | A unique number for a hierarchical grouping of Items. Fineline is the first merchandise grouping directly under Subclass. An item can only be in one Department, Subclass and Fineline. | Item Dimensions | Fineline Number,Fineline,Category Nbr INTL | Available | 25.11.4 November Release |
| Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Item Dimensions | Geo region cd | Available | 25.11.4 November Release |
| 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 Dimensions | Create Date | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Item Cube Unit of Measure Description | This is the Unit of Measure (UOM) description for item length, height, and width. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | Item Desc 2 | Available | 25.11.4 November Release |
| Item Dimension Unit Of Measure Code | The Unit of Measure code for item length, height and width. | Item Dimensions | UOM Code | Available | 25.11.4 November Release |
| Item Dimension Unit Of Measure Description | The Unit of Measure description for item length, height and width. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | Expiration Date | Available | 25.11.4 November Release |
| Item Height Quantity | This is the measured height of the actual item. | Item Dimensions | Item Height | Available | 25.11.4 November Release |
| Item Import Indicator | This indicates the merchandise shipped from an overseas vendor (Item Types 40, 42 and 43). | Item Dimensions | Is Imported Indicator | Available | 25.11.4 November Release |
| 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 Dimensions | Item Length | Available | 25.11.4 November Release |
| 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 Dimensions | Item Desc 1,Prime Item Desc | Available | 25.11.4 November Release |
| Item Order Effective Date | This is the Date that an item becomes orderable at the store. | Item Dimensions | Effective Date | Available | 25.11.4 November Release |
| 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 Dimensions | Replenish Unit ind | Available | 25.11.4 November Release |
| Item Status Code | The status of an item. Valid values are A=Active, I=Inactive, or D=Delete. | Item Dimensions | Item Status | Available | 25.11.4 November Release |
| Item Status Change Date | This is the date the item’s status changed. | Item Dimensions | Status Chg Date | Available | 25.11.4 November Release |
| 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 Dimensions | Item Type Code | Available | 25.11.4 November Release |
| 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 Dimensions | Item Type | Available | 25.11.4 November Release |
| Item Width Quantity | This is the measured width of the actual item. | Item Dimensions | Item Width | Available | 25.11.4 November Release |
| Item Weight Quantity | This represents the measurement of the weight of an item. | Item Dimensions | Item Weight | Available | 25.11.4 November Release |
| 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 Dimensions | License Code | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Store Item ID | The 6-, 7-, or 9-character number assigned to an item of merchandise that Walmart buys from a supplier, to sell in the stores. Items that are 9 digits are REACT numbers and are considered Softlines. The first two digits of a 9-digit softline (REACT) item number is the order department, positions 3-4 are the subclass. Items that are 6-7 digits are hardline items. For items that are 6 digits, the first digit is the order department number. For items that are 7 digits, the first two digits are the department number. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | Curr Item MBM Code | Available | 25.11.4 November Release |
| 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 Dimensions | Curr Item MBM Code | Available | 25.11.4 November Release |
| Never Out Indicator | Indicates if an item is designated for the stores to never be out–of-stock. | Item Dimensions | Never Out Flag | Available | 25.11.4 November Release |
| 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 Dimensions | Obsolete Date,Item End Date | Available | 25.11.4 November Release |
| Omni Category Description | The department category group description. | Item Dimensions | Category Name,Dept Category Description | Available | 25.11.4 November Release |
| Omni Category Group Description | The department category group description. | Item Dimensions | Dept Category Group Description | Available | 25.11.4 November Release |
| Omni Category Group Number | The department category group number. | Item Dimensions | Dept Category Group Description | Available | 25.11.4 November Release |
| Omni Category Number | The department category number for stores. | Item Dimensions | - | Available | 25.11.4 November Release |
| Omni Department Description | This is the description for the Omni department. Stores - department name and eComm - super department name. | Item Dimensions | Department Name | Available | 25.11.4 November Release |
| Omni Department Number | This is the number for the Omni department. Stores - department number and eComm - super department number. | Item Dimensions | Order Dept Nbr | Available | 25.11.4 November Release |
| Omni Segment Description | This is the description for the Omni segment. Stores - financial segment name and eComm - division name. | Item Dimensions | - | Available | 25.11.4 November Release |
| Omni Segment Number | This is the number for the Omni segment. Stores - financial segment number and eComm - division number. | Item Dimensions | - | Available | 25.11.4 November Release |
| Omni Subcategory Description | The department sub-category group description. | Item Dimensions | Sub Category,Dept Subcategory Description | Available | 25.11.4 November Release |
| Omni Subcategory Number | The department sub-category group number. | Item Dimensions | Subcat Nbr,Walmart.com Subcategory Nbr | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | Cubic Order Sizing Factor | Available | 25.11.4 November Release |
| 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 Dimensions | Pallet Hi Qty | Available | 25.11.4 November Release |
| 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 Dimensions | Pallet Ti Qty | Available | 25.11.4 November Release |
| Pallet UPC Number | The standardized shipping container code for pallets. | Item Dimensions | Pallet UPC | Available | 25.11.4 November Release |
| Performance Rating Description | Textual description of the Performance Rating. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | PLU Nbr | Available | 25.11.4 November Release |
| 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 Dimensions | Prime Item Nbr | Available | 25.11.4 November Release |
| Product Description | Internationalized text descriptions of the product. | Item Dimensions | Product Description | Available | 25.11.4 November Release |
| 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 Dimensions | Private Label | Available | 25.11.4 November Release |
| Replenishment 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 Dimensions | Consumer ID | Available | 25.11.4 November Release |
| Replenishment Subtype Code | In other terms: When repl_instock_denominator=1 THEN SUM(repl_instock_numerator)/SUM(repl_instock_denominator) * 100 | Item Dimensions | Item Sub Type | Available | 25.11.4 November Release |
| Replenishment Subtype Description | This determines the Shelf Label design description and informs the store how the product is ordered. | Item Dimensions | Item Sub Type | Available | 25.11.4 November Release |
| 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 Dimensions | Replenish unit ind | Available | 25.11.4 November Release |
| RFID Indicator | This item is tagged with a Radio Frequency Identifier (RFID) chip. | Item Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | RPPC Indicator | Available | 25.11.4 November Release |
| Season Code | The textual description of the season code. Examples: Spring, Summer, Winter, Fall | Item Dimensions | Season Code,PO Season Code | Available | 25.11.4 November Release |
| Season Description | The textual description of the season code. Examples: Spring, Summer, Winter, Fall | Item Dimensions | Season Code | Available | 25.11.4 November Release |
| 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 Dimensions | Season Year | Available | 25.11.4 November Release |
| 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 Dimensions | EAS Source Tag | Available | 25.11.4 November Release |
| 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 Dimensions | UOM Sell Qty,Unit Size | Available | 25.11.4 November Release |
| 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 Dimensions | Unit Size UOM | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | Shelf Label Flag | Available | 25.11.4 November Release |
| 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 Dimensions | Signing Desc | Available | 25.11.4 November Release |
| 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 Dimensions | Size Desc,Prime Size Desc | Available | 25.11.4 November Release |
| Variable Weight Indicator | Y/N whether item is weighable at front register. This field is mutually exclusive to backroom scale indicator. NOTE: This works in conjunction with the PLU number of an item and is also used for merchandise that is sold by count. | Item Dimensions | - | Available | 25.11.4 November Release |
| Vendor Department Number | The department number of the supplier agreement. | Item Dimensions | Vendor Nbr Dept | Available | 25.11.4 November Release |
| Vendor Number | A unique number identifying the vendor or supplier of this item. It is an essential product attribute for reporting. | Item Dimensions | Vendor Nbr | Available | 25.11.4 November Release |
| Vendor Name | Name of the supplier. It is an important product attribute for reporting. | Item Dimensions | Vendor Name,Supplier Name | Available | 25.11.4 November Release |
| Vendor Sequence Number | The ninth digit of a 9-digit vendor number. | Item Dimensions | Vendor Sequence Nbr | Available | 25.11.4 November Release |
| Vendor Stock ID | The vendor's item number or a Walmart generated Vendor Stock ID. Vendor Managed Items: A vendor abbreviation is added to the Vendor's item number to uniquely identify an item of merchandise. Items supplied from a third party grocery warehouse: A vendor abbreviation and vendor warehouse number is added to the vendor's item number to uniquely identify an item of merchandise. Note: we are not using using third party grocery warehouses. | Item Dimensions | Vendor Stock ID,Vendor Stk Nbr | Available | 25.11.4 November Release |
| Vendor Pack Cost Amount | The base cost of the vendor pack case of an item. This does not reflect deals and discounts which are stored separately. This is not the net cost on a Purchase Order. NOTE: The value in this field may or may not reflect the latest actual cost used on a Purchase Order since the cost for any item can be changed on the PO. This amount is shown in dollars. | Item Dimensions | VNPK Cost | Sensitive - Not Category Advisor Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Vendor Pack Cube Quantity | The cube dimensions of the vendor pack case. | Item Dimensions | VNPK Cubic Ft | Available | 25.11.4 November Release |
| Vendor Pack Cube UoM Description | The unit of measure description for the vendor pack cube. | Item Dimensions | - | Available | 25.11.4 November Release |
| Vendor Pack Height Quantity | The measured height of a vendor case pack. | Item Dimensions | VNPK Height | Available | 25.11.4 November Release |
| Vendor Pack Length Quantity | The measured length of a vendor case pack. | Item Dimensions | VNPK Length | Available | 25.11.4 November Release |
| Vendor Pack Quantity | The vendor pack quantity amount of vendor packs. | Item Dimensions | Vnpk qty,Orderable Qty | Available | 25.11.4 November Release |
| Vendor Pack Width Quantity | The measured width of a vendor case pack. | Item Dimensions | VNPK Width | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Vendor Pack Weight Format Description | Contextual description for the Vendor Pack Weight. | Item Dimensions | - | Available | 25.11.4 November Release |
| Vendor Pack Weight Quantity | The weight of the vendor pack case. This includes the weight of the case packaging. | Item Dimensions | Vendor Pack Weight | Available | 25.11.4 November Release |
| Warehouse Pack Cubic Quantity | The warehouse pack cubic feet. The size in cubic feet of a warehouse pack. | Item Dimensions | WHPK Cubic Ft | Available | 25.11.4 November Release |
| Warehouse Pack Cube UOM Code | Unit of Measure for the warehouse pack cube. | Item Dimensions | - | Available | 25.11.4 November Release |
| Warehouse Pack Cube UOM Description | Unit of measure description for the warehouse pack cube. | Item Dimensions | WHPK Cubic Ft | Available | 25.11.4 November Release |
| Warehouse Pack Dimension UOM Code | Unit of measure for the warehouse pack dimensions. | Item Dimensions | - | Available | 25.11.4 November Release |
| Warehouse Pack Height Quantity | The measured height of a warehouse case pack. | Item Dimensions | WHPK Height | Available | 25.11.4 November Release |
| Warehouse Pack Length Quantity | The measured length of a warehouse case pack. | Item Dimensions | WHPK Length | Available | 25.11.4 November Release |
| Warehouse Pack Quantity | Number of units or eaches in a warehouse pack case. Note: Currently the number of warehouse packs is a derived figure. For example, an item with a Vendor Pack Quantity of 24 and Warehouse Pack Quantity of 4 would really have 6 warehouse packs in each vendor pack. This is also the minimum quantity of eaches that a store can order from the warehouse. Once created, this field cannot be changed. This is a restriction of DC processing. If they had the same item number with different warehouse pack quantities, they could not determine what to bill the stores for shipments. Warehouse Pack Quantity must ALWAYS be evenly divisible into the Vendor Pack Quantity. There are also rules established for Warehouse and Vendor Pack Quantities based on the Case Pack Type. Only items with a Case Pack Type of B (Break pack) can have a Warehouse Pack Quantity different than the Vendor Pack Quantity. This value can be overridden from the Item for a given purchase order. | Item Dimensions | WHPK Qty, Warehouse Pack Qty (Owned only) | Available | 25.11.4 November Release |
| 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 Dimensions | WHPK Sell | Available | 25.11.4 November Release |
| Warehouse Pack UPC Format Code | Textual description of the UPC format codes. | Item Dimensions | WHPK UPC | Available | 25.11.4 November Release |
| 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 Dimensions | - | Available | 25.11.4 November Release |
| Warehouse Pack UPC Number | The standardized shipping container code (SCC-14 universal code for shipping containers); identifies the warehouse pack (inner case UPC). | Item Dimensions | WHPK UPC | Available | 25.11.4 November Release |
| Warehouse Pack Width Quantity | The measured width of a warehouse case pack. | Item Dimensions | WHPK Width | Available | 25.11.4 November Release |
| Warehouse Pack Weight Quantity | Weight of the warehouse pack case. | Item Dimensions | Whse Pack Weight | Available | 25.11.4 November Release |
| Warehouse Pack Weight UoM Code | Unit of Measure (UOM) for the warehouse pack weight. | Item Dimensions | - | Available | 25.11.4 November Release |
| Warehouse Pack Weight UoM Description | Unit of Measure (UOM) description for the warehouse pack weight. | Item Dimensions | - | Available | 25.11.4 November Release |
| Warehouse Alignment Type Code | Groups items together for warehouse-to-store alignment (for the shipment of products). This alignment is based on the type of product. Valid values include: AB - Assembly Bulk ,AC - AIDCO Conversion, AS - Assembly, CI - Circular, CW - Collectable, DG - Dry Good, DI - Distribution Freight, DS - Distribution Shoes, GB - Bakery ,FC - Freezer/Cooler, GB - Bakery, GC - Dairy, GD - Dry Grocery, GF - Frozen Foods, GM - Meats and Seafood, GP - Product, GV - Private Label and Promotion, GY - Deli, HA - Hearing Aids, HW - Hypermart, IN - International, JW - Jewelry, MT - Meat, OC - Over the Counter, OP - Optical Lab, PD - Produce, PH - Pharmacy, SB - Staple Stock Bulk, SH - Special Hypermart, SP - Special Divisions, SS - Staple Stock Shoes, TD - Tires, TS - Tires Distribution, WH - Warehouse, WP - WPM Merchandise, AP - WPM CENTER, APPAREL NETWORK, F0 - GROCERY NETWORK, HVDC Phase I, F1 - GROCERY NETWORK, HVDC Phase II, F2 - GROCERY NETWORK, F3 - GROCERY NETWORK, F4 - GROCERY NETWORK, F5 - GROCERY NETWORK, HVDC Phase VI, F8 - GROCERY NETWORK, F9 - GROCERY NETWORK, G0 - SPECIAL REALIGNMENT, G1 - SPECIAL REALIGNMENT, G2 - SPECIAL REALIGNMENT, G3 - SPECIAL REALIGNMENT, G4 - SPECIAL REALIGNMENT, G5 - SPECIAL REALIGNMENT, G6 - SPECIAL REALIGNMENT, G7 - SPECIAL REALIGNMENT, G8 - SPECIAL REALIGNMENT, G9 - SPECIAL REALIGNMENT, GZ - GROCERY EMERGENCY, PR - SLOW DRY PHASE III, PX - PRESCRIPTION REPLENISHMENT, R0 - REGIONAL NETWORK, R1 - REGIONAL NETWORK, R2 - REGIONAL NETWORK, R3 - REGIONAL NETWORK, R4 - REGIONAL NETWORK, R5 - REGIONAL NETWORK, R6 - REGIONAL NETWORK, R8 - REGIONAL NETWORK,RX - PHARMACY | Item Dimensions | Whse Align | Available | 25.11.4 November Release |
| Warehouse Alignment Type Description | The description for warehouse alignment type.,Valid values include:,AB - Assembly Bulk,AC - AIDCO Conversion,AS - Assembly,CI - Circular,CW - Collectable,DG - Dry Good,DI - Distribution Freight,DS - Distribution Shoes,GB - Bakery,FC - Freezer/Cooler,GB - Bakery,GC - Dairy,GD - Dry Grocery,GF - Frozen Foods,GM - Meats and Seafood,GP - Product,GV - Private Label and Promotion,GY - Deli,HA - Hearing Aids,HW - Hypermart,IN - International,JW - Jewelry,MT - Meat,OC - Over the Counter,OP - Optical Lab,PD - Produce,PH - Pharmacy,SB - Staple Stock Bulk,SH - Special Hypermart,SP - Special Divisions,SS - Staple Stock Shoes,TD - Tires,TS - Tires Distribution,WH - Warehouse,WP - WPM Merchandise,AP - WPM CENTER, APPAREL NETWORK,F0 - GROCERY NETWORK, HVDC Phase I,F1 - GROCERY NETWORK, HVDC Phase II,F2 - GROCERY NETWORK,F3 - GROCERY NETWORK,F4 - GROCERY NETWORK,F5 - GROCERY NETWORK, HVDC Phase VI,F8 - GROCERY NETWORK,F9 - GROCERY NETWORK,G0 - SPECIAL REALIGNMENT,G1 - SPECIAL REALIGNMENT,G2 - SPECIAL REALIGNMENT,G3 - SPECIAL REALIGNMENT,G4 - SPECIAL REALIGNMENT,G5 - SPECIAL REALIGNMENT,G6 - SPECIAL REALIGNMENT,G7 - SPECIAL REALIGNMENT,G8 - SPECIAL REALIGNMENT,G9 - SPECIAL REALIGNMENT,GZ - GROCERY EMERGENCY,PR - SLOW DRY PHASE III,PX - PRESCRIPTION REPLENISHMENT,R0 - REGIONAL NETWORK,R1 - REGIONAL NETWORK,R2 - REGIONAL NETWORK,R3 - REGIONAL NETWORK,R4 - REGIONAL NETWORK,R5 - REGIONAL NETWORK,R6 - REGIONAL NETWORK,R8 - REGIONAL NETWORK,RX - PHARMACY | Item Dimensions | - | Available | 25.11.4 November Release |
| Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Item Dimensions | - | Available | 25.11.4 November Release |
| Walmart UPC Description | The Universal Product Code (UPC) description that is used to create a base item, and the base item that is used to group all variant items. If the item is a base, then UPC and Base UPC will be the same. If the item is a variant, then UPC will be different from Base UPC. | Item Dimensions | UPC Desc | Available | 25.11.4 November Release |
| 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 Dimensions | UPC,Parent UPC | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Banner Code | A code which represents the sign or banner on the outside of the store. | Store Dimensions | - | Available | 25.11.4 November Release |
| Banner Description | The description of the sign or banner on the outside of the store. E.g. Walmart Supercenter | Store Dimensions | - | Available | 25.11.4 November Release |
| Base Division Number | Base Division Number represents the base division of the item. E.g. 01 - Walmart | Store Dimensions | Subdiv | Available | 25.11.4 November Release |
| Business Company Code | Designates the status of the store as related to comparable sales calculation. | Store Dimensions | - | Available | 25.11.4 November Release |
| Business Company Description | This is a detailed description of the status of the store as related to comparable sales calculation. Sample values: R - Relocated this year, S - Enlarged last year, T- Opened this year | Store Dimensions | - | Available | 25.11.4 November Release |
| Business Gross Size Quantity | Square footage of the store. The size of the physical building(s) of the store in square feet. | Store Dimensions | Square Footage | Available | 25.11.4 November Release |
| Business Unit Public Close Time | This is the time when the business unit (Store, Warehouse, etc.) is closed for the public. | Store Dimensions | - | Available | 25.11.4 November Release |
| Business Unit Public Open Time | This is the time when the business unit (Store,Warehouse, etc.) is open for the public. | Store Dimensions | - | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| BUO Area Name | Name of the Geographic Business Unit which is the highest geographical grouping of stores. This is an operational alignment used to manage stores. There are three distinctive geographic business units (GBUs) defined for Walmart US: West, South, and North. | Store Dimensions | - | Available | 25.11.4 November Release |
| City Name | This is the name of the city in which the Distribution Center/store resides. | Store Dimensions | City | Available | 25.11.4 November Release |
| County Name | This is the textual identifier for a county. | Store Dimensions | Physical County Name | Available | 25.11.4 November Release |
| Daylight Saving Timezone Indicator | Time Zone that follows daylight savings rules | Store Dimensions | Time Zone Daylight savings | Available | 25.11.4 November Release |
| Drive Through Pharmacy Indicator | This indicates if the location has a drive thru pharmacy or not. | Store Dimensions | - | Available | 25.11.4 November Release |
| Daylight Savings Time Zone Code | This is the daylight savings time zone that the store resides in. E.g., EDT, CDT, PDT, etc. | Store Dimensions | Time Zone Daylight Savings | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Expand Size Quantity | Square footage of a store, after its expansion. Before the expansion date this column contains the store's original square footage. After the expansion date this column displays the store's square footage after the expansion. | Store Dimensions | Expansion Size SQFT | Available | 25.11.4 November Release |
| Close Date | The date the store closed for business. | Store Dimensions | - | Available | 25.11.4 November Release |
| Financial Open Date | This is the date that the store opened for business. | Store Dimensions | Open Date | Available | 25.11.4 November Release |
| Financial Report Code | This is the code used to allow users to easily identify the type of store. For example: SC is Supercenter, SS is Small Store, etc. | Store Dimensions | Financial Rpt Code | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. | Store Dimensions | Geo region cd | Available | 25.11.4 November Release |
| Grand Open Date | The date the store is officially open for business. | Store Dimensions | Open Date | Available | 25.11.4 November Release |
| Latitude Degree | This indicates the Latitude degree of the store's physical location. | Store Dimensions | - | Available | 25.11.4 November Release |
| Longitude Degree | This indicates the Longitude degree of the store's physical location. | Store Dimensions | - | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Merchandise Sub Zone Number | 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 | 25.11.4 November Release |
| Operation Close Date | The date the store closed for business. | Store Dimensions | - | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Dimensions | Op cmpny cd | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Open Status Code | It gives information for opening stores. Values: 0 - scheduled to open, 1 - new, open less than 13 months, 2 - new, open 13 months or more, 3 - scheduled to re-grand open, 4 - old, less than 13 months since re-grand, 5 - old, more than 13 months since re-grand, 6 - scheduled to close,7 - closed | Store Dimensions | - | Available | 25.11.4 November Release |
| Open Status Description | This is the description of the Open Status Code. Values :0 - scheduled to open, 1 - new, open less than 13 months, 2 - new, open 13 months or more, 3 - scheduled to re-grand open, 4 - old, less than 13 months since re-grand, 5 - old, more than 13 months since re-grand, 6 - scheduled to close, 7 - closed | Store Dimensions | - | Available | 25.11.4 November Release |
| Open Sunday Indicator | Identifies a Walmart store as being open for business on Sunday. | Store Dimensions | Open Sunday Flag | Available | 25.11.4 November Release |
| Phone Number | The main contact phone number for the store. | Store Dimensions | Phone Nbr | Available | 25.11.4 November Release |
| Zip Code or Postal Code | An identifier for geographic area for the purpose of delivering mail. | Store Dimensions | Zip Code | Available | 25.11.4 November Release |
| Primary Language Code | This is the language of the place where the store resides. | Store Dimensions | - | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Public Close Date | The date the store was closed to the public. | Store Dimensions | - | Available | 25.11.4 November Release |
| Real Estate Prototype Code | This is used by construction to identify the general layout of the store. | Store Dimensions | - | Available | 25.11.4 November Release |
| Region Number | The operational alignment level to which markets and sub_regions report. | Store Dimensions | - | Available | 25.11.4 November Release |
| 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 TN, GA – Atlanta | Store Dimensions | - | Available | 25.11.4 November Release |
| Relocation Flip Date | The date of a store relocation when processing at the existing location flips to the temporary store number. Transactions from the store are sent under the temporary store number. | Store Dimensions | Expansion Open Date | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Segment Name | The name associated with the segment. A segment is the highest level of alignment for stores and clubs. | Store Dimensions | - | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Street Address Line 1 | The street address of the store location. | Store Dimensions | Building Address | Available | 25.11.4 November Release |
| Street Address Line 2 | The street address of the store location. | Store Dimensions | Street Address | Available | 25.11.4 November Release |
| Street Address Line 3 | The street address of the store location. | Store Dimensions | Street Address | Available | 25.11.4 November Release |
| Street Address Line 4 | The street address of the store location. | Store Dimensions | Street Address | Available | 25.11.4 November Release |
| State Province Name | The name of the state or province where the business unit is located. | Store Dimensions | - | Available | 25.11.4 November Release |
| State or Province Code | The state or province code in which the Distribution Center(DC) or store resides. | Store Dimensions | Whse State | Available | 25.11.4 November Release |
| Manager Name | The first and last name of the store manager. | Store Dimensions | Manager First Name,Manager Last Name | Available | 25.11.4 November Release |
| Store Number | The most used store identifier. It is an essential store attribute for reporting. | Store Dimensions | Store Nbr | Available | 25.11.4 November Release |
| Store Name | The most used store identifier. It is an essential store attribute for reporting. | Store Dimensions | Store Name | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Store Type Description | The descriptive text of the code identifying the type of physical building. Examples: G - General Office, R - Regular (Walmart), W – Warehouse | Store Dimensions | Store Type | Available | 25.11.4 November Release |
| Subdivision Number | An identifier for a subdivision. Today a division may have "A" or "B" as the subdivision. | Store Dimensions | - | Available | 25.11.4 November Release |
| Subdivision Name | Walmart US segmentation of the business both from an operating business unit and geographical locations. | Store Dimensions | Subdiv | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Time Zone Code | The time zone that the store resides in. Values: EST, CST, MST, PST, CST/MST | Store Dimensions | Time Zone Standard | Available | 25.11.4 November Release |
| Time Zone Name | The time zone name that the store resides in. E.g. Eastern, Central, Mountain, Pacific,Values of codes: EST, CST, MST, PST, CST/MST | Store Dimensions | Time Zone Standard | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Forecast Walmart Year Week Number | Walmart year and week (in full numeric form) for the store item forecast. Example: 201701. | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| Final Forecast Each Quantity | It is the final forecasted quantity after making all adjustments. Calculation: Final Forecast Each Quantity = Sales Forecast Each Quantity + Total Adjustment Each Quantity | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| Geographic Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| Store Number | The most used store identifier. It is an essential store attribute for reporting. | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| Walmart Item Number | Walmart-assigned number to a specific merchandise. It is the number that will be used on any purchase orders because it's vendor specific. | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| 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. | Long Range Store Demand Forecast | - | Available | 25.11.4 November Release |
| Forecast Sequence Number | Forecast sequence numbers are unique identifiers generated by the forecasting system for each store/item or DC/item combination on a specific suggested order date. Multiple orders can exist for the same suggested order date, each with its own sequence number (starting at 1 for the earliest order). To get the total forecast for an item, sum the units across all sequence numbers for that suggested order date, rather than using only the latest sequence's forecast units. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Geographic Region Code | A code which represents an operational geographic region. This can be a country, a group of countries or all countries. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Order Each Quantity | Units ordered, derived from vendor pack order quantity and vendor pack qty. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Order Placed Date | The date that the order should be placed with the vendor. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Scheduled Arrival Date | The shipment date recommended for the order to be delivered on time. This can be from the vendor or DC. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Store Number | The most used store identifier. It is an essential store attribute for reporting. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Suggested Order Date | The date on which the replenishment order is created. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Walmart Item Number | Walmart-assigned number to a specific merchandise. It is the number that will be used on any purchase orders because it's vendor specific. | Order Demand Forecast | - | Available | 25.11.4 November Release |
| Business Date | The authorized, cancelled, or refunded date depending on the event type. Use this report date for authorization-based reporting. | Store Inventory | - | Available | 25.11.4 November Release |
| Currency Code | ISO 4217 ALPHA3 CODE for the identification of currency. Hardcode "USD". | Store Inventory | - | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Gross Receipt Quantity - Last 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 | 25.11.4 November Release |
| Store In Transit Quantity - Last 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 | 25.11.4 November Release |
| Store In Transit Retail Amount - Last 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 | 25.11.4 November Release |
| Store In Warehouse Quantity - Last Year | The number of units received by the DC which are allocated specifically to a store but not yet shipped (invoiced). | Store Inventory | Curr Str In Whse Qty,Received QTY at WH (Owned only) | Available | 25.11.4 November Release |
| Store In Warehouse Retail - Last 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 | 25.11.4 November Release |
| Max Shelf Quantity - Last Year | This is the minimum amount of the item that is desired to be in inventory at the store. It represents the safety stock amount of the item. | Store Inventory | Max Shelf Qty | Available | 25.11.4 November Release |
| Net Receipt Quantity - Last year | Difference between Ships and Store Returns. Calculated as Gross Receipts # - Store Return #. | Store Inventory | Net Ship Qty | Available | 25.11.4 November Release |
| Store On Hand Quantity - Last Year | The quantity of an item which is on hand at this store. | Store Inventory | Curr On Hand Qty,Curr Str On Hand Qty,Sat On Hand Qty,Hist On Hand Qty,Fri On Hand Qty,Sun On Hand Qty,Mon On Hand Qty,Tue On Hand Qty,Wed On Hand Qty,Thu On Hand Qty,Store Weeks Supply,Est Retail Turns | Available | 25.11.4 November Release |
| Store On Hand Retail - Last Year | The total positive on-hand for that item in Retail Dollars $ | Store Inventory | Curr Str on Hand Retail | Available | 25.11.4 November Release |
| Store On Order Quantity - Last Year | The number of units on a purchase order allocated specifically to the store. | Store Inventory | Curr Str On Order Qty | Available | 25.11.4 November Release |
| Store On Order Retail Amount - Last year | The retail value of units on a purchase order allocated specifically to the store | Store Inventory | Curr Str On Order Retail | Available | 25.11.4 November Release |
| Valid Store Item Count - Last Year | Current Year Valid count of Store/Items combinations that are Replenishable items. | Store Inventory | Curr Repl Instock %, Curr Valid Store/Item Comb. | Available | 25.11.4 November Release |
| Traited Store/Item Count - Last Year | Store count of all the items with the replenishment status as Active, Inactive and New. Values: 1 - Traited, 0 – Not Traited Note:The Traited Store/Item Count is aggregated at the item level to get the distinct store count at each item level. | Store Inventory | Curr Traited Store/Item Comb. | Available | 25.11.4 November Release |
| Store Item ID | The 6-, 7-, or 9-character number assigned to an item of merchandise that Walmart buys from a supplier, to sell in the stores. Items that are 9 digits are REACT numbers and are considered Softlines. The first two digits of a 9-digit softline (REACT) item number is the order department, positions 3-4 are the subclass. Items that are 6-7 digits are hardline items. For items that are 6 digits, the first digit is the order department number. For items that are 7 digits, the first two digits are the department number. | Store Inventory | Item Nbr | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note: Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Inventory | - | Available | 25.11.4 November Release |
| Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Store Inventory | Store Nbr | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Home Office Recommended Retail Price Amount - This Year | This is the retail price for the item at the store that was set at the home office. This amount is shown in dollars. | Store Inventory | Current HO Retail | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Max Shelf Quantity - This Year | This is the minimum amount of the item that is desired to be in inventory at the store. It represents the safety stock amount of the item. | Store Inventory | Max Shelf Qty | Available | 25.11.4 November Release |
| Store On Hand Quantity - This Year | The quantity of an item which is on hand at this store. | Store Inventory | Curr On Hand Qty,Curr Str On Hand Qty,Sat On Hand Qty,Hist On Hand Qty,Fri On Hand Qty,Sun On Hand Qty,Mon On Hand Qty,Tue On Hand Qty,Wed On Hand Qty,Thu On Hand Qty,Store Weeks Supply,Est Retail Turns | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| Valid Store Item Count - This Year | Current Year Valid count of Store/Items combinations that are Replenishable items. | Store Inventory | Curr Repl Instock %, Curr Valid Store/Item Comb. | Available | 25.11.4 November Release |
| Store Specific Retail Amount - This Year | 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, Item 100, store_specific_cost_amt 600, store_specific_rtl_amt 620, Store_Nbr 2, Item 100, store_specific_cost_amt 650, store_specific_rtl_amt 670 | Store Inventory | Store Specific Retail | Available | 25.11.4 November Release |
| Traited Store/Item Count - This Year | Store count of all the items with the replenishment status as Active, Inactive and New. Values: 1 - Traited, 0 – Not Traited Note:The Traited Store/Item Count is aggregated at the item level to get the distinct store count at each item level. | Store Inventory | Curr Traited Store/Item Comb. | Available | 25.11.4 November Release |
| Vendor Number | A unique number identifying the vendor or supplier of this item. It is an essential product attribute for reporting. | Store Inventory | Vendor Number | Available | 25.11.4 November Release |
| Vendor Name | Name of the supplier. It is an important product attribute for reporting. | Store Inventory | Vendor Name | Available | 25.11.4 November Release |
| Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Store Inventory | Walmart Item Number | Available | 25.11.4 November Release |
| Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Store Inventory | Est Unit Turns, Est Retail Turns | Available | 25.11.4 November Release |
| Business Date | The authorized, cancelled, or refunded date depending on the event type. Use this report date for authorization-based reporting. | Store Sales | Store Weeks Supply | Available | 25.11.4 November Release |
| Geographic Region Code | A code that represents an operational geographic region. This can be a country, a group of countries, or all countries. The valid values are: AR- Argentina, BR- Brazil, CA - Canada, CN - China, GB - Great Britain, IN - India, JP - Japan, K1 - Central America, K2 - Chile, K3 - Southern Africa, MX - Mexico, US - United States, WW - World Wide | Store Sales | Geographic Region Code | Available | 25.11.4 November Release |
| POS Quantity - Last Year | Point of Sales quantity on previous year date from different fulfilment channels, such as online grocery and pick-up, pick up today, and ship from store. Point of Sale (POS) Quantity is the quantity of items sold of a specific item number that is scanned at a store level register. It includes all returns (total store returns) at the store level. If there are no sales on any item but there are returns, then this value shows up as a negative sales amount. When creating a report with POS Sales and POS Quantity for products that are sold with variable weight, you will want to include the following attributes: Sell Quantity and Sell UoM Description. These additional dimensions will help you to be able to answer that question. If the Sell Quantity = 1, then the POS Quantity will reflect the measure of unit. I If the Sell Quantity > 1, then the POS Quantity will be in eaches. | Store Sales | POS Qty,Fri Qty,Sat Qty,Sun Qty,Mon Qty,Tue Qty,Wed Qty,Thu Qty | Available | 25.11.4 November Release |
| POS Sales-Last Year | Realigns last year’s sales to the current 4-5-4 date (necessary for comp queries). | Store Sales | POS Sales,Sat Sales,Sun Sales,Mon Sales,Fri Sales,Wed Sales,Thu Sales,Tue Sales | Available | 25.11.4 November Release |
| Operational Company Code | Used to differentiate WMT_US, Sam's, or WMT.com based on international or US. Examples: 0 WMT-US The operational company Walmart in the US geo-region. 1 SAMS-US The operational company Sam’s Club in the US geo-region. 2 WMT The operational company Walmart in the worldwide region. 3 SAMS-MX The operational company Sam’s Club in the Mexico geo-region. 4 WMT-K1 The operational company Walmart in the Central America geo-region. Note:Although operational company is an atomic column, based on known use cases and for user convenience we chose to populate it as “Operational Company Code” (HYPHEN) “Geo Region”. | Store Sales | Op cmpny cd | Available | 25.11.4 November Release |
| Sales By Type | A unique identifier for the sell status of an item according to the Store's Item File at the time the item was sold. Values: REPORT_CODE - REPORT_TYPE_DESC 0 - Regular, 1 - Store Tab, 2 - Company Tab, 3 - New Item, 4 - Competition, 5 - Competition/Store Tab, 6 - Competition/Company Tab, 7 - Rollback, 8 - Clearance, 9 - CVP - Customer Value Product | Store Sales | - | Available | 25.11.4 November Release |
| Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | Store Sales | Store Nbr,POS Store Count | Available | 25.11.4 November Release |
| 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 | 25.11.4 November Release |
| POS Quantity - This Year | Point of Sale (POS) Quantity is the quantity of items sold of a specific item number that is scanned at a store level register from all fulfillment channels. It includes all returns (total store returns) at the store level. If there are no sales on any item but there are returns, then this value shows up as a negative sales amount. When creating a report with POS Sales and POS Quantity for products that are sold with variable weight, you will want to include the following attributes: Sell Quantity and Sell UoM Description. These additional dimensions will help you to be able to answer that question. If the Sell Quantity = 1, then the POS Quantity will reflect the measure of unit. I If the Sell Quantity > 1, then the POS Quantity will be in eaches. | Store Sales | POS Qty, Fri Qty, Sat Qty, Sun Qty, Mon Qty, Tue Qty, Wed Qty, Thu Qty, COMP Store Qty, Units per Store per Week (w/o zeros), Units per Store per Week (w/zeros), Store Weeks Supply, Avg Price, Sales Type, Est Retail Turns, Alternate Selling Unit POS Qty, Sell Thru, Alternate Selling Unit POS Avg Price | Available | 25.11.4 November Release |
| POS Sales-This Year | Point of Sale (POS) Sales is the dollar amount of sales for a specific item number that is scanned at a store level register. Corresponds to POS quantity; includes all returns (total store returns) at store level. If there are no sales on an item but there are returns, then this value shows up as a negative sales amount. | Store Sales | POS Sales, Sat Sales, Sun Sales, Mon Sales, Fri Sales, Wed Sales, Thu Sales, Tue Sales, COMP Store Sales, Sales $ per Store per Week (w/o zeros), Sales$ per Store per Week (w/zeros), Avg Price, MUMD as % of Sales, Sales Type, Est Unit Turns, Alternate Selling Unit POS Sales, Alternate Selling Unit POS Avg Price | Available | 25.11.4 November Release |
| Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | Store Sales | Walmart Item Number | Available | 25.11.4 November Release |
| Walmart Year Week Number | A number representing the full Walmart year and week. The four-digit year is followed by a two-digit week count. Example: 200701. This year is the same for all countries. Since the fiscal year begins in February, January will continue the prior year count. For example, 200649 would be the Year Week Number for the first week of January, even though wm_year_nbr is 2007. | Store Sales | WM Week | Available | 25.11.4 November Release |
| Business Date | The authorized, cancelled, or refunded date depending on the event type. Use this report date for authorization-based reporting. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Total Store On Hand Adjustment Quantity | Total Store On Hand Adjustment Quantity is the sum of Sales floor adjustments and Backroom adjustments at store level.Calculation: Total Store On Hand Adjustment Quantity = Backroom Adjustment Quantity + Adjustment Quantity | SSI - Backroom Adjusted Inventory | - | Available | 26.01.14 January Release |
| Carry Option Code | Carry Option indicates whether or not the merchandise is valid for the store | SSI | - | Available | 26.01.14 January Release |
| Carry Status Code | Carry Status indicates the current replenishable status. | SSI | - | Available | 26.01.14 January Release |
| Catalog Item ID / eComm Prod ID | The primary SKU for eCommerce products is pack specific (i.e., each pack size will have different identification numbers). Since the Catalog Item ID is for eCommerce products only, there may not be a corresponding item number when looking in datasets that only represent store metrics.,It is also known as eCommerce Item Number. | SSI - Item Dimensions | - | Available | 26.01.14 January Release |
| Currency Code | ISO 4217 ALPHA3 CODE for the identification of currency. Hardcode "USD". | SSI - MUMD | - | Available | 26.01.14 January Release |
| Day Count | Used to dived average metrics by day count. | SSI - Store Fulfillment (OPD) | - | Available | 26.01.0 January Release |
| Backroom Adjustment Quantity | This is the summarized number of eaches adjusted. | SSI - Inventory Adjustments | - | Available | 26.01.14 January Release |
| Inventory Adjustment Type Code | Indicates type of the inventory adjustment in stores 42: DAMAGED BKRM 43: STOLEN BKRM 44: SHORTAGE BKRM 45: INV REDUCTION BKRM 46: INV INCREASE BKRM 47: SNACK BAR SPOIL BKRM 48: VENDING MACHINE BKRM 49: STORE USE | SSI - Backroom Adjusted Inventory | - | Available | 26.01.14 January Release |
| Inventory Adjustment Type Description | Indicates type of the inventory adjustment in stores 42: DAMAGED BKRM 43: STOLEN BKRM 44: SHORTAGE BKRM 45: INV REDUCTION BKRM 46: INV INCREASE BKRM 47: SNACK BAR SPOIL BKRM 48: VENDING MACHINE BKRM 49: STORE USE | SSI - Backroom Adjusted Inventory | - | Available | 26.01.14 January Release |
| Adjustment Quantity - Last Year | The adjusted quantity recorded last year. It may be a positive (increase in the on-hand qty) or negative (decrease in the on-hand qty). | SSI - Inventory Adjustments | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Amount End of Period - Last Year | This is the on hand retail amount that is available for a clearance item.This amount is in Dollars. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Quantity End of Period - Last Year | The quantity of an item on clearance which is on hand at this store. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Amount End of Period - Last Year | This is the on hand retail amount that is available for a rollback item.This amount is in Dollars. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Quantity End of Period - Last Year | The quantity of an item on rollback which is on hand at this store. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Sales Amount - Last Year | Total Returns Sales amount | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Quantity - Defective (Customer Returns) - Last Year | The unit weight of measurable items which are returned as item is Defective. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Sales Amount - Defective (Returns) - Last Year | The total retail amount for the returned Defective Items. | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Unit of Measurent Quantity - Defective (Returns) - Last Year | Unit weight of measurable items which are returned as item is Defective. Unit weight represents the number of packages for most items; for items that are measured by the pound, yard, etc, unit weight represents the pounds, yards, etc. | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Gross Receipt Quantity - Last Year | The number of sellable units received at the store. These can also be weighable units and can hold decimal values. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| SI Total MUMD $ - Last Year | Total expense (in dollars) of markdowns for an item, for the time specified. | SSI - MUMD | - | Available | 26.01.14 January Release |
| SI MUMD Qty - Last Year | Scannable Item Markup/Markdown Quantity in eaches | SSI - MUMD | - | Available | 26.01.14 January Release |
| Net Receipt Quantity - Last year | Difference between Ships and Store Returns. Calculated as Gross Receipts # - Store Return #. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Return Quantity - No Retun Type (Returns) - Last Year | Last year Store return quantity of merchandise with no return type. | SSI - Store returns | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Quantity End of Period Last Year | The quantity of items on hand at the end of the previous fiscal period that were on rollback (temporary price reduction) at that time. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Return Quantity - Other Reason Type (Returns) - Last year | Last year Store return quantity of merchandise due to other Reasons to a Vendor, DC, or Return Center. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| POS Quantity - Last Year | Point of Sales quantity on previous year date from different fulfilment channels, such as online grocery and pick-up, pick up today, and ship from store. Point of Sale (POS) Quantity is the quantity of items sold of a specific item number that is scanned at a store level register. It includes all returns (total store returns) at the store level. If there are no sales on any item but there are returns, then this value shows up as a negative sales amount. When creating a report with POS Sales and POS Quantity for products that are sold with variable weight, you will want to include the following attributes: Sell Quantity and Sell UoM Description. These additional dimensions will help you to be able to answer that question. If the Sell Quantity = 1, then the POS Quantity will reflect the measure of unit. I If the Sell Quantity > 1, then the POS Quantity will be in eaches. | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Return Quantity - Recall (Returns) - Last Year | The total number of units returned by customers due to product recalls during the previous fiscal year. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Valid Store Item Count - Last Year | Last Year Valid count of Store/Items combinations that are Replenishable items. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Return Quantity - Last Year | The amount associated with the store return of merchandise to a Vendor, DC, or Return Center last year | SSI - Store Returns | - | Available | 26.01.14 January Release |
| POS Sales-Last Year | Realigns last year’s sales to the current 4-5-4 date (necessary for comp queries). | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Scan Count - Last Year | Depending on the Service Channel this Scan_cnt will be populated with either: - BIS : Bought in Store. Indicates the number of items scanned at the store's POS point of sale. - Delivery: indicates the number of items ordered on-line and fulfilled via delivery. - Pickup: indicates the number of items ordered online and picked up at store. - SFS: indicates the number of items ordered online and shipped from store. Note that this does not always reflect the number sold of that item because if a cashier uses the register's quantity key to enter the number of a given item being bought and then just scans one of them, scan_cnt will equal 1 on that item. Use unit_qty to get actual number of items sold. | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Return Quantity - To DC (Returns) - Last Year | Last year Store return quantity of merchandise to a Distribution Center (DC). | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Quantity - To Return Center - Last Year (Returns) | Last year Quantity associated with the store return of merchandise to a Return Center. | SSI - Store returns | - | Available | 26.01.14 January Release |
| Return Quantity - To Vendor via Return Center (Returns) - Last Year | Last year Store return quantity of merchandise to a Vendor via Return Center. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Store Markdown Amount - Last Year | Store initiated markdown amount. E.g., Damage, Local Price Matching.This amount is shown in dollars. | SSI - MUMD | - | Available | 26.01.14 January Release |
| Store Markdown Quantity - Last Year | Number of units to which the markdown was initiated by the store. This quantity is shown in eaches. | SSI - MUMD | - | Available | 26.01.14 January Release |
| Traited Store/Item Count - Last 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. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Unit of Measure Quantity - Last Year | Unit weight sold of measurable items.This is for weighable items: contains the unit weight of the item that was scanned. Example: 1 package of hamburger that weighs 5 lbs. The scan count would be 1 and the unit qty would be 5 Lbs. For non-weighable items: contains the scan (each) qty. Example: 2 box of tissues. The scan count and unit qty would be 2. | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Sales By Type | A unique identifier for the sell status of an item according to the Store's Item File at the time the item was sold. Values: 0 - Regular, 1 - Store Tab, 2 - Company Tab, 3 - New Item, 4 - Competition, 5 - Competition/Store Tab, 6 - Competition/Company Tab, 7 - Rollback, 8 - Clearance, 9 - CVP - Customer Value Product | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Retail Price Event Code | Event associated with Retail Price Amount. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store Number | An identifying number of a store within a country. It is the most used store identifier and is an essential store attribute for reporting. | SSI - Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Amount - Last Year | This is the on hand retail amount that is available for a clearance item.This amount is in Dollars. Calculation: ly_curr_clr_on_hand_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Quantity - Last Year | The quantity of an item on clearance which is on hand at this store. Recommended Calculation: ly_curr_clr_on_hand_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Amount - Last Year | This is the on hand retail amount that is available for a rollback item.This amount is in Dollars. Recommended Calucation: ly_curr_roll_on_hand_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Quantity - Last Year | The quantity of an item on rollback which is on hand at this store. Recommended Calculation: ly_curr_roll_on_hand_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store In Transit Quantity - Last Year | The number of units invoiced by the DC to the store but not yet received and finalized. Recommended Calculation: ly_in_trnst_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store In Transit Retail Amount - Last Year | The Retail value of the units invoiced by the DC to the store but not yet received and finalized. Recommended Calculation: ly_in_trnst_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store In Warehouse Quantity - Last Year | The number of units received by the DC which are allocated specifically to a store but not yet shipped (invoiced). Recommended Calculation: ly_in_whse_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store In Warehouse Retail - Last Year | The Retail value of units received by the DC which are allocated specifically to a store but not yet shipped (invoiced). Recommended Calculation: ly_in_whse_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Max Shelf Quantity - Last Year | This is the minimum amount of the item that is desired to be in inventory at the store. It represents the safety stock amount of the item. Recommended Calculation: ly_max_shelf_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Hand Quantity - Last Year | The quantity of an item which is on hand at this store. Recommended Calculation: ly_on_hand_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Hand Retail - Last Year | The total positive on-hand for that item in Retail Dollars $ Recommended Calculation: ly_on_hand_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Order Quantity - Last Year | The number of units on a purchase order allocated specifically to the store. Recommended Calculation: ly_on_order_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Order Retail Amount - Last Year | The retail value of units on a purchase order allocated specifically to the store. Recommended Calculation: ly_on_order_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Tab Receiving Quantity - Last Year | 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. Recommended Calculation: ly_tab_rcv_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Target Shelf Quantity - Last Year | This is the targeted number of eaches that should be stocked on the shelf. A shelf should be stocked based upon the sales volume. Recommended Calculation: ly_trgt_shelf_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Amount - This Year | This is the on hand retail amount that is available for a clearance item.This amount is in Dollars. Recommended Calculation: ty_curr_clr_on_hand_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Quantity - This Year | The quantity of an item on clearance which is on hand at this store. Recommended Calculation: ty_curr_clr_on_hand_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Amount - This Year | This is the on hand retail amount that is available for a rollback item.This amount is in Dollars. Recommended Calculation: ty_curr_roll_on_hand_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Quantity - This Year | The quantity of an item on rollback which is on hand at this store. Recommended Calculation: ty_curr_roll_on_hand_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store In Transit Quantity - This Year | The number of units invoiced by the DC to the store but not yet received and finalized. Recommended Calculation: ty_in_trnst_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| 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. Recommended Calculation: ty_in_trnst_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| 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). Recommended Calculation: ty_in_whse_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store In Warehouse Retail Amount End of Period - This Year | The Retail value of units received by the DC which are allocated specifically to a store but not yet shipped (invoiced). Note: This metric is the 'End of Period' value for the selected time period: For Example: ‘Friday’ for WMT weeks. Recommended Calculation: ty_in_whse_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Max Shelf Quantity - This Year | This is the minimum amount of the item that is desired to be in inventory at the store. It represents the safety stock amount of the item. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Hand Quantity - This Year | The quantity of an item which is on hand at this store. Recommended Calculation: ty_on_hand_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Hand Retail - This Year | The total positive on-hand for that item in Retail Dollars $ Recommended Calculation: ty_on_hand_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Order Quantity - This Year | The number of units on a purchase order allocated specifically to the store. Recommended Calculation: 'ty_on_order_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Store On Order Retail Amount - This Year | The retail value of units on a purchase order allocated specifically to the store. Recommended Calculation: ty_on_order_rtl_amt/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Tab Receiving Quantity - This Year | 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. Recommended Calculation: 'ty_tab_rcv_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Target Shelf Quantity - This Year | This is the targeted number of eaches that should be stocked on the shelf. A shelf should be stocked based upon the sales volume. Recommended Calculation: ty_trgt_shelf_qty/averager(day_count) | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Adjustment Quantity - This Year | The adjusted quantity recorded. It may be a positive (increase in the on-hand qty) or negative (decrease in the on-hand qty). | SSI - Inventory Adjustments | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Amount End of Period - This Year | This is the on hand retail amount that is available for a clearance item.This amount is in Dollars. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Clearance On Hand Quantity End of Period - This Year | The quantity of an item on clearance which is on hand at this store. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Amount End of Period - This Year | This is the on hand retail amount that is available for a rollback item.This amount is in Dollars. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Current Rollback On Hand Quantity End of Period - This Year | The quantity of an item on rollback which is on hand at this store. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Sales Amount - This Year | Total Returns Sales amount | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Quantity - Defective (Customer Returns) - This Year | Store return quantity of Defective or Overstock merchandise to a Return Center,Vendor. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Sales Amount - Defective (Returns) - This Year | Total retail amount for the returned Defective Items. | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Unit of Measurent Quantity - Defective (Returns) - This Year | Unit weight of measurable items which are returned as item is Defective. Unit weight represents the number of packages for most items; for items that are measured by the pound, yard, etc, unit weight represents the pounds, yards, etc. | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| 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. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| SI Total MUMD $ - This Year | Total expense (in dollars) of markdowns for an item, for the time specified. | SSI - MUMD | - | Available | 26.01.14 January Release |
| SI MUMD Qty | Scannable Item Markup/Markdown Quantity in eaches | SSI - MUMD | - | Available | 26.01.14 January Release |
| Net Receipt Quantity - This Year | Difference between Ships and Store Returns. Calculated as Gross Receipts # - Store Return #. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Return Quantity - No Retun Type (Returns) - This Year | This year Store return quantity of merchandise with no return type. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Store On Hand Quantity End of Period - This Year | The quantity of an item which is on hand at this store. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Return Quantity - Other Reason Type (Returns) - This Year | This year Store return quantity of merchandise due to other Reasons to a Vendor, DC, or Return Center. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| POS Quantity - This Year | Point of Sale (POS) Quantity is the quantity of items sold of a specific item number that is scanned at a store level register from all fulfillment channels. It includes all returns (total store returns) at the store level. If there are no sales on any item but there are returns, then this value shows up as a negative sales amount. When creating a report with POS Sales and POS Quantity for products that are sold with variable weight, you will want to include the following attributes: Sell Quantity and Sell UoM Description. These additional dimensions will help you to be able to answer that question. If the Sell Quantity = 1, then the POS Quantity will reflect the measure of unit. I If the Sell Quantity > 1, then the POS Quantity will be in eaches. | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Return Quantity - Recall (Returns) - This Year | This year quantity associated with the store return of Recall merchandise to a Return Center,Vendor. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Valid Store Item Count - This Year | Current Year Valid count of Store/Items combinations that are Replenishable items. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Return Quantity - This Year | The amount associated with the store return of merchandise to a Vendor, DC, or Return Center this year. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| POS Sales-This Year | Point of Sale (POS) Sales is the dollar amount of sales for a specific item number that is scanned at a store level register. Corresponds to POS quantity; includes all returns (total store returns) at store level. If there are no sales on an item but there are returns, then this value shows up as a negative sales amount. | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Scan Count - This Year | Depending on the Service Channel this Scan_cnt will be populated with either: - BIS : Bought in Store. Indicates the number of items scanned at the store's POS point of sale. - Delivery: indicates the number of items ordered on-line and fulfilled via delivery. - Pickup: indicates the number of items ordered online and picked up at store. - SFS: indicates the number of items ordered online and shipped from store. Note that this does not always reflect the number sold of that item because if a cashier uses the register's quantity key to enter the number of a given item being bought and then just scans one of them, scan_cnt will equal 1 on that item. Use unit_qty to get actual number of items sold. | SSI - Store Sales | - | Available | 26.01.14 January Release |
| Return Quantity - To DC (Returns) - This Year | This year Store return quantity of merchandise to a Distribution Center (DC). | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Quantity - To Return Center - This Year (Returns) | This year Quantity associated with the store return of merchandise to a Return Center. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Return Quantity - To Vendor via Return Center (Returns) - This Year | This year Store return quantity of merchandise to a Vendor via Return Center. | SSI - Store Returns | - | Available | 26.01.14 January Release |
| Store Markdown Amount - This Year | Store initiated markdown amount. E.g., Damage, Local Price Matching.This amount is shown in dollars. | SSI - MUMD | - | Available | 26.01.14 January Release |
| Store Markdown Quantity - This Year | Number of units to which the markdown was initiated by the store. This quantity is shown in eaches. | SSI - MUMD | - | Available | 26.01.14 January Release |
| 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. | SSI - Store Inventory | - | Available | 26.01.14 January Release |
| Unity of Measure Quantity - This Year | The unit weight sold of measurable items this year. | SSI - Store Customer Return | - | Available | 26.01.14 January Release |
| Walmart Item Number | Walmart-assigned number to a specific piece of merchandise. It is the number that will be used on any purchase orders because it's vendor specific. There may be multiple Item Numbers (ITEM_NBR) created for a single UPC. | SSI - Item Dimensions | - | Available | 26.01.14 January Release |
| 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. | SSI - Calendar Dimensions | - | Available | 26.01.14 January Release |
| Business Date | The authorized, cancelled, or refunded date depending on the event type. Use this report date for authorization-based reporting. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Catalog Item ID / eComm Prod ID | A unique identifier assigned to each product listed on Walmart's eCommerce platform. This ID is also known as the eCommerce Product ID. It serves as the primary Stock Keeping Unit (SKU) for online products and is specific to each pack size or product variation—meaning different pack sizes or configurations of the same product will have different Catalog Item IDs. Since the Catalog Item ID is used exclusively for eCommerce products, you may not find a corresponding item number in datasets that only include store (brick-and-mortar) metrics. In other words, some eCommerce products may not have a matching item number in store-focused reports. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| 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 Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Operational Company Code | Operational Company Code is used to distinguish between different Walmart and Sam's Club business entities across various geographic regions. The code is typically presented as "Operational Company Code – Geo Region" for clarity. Here are some examples:Code DescriptionWMT-US Walmart in the US geo-regionSAMS-US Sam’s Club in the US geo-regionWMT Walmart in the worldwide regionSAMS-MX Sam’s Club in the Mexico geo-regionWMT-K1 Walmart in the Central America geo-regionNote: While the operational company is stored as a single column in the data, it is often displayed as "Operational Company Code – Geo Region" for user convenience and clarity. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Store Number | A unique numerical identifier assigned to each Walmart Store location | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Placed Sales - This Year | Order Line Amount at the time the order is placed. This Year. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Customer Order Quantity - This Year | The total number of units ordered by the customer and received by the store. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| First Time Pick Rate - This Year | The percentage of items that were picked in the first pick-walk for store fulfilled orders.Calculation: (First Time Pick Rate Numerator) / (First Time Pick Rate Denominator)Terminology associated with Pick events:-Picks: All picks, as ordered, on the first picking attempt. It is based on the first pick display timestamp. It does not include any exception picks and items that are cancelled prior to dispense.-Overrides: The system says that the associate scanned the wrong item, when in fact the associate scanned the correct item. The manager can override the system to tell it to accept the associate's pick. When an override is done for the original item, it will not lead to a substitution. These are added only if they are accepted through the exception management.-Substitution: The system recommends a different item for the OPD associate to pick since the original item is out or can't be found. This Year. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| First Time Pick Rate Denominator - This Year | The measure of quantity of actual items ordered excluding cancelled items prior to dispense, this year. Example: wm_item_nbr = 123456789, store_nbr = 10, ftpr = 42.86, ftpr_qty = 3, ftpr_nmrtr = 3, ftpr_dnmntr = 7 | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| First Time Pick Rate Numerator - This Year | The measure of number of units picked as ordered, including manager approved overrides excluding the skip quantity from the first picking attempt this year. Example: wm_item_nbr = 123456789, store_nbr = 10, ftpr = 42.86, ftpr_qty = 3, ftpr_nmrtr = 3, ftpr_dnmntr = 7 | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| First Time Pick Rate Quantity - This Year | The measure of the number of units picked as ordered including manager approved overrides excluding skip quantity from the first picking attempt this year. It is same as First Time Pick Rate Numerator. Example: wm_item_nbr = 123456789, store_nbr = 10, ftpr = 42.86, ftpr_qty = 3, ftpr_nmrtr = 3, ftpr_dnmntr = 7. Also see First Time Pick Rate Numerator and First Time Pick Rate Denominator. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Nil Picks - This Year | A Nil Pick is a measure of items that were not picked or not substituted by a store. In general, a Nil Pick event occurs when: -An ordered item cannot be picked. -A suitable substitute cannot be provided. -A manager override is not possible because the item is not available on the current shelf. Example Table: wm_item_nbr store_nbr nil_pick_qty. 123456789103 | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Post Substitute Rate - This Year | An indicator of how often a customer received an item for their order, including substitutions and manager-approved overrides. The Post Substitute Rate is calculated as: Post Substitute Rate = (Post Substitute Rate Numerator) / (Post Substitute Rate Denominator) | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Post Substitute Rate Denominator - This Year | A measure of the quantity of actual items ordered, excluding the number of items cancelled prior to dispense. This value is the same as the First Time Pick Rate Denominator. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Post Substitute Rate Numerator - This Year | The total quantity of picked items after substitution, which includes the sum of Picked Quantity, Cancelled Quantity, Override Quantity, and Substituted Quantity. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Pre Substitute Quantity - This Year | The number of items picked as originally ordered before substitution, including any manager-approved overrides. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Pre Substitute Rate - This Year | An indicator of how often the customer received exactly what they ordered before any substitution occurred. Calculated as: (Pre-Substitute Rate Numerator) / (Pre-Substitute Rate Denominator) | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Pre Substitute Rate Denominator - This Year | The quantity of actual items ordered, excluding items cancelled prior to dispense. This value is the same as the First Time Pick Rate Denominator. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Pre Substitute Rate Numerator - This Year | The total quantity of items picked as originally ordered before any substitutions are made. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Scheduled Nil Pick Quantity - This Year | This is the number of units from a scheduled order that were not picked or substituted by the store. In other words, it shows how many items the store could not fulfill for a scheduled pickup or delivery order. Example: If a customer ordered 7 units of an item, but 3 were not picked or substituted, the Scheduled Nil Pick Quantity is 3. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Scheduled Nil Pick Rate - This Year | This is the percentage of items in scheduled orders that were not fulfilled (not picked or substituted) by the store. It is reported as a percent and helps measure how often items are missing from scheduled orders. Calculation: (Scheduled Nil Pick Rate Numerator) / (Scheduled Nil Pick Rate Denominator) x 100. Example: If 3 out of 7 ordered units were not picked, the Scheduled Nil Pick Rate is (3/7) x 100 = 42.86%. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Scheduled Nil Pick Rate Denominator - This Year | This is the total number of items actually ordered in scheduled orders, excluding any items that were cancelled before the order was processed. It represents the total possible items that could have been picked. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Scheduled Nil Pick Rate Numerator - This Year | This is the number of units that were not picked or substituted by the store for scheduled orders. It is the same as the Scheduled Nil Pick Quantity. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Unscheduled Nil Pick Quantity - This Year | It refers to the number of items that were not picked (i.e., not selected or retrieved from inventory) during an unscheduled or unplanned picking process. In retail and supply chain operations, a "nil pick" occurs when an item that was expected to be picked is found to be unavailable or out of stock at the time of picking. "Unscheduled" indicates that this occurred outside of the regular, planned picking schedule—often as a result of ad hoc or urgent orders. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Unscheduled Nil Pick Rate - This Year | It is a metric used in retail and supply chain operations to measure the frequency at which items are not picked (i.e., are unavailable or out of stock) during unscheduled or unplanned picking events. This rate is typically expressed as a percentage and helps organizations understand how often inventory is missing or unavailable when unexpected or urgent picking occurs. Formula: Unscheduled Nil Pick Rate = (Unscheduled Nil Pick Quantity / Total Unscheduled Pick Attempts) × 100%. Example: If there are 20 unscheduled pick attempts and 4 of those result in nil picks (items not found), the Unscheduled Nil Pick Rate is (4/20) × 100% = 20%. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Unscheduled Nil Pick Rate Denominator - This Year | It refers to the total number of unscheduled pick attempts made during a specific period. In the context of calculating the Unscheduled Nil Pick Rate, the denominator is the count of all attempts to pick items during unscheduled (unplanned or ad hoc) picking events, regardless of whether the pick was successful or resulted in a nil (not found) outcome. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| Unscheduled Nil Pick Rate Numerator - This Year | It refers to the total number of unsuccessful item picks (nil picks) that occur during unscheduled or unplanned picking events within a specific period. In other words, it is the count of times an item could not be picked because it was unavailable or out of stock during these unscheduled pick attempts. | Store Fulfillment (OPD) | - | Available | 26.01.14 January Release |
| 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 Fulfillment (OPD) | - | Available | 26.01.14 January Release |
