Data Transfer – EDI – DSV – EDI Data Transfer – US – API Doc

Electronic Data Exchange (EDI) Interface

Drop Ship Vendors can use Electronic Data Interchange (EDI) to transfer data between Walmart.com to perform various functions.

We provide specifications and examples for the Drop Ship Vendors to use EDI the interface.

Refer to the diagram below for a visual representation of how each of the standards in this section contribute to the workflow of an EDI process.

EDI File Naming Conventions

If you are using EDI in production (via SFTP), you will need to make note of the file naming convention Walmart will be expecting.

Note: For other connectivity’s such as AS2, Solution Providers, etc. – Naming Convention is not required.

Files to Walmart.com:

WMI_855PR_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi
WMI_856SH_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi
WMI_846IB_WWWWWWWWW_YYYYMMDD_HHMMSS_NNNNNN.edi
WMI_997FA_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi

Files from Walmart.com:

WMI_850PO_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi
WMI_860PC_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi
WMI_997FA_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi

Where:

VVVVVVVVV is the DSV ID assigned by Walmart.com
WWWWWWWWW is the DSV ID/DSV Facility ID assigned by Walmart.com
YYYYMMDD is an eight-digit file creation date (GMT date)
HHMMSS is a six-digit file creation time (24-hour GMT time)
NNNNNN is a six-digit random number.

EDI Delimiters

All the EDI files should use the below defined delimiters:

Segment: ~
Element: *
Field: >

Example (partial EDI 850 snippet):

ISA*00* *00* *01*12345678 *01*987654321
*180328*0027*U*00401*004360436*0*P*>~GS*PO*12345678*018978783*20180328*002737*1420623*X*004010~ST*850*0001~BEG*00*DS*9876769779896**20180328~

824 Application Device

To use the Application Advice Transaction Set (824) with an EDI environment, follow these guidelines.

Note: You can also view this information in Word format:

Functional Group AG

This Draft Standard for Trial Use contains the format and establishes the data contents of the Application Advice Transaction Set (824) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide the ability to report the results of an application system’s data content edits of transaction sets. The results of editing transaction sets can be reported at the functional group and transaction set level, in either coded or free-form format. It is designed to accommodate the business need of reporting the acceptance, rejection or acceptance with change of any transaction set. The Application Advice should not be used in place of a transaction set designed as a specific response to another transaction set (e.g., purchase order acknowledgment sent in response to a purchase order).

Heading

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	ST	Transaction Set Header	M	1			Must use
020	BGN	Beginning Segment	M	1			Must use

Detail

Pos	Id	Segment Name	Req	Max Use	Notes	Usage
010	OTI	Original Transaction Identification	M	1	see note 2/010	Must use
070	TED	Technical Error Description	O	1		Must use
080	NTE	Note/Special Instruction	O	100		Must use
090	SE	Transaction Set Trailer	M	1		Must use

Notes

2/010: The OTI loop is intended to provide a unique identification of the transaction set that is the subject of this application acknowledgment.

Sample Spec 824 File

ISA*00* *00* *01*12571829 *12*73987501ME*091104*2002*U*00401*000000131*0*T*>
GS*AG*12571829*6111970076*20060829*0849*000000874*X*004010
ST*824*0001
BGN*11*000010380*20060829*0849*GM
OTI*BP*1Q*80253*****000007681
TED*024*(ORN=12635837, LINENO=1) Line Update Failed: Order request n
NTE*ERN*ORN=12635837 LINENO=1
OTI*BP*1Q*80253*****000007681
TED*024*(ORN=12607936, LINENO=1) Line Update Failed: Order request n
NTE*ERN*ORN=12607936 LINENO=1
SE*9*0001
GE*1*000000874
IEA*1*000080646

ST Transaction Set Header

To indicate the start of a transaction set and to assign a control number

Pos: 010
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 2
Usage Option: Must use

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3	824	Application Advice
ST02	329	Transaction Set Control Number	M	AN	4/9	824	Application Advice

BGN Beginning Segment

To indicate the beginning of a transaction set. Identifies the original EDI file and when it was processed.

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

Element Summary

Usage Notes:

BGN02: Interchange Sequence Number (ISA13) from the original EDI message
BGN03: Date the original EDI file was processed
BGN04: Time the original EDI file was processed

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
BGN01	353	Transaction Set Purpose Code	M	ID	2/2	11	Response
BGN02	127	Reference Identification	M	AN	1/30
BGN03	373	Date	M	DT	8/8
BGN04	337	Time	X	TM	4/8
BGN05	623	Time Code	O	ID	2/2	GM	Greenwich Mean Time

OTI Original Transaction Identification

To identify the edited transaction set and the level at which the results of the edit are reported, and to indicate the accepted, rejected, or accepted-with-change edit result. Identifies the group of the original EDI message and an error detected within the group. If there were multiple errors, then there will be multiple OTI loop segments.

Pos: 010
Max: 1
Detail – Mandatory
Loop: OTI
Elements: 4
Usage Option: Must use

Element Summary

Usage Notes:

OTI03: Numeric reference code assigned to specific error conditions
OTI08: Group Control Number (GS06) from the original EDI message

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
OTI01	110	Application Acknowledgement Code	M	ID	1/2	BP	Batch Partial Accept/Reject
OTI02	128	Reference Identification Qualifier	M	ID	2/3	1Q	Error Identification Code
OTI03	127	Reference Identification	M	AN	1/30	00000	Default Code (see error description for details)
OTI08	28	Group Control Number	X	N0	1/9

TED Technical Error Description

To identify the error and, if feasible, the erroneous segment, or data element, or both. Includes a human-readable error message that describes the error condition. The message may be truncated to 60 characters.

Pos: 070
Max: 1
Detail – Optional
Loop: TED
Elements: 2
Usage Option: Must use

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
TED01	647	Application Error Condition Code	M	ID	1/3	024	Other Unlisted Reason
TED02	3	Free Form Message	O	AN	1/60

NTE Note/Special Instruction

To transmit information in a free-form format, if necessary, for comment or special instruction. Detailed debugging information about the error condition or the data that contained the error. If this information is more than 80 characters, then it’ll be split into multiple NTE segments.

Pos: 080
Max: 100
Detail – Optional
Loop: TED
Elements: 2
Usage Option: Must use

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
NTE01	363	Note Reference Code	O	ID	3/3	ERN	Error Notes
NTE02	352	Description	M	AN	1/80

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)

Pos: 090
Max: 1
Detail – Mandatory
Loop: N/A
Elements: 2
Usage Option: Must use

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10
SE02	329	Transaction Set Control Number	M	AN	4/9		22

846 Inventory Inquiry

To use the Inventory Inquiry and Advice Transaction set (846) with an EDI interface, follow the guidelines in this article.

Note: You can also view this article in Word format:

Functional Group IB

This Draft Standard for Trial Use contains the format and establishes the data contents of the Inventory Inquiry/Advice Transaction Set (846) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used in the following ways: (1) for a seller of goods and services to provide inventory information to a prospective purchaser, with no obligation to the purchaser to acquire these goods or services; (2) for a representative of a seller of goods and services to supply inventory information to that seller; (3) for one location to supply another location with inventory information; and (4) for an inquiry as to the availability of inventory with no obligation on the seller of goods and services to reserve that inventory.

Heading

Pos	Id	Segment Name	Req	Max Use
010	ST	Transaction Set Header	M	1
020	BIA	Beginning Segment for Inventory Inquiry/Advice	M	1
060	REF	Reference Identification	M	1

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat
010	LIN	Item Identification	M	1	LOOP ID – LIN
140	REF	Reference Identification	M	1	LOOP ID – LIN
320	QTY	Quantity	O	1	LOOP ID – QTY
340	MEA	Measurements	O	1	LOOP ID – QTY
355	DTM	Date/Time Reference	O	1	LOOP ID – QTY
356	DTM	Date/Time Reference	O	1	LOOP ID – QTY

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	CTT	Transaction Totals	M	1
020	SE	Transaction Set Trailer	M	1

