850 Purchase Order

Download this document in Word format from the following link:
Walmart.com Drop Ship Vendor_850_4010_EDI.docx

Functional Group PO

This Draft Standard for Trial Use contains the format and establishes the data contents of the Purchase Order Transaction Set (850) for use in an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practices relative to the placement of purchase orders for goods and services. This transaction set should not be used to convey purchase order changes or purchase order acknowledgment information.

Heading

Detail

Summary

Notes

• N3/010: The number of line items (CTT01) is the accumulation of the number of PO1 segments.

Sample Spec 850 Files

---

S2HS2SPAYPALGIFT CARDDISCOUNTGIFTWRAPS2HS2SPAYPALGIFT CARDDISCOUNTGIFTWRAP

ISA*00* *00* *01*12571829 *12*8478505336*070413*1811*U*00401*000000014*0*T*>
GS*PO*12571829*8478505336*20070413*1811*000000007*X*004010
ST*850*0001
BEG*00*DS*12635837**20070413
REF*CO*8890500613298
CTP*RS**41.28*1*EA
CSH*SC
DTM*806*20180412
DTM*002*20180416
DTM*010*20180412
N9*ZZ*MARKETINGMSG
MSG*0*AA*1
MSG*0*AA*2
MSG*0*AA*3
MSG*0*AA*4
N9*ZZ*RETURNSMSG
MSG*0*AA*1
MSG*0*AA*2
MSG*0*AA*3
MSG*0*AA*4
N9*ZZ*LASTDELIVERYMSG
MSG*0*AA*1
MSG*0*AA*2
MSG*0*AA*3
MSG*0*AA*4
N1*ST*Tom Smith
N3*12323 ABC Street*
N4*lowell*MA*01854*USA
REF*4N*MC-1114
REF*OD*71324148259778701029
PER*RE*Tom Smith*TE*9780032345
TD5*O*93*02*********SG
PO1*1*1*EA*23.50*QE*BP*3335027*UP*0083645300100*VP*SW-306 PID*F****Star Wars Darth Vader Lightsaber - Episode III, .45 Scaled Re SAC*N*D340******33.63****15
SAC*N*G830******5.97****15
SAC*N*H850******1.68****15
CTT*1
SE*40*0001
GE*1*000000007
IEA*1*000000014

ST Transaction Set Header

To indicate the start of a transaction set and to assign a control number.
Usage Option: Must Use

• Pos: 010
• Max: 1
• Heading – Mandatory
• Loop: N/A
• Elements: 2

Element Summary

BEG Beginning Segment for Purchase Order

To indicate the beginning of the Purchase Order Transaction Set and transmit identifying numbers and dates.

• Pos: 020
• Max: 1
• Heading – Mandatory
• Loop: N/A
• Elements: 4
• Usage Option: Must use

Element Summary

REF Reference Identification 1

To specify identifying information.
Usage Option: Must use

• Pos: 050
• Max: >1
• Heading – Optional
• Loop: N/A
• Elements: 2

Element Summary

Segment Notes

Contains the customer's order number (13-digit numeric). Note: This number can not be unique across all Purchase Orders.

REF Reference Identification 2

To specify identifying information.
Usage Option: Must use (only for Site to Store Orders)

• Pos: 050
• Max: >1
• Heading – Optional
• Loop: N/A
• Elements: 2

Element Summary

Segment Notes

Contains the Walmart Store Number for ship-to-store orders.

REF Reference Identification 3

To specify identifying information.
Usage Option: Must use

• Pos: 050
• Max: >1
• Heading – Optional
• Loop: N/A
• Elements: 2

Element Summary

Segment Notes

Walmart Assigned Internal Vendor Number. This is not used even though it always sends in the order file.

REF Reference Identification 4

To specify identifying information.
Usage Option: Optional

• Pos: 050
• Max: >1
• Heading – Optional
• Loop: N/A
• Elements: 2

Element Summary

Segment Notes

Walmart.com Assigned Facility ID Number. This segment will be sent only if the vendor has multiple ship points or Facilities. REF-02 has the Facility Number from where the order is to be shipped.

CTP Pricing Information

To specify pricing information

