The Distribution Center (DC) Dimensions feed provides information on Distribution Center level attributes like detailed address, state & country codes, open status, and more. This data feed is the latest snapshot and contains only the attributes related to the DC as of the current date.
Endpoints
GET
/v2/bulkfeeds/snapshot/dcdimensions
Feed Details
The following table provides the DC Dimensions details.
| Specification | Details |
|---|---|
| Feed Type | Dimension |
| Refresh Frequency | Daily |
| Data Grain | Geographic Region Code, Distribution Center Number |
| Incremental Data | Snapshot |
| File Format | orc, parquet |
| Target Refresh Time | Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST |
| History | NA |
Feed Structure
The following table provides the DC Dimensions structure.
| Sequence | Business Name | Technical Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|---|
| 1 | Distribution Center Number | dc_nbr | Integer | Y | - | Whse Nbr |
| 2 | Geographic Region Code | geo_region_cd | String | Y | - | - |
| 3 | Operational Company Code | op_cmpny_cd | String | - | - | - |
| 4 | State/Province Code | st_prov_cd | String | - | - | Whse State |
| 5 | Distribution Center Name | dc_nm | String | - | - | IDC Desc |
| 6 | City Name | city_nm | String | - | - | City |
| 7 | Street Address Line 1 | st_addr_line_1 | String | - | - | Street Address |
| 8 | Time Zone Name | tz_nm | String | - | - | - |
| 9 | Business Unit Format Name | bu_fmt_nm | String | - | - | - |
| 10 | Base Division Number | base_div_nbr | Integer | - | - | - |
| 11 | Store Type Description | store_type_desc | String | - | - | - |
| 12 | County Name | cnty_nm | String | - | - | - |
| 13 | Business Gross Size Quantity | bu_gross_size_qty | Integer | - | - | - |
| 14 | Business Size Unit of Measure Code | bu_size_uom_cd | String | - | - | - |
| 15 | Banner Description | banner_desc | String | - | - | - |
| 16 | Public Close Date | public_close_dt | Date | - | - | - |
| 17 | Street Address Line 2 | st_addr_line_2 | String | - | - | - |
| 18 | Time Zone Code | tz_cd | String | - | - | - |
| 19 | Grand Open Date | grand_open_dt | Date | - | - | - |
| 20 | Open Status Code | open_status_cd | String | - | - | - |
| 21 | Address Country Code | addr_cntry_cd | String | - | - | - |
| 22 | Open Status Description | open_status_desc | String | - | - | - |
| 23 | Latitude Degree | lat_dgr | Decimal (9,6) | - | - | - |
| 24 | Banner Code | banner_cd | String | - | - | - |
| 25 | Street Address Line 3 | st_addr_line_3 | String | - | - | - |
| 26 | Daylight Savings Time Zone Indicator | daylight_sav_tz_ind | Integer | - | - | - |
| 27 | Store Type Code | store_type_cd | String | - | - | - |
| 28 | Street Address Line 4 | st_addr_line_4 | String | - | - | - |
| 29 | Daylight Savings Time Zone Name | dst_tz_nm | String | - | - | - |
| 30 | Longitude Degree | long_dgr | Decimal (9,6) | - | - | - |
| 31 | Zip Code Or Postal Code | postal_cd | String | - | - | Whse Zip Code |
©️Walmart | All Rights Reserved | Confidential