Sample Inventory File

ISA*00*          *00*          *12*123456789012   *01*12571829       *200717*0601*U*00401*002382154*0*P*>
GS*IB*123456789012*12571829*20200717*06011177*1719732*X*004010
ST*846*00001
BIA*00*SI*055846*20200717*06011177
REF*VR*11223344*SAM WALTZ, LLC
LIN*1*UP*0088904833374*VN*VTH211A-9*BP*55672488
REF*ZZ*AC
QTY*17*120
MEA****DA*0*1
LIN*2*UP*0088904824734*VN*VTH211A-28*BP*55672567
REF*ZZ*AC
QTY*17*58
MEA****DA*0*1
LIN*3*UP*0088904803692*VN*ADR113B-5*BP*48553530
REF*ZZ*AC
QTY*17*26
MEA****DA*0*1
LIN*4*UP*0088904823903*VN*PLS726A-2020*BP*140038872
REF*ZZ*AC
QTY*17*567
MEA****DA*0*1
LIN*5*UP*0068372650923*VN*CY5146A-5*BP*15802629
REF*ZZ*AC
QTY*17*15
MEA****DA*0*1
LIN*6*UP*0088904857080*VN*SGU210A-3*BP*643599154
REF*ZZ*AC
QTY*17*0
MEA****DA*0*1
LIN*7*UP*0088904811292*VN*EVK226D-3*BP*48825966
REF*ZZ*AC
QTY*17*8
MEA****DA*0*1
LIN*8*UP*0088904818285*VN*EVK256A-3*BP*48825658
REF*ZZ*AC
QTY*17*0
MEA****DA*0*1
LIN*9*UP*0088904807829*VN*CLV121A-6*BP*48618577
REF*ZZ*AC
QTY*17*13
MEA****DA*0*1
LIN*10*UP*0088904817522*VN*EVK256S-3*BP*48826809
REF*ZZ*AC
QTY*17*30
MEA****DA*0*1
CTT*10
SE*45*00001
GE*1*1719732
IEA*1*002382154

ST Transaction Set Header

To indicate the start of a transaction set and to assign a control number

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

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3
ST02	329	Transaction Set Control Number	M	AN	4/9

BIA Beginning Segment for Inventory Inquiry/Advice

To indicate the beginning of an Inventory Inquiry/Advice Transaction Set.

Pos: 020
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 5

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
BIA01	353	Transaction Set Purpose Code	M	ID	2/2	00	Original
BIA02	755	Report Type Code	M	ID	2/2	SI	Seller Inventory Report
BIA03	127	Transaction Sequence Number	M	AN	1/30
BIA04	373	Date	M	DT	8/8
BIA05	337	Time	M	TM	4/8

REF Reference Identification

To specify identifying information.

Pos: 060
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3	VR	Vendor ID Number
REF02	127	Sender ID	M	AN	1/30
REF03	352	Sender Name	M	AN	1/80

LIN Item Identification

To specify basic item identification data.

Pos: 010
Max: 1
Detail – Mandatory
Loop: LIN
Elements: 7

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
LIN01	350	Assigned Identification	M	AN	1/20		Sequence Number
LIN02	235	Product/Service ID Qualifier	M	ID	2/2	UP	U.P.C. Consumer Package Code (1-5-5-1)
LIN03	234	UPC	M	AN	1/48		Walmart UPC
LIN04	235	Product/Service ID Qualifier	M	ID	2/2	VN	Vendor’s (Seller’s) Item Number
LIN05	234	Vendor SKU	M	AN	1/20		Supplier SKU or model number
LIN06	235	Product/Service ID Qualifier	X	ID	2/2	BP	Buyer’s Part Number
LIN07	234	Item Number	O	AN	1/13		Walmart.com item number

REF Reference Identification

To specify identifying information.

Pos: 140
Max: 1
Detail – Mandatory
Loop: LIN (Mandatory)
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3	ZZ	Mutually Defined
REF02	127	Availability Code	M	AN	1/2	see Notes	see Notes

Usage Notes

Many availability code values exist. They are listed and described below.
**Note: Two availability code values will automatically remove an item from the Walmart.com site catalog. The “NA” code is used if it’s possible that the item UPC may return at some time in the future and “DT” is used if the item UPC won’t return (e.g. UPC is discontinued). In either case, please send at least two consecutive updates messages before the UPC is removed from the inventory feed.**

Availability Codes:

AC: Active – Item can be ordered only if the number of items on hand is sufficient to fulfill the amount ordered. An On Hand Quantity is required and Minimum and Maximum Days to Ship are optional. If the Days are not specified, then 0 to 1 business days is assumed.
PO: Pre-Order – Supplier is accepting pre-orders for the item. An Availability Start Date is required to indicate when orders are expected to ship. In addition, an On Hand Quantity is required to determine how many items may be pre-ordered. After the start date, it acts like an active item (On Hand Quantity is required and Minimum and Maximum Days to Ship are optional).
JT: Just in Time – Item is stocked on demand. Minimum and Maximum Days to Ship are required to indicate how long it will take to fulfill an order.
BO: Build to Order – Item is pre-configured and manufactured on demand. Minimum and Maximum Days to Ship are required to indicate how long it will take to fulfill an order. Since the supplier configures these items before the order is placed, it’s assumed that the item will always ship and backorders aren’t allowed.
SE: Seasonal – Item is available, but it’s seasonal and orders are only accepted during a specified date range. Both Availability Start and End Dates are required to indicate the date range. Within the date range, it behaves like an active item (On Hand Quantity is required and Minimum and Maximum Days to Ship are optional).
RO: Run Out – Item is being discontinued and will not be restocked. The Availability End Date is required to indicate the last date on which orders will be accepted. Before the end date, it behaves like an active item (On Hand Quantity is required and Minimum and Maximum Days to Ship are optional).
NA: Not Active – Item isn’t available for purchase at this time.
DT: Deleted – Item isn’t available for purchase and may be deleted from the catalog.

QTY Quantity

To specify quantity information.

Pos: 320
Max: 1
Detail – Optional
Loop: QTY (Mandatory)
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
QTY01	673	Quantity Qualifier	M	ID	2/2	17	Quantity on Hand
QTY02	380	Quantity	X	R	1/15		On Hand Stock Quantity

MEA Measurements

To specify physical measurements or counts, including dimensions, tolerances, variances, and weights.

Pos: 340
Max: 1
Detail – Optional
Loop: QTY (Mandatory)
Elements: 4

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
MEA04	C001	Composite Unit of Measure	X
C00101	355	Unit or Basis for Measurement Code	M	ID	2/2	DA	Days
MEA05	740	Minimum Days	X	R	1/20
MEA06	741	Maximum Days	X	R	1/20

DTM Date/Time Reference

To specify pertinent dates and times.

Pos: 355
Max: 1
Detail – Optional
Loop: QTY (Mandatory)
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
DTM01	374	Date/Time Qualifier	M	ID	3/3	196	Start
DTM02	373	Availability Start Date	X	DT	8/8		Date the item will be available to sell (as CCYYMMDD)

DTM Date/Time Reference

To specify pertinent dates and times.

Pos: 356
Max: 1
Detail – Optional
Loop: QTY (Mandatory)
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
DTM01	374	Date/Time Qualifier	M	ID	3/3	197	End
DTM02	373	Availability End Date	X	DT	8/8		Last date the item will be available to sell (as CCYYMMDD)

CTT Transaction Totals

To transmit a hash total for a specific element in the transaction set.

Pos: 010
Max: 1
Summary – Mandatory
Loop: N/A
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CTT01	354	Number of Line Items	M	N0	1/6		number of LIN segments in the transaction

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).

Pos: 020
Max: 1
Summary – Mandatory
Loop: N/A
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10		Number of segments in a transaction (including ST and SE)
SE02	329	Transaction Set Control Number	M	AN	4/9

850 Purchase Order