• Pos: 090
• Max: >1
• Heading – Optional
• Loop: N/A
• Elements: 4

Element Summary

Segment Notes

Contains the total retail amount of this Purchase Order. It can be used to validate the data consistency of this message.

• Total retail price for this Purchase Order, including all lines, charges, and adjustments. Note: For gift orders, this value is zero.
• Always 1 unit quantity.

Usage Option: Must use

CSH Sales Requirements

To specify general conditions or requirements of the sale
Usage Option: Must use

• Pos: 110
• Max: 5
• Heading – Optional
• Loop: N/A
• Elements: 1

Element Summary

Segment Notes

Contains a code used to suppress split shipments within a facility. Use one of the following values:

• P2: Ship as soon as possible
• SC: Ship Complete

DTM Date/Time Reference

To specify pertinent dates and times
Usage Option: Must use

• Pos: 150
• Max: 10
• Heading – Optional
• Loop: N/A
• Elements: 2

Element Summary

Segment Notes

There is always a DTM segment containing the date the order was placed (DTM01 = “806”). There can 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. Other values are as follows:

• 002: Delivery Requested
• 806: Customer Order
• 010: Expected Ship Date (optional)
• 009: Order Processing Date (optional)

N9 Reference Identification

To transmit identifying information as specified by the Reference Identification Qualifier.
Usage Option: Must use

• Pos: 295
• Max: 1
• Heading – Optional
• Loop: N9
• Elements: 2

Element Summary

Segment Notes

The N9 segments with N9-01=ZZ are always sent in the order file. This is not to be used. Presently, the N9-02 always contains the following values.

• RETURNSMSG: Returns Message
• MARKETINGMSG: Marketing Message
• LASTDELIVERYMSG: Last Delivery Message

MSG Message Text 1

To provide a free-form format that allows the transmission of text information.
Usage Option: Must use

• Pos: 300
• Max: 1000
• Heading – Optional
• Loop: N9
• Elements: 3

Element Summary

Segment Notes

• The MSG segments with MSG-02=AA are always sent in the order file. This is not to be used
• Each message can have four lines and contain up to 100 characters of data per line

N1 Name

To identify a party by type of organization, name, and code.
Usage Option: Must use

• Pos: 310
• Max: 1
• Heading – Optional
• Loop: N1
• Elements: 2

Element Summary

Segment Notes

This loop contains three addresses related to this Purchase Order, and this segment (N101) defines the type of data to follow. The codes for N101 that are available are BT, RT, ST, and FD.

• BT: Bill-to-party – The N1 loop when N101=BT (Bill To) address is optional
• RT: Returned to
• ST: Ship To – The N1 loop when N101=ST (Ship to) address is always sent in the 850.
• FD: Physical Address – FD is used to specify the physical address of a Walmart facility for the case of orders using ship codes 81 and 91 (Wal-Mart transportation ). In that case, the optional N103/N104 elements are populated to provide the Walmart ID number for the facility, and N102 will be populated with ‘RDC’ or ‘WPM’ for this case.

N3 Address Information

To specify the location of the named party.
Usage Option: Must use

• Pos: 330
• Max: 2
• Heading – Optional
• Loop: N1
• Elements: 2

Element Summary

N4 Geographic Location

To specify the geographic place of the named party.
Usage Option: Must use

• Pos: 340
• Max: >1
• Heading – Optional
• Loop: N1
• Elements: 4

Element Summary

Segment Notes

• N404: Use the ISA ALPHA-3 Country Code.
• N405: GL used only for Integrated Shipping (backhaul)
• N406: GLN (Global Location Number of the facility) used only for Integrated Shipping (backhaul)

REF Reference Identification 5

To specify identifying information.
Usage Option: Dependent

• Pos: 350
• Max: 12
• Heading – Optional
• Loop: N1
• Elements: 3

Element Summary

Segment Notes

• REF01 = “4N”: Description of billing payment method. For gift orders, this is replaced by non-descriptive text.
• REF01 = “OD”: Returns TC Number
• REF01 = “PN”: Returns Permit Number. Additional data is populated in REF04.
• REF01 = “PHC”: Returns Method Code of “RC” (Not pre-paid), “RP” (pre-paid) or “RS” (return to vendor).
• REF04 Only used if REF01 = “PN”

