The Order Forecast table provides information about the future demand for orders.
Please note: For item- to DC-level data forecasting, please use the Store number as your store number.
Example:
store_nbr = 6006
When the item is directly ordered to the Store and not going through DC, dc_nbr will be populated with NULL values
The following provides Order Forecast column details, in alphabetical order.
| Technical Name | Business Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|
| fcst_seq_nbr | Forecast Sequence Number | Integer | Y | - | - |
| geo_region_cd | Geographic Region Code | String | Y | - | - |
| op_cmpny_cd | Operational Company Code | String | - | - | - |
| order_each_qty | Order Each Quantity | Integer | - | - | - |
| order_place_dt | Order Placed Date | Date | Y | - | - |
| sched_arvl_dt | Scheduled Arrival Date | Date | - | - | - |
| store_nbr | Store Number | Integer | Y | - | - |
| sugg_order_dt | Suggested Order Date | Date | Y | - | - |
| wm_item_nbr | Walmart Item Number | Integer | Y | - | - |
©️Walmart | All Rights Reserved | Confidential