Download this document in Word format from the link below:

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 within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice 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

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	ST	Transaction Set Header	M	1			Must use
020	BEG	Beginning Segment for Purchase Order	M	1			Must use
050	REF	Reference Identification	O	>1			Must use
090	CTP	Pricing Information	O	>1			Must use
110	CSH	Sales Requirements	O	5			Must use
150	DTM	Date/Time Reference	O	10			Must use
		LOOP ID – N9			1000
295	N9	Reference Identification	O	1		LOOP ID – N9	Must use
300	MSG	Message Text	O	1000		LOOP ID – N9	Must use
		LOOP ID – N1			200
310	N1	Name	O	1		LOOP ID – N1	Must use
330	N3	Address Information	O	2		LOOP ID – N1	Must use
340	N4	Geographic Location	O	>1		LOOP ID – N1	Must use
350	REF	Reference Identification	O	12		LOOP ID – N1	Dependent
360	PER	Administrative Communications Contact	O	>1		LOOP ID – N1	Dependent
390	TD5	Carrier Details (Routing Sequence/Transit Time)	O	12		LOOP ID – N1	Dependent

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
		LOOP ID – P01			100000
010	P01	Baseline Item Data	M	1		LOOP ID – P01	Must use
		LOOP ID – PID			1000
050	PID	Product/Item Description	O	1		LOOP ID – PID	Must use
		LOOP ID – SAC			25
130	SAC	Service, Promotion, Allowance, or Charge Information	O	1		LOOP ID – SAC	Must use
		LOOP ID – N9			1000
330	N9	Reference Identification	O	1		LOOP ID – N9	Dependent
340	MSG	Message Text	O	1000		LOOP ID – N9	Dependent

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
		LOOP ID – CTT			1
010	CTT	Transaction Totals	O	1		N3/010	Must use
030	SE	Transaction Set Trailer	M	1			Must use

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 Lightaber - 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3
ST02	329	Transaction Set Control Number	M	AN	4/9

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	Id	Element Name	Req	Type	Min/Max	Code	Name
BEG01	353	Transaction Set Purpose Code	M	ID	2/2	00	Original
BEG02	92	Purchase Order Type Code	M	ID	2/2	DS	Dropship
BEG03	324	Purchase Order Number	M	AN	1/22
BEG05	373	Date	M	DT	8/8		Date the Purchase Order was created

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3	CO	Customer Order Number
REF02	127	Reference Identification	X	AN	1/30

Segment Notes

Contains the customer’s order number (13-digit numeric). Note: This number may 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3	ST	Walmart Store Number
REF02	127	Reference Identification	X	AN	1/30

Segment Notes

Contains the Wal-mart 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3	IA	Internal Vendor Number
REF02	127	Reference Identification	X	AN	1/30

Segment Notes

Walmart Assigned Internal Vendor Number. This is not to be used even though always send 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3	VR	Facility ID Number
REF02	127	Reference Identification	X	AN	1/30

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.

CTP Pricing Information

To specify pricing information

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

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CTP01	687	Class of Trade Code	M	ID	2/2	RS	Resale
CTP03	212	Unit Price	M	R	1/17
CTP04	380	Quantity	M	R	1/15
CTP05	C001	Component Unit of Measure	OT	Comp
	355		M	ID	2/2	EA	Each

Segment Notes

Contains the total retail amount of this Purchase Order. It may 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CSH01	563	Sales Requirement Code	O	ID	2/2	P2	Ship as soon as possible

Segment Notes

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

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
DTM01	374	Date/Time Qualifier	M	ID	3/3		see Notes
DTM02	373	Date	X	DT	8/8

Segment Notes

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

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
N901	128	Reference Identification Qualifier	M	ID	2/3	ZZ	Mutually Defined
N902	127	Reference Identification	X	AN	1/30		see notes

Segment Notes

The N9 segments with N9-01=ZZ are always send in the order file. This is not to be used. Presently the N9-02 always contains the below mentioned 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
MSG01	933	Free-Form Message Text	M	AN	1/264
MSG02	934	Printer Carriage Control Code	X	ID	2/2	AA	Advance the Specified Number of Lines before Print
MSG03	1470	Number	O	N0	1/9		Message Line Number (1 to 4)

Segment Notes

The MSG segments with MSG-02=AA are always send in the order file. This is not to be used
Each message may 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
N101	98	Entity Identifier Code	M	ID	2/3		see notes
N102	93	Name	X	AN	1/60

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 which 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 send 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 code 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 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
N301	166	Address Information	M	AN	1/55
N302	166	Address Information	O	AN	1/55

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
N401	19	City Name	O	AN	2/30
N402	156	State or Province Code	O	ID	2/2
N403	116	Postal Code	O	ID	3/15
N404	26	Country Code	O	ID	2/3		see notes
N405	309	Location Qualifier	X	ID	1/2	GL	see notes
N406	310	Location Qualifier	O	AN	1/30	GLN	see notes

Segment Notes