PER Administrative Communications Contact

To identify a person or office to whom administrative communications should be directed.
Usage Option: Dependent

• Pos: 360
• Max: >1
• Heading – Optional
• Loop: N1
• Elements: 6

Element Summary

Segment Notes

• Segment mandatory with PER01 = “BI” for N101 = “BT”
• Segment mandatory with PER01 = “RE” for N101 = “ST”

For the PER01 Contact Function Code, use one of the following:

• BI: Bill Inquiry Contact
• RE: Receiving Contact

TD5 Carrier Details (Routing Sequence/Transit Time)

To specify the carrier and sequence of routing and provide transit time information.
Usage Option: Dependent

• Pos: 390
• Max: 12
• Heading – Optional
• Loop: N1
• Elements: 6

Element Summary

Segment Notes

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

• TD508 value is the store number if TD507 = ‘IS’

TD512 is the service level chosen by the customer for this order. TD512 can use one of the following codes:

• ND: Next Day Air
• SE: Second Day
• SG: Standard Ground
• ZZ: Mutually Defined
• DF: Value Shipping

TD503 can use one of the following codes:

PO1 Baseline Item Data

To specify basic and most frequently used line item data
Usage Option: Must Use

• Pos: 010
• Max: 1
• Detail – Mandatory
• Loop: PO1
• Elements: 11

Element Summary

Segment Notes

PO101 is a unique identifier for this Purchase Order Line. This number is necessary when responding with a status update or shipping notification.

PID Product/Item Description

To describe a product or process in coded or free-form format.
Usage Option: Must Use

• Pos: 050
• Max: 1
• Detail – Optional
• Loop: PID
• Elements: 2

Element Summary

Segment Notes

SAC Service, Promotion, Allowance, or Charge Information

To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge.
Usage Option: Must Use

• Pos: 130
• Max: 1
• Detail – Optional
• Loop: SAC
• Elements: 5

Element Summary

Segment Notes

• SAC02 can have one of several values listed as follows:
  • D340: Goods and Services Charge. Charge to the customer for each item – always present.
  • G830: Shipping and Handling. Charge to the customer for shipping and handling – always present.
  • H000: Special Allowance – Allowance to the customer for customer service adjustment or promotion – present only if non-zero.
  • H151: Special Services – Charge to the customer for value-added service – present only if non-zero.
  • H850: Tax – Charge to the customer for sales tax – always present.
• SAC08 should be the retail price per unit. For gift orders, this value is zero.
• SAC15: A free-text description is supplied if SAC02 is “H000” or “H151”

N9 Reference Identification 2

To transmit identifying information as specified by the Reference Identification Qualifier Usage Option: Dependent

• Pos: 330
• Max: 1
• Detail – Optional
• Loop: N9
• Elements: 4

Element Summary

Segment Notes

• N901 can be one of the following values:
  • QY: Service Performed Code
  • S2: Data Source
• N902: If N901 = “QY”, then N902 is a value-added service code as defined by Walmart.com:
  • VGM: Gift Message (Four lines)
  • VGT: Gift Tag (to/from)
  • VGW: Gift Wrapping
  • VSR: Signature on Delivery
• N903: If N901 = “S2”, then this is the name of a dynamic data element
• N907: If N901 = “QY”, then this contains a unique sequence number for each value-added service request

MSG Message Text 2

To provide a free-form format that allows the transmission of text information
Usage Option: Dependent

• Pos: 340
• Max: 1000
• Detail – Optional
• Loop: N9
• Elements: 1

Element Summary

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 N9-02=VGM. When N9-02=VSR ,MSG-01 =SOD|Y for signature on delivery

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 can be one or many MSG segments depending on the length of the data.

CTT Transaction Totals

To transmit a hash total for a specific element in the transaction set
Usage Option: Must Use

• Pos: 010
• Max: 1
• Summary – Optional
• Loop: CTT
• Elements: 1

Element Summary

SE Transaction Set Trailer

To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
Usage Option: Must Use

• Pos: 030
• Max: 1
• Summary – Mandatory
• Loop: N/A
• Elements: 2

Element Summary