Walmart.com EDI 850 Ship-to-Home Notes

Walmart.com EDI 850 Ship-to-Home / Ship-to-Store Mapping Notes



Below are EXTOL EBI map (rulesets) templates. These templates include the following:

  • Ruleset
  • Collaboration
  • Endpoints
  • Business Process Script(s)
  • Documentation
  • Sample X12 data



Some notes:
1. We need to determine if the order is S2S or S2H.
2. We need to consider gift messages. They are being sent at the detail level
3. We have to capture the carrier code (digits) and cross walk them to a SCAC code.

REF*CO
Segment Notes
Contains the customer's order number (13-digit numeric) that will appear on the packing slip. Note: This number may not be unique across all Purchase Orders.

REF*ST
Segment Notes
Contains the Wal-mart Store Number for ship to store orders

REF*VR
Segment Notes
Walmart.com Assigned Facility id Number. This segment will be send only if the vendor has multiple ship points or Facilities. REF-02 has the Facility Number from where the order is to be shipped.

DTM (Header)
002 Delivery Requested
806 Customer Order
Segment Notes
There is always a DTM segment containing the date the order was placed (DTM01 = "806") for the customer's packing slip.
There may be a DTM segment containing a date on which the customer has requested the item be delivered (DTM01 = "002"). This option is not supported by all suppliers.


N1
BT Bill-to-Party
RT Returned to
ST Ship To
Segment Notes
This loop contains three addresses related to this Purchase Order, and this segment (N101) defines the type of data to follow.
The N1 loop when N101=ST (Ship to) address is always send in the 850.
The N1 loop when N101=BT (Bill To) address is not send for payment methods Paypal or gift cards. In this case the ‘Ordered By’ Name and address is to be blank in the packing slip.


N1*REF
REF01 = "OD": Returns TC Number to be printed on the customer's packing slip.
Segment Notes
Segments mandatory with REF01 = "4N" and “OD” for N101 = "ST".


TD503
Usage Notes
A carrier method code as defined by Walmart.com. The value of this element determines whether this is a site-to-home or site-to-store order.

Carrier codes for site-to-store orders are – 77,78,79,80, 88, 90, 92 and 97 (highlighted in blue in the list below).
X AN 2/80
Code Name
01 USPS 3rd Class
02 UPS Ground
03 Clark Transport
04 Yellow Freight System
05 USPS Express Mail
07 USPS 4th Inter
08 UPS Basic
09 UPS Second day Air
10 USPS First Class
12 Silver Star
13 UPS Second Day Ground
14 Consolidation
16 UPS Next Day Air
17 Common Carrier
19 FedEx Express Saver (3 Day Service)
20 FedEx Ground
21 FedEx Priority Overnight
22 FedEx Two Day
23 FedEx Priority Overnight (duplicate or 21)
24 FedEx Standard Overnight (PM Delivery)
26 UPS Next Day Air Saver
29 UPS 3 Day Select
30 USPS Priority Mail
31 USPS Priority Mail
32 OLD Dominion Freight Line LTL
33 Newgistics
34 Airborne Ground Delivery
35 Airborne Express
36 Airborne
37 Airborne 2-DAY
38 UPS Ground
41 ABF Freight System
42 Bekins
43 Pilot Freight Basic Delivery
44 FedEx Priority Overnight w/Saturday Delivery
45 UPS Next Day Air Saver (Saturday Delivery)
46 SmartMail
47 USPS Media Mail
48 USPS Bound Printed Matter
50 Bekins Premium
51 USA Truck
52 Contract Freighers, Inc
53 Crete Carrier
54 Eagle Global Logistics - Three Day Service
55 Eagle Global Logistics - Economy
56 US Xpress
57 Heartland Express
58 Dart Transit
61 UPS Ground (CTN, GA)
62 UPS Ground (Parsippany, NJ)
63 UPS Ground (Chicago, IL)
64 UPS Ground (Vernon, CA)
65 FedEx SmartPost - BMC
66 FedEx SmartPost - DDU
67 FedEx Home Delivery
68 Streamlite
69 UPS Mail Innovations BPM
70 UPS Mail Innovations
71 USPS
72 Sun Delivery, Inc
73 APX-DDU
74 APX-BMC
77 Direct to Store FedEx Priority Overnight
78 Direct to Store FedEx Two Day
79 Direct to Store FedEx, Ground
80 Direct to Store UPS, Ground
81 In-Store delivery through WPM RDC
82 Seko Worldwide
83 DHL@home
84 DHL@home(expedited)
85 DHL 2nd Day
86 DHL Next Day 03:00pm
87 FTD Florist
88 Direct to Store UPS Next Day Air
89 1 Hour Burn on Demand
90 Direct to Store – Freight
91 In-Store delivery through Bypass WPM
92 Direct to Store via UPS Ground Sort (Jewelry & Media)
95 Fulfilled with Inventory from a Wal-Mart Store
96 Wal_Mart Fleet for In-Store Pickup
97 Direct to Store UPS, second Day Air
98 Downloads
99 In-Store Pickup
100 DHL Next Day 12:00pm
101 DHL Next Day w/Sat

Note : A list of actual applicable codes will be provided separately based on the item assortment

TD507
Location Qualifier
Usage Notes
If the customer chose in-store pickup, then TD507 and TD508 are required to specify the store number. All suppliers do not support this delivery method.

TD508
Location Identifier
Usage Notes
Wal-Mart Store Number if TD507 = "IS".

TD512
Service Level Code
Usage Notes
Code indicating the service level chosen by the customer for this order.

Code Name
ND Next Day Air
SE Second Day
SG Standard Ground
ZZ Mutually Defined

PID05
Usage Notes
Item description that appears on the customer's packing slip.

PO1-SAC
Segment Notes
These elements reflect retail prices that appear on the customer's packing slip.
SAC02 = "D340": Charge to the customer for each item - always present.
SAC02 = "G830": Charge to the customer for shipping and handling - always present.
SAC02 = "H850": Charge to the customer for sales tax - always present.

The below segments are not always present in the 850. These are for information only and not to be printed in the packing slip nor used for packing slip total calculations.
SAC02 = "H000": Allowance to the customer for customer service adjustment or promotion - present only if non-zero.
SAC02 = "H151": Charge to the customer for value-added service - present only if non-zero.


PO1-N9*QY
Segment Notes
These segments contain value-added services that the customer has requested (N901 = "QY") or dynamic-data elements for item configuration (N901 = "S2"). The N9 segments with N901=QY will be send when the order is a Gift order with Gift message, Gift wrapping or Gift Tag.

PO1-N9-MSG
Segment Notes
If N901 = "QY", then there is one MSG element for each value-added service data element. MSG01 will contain a name/value pair separated by a "|" character (e.g. "LINE1|Hi Mom").
There will 4 MSG segments containing 4 lines of text when MSG-02=VGM. The messages have to be printed in the packing slip body under the item description.

If N901 = "S2", then there are MSG segments containing the dynamic-data value corresponding to the N903 dynamic-data name. The data will be split into 264 character blocks, so there may be one or many MSG segments depending on the length of the data.






By: on
EXTOL Business Partner Logo

Cleo/ERP Set-ups

We have examples for many ERPs that interface with Cleo. We customize interfaces for JDEdwards, SAP, VAI/S2K, and Oracle.