N404: Use the ISA ALPHA-3 Country Code.
N405: GL used only for Integrated Shipping (backhaul)
N406: GLN (Global Location Number of 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
REF01	128	Reference Identification Qualifier	M	ID	2/3		see notes
REF02	127	Reference Identification	X	AN	1/30		see notes
REF04	C040	Reference Identifier	O	Comp	2/3	ZZ	Mutually Defined

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
PER01	366	Contact Function Code	M	ID	2/2		see notes
PER02	93	Name	O	AN	1/60
PER03	365	Communication Number Qualifier	X	ID	2/2	TE	Telephone
PER04	364	Communication Number	X	AN	1/80
PER05	365	Communication Number Qualifier	X	ID	2/2	EM	Electronic Mail
PER06	364	Communication Number	X	AN	1/80

Segment Notes

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

For 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
TD501	133	Routing Sequence Code	O	ID	1/2	O	Origin Carrier (Air, Motor, or Ocean)
TD502	66	Identification Code Qualifier	X	ID	1/2	93	Code assigned by the organization originating the transaction set
TD503	67	Identification Code	X	AN	2/80		see notes
TD507	309	Location Qualifier	O	ID	1/2	IS	In Store (see notes)
TD508	310	Location Identifier	X	AN	1/30		see notes
TD512	284	Service Level Code	X	ID	2/2		see notes

Segment 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 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:

CMID	XML	Carrier Method Name	CARRIER
9	9	UPS Second Day Air	UPS
17	17	Common Carrier	Common Carrier
18	18	FedEx Freight	FedEx
19	19	FedEx Express Saver (3-Day Service)	FedEx
20	20	FedEx Ground	FedEx
21	21	FedEx Priority Overnight	FedEx
22	22	FedEx 2-Day	FedEx
24	24	FedEx Standard Overnight (PM Delivery)	FedEx
31	31	USPS Priority Mail	USPS
43	43	Pilot Freight Basic Delivery	Pilot
65	65	FedEx Smartpost Over 1lb	Smartpost
66	66	FedEx Smartpost Under 1lb	Smartpost
67	67	FedEx Home Delivery	FedEx
68	20	FedEx Ground	FedEx
79	79	FedEx Ground – S2S	FedEx
80	80	UPS Ground – S2S	UPS
82	82	Seko Worldwide	Seko
90	90	Yellow Freight System – S2S	YRC
97	97	UPS Second Day Air – S2S	UPS
98	98	Downloads	In-Store Pickup
143	43	Pilot Freight Room of Choice Delivery	Pilot
155	55	Estes Forwarding Worldwide Basic Delivery	Estes
223	22	FedEx 2-Day	FedEx
243	43	Pilot Freight White Glove	Pilot
255	55	Estes Forwarding Worldwide Glove Delivery	Estes
267	67	FedEx Home Delivery	FedEx
355	55	Estes Forwarding Worldwide Room of Choice Delivery	Estes
443	43	Pilot Freight Unattended Delivery	Pilot
501	2	UPS Ground	UPS
545	146	NSD for DSV	Non Stop Delivery
6761	20	FedEx Ground Cold Split	FedEx
6762	67	FedEx Home Delivery Cold Split	FedEx
6763	20	FedEx Ground Cold Split	FedEx
6764	67	FedEx Home Delivery Cold Split	FedEx
6766	801	FedEx Ground Hot Split	FedEx
6767	802	FedEx Home Delivery Hot Split	FedEx
6768	801	FedEx Ground Hot Split	FedEx
6769	802	FedEx Home Delivery Hot Split	FedEx

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
PO101	350	Assigned Identification	O	AN	1/20		see notes
PO102	330	Quantity Ordered	X	R	1/15
PO103	355	Unit or Basis for Measurement Code	O	ID	2/2	EA	Each
PO104	212	Unit Price	X	R	1/17
PO105	639	Basis of Unit Price Code	O	ID	2/2	QE	Quoted Price per Each
PO106	235	Product/Service ID Qualifier	X	ID	2/2	BP	Buyer’s Part Number
PO107	234	Product/Service ID	X	AN	1/48		Walmart.com item SKU
PO108	235	Product/Service ID Qualifier	X	ID	2/2	UP	U.P.C. Consumer Package Code (1-5-5-1)
PO109	234	Product/Service ID	X	AN	1/48		Walmart Item UPC
PO110	235	Product/Service ID Qualifier	X	ID	2/2	VP	Vendor’s (Seller’s) Part Number
PO111	234	Product/Service ID	X	AN	1/48		Supplier’s item SKU

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
PID01	349	Item Description Type	M	ID	1/1	F	Free-form
PID05	352	Description	X	AN	1/80		Item description

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SAC01	248	Allowance or Charge Indicator	M	ID	1/1	N	No Allowance or Charge
SAC02	1300	Service, Promotion, Allowance, or Charge Code	X	ID	4/4		see notes
SAC08	118	Rate	O	R	1/9		see notes
SAC12	331	Allowance or Charge Method of Handling Code	O	ID	2/2	15	Information Only
SAC15	352	Description	X	AN	1/80		see notes

Segment Notes

SAC02 may have one of several values, listed below:
- 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
N901	128	Reference Identification Qualifier	M	ID	2/3		see notes
N902	127	Reference Identification	X	AN	1/30		see notes
N903	369	Free-form description	X	AN	1/45		see notes
N907	128	Reference Identification Qualifier	M	ID	2/3	55	Sequence Number – see notes

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
MSG01	933	Free-form message text	M	AN	1/264		see notes

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 may 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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CTT01	354	Number of Line Items (count of PO1 elements)	M	N0	1/6

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10
SE02	329	Transaction Set Control Number	M	AN	4/9		4

855 Purchase Order Acknowledgement

To use the Purchase Order Acknowledgment Transaction Set (855) with an EDI environment, follow the guidelines in this article.

Interface Description

This Draft Standard for Trial Use contains the format and establishes the data contents of the Purchase Order Acknowledgment Transaction Set (855) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice relative to a seller’s acknowledgment of a buyer’s purchase order. This transaction set can also be used as notification of a vendor generated order. This usage advises a buyer that a vendor has or will ship merchandise as prearranged in their partnership.

Heading

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	ST	Transaction Set Header	M	1			Must use
020	BAK	Beginning Segment for Purchase Order Acknowledgement	M	1			Must use

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
		LOOP ID – P01			100000
010	P01	Baseline Item Data	M	1		LOOP ID – P01	Must use
		LOOP ID – ACK			1000
270	ACK	Line Item Acknowledgement	M	1		LOOP ID – ACK	Must use

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
		LOOP ID – CTT			1
010	CTT	Transaction Totals	O	1		N3/010	Must use
030	SE	Transaction Set Trailer	M	1			Must use

Notes

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

Sample Spec 855 Files by Status

ACK*IAACK*IDACK*R4ACK*ARACK*R1 & ACK*R2ACK*IAACK*IDACK*R4ACK*ARACK*R1 & ACK*R2

ISA*00* *00* *01*12571829 *12*73987501ME*091104*2002*U*00401*000000131*0*T*>
GS*PR*8478505336*12571829*20070418*1522*3*X*004010
ST*855*0002
BAK*00*NA*12635837*20070418
PO1*1*****PL*1
ACK*IA
CTT*1
SE*6*0002
GE*1*3
IEA*1*000000003

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3	855	Purchase Order Acknowledgement
ST02	329	Transaction Set Control Number	M	AN	4/9

BEG Beginning Segment for Purchase Order Acknowledgement

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	Id	Element Name	Req	Type	Min/Max	Code	Name
BAK01	353	Transaction Set Purpose Code	M	ID	2/2	00	Original
BAK02	587	Acknowledgement Type	M	ID	2/2	NA	No Acknowledgement Needed
BAK03	324	Purchase Order Number	M	AN	1/22		see notes
BAK04	373	Date	M	DT	8/8		Date the Purchase Order was created

Segment Notes

BAK03: Original Purchase Order – BEG03 from the 850 PO

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: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
PO101	350	Assigned Identification	O	AN	1/20		see notes
PO106	235	Product/Service ID Qualifier	M	ID	2/2	PL	Purchaser’s Order Line Number
PO107	234	Product/Service ID	M	AN	1/48

Segment Notes

PO101: Sequential number to distinguish this line detail within the transaction set.
P107: Original Purchase Order Line Number – PO101 from the 850 PO.

ACK Line Item Acknowledgemnet

To acknowledge the ordered quantities and specify the ready date for a specific line item
Usage Option: Must Use

Pos: 270
Max: 1
Detail – Mandatory
Loop: ACK
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ACK01	668	Line Item Status Code	M	ID	2/2		see notes
ACK02	380	Quantity	C	R	1/15		see notes
ACK03	355	Unit or Basis for Measurement Code	X	ID	2/2	EA	Each – see notes

Segment Notes

ACK01: can accept a number of codes for various value names:
- IA: Item Accepted
- ID: Item Deleted
- IH: Item on Hold
- R1: Item Rejected, Not a Contract Item
- R2: Item Rejected, Invalid Item Product Number
- R4: Item Rejected, Contract Item Not Available
- AR: Item Accepted and Released for Shipment
** Note: EDI 855 Release for shipment status (AR) is a second status after the initial mandatory line acceptance IA status. Both statuses IA and AR can be send in the same file, however IA status must precede the AR
The status IA indicates there is enough stock for the line item and the line item can be fulfilled, while on receiving the second 855 with AR status prevents customer to cancel the line item through the web site. In case customer wants to cancel a line item after AR status is received by Walmart.com, the customer has to call customer service.**
ACK02: Used to indicate quantity not available, only if the ACK01 element is “R4”. Used to indicate quantity released for shipment, only if the ACK01 element is “AR”
ACK03: Required if ACK02 is present

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CTT01	354	Number of Line Items	M	N0	1/6

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10
SE02	329	Transaction Set Control Number	M	AN	4/9

856 Ship Notice and Manifest Transaction Set

To use the Ship Notice and Manifest Transaction Set (856) with an EDI environment, follow the guidelines in this article.

Note: You can also view this information in Word format:

Functional Group SH

This Draft Standard for Trial Use contains the format and establishes the data contents of the Ship Notice/Manifest Transaction Set (856) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to list the contents of a shipment of goods as well as additional information relating to the shipment, such as order information, product description, physical characteristics, type of packaging, marking, carrier information, and configuration of goods within the transportation equipment. The transaction set enables the sender to describe the contents and configuration of a shipment in various levels of detail and provides an ordered flexibility to convey information. The sender of this transaction is the organization responsible for detailing and communicating the contents of a shipment, or shipments, to one or more receivers of the transaction set. The receiver of this transaction set can be any organization having an interest in the contents of a shipment or information about the contents of a shipment.

Heading

Pos	Id	Segment Name	Req	Max Use	Usage
010	ST	Transaction Set Header	M	1	Must use
020	BSN	Beginning Segment for Ship notice	M	1	Must use
040	DTM	Date/Time Reference	M	10	Must use

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
		LOOP ID – HL			200000
010	HL	Hierarchical Level	M	1		LOOP ID – HL, C2/010	Must Use
020	LIN	Item Identification	M	1		LOOP ID – HL	Must Use
030	SN1	Item Detail (Shipment)	M	1		LOOP ID – HL	Must Use
050	PRF	Purchase Order Reference	M	1		LOOP ID – HL	Must Use
110	TD1	Carrier Details (Quantity and Weight)	M	20		LOOP ID – HL	Must Use
120	TD5	Carrier Details (Routing Sequence/Transit Time)	M	12		LOOP ID – HL	Must Use
190	MAN	Marks and Numbers	M	>1		LOOP ID – HL	Dependent
		LOOP ID – SAC			>1
320	SAC	Service, Promotion, Allowance, or Charge Information	M	1		LOOP ID – SAC	Must use

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	CTT	Transaction Totals	O	1		N3/010	Must use
020	SE	Transaction Set Trailer	M	1			Must use

Notes

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

Sample Spec 856 Files

S2HS2SS2HS2S

ISA*00* *00* *12*8478505336 *01*12571829*070424*0757*U*00401*000000008*0*P*>
GS*SH*8478505336*12571829*20070424*0757*8*X*004010
ST*856*0001
BSN*00*1584552300*20070424*0755
DTM*011*20070312*1521*ET
HL*1*0*O
PRF*12635837******DS
HL*2*1*P
TD1******G*1.5*LB
TD5*O*94*02
MAN*CP*1ZR580970342882215
MAN*SM*8890500613298
SAC*N*G821******0****06
HL*3*2*I
LIN*1*PL*1
SN1*1*1*EA
CTT*3
SE*16*0001
GE*1*8
IEA*1*000000008

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3	856	Ship Notice/Manifest
ST02	329	Transaction Set Control Number	M	AN	4/9

BSN Beginning Segment for Ship Notice

To transmit identifying numbers, dates, and other basic data relating to the transaction set.

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

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
BSN01	353	Transaction Set Purpose Code	M	ID	2/2	00	Original
BSN02	396	Shipment Identification	M	AN	2/30		see notes
BSN03	373	Date	M	DT	8/8
BSN04	337	Time	M	TM	4/8

Segment Notes

BSN02: Unique numeric identifier for this shipment, assigned by the supplier
BSN03: Date the Transaction Set was created
BSN04: Time the Transaction Set was created

DTM Date/Time Reference

To specify pertinent dates and times
Usage Option: Must use

Pos: 040
Max: 10
Heading – Optional
Loop: N/A
Elements: 4

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
DTM01	374	Date/Time Qualifier	M	ID	3/3	011	shipped
DTM02	373	Date	M	DT	8/8
DTM03	337	Time	M	TM	4/8
DTM04	623	Time Zone Qualifier	M	ID	2/2		see notes

Segment Notes

Time Zone Values (North America/Europe):

ET: Eastern Time
CT: Central Time
MT: Mountain Time
PT: Pacific Time
ED: Eastern Daylight Time
CD: Central Daylight Time
MD: Mountain Daylight Time
PD: Pacific Daylight Time
GM: Greenwich Mean Time (GMT England)

Example: DTM*011*20080708*1150*PT~

HL Hierarchical Level

To identify dependencies among and the content of hierarchically related groups of data segments
Usage Option: Must use

Pos: 010
Max: 1
Detail – Mandatory
Loop: HL
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Name
HL01	628	Hierarchical ID Number	M	AN	1/12	see notes
HL02	734	Hierarchical Parent ID Number	M	AN	1/12	see notes
HL03	735	Hierarchical Level Code	M	ID	1/2	see notes

Segment Notes

HL01: Numeric sequence number to uniquely identify this HL segment within the transaction set
HL02:
- If HL03 = “O”, this value is “0” (zero)
- If HL03 = “P”, this value is the ID Number (HL01) from the associated order HL
- If HL03 = “I”, this value is the ID Number (HL01) from the associated package HL
HL03:
- I: Item
- O: Order
- P: Pack

LIN Item Identification

To specify basic item identification data
Usage Option: Must use

Pos: 020
Max: 1
Detail – Optional
Loop: HL
Elements: 5

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
LIN01	350	Assigned Identification	M	AN	1/20		see notes
LIN02	235	Product/Service ID Qualifier	M	ID	2/2	PL	Purchaser’s Order Line Number
LIN03	234	Product/Service ID	M	AN	1/48		see notes
LIN04	N/A	Product/Service ID	O	ID	2/2		see notes
LIN05	N/A	Product/Service ID	O	AN	1/48		see notes

Segment Notes

Contains the purchase order line number, only used in the line hierarchical level (HL03 = “I”).
May (optional ) contain the store number id and actual store number only in the line hierarchical level (HL03 = “I”).

LIN01: Numeric sequence number to uniquely identify this LIN segment within the transaction set
LIN03: Purchase Order Line Number (PO101) from the original 850 PO
LIN04: Is used to indicate Store Number Identifier “SN”
LIN05: Is used to indicate actual Store Number

SN1 Item Detail (Shipment)

To specify line-item detail relative to shipment
Usage Option: Must use

Pos: 030
Max: 1
Detail – Optional
Loop: HL
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SN101	350	Assigned Identification	M	AN	1/20		see notes
SN102	382	Number of Units Shipped	M	R	1/10
SN103	355	Unit or Basis for Measure Code	M	ID	2/2	EA	Each

Segment Notes

Contains the number of units shipped, only used in the line hierarchical level (HL03 = “I”).

SN101: Numeric sequence number to uniquely identify this SN1 segment within the transaction set. May be the same as the LIN01 ID Number within this same HL loop.

PRF Purchase Order Reference

To provide reference to a specific purchase order Usage Option: Must use

Pos: 050
Max: 1
Detail – Optional
Loop: HL
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
PRF01	324	Purchase Order Number	M	AN	1/22		see notes
PRF07	92	Purchase Order Type Code	M	ID	2/2	DS	Dropship

Segment Notes

Contains a reference to the purchase order number, only used in the order hierarchical level (HL03 = “O”).

PRF01: Purchase Order Number (BEG03) from the original 850 PO

TD1 Carrier Details (Quantity and Weight)

To specify the transportation details relative to commodity, weight, and quantity Usage Option: Must use

Pos: 110
Max: 20
Detail – Optional
Loop: HL
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
TD106	187	Weight Qualifier	M	ID	1/2	G	Gross Weight
TD107	81	Weight	M	R	1/10
TD108	355	Unit or Basis for Measurement Code	M	ID	2/2	LB	Pound

Segment Notes

Contains the package weight, must be used in the package hierarchical level (HL03 = “P”).

TD5 Carrier Details (Routing Sequence/Transit Time)

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

Pos: 120
Max: 12
Detail – Optional
Loop: HL
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
TD501	133	Routing Sequence Code	M	ID	1/2	O	Origin Carrier (Air, Motor, or Ocean)
TD502	66	Identification Code Qualifier	M	ID	1/2	94	see notes
TD503	67	Identification Code	M	AN	2/80		see notes

Segment Notes

Contains the package shipping method, Must be used in the package hierarchical level (HL03 = “P”).

TD502: Code assigned by the organization that is the ultimate destination of the transaction set

TD503 can use one of the following codes:

CMID	XML	Carrier Method Name	CARRIER
9	9	UPS Second Day Air	UPS
17	17	Common Carrier	Common Carrier
18	18	FedEx Freight	FedEx
19	19	FedEx Express Saver (3-Day Service)	FedEx
20	20	FedEx Ground	FedEx
21	21	FedEx Priority Overnight	FedEx
22	22	FedEx 2-Day	FedEx
24	24	FedEx Standard Overnight (PM Delivery)	FedEx
31	31	USPS Priority Mail	USPS
43	43	Pilot Freight Basic Delivery	Pilot
65	65	FedEx Smartpost Over 1lb	Smartpost
66	66	FedEx Smartpost Under 1lb	Smartpost
67	67	FedEx Home Delivery	FedEx
68	20	FedEx Ground	FedEx
79	79	FedEx Ground – S2S	FedEx
80	80	UPS Ground – S2S	UPS
82	82	Seko Worldwide	Seko
90	90	Yellow Freight System – S2S	YRC
97	97	UPS Second Day Air – S2S	UPS
98	98	Downloads	In-Store Pickup
143	43	Pilot Freight Room of Choice Delivery	Pilot
155	55	Estes Forwarding Worldwide Basic Delivery	Estes
223	22	FedEx 2-Day	FedEx
243	43	Pilot Freight White Glove	Pilot
255	55	Estes Forwarding Worldwide Basic Delivery	Estes
267	67	FedEx Home Delivery	FedEx
355	55	Estes Forwarding Worldwide Room of Choice Delivery	Estes
443	43	Pilot Freight Unattended Delivery	Pilot
501	2	UPS Ground	UPS
545	146	NSD for DSV	Non Stop Delivery
6761	20	FedEx Ground Cold Split	FedEx
6762	67	FedEx Home Delivery Cold Split	FedEx
6763	20	FedEx Ground Cold Split	FedEx
6764	67	FedEx Home Delivery Cold Split	FedEx
6766	801	FedEx Ground Hot Split	FedEx
6767	802	FedEx Home Delivery Hot Split	FedEx
6768	801	FedEx Ground Hot Split	FedEx
6769	802	FedEx Home Delivery Hot Split	FedEx

MAN Marks and Numbers

To indicate identifying marks and numbers for shipping containers
Must use for MAN*CP and MAN*SM

Pos: 190
Max: >1
Detail – Optional
Loop: HL
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
MAN01	88	Marks and Numbers Qualifier	M	ID	1/2		see notes
TD503	67	Identification Code	M	AN	2/80		see notes

Segment Notes

Contains the package identification numbers, only used in the package hierarchical level (HL03 = “P”).

MAN01 can accept several codes:
- CP: Carrier-Assigned Package ID Number
- SM: Shipper Assigned
- GM: SSCC-18 Bar code
MAN02:
- If MAN01 = “CP, then this is the tracking number assigned by the carrier. Required for all packages, both Site to Home and Site to Store.
- If MAN01 = “SM”, then this is a unique package ID assigned by the supplier. Required for all packages both Site to Home and Site to Store. Can be the same value as in MAN-02 when MAN-01=”CP”.
- If MAN01 = “GM”, then this is a vendor assigned 20 digit SSCC-18 bar code number. Must for only Site to Store packages. Do not send this for Site to Home packages.

SAC Service, Promotion, Allowance, or 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: 320
Max: 1
Detail – Optional
Loop: SAC
Elements: 5

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SAC01	248	Allowance or Charge Indicator	M	ID	1/1	N	No Allowance or Charge
SAC02	1300	Service, Promotion, Allowance, or Charge Code	X	ID	4/4		see notes
SAC08	118	Rate	M	R	1/9		Can be defaulted to zero
SAC12	331	Allowance or Charge Method of Handling Code	M	ID	2/2		see notes
SAC15	352	Description	X	AN	1/80		see notes

Segment Notes

Contains the information about related costs.
Shipping costs (SAC02 = “G821”) is mandatory and is reported on the package hierarchical level (HL03 = “P”).
Handling and special service costs (SAC02 = “D500” and “H151”) are optional and are reported on the item hierarchical level (HL03 = “I”).

SAC02 codes:
- D500: Handling
- G821: Shipping (Must Use)
- H151: Special Services
SAC02 codes:
- If SAC02 = “G821”, then the shipping cost may be paid by Walmart.com to the vendor (SAC12 = “06”) or directly to the carrier (SAC12 = “15”). Otherwise the costs are paid to the vendor (SAC12 = “06”).
- 06: Charge to be Paid by Customer
- 15: Information Only
SAC15 codes:
- If SAC02 = “H151”, then this field contains the VAS code associated with the special service. Otherwise this element is not used.
- VGM: Gift Message (Up to 4 Lines)
- VGT: Gift Tag (To/From)
- VGW: Gift Wrapping

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: N/A
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CTT01	354	Count of the Number of HL levels	M	N0	1/6

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10
SE02	329	Transaction Set Control Number	M	AN	4/9

860 Purchase Order Change Request

Download this document in Word format from the link below:

Functional Group PC

This Draft Standard for Trial Use contains the format and establishes the data contents of the Purchase Order Change Request – Buyer Initiated Transaction Set (860) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide the information required for the customary and established business and industry practice relative to a purchase order change. This transaction can be used: (1) by a buyer to request a change to a previously submitted purchase order or (2) by a buyer to confirm acceptance of a purchase order change initiated by the seller or by mutual agreement of the two parties.

Heading

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	ST	Transaction Set Header	M	1			Must use
020	BCH	Beginning Segment for Purchase Order Change	M	1			Must use

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
		LOOP ID – POC			>1
010	POC	Line Item Change	O	1		LOOP ID – POC	Must Use

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	CTT	Transaction Totals	O	1		N3/010	Must use
020	SE	Transaction Set Trailer	M	1			Must use

Notes

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

Sample Spec 860 File

ISA*00* *00* *01*12571829 *12*73987501ME*091104*2002*U*00401*000000131*0*T*>
GS*PC*12571829*73987501ME*20091104*200228*5*X*004010
ST*860*0001
BCH*00*DS*12845747***20091104
POC*0001*DI******PL*1
CTT*1
SE*5*0001
GE*1*5
IEA*1*000000131

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3	860	Purchase Order Change Request – Buyer Initiated
ST02	329	Transaction Set Control Number	M	AN	4/9

BCH Beginning Segment for Purchase Order Change

To indicate the beginning of the Purchase Order Change Transaction Set and transmit identifying numbers and dates
Usage Option: Must use

Pos: 020
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 4

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
BCH01	353	Transaction Set Purpose Code	M	ID	2/2	00	Original
BCH02	92	Purchase Order Type Code	M	ID	2/2	DS	Dropship
BCH03	324	Purchase Order Number	M	AN	1/22		see notes
BCH06	373	Date	M	DT	8/8		Date of cancel request

Segment Notes

BCH03: Original Purchase Order – BEG03 from the 850 PO.

POC Line Item Change

To specify changes to a line item
Usage Option: Must use

Pos: 010
Max: 1
Detail – Optional
Loop: POC
Elements: 4

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
POC01	350	Assigned Identification	O	AN	1/20		see notes
POC02	670	Change or Response Type Code	M	ID	2/2	DI	Deleted Items
POC08	235	Product/Service ID Qualifier	X	ID	2/2	PL	Purchaser’s Order Line Number
POC09	234	Product/Service ID	X	AN	1/48		see notes

Segment Notes

Indicates the Purchase Order Line to be cancelled. It’s assumed that the entire quantity of items in this line will be cancelled.

POCO1: Sequential number to distinguish this purchase order change line within the transaction set.
POC09: Original Purchase Order Line Number – PO101 from the 850 PO.

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
CTT01	354	Number of Line Items	M	N0	1/6

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10
SE02	329	Transaction Set Control Number	M	AN	4/9

879 Price Information Advice

To use the Unit Cost Price Information Transaction Set (879) with an EDI environment, follow the guidelines in this article.

Note: You can also download this information in Word format: 7

Functional Group PC

This X12 Transaction Set contains the format and establishes the data contents of the Unit Cost Price Information Transaction Set (879) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used to enable a manufacturer, supplier, broker, or agent to provide a trading partner with pricing information.

Heading

Pos	Id	Segment Name	Req	Max Use	Repeat	Usage
0100	ST	Transaction Set Header	M	1		Must use
0200	G91	Price Change Status	M	1		Must use
LOOP ID – 0100					1
0400	N1	Party Identification	M	1		Must use
1600	G62	Date/Time	M	1		Must use

Detail

Pos	Id	Segment Name	Req	Max Use	Repeat	Usage
LOOP ID – 0200					>1
0200	G28	Line Item Numbers	M	1		Must Use
0300	G69	Line Item Description	O	1		Used
0550	G62	Date/Time	O	1		Used
LOOP ID – 0210					1
0650	G40	Bracket Price	M	1		Must Use

Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
0700	CTT	Transaction Totals	M	1			Must use
0750	SE	Transaction Set Trailer	M	1			Must use

Sample Spec 879 File

ISA*00*          *00*          *ZZ*TEST999999W    *01*12571829       *200207*1315*U*00401*000001985*0*P*>
GS*QG*TEST999999W*12571829*20200207*1315*1985*X*004010
ST*879*1985
G91*B
N1*VN*WM Distributing*92*44103001
G62*09*20200207
G28**0019254569598*VN*15MCP0011DXREF
G69*Product Item descriptions
G62*87*20200207
G40**429.00*****EA
G28**0081947202254*VN*MBPR16LDG01
G62*87*20200207
G40**38.45*****EA
G28**0081947202255*VN*MBPR16LDG01CL
G62*87*20200207
G40**51.78*****EA
G28**0081947202256*VN*MBPR16LDG01KL
G62*87*20200207
G40**51.78*****EA
G28**0081788202888*VN*ULEDATUS
G62*87*20200207
G40**128.67*****EA
CTT*5
SE*21*1985
GE*1*1985
IEA*1*000001985

ST Transaction Set Header

To indicate the start of a transaction set and to assign a control number

Pos: 0100
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 3

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
ST01	143	Transaction Set Identifier Code Description: Code Uniquely identifying a Transaction Set All valid standard codes are used(Total codes: 318)	M	ID	3/3	Must use
ST02	329	Transaction Set Control Number Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set	M	AN	4/9	Must use
ST03	1705	Implementation convention Reference Description: Reference assigned to identify implementation convention	O	AN	1/35	Used

Semantics

The transaction set identifier (ST01) is used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the invoice Transaction Set).
The Implementation convention reference (ST03) is used by the translation routines of the interchange partners to select the appropriate implementation convention to match the transaction set definition. When used, this implementation convention reference takes precedence over the implementation reference specified in the GS08.

