Store Dim Columns

The Store Fulfillment (OPD) table provides information about all scheduled store fulfillment orders at Walmart item and store level.

The following provides Store Fulfillment (OPD) column details, in alphabetical order.

Technical Name	Business Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
addr_cntry_cd	Address Country Code	String	-	-	Country
banner_cd	Banner Code	String	-	-	-
banner_desc	Banner Description	String	-	-	-
base_div_nbr	Base Division Number	Integer	-	-	Subdiv
bu_comp_cd	Business Company Code	String	-	-	-
bu_comp_desc	Business Company Description	String	-	-	-
bu_gross_size_qty	Business Gross Size Quantity	Integer	-	-	-
bu_public_close_tm	Business Unit Public Close Time	String	-	-	-
bu_public_open_tm	Business Unit Public Open Time	String	-	-	-
bu_size_uom_cd	Business Size Unit of Measure Code	String	-	-	-
buo_area_nbr	Business Unit Area Number	Integer	-	-	-
buo_area_nm	BUO Area Name	String	-	-	-
city_nm	City Name	String	-	-	City
cnty_nm	County Name	String	-	-	Physical County Name
daylight_sav_tz_ind	Daylight Saving Timezone Indicator	Integer	-	-	Timezone Daylight Savings
drv_thru_pharm_ind	Drive Through Pharmacy Indicator	Integer	-	-	-
dst_tz_cd	Daylight Savings Time Zone Code	String	-	-	Time Zone Daylight Savings
dst_tz_nm	Daylight Savings Time Zone Name	String	-	-	Time Zone Daylight Savings
expnd_size_qty	Expand Size Quantity	Integer	-	-	Expansion Size SQFT
fin_close_dt	Close Date	Date	-	-	-
fin_open_dt	Financial Open Date	Date	-	-	Open Date
fin_rpt_cd	Financial Report Code	String	-	-	Financial Rpt Code
fips_cnty_cd	Federal Information Processing Standard County Code	String	-	-	-
geo_region_cd	Geographic Region Code	String	-	-	-
grand_open_dt	Grand Open Date	Date	-	-	Open Date
lat_dgr	Latitude Degree	Float	-	-	-
long_dgr	Longitude Degree	Float	-	-	-
market_nbr	Market Number	Integer	-	-	-
market_nm	Market Name	String	-	-	District
mdse_maj_zone_nbr	Merchandise Major Zone Number	Integer	-	-	MDSE Major Zone
mdse_sub_zone_nbr	Merchandise Sub Zone Number	Integer	-	-	MDSE Sub Zone
op_close_dt	Operation Close Date	Date	-	-	-
op_cmpny_cd	Operational Company Code	String	-	-	-
open_24_hr_ind	Open 24 HR Indicator	Integer	-	-	-
open_status_cd	Open Status Code	String	-	-	-
open_status_desc	Open Status Description	String	-	-	-
open_sun_ind	Open Sunday Indicator	Integer	-	-	Open Sunday Flag
ph_nbr	Phone Number	String	-	-	Phone Nbr
postal_cd	Zip Code or Postal Code	String	-	-	Zip Code
prmry_lang_cd	Primary Language Code	String	-	-	-
proto_nbr	Prototype Number	String	-	-	Store Prototype Nbr
public_close_dt	Public Close Date	Date	-	-	-
real_estat_proto_cd	Real Estate Prototype Code	String	-	-	-
region_nbr	Region Number	Integer	-	-	-
region_nm	Region Name	String	-	-	-
relo_flip_dt	Relocation Flip Date	Date	-	-	Expansion Open Date
seg_nbr	Segment Number	Integer	-	-	-
seg_nm	Segment Name	String	-	-	-
soft_open_dt	Soft Open Date	Date	-	-	Dry Run Date
st_addr_line_1	Street Address Line 1	String	-	-	Building Address
st_addr_line_2	Street Address Line 2	String	-	-	Street Address
st_addr_line_3	Street Address Line 3	String	-	-	Street Address
st_addr_line_4	Street Address Line 4	String	-	-	Street Address
st_prov_nm	State Province Name	String	-	-	State
state_prov_cd	State Province Code	String	-	-	Whse State
store_mgr_nm	Manager Name	String	-	-	Manager Last Name
store_nbr	Store Number	Integer	Y	-	Store Nbr
store_nm	Store Name	String	-	-	Store Name
store_type_cd	Store Type Code	String	-	-	-
store_type_desc	Store Type Description	String	-	-	Store Type Descr
subdivision_nbr	Subdivision Number	String	-	-	-
subdivision_nm	Subdivision Name	String	-	-	Subdiv
temp_close_dt	Temporary Close Date	Date	-	-	-
temp_reopn_dt	Temporary Reopen Date	Date	-	-	-
tz_cd	Time Zone Code	String	-	-	Time Zone Standard
tz_nm	Time Zone Name	String	-	-	Time Zone Standard
wea_zone_cd	Planting Zone Code	String	-	-	-