Omni Item Dimensions Details & Structure

Omni Item Dimensions will act as a single, authoritative, and governed view of every item’s physical and packaging attributes across channels.

Endpoints

GET
/bulkfeeds/snapshot/omniitemdim

Feed Details

The following table provides the Omni Item Dimensions feed details.

SpecificationDetails
Feed TypeDimension
Feed AvailabilitySupplier,Catman and Media
Refresh FrequencyDaily
Data GrainCatalog Item ID, Geographic Region Code ,Operational Company Code, Walmart Item Number
Incremental Datasnapshot
File Formatcsv,orc,parquet
Target Refresh Time(SLA)Monday - Friday: 3:00 PM CST.
Saturday, and Sunday: 11:30 PM CST.
HistoryNA

Feed Structure

The following table provides the Omni Item Dimensions feed structure.

SequenceTechnical NameBusiness NameData TypePrimary KeySensitive MetricsDSS Mapping
55catlg_item_idCatalog Item ID / eComm Prod IDLongY--
330wm_item_nbrWalmart Item NumberLongY--
334geo_region_cdGeographic Region CodeStringY--
335op_cmpny_cdOperational Company CodeStringY--
1abstr_prod_idAbstract Product IDString---
2accpt_tempr_hi_qtyAcceptable Temperature High QuantityInteger---
3accpt_tempr_low_qtyAcceptable Temperature Low QuantityInteger---
4acct_nbrAccount NumberInteger---
5acct_nbr_type_cdAccount Number Type CodeInteger---
6acct_nbr_type_descAccount Number Type DescriptionString---
7acctg_dept_descAccounting Department DescriptionString---
8acctg_dept_nbrAccounting Department NumberInteger---
9actv_cdActivity CodeString---
10actv_descActivity DescriptionString---
11aerosol_indAerosol IndicatorInteger---
12alcohol_pctAlcohol PercentageDecimal(5,2)---
13all_links_item_desc_1All Links Item DescriptionString---
14all_links_item_nbrAll Links Item NumberInteger---
15all_links_mds_fam_idAll Links Store Item IdInteger---
16alt_chnl_src_indAlternate Channel Sourcing IndicatorInteger---
17asort_type_cdAssortment Type CodeInteger---
18asort_type_descAssortment Type DescriptionString---
19assem_ht_qtyAssembled Height QuantityDecimal(18,7)---
20assem_ht_uom_cdAssembled Height Unit of Measure CodeString---
21assem_len_qtyAssembled Length QuantityDecimal(18,7)---
22assem_len_uom_cdAssembled Length Unit of Measure CodeString---
23assem_wdth_qtyAssembled Width QuantityDecimal(18,7)---
24assem_wdth_uom_cdAssembled Width Unit of Measure CodeString---
25assem_wt_qtyAssembled Weight QuantityDecimal(18,7)---
26assem_wt_uom_cdAssembled Weight Unit of Measure CodeString---
27assoc_disc_indAssociate Discount IndicatorInteger---
28backrm_scale_indBackroom Scale IndicatorInteger---
29base_div_nbrBase Division NumberInteger---
30base_item_idBase Item IDLong---
31base_rtl_uom_cdBase Retail UOM CodeString---
32base_rtl_uom_descBase Retail UOM DescriptionString---
33base_unit_rtl_amtBase Unit Retail AmountDecimal(11,2)---
34base_wpidBase Walmart Product IDString---
35battery_indBattery IndicatorInteger---
36battery_type_cdBattery Type CodeInteger---
37battery_type_descBattery Type DescriptionString---
38brand_class_descBrand Class DescriptionString---
39brand_fam_idBrand Family IDInteger---
40brand_fam_nmBrand Family NameString---
41brand_idBrand IDInteger---
42brand_nmBrand NameString---
43brand_ownr_idBrand Owner IDInteger---
44brand_ownr_nmBrand Owner NameString---
45buyer_full_nmBuyer NameString---
46buyer_useridBuyer User IDString---
47buyg_region_cdBuying Region CodeInteger---
48buyg_region_descBuying Region DescriptionString---
49buyr_rpt_postn_idBuyer Reporting Position IDInteger---
50canned_order_indCanned Order IndicatorInteger---
51case_upc_fmt_cdCase UPC Format CodeInteger---
52case_upc_fmt_descCase UPC Format DescriptionString---
53case_upc_nbrCase UPC NumberDecimal(15,0)---
54catch_wt_indCatch Weight IndicatorInteger---
56chem_indChemical IndicatorInteger---
57cmpnt_cntry_of_orign_nmComponents Country of Origin NameString---
58cncl_when_out_indCancel When Out IndicatorInteger---
59cnsumable_div_nbrConsumable Division numberInteger---
60cntrl_substance_indControlled Substance IndicatorInteger---
61cntry_nmCountry NameString---
62color_descColor DescriptionString---
63commodity_idCommodity IDInteger---
64cons_item_descConsumer Item DescriptionString---
65cons_item_nbrConsumer Item NumberInteger---
66convey_indConveyable IndicatorInteger---
67cpsc_cert_indCPSC Certificate IndicatorInteger---
68crush_fctr_cdCrush Factor CodeInteger---
69crush_fctr_descCrush Factor DescriptionString---
70ctent_qlty_score_nbrContent Quality ScoreDecimal(18,5)---
71cust_base_rtl_amtCustomer Base Unit Retail AmountDecimal(11,2)---
72cust_ratg_avg_valCustomer Average Rating ValueDecimal(4,3)---
73cust_ratg_cntCustomer Rating CountDecimal(15,0)---
74cvi_have_it_indCVI Have It IndicatorInteger---
75dc_dea_rpt_indDC Drug Enforcement Agency IndicatorInteger---
76dest_cdGrocery Item Destination CodeInteger---
77dest_descGrocery Item Destination DescriptionString---
78diet_type_cdDiet Type CodeInteger---
79diet_type_descDiet Type DescriptionString---
80ecomm_item_indE-commerce Item IndicatorInteger---
81ecomm_upc_nbrUniversal Product Code NumberString---
82electronc_waste_indElectronic Waste IndicatorInteger---
83elig_put_indPut Eligibility IndicatorInteger---
84elig_s2h_indS2H Eligibility IndicatorInteger---
85est_out_of_stock_dtEstimated Out of Stock DateDate---
86fhs_dc_slot_cdFire Health and Safety Distribution Center SlotInteger---
87fhs_dc_slot_descFire Health and Safety Distribution Center DescriptionString---
88fineline_descFineline DescriptionString---
89fineline_nbrFineline NumberInteger---
90fsa_indFSA IndicatorInteger---
91future_effective_dateFuture Effective DateDate---
92future_vnpk_cost_amtFuture Vendor Pack Cost AmountDecimal(38,9)-Y-
93gift_card_face_amtGift Card Face AmountDecimal(11,2)---
94gift_card_fee_amtGift Card Fee AmountDecimal(9,2)---
95gift_card_fee_pctGift Card Fee PercentageDecimal(5,3)---
96gift_card_type_cdGift Card Type CodeInteger---
97gift_card_type_descGift Card Type DescriptionString---
98grp_item_nmGroup Item NameString---
99gtinGTINString---
100guar_sales_indGuaranteed Sales IndicatorInteger---
101ideal_tempr_hi_qtyIdeal Temperature HI QtyInteger---
102ideal_tempr_low_qtyIdeal Temperature LOW QtyInteger---
103ideal_tempr_uom_cdIdeal Temperature Unit of Measure CodeString---
104infrm_reord_type_cdInforem Reorder Type CodeString---
105infrm_reord_type_descInforem Reorder Type DescriptionString---
106intangible_indIntangible Item IndicatorInteger---
107item_cost_amtItem Cost AmountDecimal(13,4)-Y-
108item_create_dtItem Create DateDate---
109item_cube_qtyItem Cube QuantityDecimal(9,3)---
110item_cube_uom_cdItem Cube UoM CodeString---
111item_cube_uom_descItem Cube Unit of Measure DescriptionString---
112item_desc_2Item Description 2String---
113item_dim_uom_cdItem Dimension Unit Of Measure CodeString---
114item_dim_uom_descItem Dimension Unit Of Measure DescriptionString---
115item_expire_dtItem Expiry DateDate---
116item_ht_qtyItem Height QuantityDecimal(9,3)---
117item_import_indItem Import IndicatorInteger---
118item_len_qtyItem Length QuantityDecimal(9,3)---
119item_nameItem NameString---
120item_order_eff_dtItem Order Effective DateDate---
121item_repl_indItem Replenishment IndicatorInteger---
122item_scannable_indItem Scannable IndicatorInteger---
123item_share_indItem Share IndicatorString---
124item_share_cost_indItem Share Cost IndicatorString---
125item_status_cdItem Status CodeString---
126item_status_chng_dtItem Status Change DateDate---
127item_status_descItem Status DescriptionString---
128item_sync_status_cdItem Synchronized Status CodeInteger---
129item_sync_status_descItem Synchronized Status DescriptionString---
130item_type_cdItem Type CodeInteger---
131item_type_descItem Type DescriptionString---
132item_wdth_qtyItem Width QuantityDecimal(9,3)---
133item_wt_qtyItem Weight QuantityDecimal(11,4)---
134item_wt_uom_cdItem Weight Unit of Measure CodeString---
135item_wt_uom_descItem Weight Unit of Measure DescriptionString---
136itemfile_src_nmItem File Source NameString---
137kit_comp_indPart of Bundle (Y/N)Integer---
138last_order_dtLast Order DateDate---
139lic_cdLicense CodeInteger---
140lic_descLicense DescriptionString---
141lifecyc_status_nmCurrent Display StatusString---
142master_carton_indMaster Carton IndicatorInteger---
143mds_fam_idStore Item IDLong---
144mdse_pgm_idMerchandise Program IDInteger---
145mdse_subgroup_descOmni Subgroup DescriptionString---
146mdse_subgroup_nbrOmni Subgroup NumberInteger---
147mercury_indMercury IndicatorInteger---
148mfg_cmpny_idManufacturer Company ID(s)String---
149mfgr_pre_price_amtManufacturer Pre-Price AmountDecimal(18,2)---
150mfgr_sugd_rtl_amtManufacturer Suggested Retail AmountDecimal(18,2)---
151min_price_indMinimum Price IndicatorInteger---
152min_rcvng_days_qtyMinimum Receiving DaysInteger---
153min_whse_life_qtyMinimum Wholesale Life QuantityInteger---
154modlr_base_mdse_cdModular Based Merchandising CodeString---
155modlr_base_mdse_descModular Based Merchandising DescriptionString---
156multi_pack_indMulti-pack IndicatorInteger---
157never_out_indNever Out IndicatorInteger---
158non_mbr_upchrg_indNon Member Upcharge IndicatorInteger---
159obsolete_dtItem End DateDate---
160offr_end_dtOffer End DateDate---
161offr_start_dtOffer Start DateDate---
162omni_catg_descOmni Category DescriptionString---
163omni_catg_grp_descOmni Category Group DescriptionString---
164omni_catg_grp_nbrOmni Category Group NumberLong---
165omni_catg_nbrOmni Category NumberLong---
166omni_dept_descOmni Department DescriptionString---
167omni_dept_nbrOmni Department NumberLong---
168omni_seg_descOmni Segment DescriptionString---
169omni_seg_nbrOmni Segment NumberLong---
170omni_subcatg_descOmni Subcategory DescriptionString---
171omni_subcatg_nbrOmni Subcategory NumberLong---
172order_dept_nbrOrder Department NumberInteger---
173order_sizng_fctr_qtyOrder Sizing Factory QuantityDecimal(9,3)---
174orign_cntry_cd_arrayOrigin Country CodeString---
175osa_supplier_idOSA Supplier IDInteger---
176own_repl_indCurrent Replenishment FlagInteger---
177pallet_hi_qtyPallet HI QuantityInteger---
178pallet_rnd_pctPallet Rounding PercentDecimal(3,2)---
179pallet_size_cdPallet Size CodeString---
180pallet_ti_qtyPallet TI QuantityInteger---
181pallet_upc_fmt_cdPallet UPC Format CodeInteger---
182pallet_upc_fmt_descPallet UPC Format DescriptionString---
183pallet_upc_nbrPallet UPC NumberDecimal(15,0)---
184paper_wood_indPaper Wood IndicatorInteger---
185perfm_ratg_cdPerformance Rating CodeInteger---
186perfm_ratg_descPerformance Rating DescriptionString---
187pesticide_indPesticide IndicatorInteger---
188plnr_rpt_postn_idPlanner Reporting Position IDInteger---
189plu_nbrPrice Look Up NumberInteger---
190price_comp_qtyPrice Comparison QtyDecimal(9,4)---
191price_comp_uom_cdPrice Comparison UOM CodeString---
192price_type_nmCurrent Price Display CodeString-Y-
193prime_lia_item_nbrPrime Lia Item NumberInteger---
194prime_lia_mds_fam_idPrime Lia MDS Fam IDInteger---
195prime_upc_item_nbrPrime UPC Item NumberInteger---
196prime_upc_mds_fam_idPrime UPC MDS Fam IDInteger---
197prime_xref_item_descPrime Item descriptionString---
198prime_xref_item_nbrPrime Item NumberInteger---
199prime_xref_mds_fam_idPrime MDS Fam IDInteger---
200prmpt_price_indPrompt Price IndicatorInteger---
201prmry_catg_path_cdprimary product category codeString---
202prmry_catg_path_nmprimary product categoryString---
203prmry_offr_idPrimary Offer IDString---
204prmry_shelf_idPrimary Shelf IDInteger---
205prod_class_type_idProduct Class Type IDInteger---
206prod_class_type_nmProduct Class Type NameString---
207prod_clsfctn_hrchy_node_idProduct Classification Hierarchy Node IDDecimal(18,0)---
208prod_cost_dsv_amtProduct Cost Direct Store Vendor AmountDecimal(18,5)-Y-
209prod_cost_own_amtProduct Cost Own AmountDecimal(18,5)-Y-
210prod_descProduct DescriptionString---
211prod_extd_descProduct Extended DescriptionString---
212prod_grp_class_type_nmProduct Group Class Type NameString---
213prod_lifecyc_status_chng_tsProduct Lifecycle Status Change TimestampTimestamp---
214prod_nbrProduct NumberInteger---
215prod_nmProduct NameString---
216prod_pub_status_chng_tsProduct Group Class Type NameTimestamp---
217prod_pub_status_nmProduct Publication Status NameString---
218prod_type_nmProduct Type NameString---
219proj_yr_sale_qtyProjected Year Sale QtyInteger---
220promo_order_book_cdPromotion Order Book CodeInteger---
221promo_order_book_descPromotion Order Book DescriptionString---
222pvt_lbl_indPrivate Label IndicatorInteger---
223pvt_lbl_unbranded_indPrivate Label / Unbranded IndicatorInteger---
224qlty_cntrl_cdQC CodeInteger---
225qlty_cntrl_descQC DescriptionString---
226repl_group_nbrReplenishment Group NumberDecimal(18,0)---
227repl_subtype_cdReplenishment Subtype CodeInteger---
228repl_subtype_descReplenishment Subtype DescriptionString---
229repl_unit_indReplenishment Unit IndicatorInteger---
230rfid_indRFID IndicatorInteger---
231rppc_indRPPC IndicatorInteger---
232rpt_hrchy_lvl1_idWalmart Order Department NumberInteger---
233rpt_hrchy_lvl3_descWalmart Order Department DescriptionString---
234rsrv_mdse_cdReserve Merchandise CodeInteger---
235rsrv_mdse_descReserve Merchandise DescriptionString---
236rsrv_mdse_indReserve MDSE IndicatorInteger---
237rtl_incl_vat_indRetail VAT IndicatorInteger---
238rtl_notif_store_indRetail Notify Store IndicatorInteger---
239rtn_resale_indReturn Resale IndicatorInteger---
240seasn_cdSeason CodeInteger---
241seasn_descSeason DescriptionString---
242seasn_yrSeason YearInteger---
243secur_tag_indElectronic Security Tag IndicatorInteger---
244segregation_cdSegregation CodeInteger---
245segregation_descSegregation DescriptionString---
246sell_qtySell QuantityDecimal(9,4)---
247sell_uom_cdSell Unit of Measure CodeString---
248sell_uom_descSell Unit of Measure DescriptionString---
249send_store_dtSend to Store DateDate---
250shelf_lbl_reqmt_indShelf Label Requirement IndicatorInteger---
251shelf_life_dys_qtyShelf Life Days QtyInteger---
252shelf_rotation_indShelf Rotation IndicatorInteger---
253shop_descShop DescriptionString---
254shpg_chrg_amtCurrent S2H Ship ChargeDecimal(18,5)---
255shpg_mthd_chrg_arrayCurrent Lowest Ship MethodMap<String,String>---
256signing_descSigning DescriptionString---
257size_descSize DescriptionString---
258sku_idSKU IDString---
259street_dtStreet DateDate---
260supplier_disp_indSupplier Display IndicatorInteger---
261tempr_sensitive_indTemperature Sensitive IndicatorInteger---
262tempr_uom_cdAcceptable Temperature Unit of Measure CodeString---
263upc_fmt_cdUPC Format CodeInteger---
264upc_fmt_descUPC Format DescriptionString---
265upc_hier_wm_item_nbrUPC Hierarchy Walmart Item NumberLong---
266var_comp_indVariable Comp IndicatorInteger---
267var_wt_indVariable Weight IndicatorInteger---
268variety_indVariety IndicatorInteger---
269vendor_dept_nbrVendor Department NumberInteger---
270vendor_nbrVendor NumberInteger---
271vendor_nmVendor NameString---
272vendor_seq_nbrVendor Sequence NumberInteger---
273vendor_stock_idVendor Stock IDString---
274vndr_first_avlbl_dtVendor First Available DateDate---
275vndr_first_order_dtVendor First Order DateDate---
276vndr_first_ship_dtVendor First Ship DateDate---
277vndr_incrm_order_qtyVendor Incremental Order QtyInteger---
278vndr_last_ship_dtVendor Last Ship DateDate---
279vndr_ld_tm_qtyVendor Lead TimeInteger---
280vndr_min_order_qtyVendor Minimum Order QuantityInteger---
281vndr_min_order_uom_cdVendor Minimum Order UOMString---
282vnpk_cost_amtVendor Pack Cost AmountDecimal(13,4)-Y-
283vnpk_cspk_cdVendor Case Pack CodeString---
284vnpk_cspk_descVendor Case Pack DescriptionString---
285vnpk_cube_qtyVendor Pack Cube QuantityDecimal(9,3)---
286vnpk_cube_uom_cdVendor Pack Cube UoM CodeString---
287vnpk_cube_uom_descVendor Pack Cube UoM DescriptionString---
288vnpk_dim_uom_cdVendor Pack Dimension UOM CodeString---
289vnpk_dim_uom_descVendor Pack Dimension UOM DescriptionString---
290vnpk_ht_qtyVendor Pack Height QuantityDecimal(9,3)---
291vnpk_len_qtyVendor Pack Length QuantityDecimal(9,3)---
292vnpk_net_wt_qtyVendor Pack Net Weight QuantityDecimal(11,4)---
293vnpk_net_wt_uom_cdVendor Pack Net Weight UOM CodeString---
294vnpk_qtyVendor Pack QuantityInteger---
295vnpk_wdth_qtyVendor Pack Width QuantityDecimal(9,3)---
296vnpk_wt_fmt_cdVendor Pack Weight Format CodeString---
297vnpk_wt_fmt_descVendor Pack Weight Format DescriptionString---
298vnpk_wt_qtyVendor Pack Weight QuantityDecimal(18,4)---
299vnpk_wt_uom_cdVendor Pack Weight UOM CodeString---
300vnpk_wt_uom_descVendor Pack Weight DescriptionString---
301whpk_calc_mthd_cdWarehouse Pack Calculation Method CodeString---
302whpk_calc_mthd_descWarehouse Pack Calculation Method DescriptionString---
303whpk_cube_qtyWarehouse Pack Cubic QuantityDecimal(9,3)---
304whpk_cube_uom_cdWarehouse Pack Cube UOM CodeString---
305whpk_cube_uom_descWarehouse Pack Cube UOM DescriptionString---
306whpk_dim_uom_cdWarehouse Pack Dimension UOM CodeString---
307whpk_dim_uom_descWarehouse Pack Dimension UOM DescriptionString---
308whpk_ht_qtyWarehouse Pack Height QuantityDecimal(9,3)---
309whpk_len_qtyWarehouse Pack Length QuantityDecimal(9,3)---
310whpk_net_wt_qtyWarehouse Pack Net Weight QuantityDecimal(11,4)---
311whpk_qtyWarehouse Pack QuantityInteger---
312whpk_sell_amtWarehouse Pack Sell AmountDecimal(13,4)---
313whpk_unit_costWarehouse Pack Unit CostDecimal(13,4)-Y-
314whpk_upc_fmt_cdWarehouse Pack UPC Format CodeInteger---
315whpk_upc_fmt_descWarehouse Pack UPC Format DescriptionString---
316whpk_upc_nbrWarehouse Pack UPC NumberDecimal(15,0)---
317whpk_wdth_qtyWarehouse Pack Width QuantityDecimal(9,3)---
318whpk_wt_qtyWarehouse Pack Weight QuantityDecimal(11,4)---
319whpk_wt_uom_cdWarehouse Pack Weight UoM CodeString---
320whpk_wt_uom_descWarehouse Pack Weight UoM DescriptionString---
321whse_algn_type_cdWarehouse Alignment Type CodeString---
322whse_algn_type_descWarehouse Alignment Type DescriptionString---
323whse_area_cdWarehouse Area CodeInteger---
324whse_area_descWarehouse Area DescriptionString---
325whse_max_order_qtyWarehouse Max Order QtyInteger---
326whse_min_order_qtyWarehouse Min Order QuantityInteger---
327whse_rotation_cdWarehouse Rotation CodeInteger---
328whse_rotation_descWarehouse Rotation DescriptionString---
329wm_item_indWalmart Item IndicatorInteger---
331wm_upc_descWalmart UPC DescriptionString---
332wm_upc_nbrUniversal Product Code NumberDecimal(18,0)---
333wpidWalmart Product IDString---



©️Walmart | All Rights Reserved | Confidential