G91 Price Change Status

To enable the supplier/broker to change pricing information

Pos: 0200
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 1

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G9101

259

Change Type Code
Description: Code indicating change type
Code List Summary(Total Codes: 21, included: 1)

Code	Name
B	Original Price Change Transaction

1/1

Must use

Loop Party Identification

To identify a party by type of organization, name and code

Pos: 0400
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 1

Loop Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
0400	N1	Party Identification	M	1			Must Use

N1 Party Identification

To identify a party by type of organization, name, and code

Pos: 0400
Max: 1
Heading – Mandatory
Loop: 0100
Elements: 4

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

N101

Entity Identifier Code
Description: Code Uniquely identifying an organizational entity, a physical location, property or an individual
Code List Summary(Total codes: 1500, included: 1)

Code	Name
VN	Vendor

User Note 1:Mandatory

2/3

Must use

N102

Name
Description: Free-form name
User Note 1: Mandatory when N101=VN

1/60

Must use

N103

Identification Code Qualifier
Description: Code designating the system/method of code structure used for identification code (67)
Code List Summary (Total codes: 241, included: 1)

Code	Name
92	Assigned by Buyer or Buyer’s Agent

1/2

Must use

N104

Identification Code
Description: Code identifying a party or other code (Walmart Drop Ship Vendor – Distributor ID/Facility ID depending upon the updates and your account configuration).

2/80

Must use

Syntax Rules

R0203 – At least one of N102 or N103 is required
P0304 – If either N103 or N104 is present, then the other is required

Comments

This segment, when used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency, the “ID Code” (N104) must provide a key to the table maintained by the transaction processing party.
N105 and N106 further define the type of entity in N101 (N105 and N106 are not used here).

G62 Date/Time

To specify pertinent dates and times.

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

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G6201

432

Date Qualifier
Description: Code specifying type of date
Code List Summary (Total Codes: 139, included: 1)

Code	Name
09	Process Date

2/2

Used

G6202

373

Date
Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year.

8/8

Used

Syntax Rules

R0103 – At least one of G6201 or G6203 is required.
P0102 – If either G6201 or G6202 is present, then the other is required.
P0304 – If either G6203 or G6204 is present, then the other is required (G6203 or G6204 is not used here).

Loop Line Item Numbers

To provide basic product identification information.

Pos: 0200
Repeat: >1
Detail – Mandatory
Loop: 0200
Elements: N/A

Loop Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Usage
0200	G28	Line Item Numbers	M	1		Must Use
0300	G69	Line Item Description	O	5		Used
0550	G62	Date/Time	O	4		Used
0650		Loop 0210	M		100	Must Use

G28 Line Item Numbers

To provide basic product identification information.

Pos: 0200
Max: 1
Detail – Mandatory
Loop: 0200
Elements: 3

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G2802

766

U.P.C./EAN Consumer Package Code
Description: Walmart UPC Code Uniquely identifying the retail shelf unit.

13/13

Must Use

G2803

235

Product/Service ID Qualifier
Description: Code identifying the type/source of the descriptive number used in Product/Service ID (234).
Code List Summary (Total Codes: 519, included: 1)

Code	Name
VN	Vendor’s (Seller’s) Item/SKU number

2/2

Must Use

G2804

234

Product/Service ID
Description: Identifying number for a product or service (Vendor SKU).

1/48

Must Use

Syntax Rules

R010203 – At least one of G2801, G2802 or G2803 is required.
P0304 – If either G2803 or G2804 is present, then the other is required.
P0506 – If either G2805 or G2806 is present, then the other is required (G2805 or G2806 is not used here).

G69 Line Item Description

To specify the item description for which you want to update the unit cost.

Pos: 0300
Max: 1
Detail – Optional
Loop: 0200
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
G6901	369	Free Form Description	M	AN	1/45	Must Use

G62 Date/Time

To specify pertinent dates and times.

Pos: 0550
Max: 1
Detail – Optional
Loop: 0200
Elements: 2

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G6201

432

Date Qualifier
Description: Code specifying type of date
Code List Summary (Total Codes: 139, included: 1)

Code	Name
87	First Order Date

2/2

Used

G6202

373

Date
Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year

8/8

Used

Syntax Rules

R0103 – At least one of G6201, or G6203 is required.
P0102 – If either G6201 or G6202 is present, then the other is required.
P0304 – If either G6203 or G6204 is present, then the other is required (G6203 or G6204 is not used here).

Loop Bracket Price

To provide a vendor’s pricing structure associated with a specific line item.

Pos: 0650
Repeat: 1
Detail – Mandatory
Loop: 0210
Elements: N/A

Loop Summary

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
0650	G40	Bracket Price	M	1			Must Use

G40 Bracket Price

To provide a vendor’s pricing structure associated with a specific line item.

Pos: 0650
Max: 1
Detail – Mandatory
Loop: 0210
Elements: 3

Element Summary

Ref

Element Name

Req

Type

Min/Max

Usage

G4001

417

Price Bracket Identifier
Description: Identifier assigned by the vendor for a specific price bracket.

1/3

Used

G4002

418

Item List Cost – New
Description: Unit Cost Price within the appropriate price bracket for a line item.

1/9

Must Use

G4007

355

Unit or Basis for Measurement Code
Description: Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken.
Code List Summary (Total Codes: 844, included: 1)

Code	Name
EA	Each

2/2

Must Use

Semantics

G4009 is the shipping unit to billing unit conversion factor (G4009 is not used here).

Comments

G4007 is the invoicing unit of measure for the costs specified in G4002 and G4003.

CTT Transaction Totals

To transmit a hash total for a specific element in the transaction set.

Pos: 0700
Max: 1
Summary – Mandatory
Loop: N/A
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
CTT01	354	Number of Line Items	M	N0	1/6	Must Use

Comments

Number of G28 segments in the transaction set.

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).

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

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Usage
SE01	96	Number of Included Segments Description: Total number of segments included in a transaction set including ST and SE segments.	M	N0	1/10	Must Use
SE02	329	Transaction Set Control Number Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set.	M	AN	4/9	Must Use

Comments

SE is the last segment of each transaction set.

Version

Indicate the version number in ISA and GS segment Version number as 004010

997 Functional Acknowledgement

To use the Functional Acknowledgment Transaction Set (997) in an EDI environment, follow the guidelines in this article.

Note: You can also view this information in Word format:

Functional Group FA

This Draft Standard for Trial Use contains the format and establishes the data contents of the Functional Acknowledgment Transaction Set (997) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to define the control structures for a set of acknowledgments to indicate the results of the syntactical analysis of the electronically encoded documents. The encoded documents are the transaction sets, which are grouped in functional groups, used in defining transactions for business data interchange. This standard does not cover the semantic meaning of the information encoded in the transaction sets.

Heading

Pos	Id	Segment Name	Req	Max Use	Repeat	Notes	Usage
010	ST	Transaction Set Header	M	1		N1/010	Must use
020	AK1	Functional Group Response Header	M	1		N1/020	Must use
		LOOP ID – AK2			200000
030	AK2	Transaction Set Response Header	O	1		N1/030	Must use
060	AK5	Transaction Set Response Trailer	M	1			Must use
070	AK9	Functional Group Response Trailer	M	1			Must use
080	SE	Transaction Set Trailer	M	1			Must use

Notes

1/010: These acknowledgments shall not be acknowledged, thereby preventing an endless cycle of acknowledgments of acknowledgments. Nor shall a Functional Acknowledgment be sent to report errors in a previous Functional Acknowledgment. The Functional Group Header Segment (GS) is used to start the envelope for the Functional Acknowledgment Transaction Sets. In preparing the functional group of acknowledgments, the application sender’s code and the application receiver’s code, taken from the functional group being acknowledged, are exchanged; therefore, one acknowledgment functional group responds to only those functional groups from one application receiver’s code to one application sender’s code. There is only one Functional Acknowledgment Transaction Set per acknowledged functional group.
1/020: AK1 is used to respond to the functional group header and to start the acknowledgement for a functional group. There shall be one AK1 segment for the functional group that is being acknowledged.
1/030: AK2 is used to start the acknowledgement of a transaction set within the received functional group. The AK2 segments shall appear in the same order as the transaction sets in the functional group that has been received and is being acknowledged.

Sample Spec 997 Files

FOR 850FOR 860FOR 850FOR 860

ISA*00* *00* *12*8478505336 *01*12571829*070426*1038*U*00401*000000008*0*P*>
GS*FA*8478505336*12571829*20070426*1038*8*X*004010
ST*997*0002
AK1*PO*000000009
AK2*850*0001
AK5*A
AK9*A*1*1*1
SE*6*0002
GE*1*8
IEA*1*000000008

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

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
ST01	143	Transaction Set Identifier Code	M	ID	3/3	997	Functional Acknowledgement
ST02	329	Transaction Set Control Number	M	AN	4/9

AK1 Functional Group Response Header

To start acknowledgment of a functional group
Usage Option: Must use

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

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
AK101	479	Functional Identifier Code	M	ID	2/2		see notes
AK102	28	Group Control Number	M	N0	1/9

Segment Notes

AG: Application Advice (824)
IB: Inventory Inquiry/Advice (846)
IN: Invoice Information (810, 819)
PC: Purchase Order Change Request – Buyer Initiated (860)
PO: Purchase Order (850)
PR: Purchase Order Acknowledgement (855)
SH: Ship Notice/Manifest (856)

AK2 Transaction Set Response Header

To start acknowledgment of a single transaction set
Usage Option: Must use

Pos: 030
Max: 1
Heading – Optional
Loop: AK2
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
AK201	143	Transaction Set Identifier Code	M	ID	3/3
AK202	329	Transaction Set Control Number	M	AN	4/9

Segment Notes

810: Invoice
824: Application Advice
846: Inventory Inquiry/Advice
850: Purchase Order
855: Purchase Order Acknowledgement
856: Ship Notice/Manifest
860: Purchase Order Change Request – Buyer Initiated

AK5 Transaction Set Response Trailer

To acknowledge acceptance or rejection and report errors in a transaction set
Usage Option: Must use

Pos: 060
Max: 1
Heading – Mandatory
Loop: AK2
Elements: 1

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
AK501	717	Transaction Set Acknowledgement Code	M	ID	1/1		see notes

Segment Notes

Each Transaction Set is marked as valid or rejected to indicate our validation results, but all transaction sets are rejected if the Group is rejected.

A: Accepted
W: Rejected, Assurance Failed Validity Tests

AK9 Functional Group Response Trailer

To acknowledge acceptance or rejection of a functional group and report the number of included transaction sets from the original trailer, the accepted sets, and the received sets in this functional group. Usage Option: Must use

Pos: 070
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 4

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Name
AK901	715	Functional Group Acknowledge Code	M	ID	1/1	see notes
AK902	97	Number of Transaction Sets Included	M	N0	1/6
AK903	123	Number of Received Transaction Sets	M	N0	1/6
AK904	2	Number of Accepted Transaction Sets	M	N0	1/6

Segment Notes

Even if some transaction sets were marked as accepted, the group will never be partially accepted. The group is either fully accepted or fully rejected.

A: Accepted
R: Rejected

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: 080
Max: 1
Heading – Mandatory
Loop: N/A
Elements: 2

Element Summary

Ref	Id	Element Name	Req	Type	Min/Max	Code	Name
SE01	96	Number of Included Segments	M	N0	1/10
SE02	329	Transaction Set Control Number	M	AN	4/9

EDI Connection Types

You can use several connection types with an EDI interface:

AS2 – secure method to transfer data reliably over the internet. It takes client and server computers that connect point-to-point over the web. AS2 creates an envelope for EDI data that allows it to be sent securely using digital certificates and encryption. Walmart sends and receives EDI files with a direct AS2 connection with the DSV.
Value-added Network (VAN) – third-party private network provider to transfer or exchange EDI documents. Walmart sends via VAN, but does not govern or dictate the data flow between VAN and DSV.
SSH File transfer protocol (SFTP) – provides a point-to-point connectivity to enable secure file transfer capabilities between networked hosts. Walmart sends and receives EDI files with a direct SFTP connection with the DSV.
Solution Provider – a third party that provides EDI process capability to its partners. Walmart will send and receive EDI files via Solution Provider or AS2 connectivity, but does not govern or dictate the data flow between the Solution Provider and DSV.

Data Transfer - EDI

Electronic Data Exchange (EDI) Interface

EDI File Naming Conventions

EDI Delimiters

824 Application Device

Functional Group AG

Heading

Detail

Notes

ST Transaction Set Header

Element Summary

BGN Beginning Segment

Element Summary

OTI Original Transaction Identification

Element Summary

TED Technical Error Description

Element Summary

NTE Note/Special Instruction

Element Summary

SE Transaction Set Trailer

Element Summary

846 Inventory Inquiry

Functional Group IB

Heading

Detail

Summary

ST Transaction Set Header

Element Summary

BIA Beginning Segment for Inventory Inquiry/Advice

Element Summary

REF Reference Identification

Element Summary

LIN Item Identification

Element Summary

REF Reference Identification

Element Summary

Usage Notes

QTY Quantity

Element Summary

MEA Measurements

Element Summary

DTM Date/Time Reference

Element Summary

DTM Date/Time Reference

Element Summary

CTT Transaction Totals

Element Summary

SE Transaction Set Trailer

Element Summary

850 Purchase Order

Functional Group PO

Heading

Detail

Summary

ST Transaction Set Header

Element Summary

BEG Beginning Segment for Purchase Order

Element Summary

REF Reference Identification 1

Element Summary

Segment Notes

REF Reference Identification 2

Element Summary

Segment Notes

REF Reference Identification 3

Element Summary

Segment Notes

REF Reference Identification 4

Element Summary

Segment Notes

CTP Pricing Information

Element Summary

Segment Notes

CSH Sales Requirements

Element Summary

Segment Notes

DTM Date/Time Reference

Element Summary

Segment Notes

N9 Reference Identification