850 Import 5010

Download as pdf or txt
Download as pdf or txt
You are on page 1of 95

Wal-Mart Stores, Inc.

Electronic Data Interchange Implementation Guideline


ANSI X12 Version 5010

5
0
1
0
850 Purchase Order
Purchase Order

Business Usage:
Imports Products
Consolidator
De-Consolidator
Customs Broker

EDI Direction: From Wal-Mart

Implementation Guide Version 1.0


Published January 2005
Last Changed January 2005
Table of Contents

850 Purchase Order - Wal-Mart Stores, Inc. Introduction................................................................................................3

850 Purchase Order - Wal-Mart Stores, Inc. Guidelines....................................................................................................4

Wal-Mart Business Example of an 850 Purchase Order – Single Location..................................................................6

Wal-Mart Business Example of an 850 Purchase Order– Multiple Locations ...........................................................10

850 Purchase Order – ANSI X12 Introduction ...................................................................................................................81

850 Purchase Order – ANSI X12 Standards ........................................................................................................................82

850 Purchase Order – VICS Introduction ............................................................................................................................88

850 Purchase Order – VICS Guidelines ................................................................................................................................89

Conventions used in these guidelines .....................................................................................................................................92

Example of Conventions ............................................................................................................................................................93

850 Purchase Order - Changes from Previous (4030) Version .......................................................................................94

Change History.............................................................................................................................................................................95

51850-IM (005010) Wal-Mart Confidential 2


850 Purchase Order - Wal-Mart Stores, Inc. Introduction

Wal-Mart uses the 850 Import EDI document to communicate detailed import Purchase Order
information (including distribution details) to it's trading partners.

Functional Acknowledgment
A Functional Acknowledgment, VICS/EDI transaction set 997 must be sent within 24 hours of
receipt of originating transmission to acknowledge receipt of the 850 transmission or to notify
Wal-Mart Stores, Inc. of format or syntax errors.

Business Changes
To support our growing company, Wal-Mart Stores, Inc. will be incorporating the following
business changes into this 5010 upgrade.

Wal-Mart will utilize the GTIN (Global Traded Item Number) in EDI X12 Version 5010. GTIN
information will be sent in addition to the UPC code. It will be the suppliers' responsibility to
handle the information as their systems become GTIN compliant. For more information
regarding GTIN, please visit the website of the UCC (<www.uc-council.org>) in the U.S. and
ECCC (<www.eccc.org>) in Canada or the appropriate numbering organization for your country.

51850-IM (005010) Wal-Mart Confidential 3


850 Purchase Order - Wal-Mart Stores, Inc. Guidelines
Functional Group ID=PO

Heading:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
M 0100 ST Transaction Set Header M 1
M 0200 BEG Beginning Segment for Purchase Order M 1
0500 REF Reference Information O >1
0500 REF Reference Information O >1
0500 REF Reference Information O >1
0600 PER Administrative Communications Contact O 3
0800 FOB F.O.B. Related Instructions O >1
1500 DTM Date/Time Reference O 10
1500 DTM Date/Time Reference O 10
1500 DTM Date/Time Reference O 10
1500 DTM Date/Time Reference O 10
1500 DTM Date/Time Reference O 10
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
LOOP ID - N1 200
3100 N1 Party Identification O 1

LOOP ID - N1 200
3100 N1 Party Identification O 1

LOOP ID - N1 200
3100 N1 Party Identification O 1
3300 N3 Party Location O 2
3400 N4 Geographic Location O >1

LOOP ID - N1 200
3100 N1 Party Identification O 1
3300 N3 Party Location O 2
3400 N4 Geographic Location O >1

LOOP ID - N1 200
3100 N1 Party Identification O 1
3300 N3 Party Location O 2
3400 N4 Geographic Location O >1

Detail:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
LOOP ID - PO1 100000

51850-IM (005010) Wal-Mart Confidential 4


M 0100 PO1 Baseline Item Data M 1 n1
LOOP ID - CTP >1
0400 CTP Pricing Information O 1
0430 CUR Currency O 1

LOOP ID - CTP >1


0400 CTP Pricing Information O 1
0430 CUR Currency O 1

LOOP ID - PID 1000


0500 PID Product/Item Description O 1

0900 PO4 Item Physical Details O >1


2700 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
LOOP ID - SCH 200
2950 SCH Line Item Schedule O 1 n2

LOOP ID - N9 1000
3300 N9 Extended Reference Information O 1

LOOP ID - SLN 1000


4700 SLN Subline Item Detail O 1
4750 MTX Text O >1
LOOP ID - N9 >1
5230 N9 Extended Reference Information O 1

LOOP ID - N9 >1
5230 N9 Extended Reference Information O 1

LOOP ID - SAC 25
5260 SAC Service, Promotion, Allowance, or Charge O 1
Information

Summary:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
LOOP ID - CTT 1
0100 CTT Transaction Totals O 1 n3

M 0300 SE Transaction Set Trailer M 1

Transaction Set Notes

1. PO102 is required.
2. The SCH segment is used to specify various quantities of items ordered that are to be scheduled. When this
segment is used the unit of measurement code (SCH02) should always be identical to the unit of
measurement code in the associated PO1 segment (PO103) and the sum of values of quantity (SCH01) should
always equal the quantity ordered (PO102) in the PO1 segment.
3. The number of line items (CTT01) is the accumulation of the number of PO1 segments. If used, hash total
(CTT02) is the sum of the value of quantities ordered (PO102) for each PO1 segment.

51850-IM (005010) Wal-Mart Confidential 5


Wal-Mart Business Example of an 850 Purchase Order –
Single Location

EDI TRANSMISSION DATA EXPLANATION

ST*850*0001 850 is the Transaction Set Identifier Code. "850" indicates


"Purchase Order".
0001 is the Transaction Set Control Number.
BEG*00*BE*0021637560**20040202 00 is the Transaction Set Purpose Code. "00" indicates
"Original".
BE is the Purchase Order Type Code. “BE” indicates
“Blanket Order/Estimated Quantities (Not firm Commitment).”
0021637560 is the Purchase Order Number.
20040202 is the Purchase Order Date.
REF*DP*00063 DP is the Reference Identification Qualifier. “DP” indicates
“Department Number”
00063 is the Reference Identification (Department Number).
REF*MR*0021 MR is the Reference Identification Qualifier. “MR”
indicates “Merchandise Type Code”
0021 is the Reference Identification (Order Type).
PER*BD*YOLANDA LAMBREY BD is the Contact Function Code. “BD” indicates “Buyer
Name or Department.”
YOLANDA LAMBREY is the Name (Buyer’s Name).
FOB*CC* ZZ*FOB*01*CFR CC is the Shipment Method of Payment. "CC" indicates
"Collect".
ZZ is the Location Qualifier. "ZZ" indicates "Mutually
Defined". This indicates the Place of Possession.
FOB is the Description (Free-form name of transportation
responsibility location).
01 is the Transportation Terms Qualifier Code. “01”
indicates “Incoterms”.
CFR is the Transportation Terms Code. “CFR” indicates
“Cost and Freight”. This is the Incoterms code.
DTM*010*20040301 010 is the Date/Time Qualifier. “010” indicates “Requested
Ship.”
20040301 is the Date.
DTM*001*20040315 001 is the Date/Time Qualifier. “001” indicates “Cancel
After.”
20040315 is the Date.
DTM*037*20040201 037 is the Date/Time Qualifier. “037” indicates “Ship Not
Before.”
20040201 is the Date.
DTM*038*20040215 038 is the Date/Time Qualifier. “038” indicates “Ship No
Later”
20040215 is the Date.
DTM*002*20040401 002 is the Date/Time Qualifier. "002" indicates “Delivery
Requested.”
20040401 is the Date .
TD5****O***KL*LEGHORN****ZZ***IT O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
KL is the Location Qualifier. “KL” indicates “Port of
Loading.”
LEGHORN is the Location Identifier. (Port Name)
ZZ is the Service Level Code. “ZZ” indicates “Mutually
51850-IM (005010) Wal-Mart Confidential 6
Defined.”
IT is the Country Code.
TD5****O***DE*STATESBORO O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
DE is the Location Qualifier. “DE” indicates “Destination.”
STATESBORO is the Location Identifier. (Port Name)
TD5****O***PB*STATESBORO O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
PB is the Location Qualifier. “PB” indicates “Port of
Discharge.”
STATESBORO is the Location Identifier. (Port Name)
TD5****O***CA*IT O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
CA is the Location Qualifier. “CA” indicates “Country of
Origin.”
IT is the Location Identifier. (Country Code)
N1*BT*WAL-MART STORES, BT is the Entity Identifier Code. “BT” indicates “Bill-to-
INC*UL*0078742000008 Party.”
WAL-MART STORES, INC is the Name.
UL is the Identification Code Qualifier. ”UL” indicates
“UCC/EAN Location Code.”
0078742000008 is the Identification Code. (Global Location
Number)
N1*BO*PREL ITALY*92*051 BO is the Entity Identifier Code. “BO” indicates “Broker or
Sales Office.”
PREL ITALY is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
051 is the Identification Code. (Broker office Number)
N1*SF*SUPPLIER NAME*92*123456789 SF is the Entity Identifier Code. “SF” indicates “Ship From.”
SUPPLIER NAME is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
123456789 is the Identification Code. (Internal Import
Vendor Number)
N3*1234 MAIN STREET 1234 MAIN STREET is the Address Information.
N4*VENICE*VN*01286*IT VENICE is the City Name.
VN is the State or Province Code.
01286 is the Postal Code.
IT is the Country Code.
N1*AE*SHIP TO NAME*92*0571910095 AE is the Entity Identifier Code. “AE” indicates “Additional
Delivery Address.”
SHIP TO NAME is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
0571910092 is the Identification Code. (Fax Number)
N3*4321 MAIN STREET 4321 MAIN STREET is the Address Information.
N4*ITALY***IT ITALY is the City Name.
IT is the Country Code.
N1*MF*FACTORY NAME*92*87654321 MF is the Entity Identifier Code. “MR” indicates
“Manufacturer of Goods.”
FACTORY NAME is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
87654321 is the Identification Code. (Internal Import
Manufacturer Number)
N3*9876 MAIN STREET 9876 MAIN STREET is the Address Information.
N4*ITALY***IT ITALY is the City Name.
IT is the Country Code.
PO1*1*744*CA***IN*1620921*UP*718649253465*V 1 is the Assigned Identification.
51850-IM (005010) Wal-Mart Confidential 7
N*BC3121*C3*N***OT*00000016209213*UK*07186 744 is the Quantity Ordered.
492534650 CA is the Unit or Basis for Measurement Code.
IN is the Product/Service ID Qualifier. “IN” indicates
“Buyer’s Item Number.”
1620921 is the Product/Service ID.
UP is the Product/Service ID Qualifier. “UP” indicates
“U.P.C. Consumer Package Code (1-5-5-1).”
718649253465 is the Product/Service ID.
VN is the Product/Service ID Qualifier. "VN" indicates
"Vendor's (Seller's) Item Number".
BC3121 is the Product/Service ID.
C3 is the Product/Service ID Qualifier. “C3” indicates
“Classification.”
N is the Product/Service ID indicating that the item is not pre-
classed.
OT is the Product/Service ID Qualifier. "OT" indicates
"Internal Number".
00000016209213 is the Product/Service ID.
UK is the Product/Service ID Qualifier. "UK" indicates
"GTIN 14-digit Data Structure".
00123456789980 is the Product/Service ID.
CTP**FCP*12.1 FCP is the Price Identifier Code. “FCP” indicates “First Cost
Price.”
12.1 is the Unit Price.
CUR*BY*USD BY is the Entity Identifier Code. "BY" indicates "Buying
Party (Purchaser)".
USD is the Currency Code (US Dollar).
CTP**ALT*36.2 FCP is the Price Identifier Code. “ALT” indicates “Alternate
Price.”
36.2 is the Unit Price
CUR*BY*EUR BY is the Entity Identifier Code. "BY" indicates "Buying
Party (Purchaser)".
EUR is the Currency Code (Euro).
PID*F****HAND PAINTTED CERAMIC SQUARE F is the Item Description Type. “F” indicates “Free-Form.”
PLATTER HAND PAINTTED CERAMIC SQUARE PLATTER is the
Description.
PO4*6*****0.076*KG*0.076*CR 6 is the Pack.
0.076 is the Gross Weight per Pack.
KG is the Unit or Basis for Measurement Code. “KG”
indicates “Kilograms.”
0.076 is the Gross Volume per Pack.
CR is the Unit or Basis for Measurement Code. “CR”
indicates “Cubic Meter.”
TD4*HAZ***Hazardous materials - Handle with care HAZ is the Special Handling Code. "HAZ" indicates
"Hazardous Cargo".
Hazardous materials - Handle with care is the Description
(Free-form text description).
N9*CR*010007665400 CR is the Reference Identification Qualifier. “CR” indicates
“Customer Reference Number.”
010007665400 is the Reference Identification. (Quote Sheet
Number).
SLN*1**O******ZZ*6912004500*CH*IT 1 is the Assigned Identification.
O is the Relationship Code. “O” indicates “Information
Copy.”
ZZ is the Product/Service ID Qualifier. “ZZ” indicates
“Mutually Defined.”
6912004500 is the Product/Service ID. (Tariff Number).
CH is the Product./Service ID Qualifier. “CH” indicates
“Country of Origin Code.”
IT is the Product/Service ID.

51850-IM (005010) Wal-Mart Confidential 8


SAC*C* ZZZZ****2*30*****15***NAFTA C is the Allowance or Charge Indicator . "C" indicates
"Charge".
ZZZZ is the Service, Promotion, Allowance, or Charge
Code. "ZZZZ" indicates "Mutually Defined".
2 is the Allowance/Charge Percent Qualifier. "2" indicates
"Item Net Cost".
30 is the Percent.
15 is the Allowance or Charge Method of Handling Code .
"15" indicates "Information Only".
NAFTA is the Description. This describes the allowance or
charge.
CTT*1**126.025*KG*126.0252*CR 1 is the Number of Line Items.
126.025 is the Weight.
KG is the Unit or Basis for Measurement Code. “KG”
indicates “Kilogram.”
126.0252 is the Volume.
CR is the Unit or Basis for Measurement Code. “CR”
indicates “Cubic Meter.”
SE*39*0001 39 is the Number of Included Segments.
0001 is the Transaction Set Control Number.

51850-IM (005010) Wal-Mart Confidential 9


Wal-Mart Business Example of an 850 Purchase Order–
Multiple Locations

EDI TRANSMISSION DATA EXPLANATION

ST*850*0001 850 is the Transaction Set Identifier Code. "850" indicates


"Purchase Order".
0001 is the Transaction Set Control Number.
BEG*04*BE*0043576655**20040923 04 is the Transaction Set Purpose Code. "04" indicates
"Change".
BE is the Purchase Order Type Code. “BE” indicates
“Blanket Order/Estimated Quantities (Not firm Commitment).”
0043576655 is the Purchase Order Number.
20040923 is the Purchase Order Date.
REF*DP*00007 DP is the Reference Identification Qualifier. “DP” indicates
“Department Number”
00007 is the Reference Identification (Department Number).
REF*PD*NEWSTRAP PD is the Reference Identification Qualifier. “PD” indicates
“Promotional/Deal Number”
NEWSTRAP is the Reference Identification (Wal-Mart
event code).
REF*MR*0043 MR is the Reference Identification Qualifier. “MR”
indicates “Merchandise Type Code”
0043 is the Reference Identification (Order Type).
PER*BD*ANDY PRINCE BD is the Contact Function Code. “BD” indicates “Buyer
Name or Department.”
ANDY PRINCE is the Name (Buyer’s Name).
FOB*CC*ZZ*FOB*01*CFR CC is the Shipment Method of Payment. "CC" indicates
"Collect".
ZZ is the Location Qualifier. "ZZ" indicates "Mutually
Defined". This indicates the Place of Possession.
FOB is the Description (Free-form name of transportation
responsibility location).
01 is the Transportation Terms Qualifier Code. “01”
indicates “Incoterms”.
CFR is the Transportation Terms Code. “CFR” indicates
“Cost and Freight”. This is the Incoterms code.
DTM*010*20041201 010 is the Date/Time Qualifier. “010” indicates “Requested
Ship.”
20041201 is the Date.
DTM*001*20041208 001 is the Date/Time Qualifier. “001” indicates “Cancel
After.”
20041208 is the Date.
DTM*037*20041014 037 is the Date/Time Qualifier. “037” indicates “Ship Not
Before.”
20041014 is the Date.
DTM*038*20041021 038 is the Date/Time Qualifier. “038” indicates “Ship No
Later”
20041021 is the Date.
DTM*002*20041213 002 is the Date/Time Qualifier. "002" indicates “Delivery
Requested.”
20041213 is the Date .
TD5****O***KL*HUANGPU****ZZ***CN O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
KL is the Location Qualifier. “KL” indicates “Port of
51850-IM (005010) Wal-Mart Confidential 10
Loading.”
HUANGPU is the Location Identifier. (Port Name)
ZZ is the Service Level Code. “ZZ” indicates “Mutually
Defined.”
CN is the Country Code.
TD5****O***DE*SUFFOLK-FLOW O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
DE is the Location Qualifier. “DE” indicates “Destination.”
SUFFOLK-FLOW is the Location Identifier. (Port Name)
TD5****O***PB*SUFFOLK-FLOW O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
PB is the Location Qualifier. “PB” indicates “Port of
Discharge.”
SUFFOLK-FLOW is the Location Identifier. (Port Name)
TD5****O***CA*CN O is the Transportation Method/Type Code. “O” indicates
“Containerized Ocean.”
CA is the Location Qualifier. “CA” indicates “Country of
Origin.”
CN is the Location Identifier. (Country Code)
N1*BT*WAL-MART STORES, BT is the Entity Identifier Code. “BT” indicates “Bill-to-
INC*UL*0078742000008 Party.”
WAL-MART STORES, INC is the Name.
UL is the Identification Code Qualifier. ”UL” indicates
“UCC/EAN Location Code.”
0078742000008 is the Identification Code. (Global Location
Number)
N1*BO*PREL HONG KONG*92*010 BO is the Entity Identifier Code. “BO” indicates “Broker or
Sales Office.”
PREL HONG KONG is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
010 is the Identification Code. (Broker office Number)
N1*SF*SUPPLIER NAME*92*12345678 SF is the Entity Identifier Code. “SF” indicates “Ship From.”
SUPPLIER NAME is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
12345678 is the Identification Code. (Internal Import Vendor
Number)
N3*1234 MAIN STREET 1234 MAIN STREET is the Address Information.
N4*NORTH POINT***HK NORTH POINT is the City Name.
HK is the Country Code.
N1*AE*SHIP TO NAME*92*0571910095 AE is the Entity Identifier Code. “AE” indicates “Additional
Delivery Address.”
SHIP TO NAME is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
0571910092 is the Identification Code. (Fax Number)
N3*4321 MAIN STREET 4321 MAIN STREET is the Address Information.
N4*NORTH POINT***HK NORTH POINT is the City Name.
HK is the Country Code.
N1*MF*FACTORY NAME*92*87654321 MF is the Entity Identifier Code. “MR” indicates
“Manufacturer of Goods.”
FACTORY NAME is the Name.
92 is the Identification Code Qualifier. ”92” indicates
“Assigned by Buyer or Buyer’s Agent.”
87654321 is the Identification Code. (Internal Import
Manufacturer Number)
N3*9876 MAIN STREET 9876 MAIN STREET is the Address Information.
N4*NORTH POINT***HK NORTH POINT is the City Name.
HK is the Country Code.
51850-IM (005010) Wal-Mart Confidential 11
PO1*1*744*CA***IN*1620921*UP*718649253465*V 1 is the Assigned Identification.
N*BC3121*C3*N***OT*00000016209213*UK*07186 744 is the Quantity Ordered.
492534650 CA is the Unit or Basis for Measurement Code.
IN is the Product/Service ID Qualifier. “IN” indicates
“Buyer’s Item Number.”
1620921 is the Product/Service ID.
UP is the Product/Service ID Qualifier. “UP” indicates
“U.P.C. Consumer Package Code (1-5-5-1).”
718649253465 is the Product/Service ID.
VN is the Product/Service ID Qualifier. "VN" indicates
"Vendor's (Seller's) Item Number".
BC3121 is the Product/Service ID.
C3 is the Product/Service ID Qualifier. “C3” indicates
“Classification.”
N is the Product/Service ID indicating that the item is not pre-
classed.
OT is the Product/Service ID Qualifier. "OT" indicates
"Internal Number".
00000016209213 is the Product/Service ID.
UK is the Product/Service ID Qualifier. "UK" indicates
"GTIN 14-digit Data Structure".
00123456789980 is the Product/Service ID.
CTP**FCP*2.6003 FCP is the Price Identifier Code. “FCP” indicates “First Cost
Price.”
2.6003 is the Unit Price.
CUR*BY*USD BY is the Entity Identifier Code. "BY" indicates "Buying
Party (Purchaser)".
USD is the Currency Code (US Dollar).
CTP**ALT*36.2 FCP is the Price Identifier Code. “ALT” indicates “Alternate
Price.”
36.2 is the Unit Price
CUR*BY*EUR BY is the Entity Identifier Code. "BY" indicates "Buying
Party (Purchaser)".
EUR is the Currency Code (Euro).
PID*F****QUICK INFLATOR F is the Item Description Type. “F” indicates “Free-Form.”
QUICK INFLATOR is the Description.
PO4*14*****6.6*KG*0.041*CR 14 is the Pack.
6.6 is the Gross Weight per Pack.
KG is the Unit or Basis for Measurement Code. “KG”
indicates “Kilograms.”
0.041 is the Gross Volume per Pack.
CR is the Unit or Basis for Measurement Code. “CR”
indicates “Cubic Meter.”
TD4*HAZ***Hazardous materials - Handle with care HAZ is the Special Handling Code. "HAZ" indicates
"Hazardous Cargo".
Hazardous materials - Handle with care is the Description
(Free-form text description).
SCH*11*CA***167*19991015*2304****0043576655* 11 is the Quantity.
0078742028569 CA is the Unit or Basis for Measurement. “CA” indicates
“Case.”
167 is the Date/Time Qualifier. “167” indicates “Most Recent
Revision (or Initial Version)”
19991015 is the Date.
2304 is the Time.
0043576655 IS THE REQUEST REFERENCE NUMBER.
(WAL-MART DISTRIBUTION PURCHASE ORDER
NUMBER)
0078742028569 IS THE ASSIGNED IDENTIFICATION.
(WAL-MART GLN FOR DISTRIB UTION CENTER).
SCH*13*CA***167*19991013*2316****0043576655* 13 is the Quantity.

51850-IM (005010) Wal-Mart Confidential 12


0078742029467 CA is the Unit or Basis for Measurement. “CA” indicates
“Case.”
167 is the Date/Time Qualifier. “167” indicates “Most Recent
Revision (or Initial Version)”
19991013 is the Date.
2316 is the Time.
0043576655 IS THE REQUEST REFERENCE NUMBER.
(WAL-MART DISTRIBUTION PURCHASE ORDER
NUMBER)
0078742029467 is the Assigned Identification. (Wal-Mart
GLN for distribution center).
SCH*0*CA***167*19991015*2304****0043576655* 0 is the Quantity.
0078742030005 CA is the Unit or Basis for Measurement. “CA” indicates
“Case.”
167 is the Date/Time Qualifier. “167” indicates “Most Recent
Revision (or Initial Version)”
19991015 is the Date.
2304 is the Time.
0043576655 IS THE REQUEST REFERENCE NUMBER.
(WAL-MART DISTRIBUTION PURCHASE ORDER
NUMBER)
0078742030005 is the Assigned Identification. (Wal-Mart
GLN for distribution center).
SCH*1*CA***167*19991013*2316****0043576655* 1 is the Quantity.
0078742031170 CA is the Unit or Basis for Measurement. “CA” indicates
“Case.”
167 is the Date/Time Qualifier. “167” indicates “Most Recent
Revision (or Initial Version)”
19991013 is the Date.
2316 is the Time.
0043576655 IS THE REQUEST REFERENCE NUMBER.
(WAL-MART DISTRIBUTION PURCHASE ORDER
NUMBER)
0078742031170 is the Assigned Identification. (Wal-Mart
GLN for distribution center).
N9*CR*010013992400 CR is the Reference Identification Qualifier. “CR” indicates
“Customer Reference Number.”
010013992400 is the Reference Identification. (Quote Sheet
Number).
SLN*1**O******ZZ*8414801585*CH*CN 1 is the Assigned Identification.
O is the Relationship Code. “O” indicates “Information
Copy.”
ZZ is the Product/Service ID Qualifier. “ZZ” indicates
“Mutually Defined.”
8414801585 IS THE PRODUCT/SERVICE ID. (TARIFF
NUMBER).
CH is the Product./Service ID Qualifier. “CH” indicates
“Country of Origin Code.”
CN is the Product/Service ID.
SAC*C* ZZZZ****2*0.05*0.6*KG*165**15***NAFT C is the Allowance or Charge Indicator. “C” indicates
A “Charge.”
ZZZZ is the Service, Promotion, Allowance, or Charge
Code. “ZZZZ” indicates “Mutually Defined.”
2 is the Allowance/Charge Percent Qualifier. “2” indicates
“Item Net Cost.”
0.05 is the Percent.
0.6 is the Rate.
KG is the Unit or Basis for Measurement. “KG” indicates
“Kilogram.”
165 is the Quantity.
15 is the Allowance or Charge Method of Handling Code.
51850-IM (005010) Wal-Mart Confidential 13
“15” indicates “Information Only.”
NAFTA is the Description. This describes the allowance or
charge.
CTT*1**165*KG*1.025*CR 1 is the Number of Line Items.
165 is the Weight.
KG is the Unit or Basis for Measurement Code. “KG”
indicates “Kilogram.”
1.025 is the Volume.
CR is the Unit or Basis for Measurement Code. “CR”
indicates “Cubic Meter.”
SE*44*0001 44 is the Number of Included Segments.
0001 is the Transaction Set Control Number.

51850-IM (005010) Wal-Mart Confidential 14


Segment: ST Transaction Set Header
Position: 0100
Loop:
Level: Heading
Usage: Mandatory
Max Use: 1
Purpose: To indicate the start of a transaction set and to assign a control number
Syntax Notes:
Semantic Notes: 1 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).
2 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.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M ST01 143 Transaction Set Identifier Code M 1 ID 3/3
Code uniquely identifying a Transaction Set
850 Purchase Order
850 Purchase Order
M ST02 329 Transaction Set Control Number M 1 AN 4/9
Identifying control number that must be unique within the transaction set
functional group assigned by the originator for a transaction set
The number is sequentially assigned by the sender, starting with one
within each functional group. For each functional group, the first
transaction set control number will be 0001 and incremented by one for
each additional transaction set within the group.
ST03 1705 Implementation Convention Reference O 1 AN 1/35
Reference assigned to identify Implementation Convention

51850-IM (005010) Wal-Mart Confidential 15


Segment: BEG Beginning Segment for Purchase Order
Position: 0200
Loop:
Level: Heading
Usage: Mandatory
Max Use: 1
Purpose: To indicate the beginning of the Purchase Order Transaction Set and transmit identifying
numbers and dates
Syntax Notes:
Semantic Notes: 1 BEG05 is the date assigned by the purchaser to purchase order.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M BEG01 353 Transaction Set Purpose Code M 1 ID 2/2
Code identifying purpose of transaction set
00 Original
01 Cancellation
04 Change
22 Information Copy
This code is used to notify anyone other than the
seller about this order.
M BEG02 92 Purchase Order Type Code M 1 ID 2/2
Code specifying the type of Purchase Order
BE Blanket Order/Estimated Quantities (Not firm
Commitment)
M BEG03 324 Purchase Order Number M 1 AN 1/22
Identifying number for Purchase Order assigned by the orderer/purchaser
Retailer's original purchase order number
BEG04 328 Release Number O 1 AN 1/30
Number identifying a release against a Purchase Order previously placed by
the parties involved in the transaction
Retailer's release against the purchase order, if used
M BEG05 373 Date M 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
Retailer's original purchase order date
BEG06 367 Contract Number O 1 AN 1/30
Contract number
BEG07 587 Acknowledgment Type O 1 ID 2/2
Code specifying the type of acknowledgment
BEG08 1019 Invoice Type Code O 1 ID 3/3
Code defining the method by which invoices are to be processed
BEG09 1166 Contract Type Code O 1 ID 2/2
Code identifying a contract type
BEG10 1232 Purchase Category O 1 ID 2/2
Code identifying the broad category of products or services being acquired
BEG11 786 Security Level Code O 1 ID 2/2
Code indicating the level of confidentiality assigned by the sender to the
information following
BEG12 640 Transaction Type Code O 1 ID 2/2
Code specifying the type of transaction

51850-IM (005010) Wal-Mart Confidential 16


Segment: REF Reference Information
Position: 0500
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify identifying information
Syntax Notes: 1 At least one of REF02 or REF03 is required.
2 If either C04003 or C04004 is present, then the other is required.
3 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 REF04 contains data relating to the value cited in REF02.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M REF01 128 Reference Identification Qualifier M 1 ID 2/3
Code qualifying the Reference Identification
DP Department Number
This code may be used in the header area or the
detail area, but not both.
REF02 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
This is the Wal-Mart assigned department number.
REF03 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
REF04 C040 Reference Identifier O 1
To identify one or more reference numbers or identification numbers as
specified by the Reference Qualifier
C04001 128 Reference Identification Qualifier M ID 2/3
Code qualifying the Reference Identification
C04002 127 Reference Identification M AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04003 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04004 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04005 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04006 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier

51850-IM (005010) Wal-Mart Confidential 17


Segment: REF Reference Information
Position: 0500
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify identifying information
Syntax Notes: 1 At least one of REF02 or REF03 is required.
2 If either C04003 or C04004 is present, then the other is required.
3 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 REF04 contains data relating to the value cited in REF02.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M REF01 128 Reference Identification Qualifier M 1 ID 2/3
Code qualifying the Reference Identification
MR Merchandise Type Code
REF02 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
This is the Wal-Mart order type.
REF03 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
REF04 C040 Reference Identifier O 1
To identify one or more reference numbers or identification numbers as
specified by the Reference Qualifier
C04001 128 Reference Identification Qualifier M ID 2/3
Code qualifying the Reference Identification
C04002 127 Reference Identification M AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04003 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04004 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04005 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04006 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier

51850-IM (005010) Wal-Mart Confidential 18


Segment: REF Reference Information
Position: 0500
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify identifying information
Syntax Notes: 1 At least one of REF02 or REF03 is required.
2 If either C04003 or C04004 is present, then the other is required.
3 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 REF04 contains data relating to the value cited in REF02.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M REF01 128 Reference Identification Qualifier M 1 ID 2/3
Code qualifying the Reference Identification
PD Promotion/Deal Number
Product group or selling zone
REF02 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
This is the Wal-Mart event code.
REF03 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
REF04 C040 Reference Identifier O 1
To identify one or more reference numbers or identification numbers as
specified by the Reference Qualifier
C04001 128 Reference Identification Qualifier M ID 2/3
Code qualifying the Reference Identification
C04002 127 Reference Identification M AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04003 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04004 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04005 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04006 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier

51850-IM (005010) Wal-Mart Confidential 19


Segment: PER Administrative Communications Contact
Position: 0600
Loop:
Level: Heading
Usage: Optional
Max Use: 3
Purpose: To identify a person or office to whom administrative communications should be directed
Syntax Notes: 1 If either PER03 or PER04 is present, then the other is required.
2 If either PER05 or PER06 is present, then the other is required.
3 If either PER07 or PER08 is present, then the other is required.
Semantic Notes:
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M PER01 366 Contact Function Code M 1 ID 2/2
Code identifying the major duty or responsibility of the person or group named
BD Buyer Name or Department
PER02 93 Name O 1 AN 1/60
Free-form name
This is the buyer’s name.
PER03 365 Communication Number Qualifier X 1 ID 2/2
Code identifying the type of communication number
PER04 364 Communication Number X 1 AN 1/256
Complete communications number including country or area code when
applicable
PER05 365 Communication Number Qualifier X 1 ID 2/2
Code identifying the type of communication number
PER06 364 Communication Number X 1 AN 1/256
Complete communications number including country or area code when
applicable
PER07 365 Communication Number Qualifier X 1 ID 2/2
Code identifying the type of communication number
PER08 364 Communication Number X 1 AN 1/256
Complete communications number including country or area code when
applicable
PER09 443 Contact Inquiry Reference O 1 AN 1/20
Additional reference number or description to clarify a contact number

51850-IM (005010) Wal-Mart Confidential 20


Segment: FOB F.O.B. Related Instructions
Position: 0800
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify transportation instructions relating to shipment
Syntax Notes: 1 If FOB03 is present, then FOB02 is required.
2 If FOB04 is present, then FOB05 is required.
3 If FOB07 is present, then FOB06 is required.
4 If FOB08 is present, then FOB09 is required.
Semantic Notes: 1 FOB01 indicates which party will pay the carrier.
2 FOB02 is the code specifying transportation responsibility location.
3 FOB06 is the code specifying the title passage location.
4 FOB08 is the code specifying the point at which the risk of loss transfers. This may
be different than the location specified in FOB02/FOB03 and FOB06/FOB07.
Comments:
Notes: This segment is only used for Canada Sam’s Fresh Orders.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M FOB01 146 Shipment Method of Payment M 1 ID 2/2
Code identifying payment terms for transportation charges
CC Collect
PP Prepaid (by Seller)
FOB02 309 Location Qualifier X 1 ID 1/2
Code identifying type of location
DE Destination (Shipping)
ZZ Mutually Defined
Indicates the place of possession.
FOB03 352 Description O 1 AN 1/80
A free-form description to clarify the related data elements and their content
Free-form name of transportation responsibility location. This is the place
of possession.
FOB04 334 Transportation Terms Qualifier Code O 1 ID 2/2
Code identifying the source of the transportation terms
01 Incoterms
FOB05 335 Transportation Terms Code X 1 ID 3/3
Code identifying the trade terms which apply to the shipment transportation
responsibility
This is the Incoterms code
FOB06 309 Location Qualifier X 1 ID 1/2
Code identifying type of location
FOB07 352 Description O 1 AN 1/80
A free-form description to clarify the related data elements and their content
FOB08 54 Risk of Loss Code O 1 ID 2/2
Code specifying where responsibility for risk of loss passes
FOB09 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content

51850-IM (005010) Wal-Mart Confidential 21


Segment: DTM Date/Time Reference
Position: 1500
Loop:
Level: Heading
Usage: Optional
Max Use: 10
Purpose: To specify pertinent dates and times
Syntax Notes: 1 At least one of DTM02 DTM03 or DTM05 is required.
2 If DTM04 is present, then DTM03 is required.
3 If either DTM05 or DTM06 is present, then the other is required.
Semantic Notes:
Comments:
Notes: This segment contains the warehouse cancel date.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M DTM01 374 Date/Time Qualifier M 1 ID 3/3
Code specifying type of date or time, or both date and time
001 Cancel After
If the order has not been shipped by this date, the
order is considered canceled
DTM02 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
If the order has not been shipped by this date, the order is considered
canceled
DTM03 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-
59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds
are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
DTM04 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
DTM05 1250 Date Time Period Format Qualifier X 1 ID 2/3
Code indicating the date format, time format, or date and time format
DTM06 1251 Date Time Period X 1 AN 1/35
Expression of a date, a time, or range of dates, times or dates and times

51850-IM (005010) Wal-Mart Confidential 22


Segment: DTM Date/Time Reference
Position: 1500
Loop:
Level: Heading
Usage: Optional
Max Use: 10
Purpose: To specify pertinent dates and times
Syntax Notes: 1 At least one of DTM02 DTM03 or DTM05 is required.
2 If DTM04 is present, then DTM03 is required.
3 If either DTM05 or DTM06 is present, then the other is required.
Semantic Notes:
Comments:
Notes: This segment contains the warehouse ship date.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M DTM01 374 Date/Time Qualifier M 1 ID 3/3
Code specifying type of date or time, or both date and time
010 Requested Ship
DTM02 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
DTM03 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-
59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds
are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
DTM04 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
DTM05 1250 Date Time Period Format Qualifier X 1 ID 2/3
Code indicating the date format, time format, or date and time format
DTM06 1251 Date Time Period X 1 AN 1/35
Expression of a date, a time, or range of dates, times or dates and times

51850-IM (005010) Wal-Mart Confidential 23


Segment: DTM Date/Time Reference
Position: 1500
Loop:
Level: Heading
Usage: Optional
Max Use: 10
Purpose: To specify pertinent dates and times
Syntax Notes: 1 At least one of DTM02 DTM03 or DTM05 is required.
2 If DTM04 is present, then DTM03 is required.
3 If either DTM05 or DTM06 is present, then the other is required.
Semantic Notes:
Comments:
Notes: This segment contains the supplier ship date.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M DTM01 374 Date/Time Qualifier M 1 ID 3/3
Code specifying type of date or time, or both date and time
037 Ship Not Before
If the retailer allows shipment before the requested
ship date, this is the earliest date shipping can occur
DTM02 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
If the retailer allows shipment before the requested ship date, this is the
earliest date shipping can occur
DTM03 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-
59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds
are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
DTM04 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
DTM05 1250 Date Time Period Format Qualifier X 1 ID 2/3
Code indicating the date format, time format, or date and time format
DTM06 1251 Date Time Period X 1 AN 1/35
Expression of a date, a time, or range of dates, times or dates and times

51850-IM (005010) Wal-Mart Confidential 24


Segment: DTM Date/Time Reference
Position: 1500
Loop:
Level: Heading
Usage: Optional
Max Use: 10
Purpose: To specify pertinent dates and times
Syntax Notes: 1 At least one of DTM02 DTM03 or DTM05 is required.
2 If DTM04 is present, then DTM03 is required.
3 If either DTM05 or DTM06 is present, then the other is required.
Semantic Notes:
Comments:
Notes: This segment contains the supplier cancel date.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M DTM01 374 Date/Time Qualifier M 1 ID 3/3
Code specifying type of date or time, or both date and time
038 Ship No Later
DTM02 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
DTM03 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-
59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds
are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
DTM04 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
DTM05 1250 Date Time Period Format Qualifier X 1 ID 2/3
Code indicating the date format, time format, or date and time format
DTM06 1251 Date Time Period X 1 AN 1/35
Expression of a date, a time, or range of dates, times or dates and times

51850-IM (005010) Wal-Mart Confidential 25


Segment: DTM Date/Time Reference
Position: 1500
Loop:
Level: Heading
Usage: Optional
Max Use: 10
Purpose: To specify pertinent dates and times
Syntax Notes: 1 At least one of DTM02 DTM03 or DTM05 is required.
2 If DTM04 is present, then DTM03 is required.
3 If either DTM05 or DTM06 is present, then the other is required.
Semantic Notes:
Comments:
Notes: This segment contains the in-store date.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M DTM01 374 Date/Time Qualifier M 1 ID 3/3
Code specifying type of date or time, or both date and time
002 Delivery Requested
DTM02 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
DTM03 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-
59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds
are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
DTM04 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
DTM05 1250 Date Time Period Format Qualifier X 1 ID 2/3
Code indicating the date format, time format, or date and time format
DTM06 1251 Date Time Period X 1 AN 1/35
Expression of a date, a time, or range of dates, times or dates and times

51850-IM (005010) Wal-Mart Confidential 26


Segment: TD5 Carrier Details (Routing Sequence/Transit Time)
Position: 2400
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the carrier and sequence of routing and provide transit time information
Syntax Notes: 1 At least one of TD502 TD504 TD505 TD506 or TD512 is required.
2 If TD502 is present, then TD503 is required.
3 If TD507 is present, then TD508 is required.
4 If TD510 is present, then TD511 is required.
5 If TD513 is present, then TD512 is required.
6 If TD514 is present, then TD513 is required.
7 If TD515 is present, then TD512 is required.
Semantic Notes: 1 TD515 is the country where the service is to be performed.
Comments: 1 When specifying a routing sequence to be used for the shipment movement in lieu of
specifying each carrier within the movement, use TD502 to identify the party
responsible for defining the routing sequence, and use TD503 to identify the actual
routing sequence, specified by the party identified in TD502.
Notes: This segment contains the port of loading.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD501 133 Routing Sequence Code O 1 ID 1/2
Code describing the relationship of a carrier to a specific shipment movement
TD502 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
TD503 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
TD504 91 Transportation Method/Type Code X 1 ID 1/2
Code specifying the method or type of transportation for the shipment
A Air
MB Motor (Bulk Carrier)
O Containerized Ocean
R Rail
TD505 387 Routing X 1 AN 1/35
Free-form description of the routing or requested routing for shipment, or the
originating carrier's identity
TD506 368 Shipment/Order Status Code X 1 ID 2/2
Code indicating the status of an order or shipment or the disposition of any
difference between the quantity ordered and the quantity shipped for a line
item or transaction
TD507 309 Location Qualifier O 1 ID 1/2
Code identifying type of location
KL Port of Loading
TD508 310 Location Identifier X 1 AN 1/30
Code which identifies a specific location
TD509 731 Transit Direction Code O 1 ID 2/2
The point of origin and point of direction
TD510 732 Transit Time Direction Qualifier O 1 ID 2/2
Code specifying the value of time used to measure the transit time
TD511 733 Transit Time X 1 R 1/4
The numeric amount of transit time

51850-IM (005010) Wal-Mart Confidential 27


TD512 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
Used when TD507 is KL.
ZZ Mutually Defined
TD513 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD514 284 Service Level Code O 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD515 26 Country Code O 1 ID 2/3
Code identifying the country
Used when TD507 is KL.

51850-IM (005010) Wal-Mart Confidential 28


Segment: TD5 Carrier Details (Routing Sequence/Transit Time)
Position: 2400
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the carrier and sequence of routing and provide transit time information
Syntax Notes: 1 At least one of TD502 TD504 TD505 TD506 or TD512 is required.
2 If TD502 is present, then TD503 is required.
3 If TD507 is present, then TD508 is required.
4 If TD510 is present, then TD511 is required.
5 If TD513 is present, then TD512 is required.
6 If TD514 is present, then TD513 is required.
7 If TD515 is present, then TD512 is required.
Semantic Notes: 1 TD515 is the country where the service is to be performed.
Comments: 1 When specifying a routing sequence to be used for the shipment mo vement in lieu of
specifying each carrier within the movement, use TD502 to identify the party
responsible for defining the routing sequence, and use TD503 to identify the actual
routing sequence, specified by the party identified in TD502.
Notes: This segment contains the final destination.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD501 133 Routing Sequence Code O 1 ID 1/2
Code describing the relationship of a carrier to a specific shipment movement
TD502 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
TD503 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
TD504 91 Transportation Method/Type Code X 1 ID 1/2
Code specifying the method or type of transportation for the shipment
A Air
MB Motor (Bulk Carrier)
O Containerized Ocean
R Rail
TD505 387 Routing X 1 AN 1/35
Free-form description of the routing or requested routing for shipment, or the
originating carrier's identity
TD506 368 Shipment/Order Status Code X 1 ID 2/2
Code indicating the status of an order or shipment or the disposition of any
difference between the quantity ordered and the quantity shipped for a line
item or transaction
TD507 309 Location Qualifier O 1 ID 1/2
Code identifying type of location
DE Destination (Shipping)
TD508 310 Location Identifier X 1 AN 1/30
Code which identifies a specific location
TD509 731 Transit Direction Code O 1 ID 2/2
The point of origin and point of direction
TD510 732 Transit Time Direction Qualifier O 1 ID 2/2
Code specifying the value of time used to measure the transit time
TD511 733 Transit Time X 1 R 1/4
The numeric amount of transit time

51850-IM (005010) Wal-Mart Confidential 29


TD512 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD513 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD514 284 Service Level Code O 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD515 26 Country Code O 1 ID 2/3
Code identifying the country

51850-IM (005010) Wal-Mart Confidential 30


Segment: TD5 Carrier Details (Routing Sequence/Transit Time)
Position: 2400
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the carrier and sequence of routing and provide transit time information
Syntax Notes: 1 At least one of TD502 TD504 TD505 TD506 or TD512 is required.
2 If TD502 is present, then TD503 is required.
3 If TD507 is present, then TD508 is required.
4 If TD510 is present, then TD511 is required.
5 If TD513 is present, then TD512 is required.
6 If TD514 is present, then TD513 is required.
7 If TD515 is present, then TD512 is required.
Semantic Notes: 1 TD515 is the country where the service is to be performed.
Comments: 1 When specifying a routing sequence to be used for the shipment movement in lieu of
specifying each carrier within the movement, use TD502 to identify the party
responsible for defining the routing sequence, and use TD503 to identify the actual
routing sequence, specified by the party identified in TD502.
Notes: This segment contains the country of origin.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD501 133 Routing Sequence Code O 1 ID 1/2
Code describing the relationship of a carrier to a specific shipment movement
TD502 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
TD503 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
TD504 91 Transportation Method/Type Code X 1 ID 1/2
Code specifying the method or type of transportation for the shipment
A Air
MB Motor (Bulk Carrier)
O Containerized Ocean
R Rail
TD505 387 Routing X 1 AN 1/35
Free-form description of the routing or requested routing for shipment, or the
originating carrier's identity
TD506 368 Shipment/Order Status Code X 1 ID 2/2
Code indicating the status of an order or shipment or the disposition of any
difference between the quantity ordered and the quantity shipped for a line
item or transaction
TD507 309 Location Qualifier O 1 ID 1/2
Code identifying type of location
CA Country of Origin
TD508 310 Location Identifier X 1 AN 1/30
Code which identifies a specific location
TD509 731 Transit Direction Code O 1 ID 2/2
The point of origin and point of direction
TD510 732 Transit Time Direction Qualifier O 1 ID 2/2
Code specifying the value of time used to measure the transit time
TD511 733 Transit Time X 1 R 1/4
The numeric amount of transit time

51850-IM (005010) Wal-Mart Confidential 31


TD512 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD513 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD514 284 Service Level Code O 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD515 26 Country Code O 1 ID 2/3
Code identifying the country

51850-IM (005010) Wal-Mart Confidential 32


Segment: TD5 Carrier Details (Routing Sequence/Transit Time)
Position: 2400
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the carrier and sequence of routing and provide transit time information
Syntax Notes: 1 At least one of TD502 TD504 TD505 TD506 or TD512 is required.
2 If TD502 is present, then TD503 is required.
3 If TD507 is present, then TD508 is required.
4 If TD510 is present, then TD511 is required.
5 If TD513 is present, then TD512 is required.
6 If TD514 is present, then TD513 is required.
7 If TD515 is present, then TD512 is required.
Semantic Notes: 1 TD515 is the country where the service is to be performed.
Comments: 1 When specifying a routing sequence to be used for the shipment movement in lieu of
specifying each carrier within the movement, use TD502 to identify the party
responsible for defining the routing sequence, and use TD503 to identify the actual
routing sequence, specified by the party identified in TD502.
Notes: This segment contains the port of arrival for the purchase order.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD501 133 Routing Sequence Code O 1 ID 1/2
Code describing the relationship of a carrier to a specific shipment movement
TD502 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
TD503 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
TD504 91 Transportation Method/Type Code X 1 ID 1/2
Code specifying the method or type of transportation for the shipment
A Air
MB Motor (Bulk Carrier)
O Containerized Ocean
R Rail
TD505 387 Routing X 1 AN 1/35
Free-form description of the routing or requested routing for shipment, or the
originating carrier's identity
TD506 368 Shipment/Order Status Code X 1 ID 2/2
Code indicating the status of an order or shipment or the disposition of any
difference between the quantity ordered and the quantity shipped for a line
item or transaction
TD507 309 Location Qualifier O 1 ID 1/2
Code identifying type of location
PA Port of Arrival
Port where shipment enters country
Port where the shipment enters the country
TD508 310 Location Identifier X 1 AN 1/30
Code which identifies a specific location
TD509 731 Transit Direction Code O 1 ID 2/2
The point of origin and point of direction
TD510 732 Transit Time Direction Qualifier O 1 ID 2/2
Code specifying the value of time used to measure the transit time

51850-IM (005010) Wal-Mart Confidential 33


TD511 733 Transit Time X 1 R 1/4
The numeric amount of transit time
TD512 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD513 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD514 284 Service Level Code O 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD515 26 Country Code O 1 ID 2/3
Code identifying the country

51850-IM (005010) Wal-Mart Confidential 34


Segment: TD5 Carrier Details (Routing Sequence/Transit Time)
Position: 2400
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the carrier and sequence of routing and provide transit time information
Syntax Notes: 1 At least one of TD502 TD504 TD505 TD506 or TD512 is required.
2 If TD502 is present, then TD503 is required.
3 If TD507 is present, then TD508 is required.
4 If TD510 is present, then TD511 is required.
5 If TD513 is present, then TD512 is required.
6 If TD514 is present, then TD513 is required.
7 If TD515 is present, then TD512 is required.
Semantic Notes: 1 TD515 is the country where the service is to be performed.
Comments: 1 When specifying a routing sequence to be used for the shipment movement in lieu of
specifying each carrier within the movement, use TD502 to identify the party
responsible for defining the routing sequence, and use TD503 to identify the actual
routing sequence, specified by the party identified in TD502.
Notes: This segment contains the port of unloading for the purchase order.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD501 133 Routing Sequence Code O 1 ID 1/2
Code describing the relationship of a carrier to a specific shipment movement
TD502 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
TD503 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
TD504 91 Transportation Method/Type Code X 1 ID 1/2
Code specifying the method or type of transportation for the shipment
A Air
MB Motor (Bulk Carrier)
O Containerized Ocean
R Rail
TD505 387 Routing X 1 AN 1/35
Free-form description of the routing or requested routing for shipment, or the
originating carrier's identity
TD506 368 Shipment/Order Status Code X 1 ID 2/2
Code indicating the status of an order or shipment or the disposition of any
difference between the quantity ordered and the quantity shipped for a line
item or transaction
TD507 309 Location Qualifier O 1 ID 1/2
Code identifying type of location
PB Port of Discharge
Port where shipment is unloaded
Port where the shipment is unloaded
TD508 310 Location Identifier X 1 AN 1/30
Code which identifies a specific location
TD509 731 Transit Direction Code O 1 ID 2/2
The point of origin and point of direction
TD510 732 Transit Time Direction Qualifier O 1 ID 2/2
Code specifying the value of time used to measure the transit time

51850-IM (005010) Wal-Mart Confidential 35


TD511 733 Transit Time X 1 R 1/4
The numeric amount of transit time
TD512 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD513 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD514 284 Service Level Code O 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD515 26 Country Code O 1 ID 2/3
Code identifying the country

51850-IM (005010) Wal-Mart Confidential 36


Segment: TD5 Carrier Details (Routing Sequence/Transit Time)
Position: 2400
Loop:
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the carrier and sequence of routing and provide transit time information
Syntax Notes: 1 At least one of TD502 TD504 TD505 TD506 or TD512 is required.
2 If TD502 is present, then TD503 is required.
3 If TD507 is present, then TD508 is required.
4 If TD510 is present, then TD511 is required.
5 If TD513 is present, then TD512 is required.
6 If TD514 is present, then TD513 is required.
7 If TD515 is present, then TD512 is required.
Semantic Notes: 1 TD515 is the country where the service is to be performed.
Comments: 1 When specifying a routing sequence to be used for the shipment movement in lieu of
specifying each carrier within the movement, use TD502 to identify the party
responsible for defining the routing sequence, and use TD503 to identify the actual
routing sequence, specified by the party identified in TD502.
Notes: This segment contains the port where customs declaration occurs.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD501 133 Routing Sequence Code O 1 ID 1/2
Code describing the relationship of a carrier to a specific shipment movement
TD502 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
TD503 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
TD504 91 Transportation Method/Type Code X 1 ID 1/2
Code specifying the method or type of transportation for the shipment
A Air
MB Motor (Bulk Carrier)
O Containerized Ocean
R Rail
TD505 387 Routing X 1 AN 1/35
Free-form description of the routing or requested routing for shipment, or the
originating carrier's identity
TD506 368 Shipment/Order Status Code X 1 ID 2/2
Code indicating the status of an order or shipment or the disposition of any
difference between the quantity ordered and the quantity shipped for a line
item or transaction
TD507 309 Location Qualifier O 1 ID 1/2
Code identifying type of location
Port where the customs is declared
PE Port of Entry
Port where customs is declared
Port where the customs is declared
TD508 310 Location Identifier X 1 AN 1/30
Code which identifies a specific location
TD509 731 Transit Direction Code O 1 ID 2/2
The point of origin and point of direction
TD510 732 Transit Time Direction Qualifier O 1 ID 2/2

51850-IM (005010) Wal-Mart Confidential 37


Code specifying the value of time used to measure the transit time
TD511 733 Transit Time X 1 R 1/4
The numeric amount of transit time
TD512 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD513 284 Service Level Code X 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD514 284 Service Level Code O 1 ID 2/2
Code indicating the level of transportation service or the billing service offered
by the transportation carrier
TD515 26 Country Code O 1 ID 2/3
Code identifying the country

51850-IM (005010) Wal-Mart Confidential 38


Segment: N1 Party Identification
Position: 3100
Loop: N1
Level: Heading
Usage: Optional
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.
Notes: Store/warehouse information can be found in the 816 Organizational Relationships
Transaction Set.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N101 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
BT Bill-to-Party
N102 93 Name X 1 AN 1/60
Free-form name
N103 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
UL Global Location Number (GLN)
A globally unique 13 digit code for the identification of a
legal, functional or physical location within the Uniform
Code Council (UCC) and International Article Number
Association (EAN) numbering system
This is the 13-digit Global Location Number (GLN).
See External Code Source 583 in Section III for
reference document.
N104 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
This is the 13-digit corporate Wal-Mart global location number.
N105 706 Entity Relationship Code O 1 ID 2/2
Code describing entity relationship
N106 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

51850-IM (005010) Wal-Mart Confidential 39


Segment: N1 Party Identification
Position: 3100
Loop: N1
Level: Heading
Usage: Optional
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comme nts: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N101 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
BO Broker or Sales Office
For a domestic purchase order, this is the
manufacturer's sales office. For an import purchase
order, this is the sales office that interacts with the
manufacturer's/buyer's agent.
N102 93 Name X 1 AN 1/60
Free-form name
N103 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
92 Assigned by Buyer or Buyer's Agent
N104 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
This is the broker office number.
N105 706 Entity Relationship Code O 1 ID 2/2
Code describing entity relationship
N106 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

51850-IM (005010) Wal-Mart Confidential 40


Segment: N1 Party Identification
Position: 3100
Loop: N1
Level: Heading
Usage: Optional
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.
Notes: This segment contains the supplier information.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N101 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
SF Ship From
N102 93 Name X 1 AN 1/60
Free-form name
N103 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
92 Assigned by Buyer or Buyer's Agent
N104 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
This is the internal import vendor number.
N105 706 Entity Relationship Code O 1 ID 2/2
Code describing entity relationship
N106 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

51850-IM (005010) Wal-Mart Confidential 41


Segment: N3 Party Location
Position: 3300
Loop: N1
Level: Heading
Usage: Optional
Max Use: 2
Purpose: To specify the location of the named party
Syntax Notes:
Semantic Notes:
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N301 166 Address Information M 1 AN 1/55
Address information
N302 166 Address Information O 1 AN 1/55
Address information

51850-IM (005010) Wal-Mart Confidential 42


Segment: N4 Geographic Location
Position: 3400
Loop: N1
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the geographic place of the named party
Syntax Notes: 1 Only one of N402 or N407 may be present.
2 If N406 is present, then N405 is required.
3 If N407 is present, then N404 is required.
Semantic Notes:
Comments: 1 A combination of either N401 through N404, or N405 and N406 may be adequate to
specify a location.
2 N402 is required only if city name (N401) is in the U.S. or Canada.

Data Element Summary


Ref. Data
Des. Element Name Attributes
N401 19 City Name O 1 AN 2/30
Free-form text for city name
N402 156 State or Province Code X 1 ID 2/2
Code (Standard State/Province) as defined by appropriate government agency
N403 116 Postal Code O 1 ID 3/15
Code defining international postal zone code excluding punctuation and blanks
(zip code for United States)
N404 26 Country Code X 1 ID 2/3
Code identifying the country
N405 309 Location Qualifier X 1 ID 1/2
Code identifying type of location
N406 310 Location Identifier O 1 AN 1/30
Code which identifies a specific location
N407 1715 Country Subdivision Code X 1 ID 1/3
Code identifying the country subdivision

51850-IM (005010) Wal-Mart Confidential 43


Segment: N1 Party Identification
Position: 3100
Loop: N1
Level: Heading
Usage: Optional
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.
Notes: This segment contains the ticket ship to information.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N101 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
AE Additional Delivery Address
N102 93 Name X 1 AN 1/60
Free-form name
N103 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
92 Assigned by Buyer or Buyer's Agent
N104 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
N105 706 Entity Relationship Code O 1 ID 2/2
Code describing entity relationship
N106 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

51850-IM (005010) Wal-Mart Confidential 44


Segment: N3 Party Location
Position: 3300
Loop: N1
Level: Heading
Usage: Optional
Max Use: 2
Purpose: To specify the location of the named party
Syntax Notes:
Semantic Notes:
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N301 166 Address Information M 1 AN 1/55
Address information
N302 166 Address Information O 1 AN 1/55
Address information

51850-IM (005010) Wal-Mart Confidential 45


Segment: N4 Geographic Location
Position: 3400
Loop: N1
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the geographic place of the named party
Syntax Notes: 1 Only one of N402 or N407 may be present.
2 If N406 is present, then N405 is required.
3 If N407 is present, then N404 is required.
Semantic Notes:
Comments: 1 A combination of either N401 through N404, or N405 and N406 may be adequate to
specify a location.
2 N402 is required only if city name (N401) is in the U.S. or Canada.

Data Element Summary


Ref. Data
Des. Element Name Attributes
N401 19 City Name O 1 AN 2/30
Free-form text for city name
N402 156 State or Province Code X 1 ID 2/2
Code (Standard State/Province) as defined by appropriate government agency
N403 116 Postal Code O 1 ID 3/15
Code defining international postal zone code excluding punctuation and blanks
(zip code for United States)
N404 26 Country Code X 1 ID 2/3
Code identifying the country
N405 309 Location Qualifier X 1 ID 1/2
Code identifying type of location
N406 310 Location Identifier O 1 AN 1/30
Code which identifies a specific location
N407 1715 Country Subdivision Code X 1 ID 1/3
Code identifying the country subdivision

51850-IM (005010) Wal-Mart Confidential 46


Segment: N1 Party Identification
Position: 3100
Loop: N1
Level: Heading
Usage: Optional
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.
Notes: This segment contains the factory information.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N101 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
MF Manufacturer of Goods
Manufacturer of goods being supplied when supplier
is not the manufacturer
N102 93 Name X 1 AN 1/60
Free-form name
N103 66 Identification Code Qualifier X 1 ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
92 Assigned by Buyer or Buyer's Agent
N104 67 Identification Code X 1 AN 2/80
Code identifying a party or other code
N105 706 Entity Relationship Code O 1 ID 2/2
Code describing entity relationship
N106 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

51850-IM (005010) Wal-Mart Confidential 47


Segment: N3 Party Location
Position: 3300
Loop: N1
Level: Heading
Usage: Optional
Max Use: 2
Purpose: To specify the location of the named party
Syntax Notes:
Semantic Notes:
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N301 166 Address Information M 1 AN 1/55
Address information
N302 166 Address Information O 1 AN 1/55
Address information

51850-IM (005010) Wal-Mart Confidential 48


Segment: N4 Geographic Location
Position: 3400
Loop: N1
Level: Heading
Usage: Optional
Max Use: >1
Purpose: To specify the geographic place of the named party
Syntax Notes: 1 Only one of N402 or N407 may be present.
2 If N406 is present, then N405 is required.
3 If N407 is present, then N404 is required.
Semantic Notes:
Comments: 1 A combination of either N401 through N404, or N405 and N406 may be adequate to
specify a location.
2 N402 is required only if city name (N401) is in the U.S. or Canada.

Data Element Summary


Ref. Data
Des. Element Name Attributes
N401 19 City Name O 1 AN 2/30
Free-form text for city name
N402 156 State or Province Code X 1 ID 2/2
Code (Standard State/Province) as defined by appropriate government agency
N403 116 Postal Code O 1 ID 3/15
Code defining international postal zone code excluding punctuation and blanks
(zip code for United States)
N404 26 Country Code X 1 ID 2/3
Code identifying the country
N405 309 Location Qualifier X 1 ID 1/2
Code identifying type of location
N406 310 Location Identifier O 1 AN 1/30
Code which identifies a specific location
N407 1715 Country Subdivision Code X 1 ID 1/3
Code identifying the country subdivision

51850-IM (005010) Wal-Mart Confidential 49


Segment: PO1 Baseline Item Data
Position: 0100
Loop: PO1
Level: Detail
Usage: Mandatory
Max Use: 1
Purpose: To specify basic and most frequently used line item data
Syntax Notes: 1 If PO103 is present, then PO102 is required.
2 If PO105 is present, then PO104 is required.
3 If either PO106 or PO107 is present, then the other is required.
4 If either PO108 or PO109 is present, then the other is required.
5 If either PO110 or PO111 is present, then the other is required.
6 If either PO112 or PO113 is present, then the other is required.
7 If either PO114 or PO115 is present, then the other is required.
8 If either PO116 or PO117 is present, then the other is required.
9 If either PO118 or PO119 is present, then the other is required.
10 If either PO120 or PO121 is present, then the other is required.
11 If either PO122 or PO123 is present, then the other is required.
12 If either PO124 or PO125 is present, then the other is required.
Semantic Notes: 1 PO102 is quantity ordered.
Comments: 1 See the Data Element Dictionary for a complete lis t of IDs.
2 PO101 is the line item identification.
3 PO106 through PO125 provide for ten different product/service IDs per each item.
For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.

Data Element Summary


Ref. Data
Des. Element Name Attributes
PO101 350 Assigned Identification O 1 AN 1/20
Alphanumeric characters assigned for differentiation within a transaction set
Purchase Order Line Number
PO102 380 Quantity X 1 R 1/15
Numeric value of quantity
PO103 355 Unit or Basis for Measurement Code O 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
CA Case
PO104 212 Unit Price X 1 R 1/17
Price per unit of product, service, commodity, etc.
PO105 639 Basis of Unit Price Code O 1 ID 2/2
Code identifying the type of unit price for an item
PO106 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
IN Buyer's Item Number
PO107 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
PO108 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
EN EAN/UCC - 13
Data structure for the 13 digit EAN.UCC (EAN
International.Uniform Code Council) Global Trade
Identification Number (GTIN)
UP UCC - 12

51850-IM (005010) Wal-Mart Confidential 50


Data structure for the 12 digit EAN.UCC (EAN
International.Uniform Code Council) Global Trade
Identification Number (GTIN). Also known as the
Universal Product Code (U.P.C.)
PO109 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
PO110 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
VN Vendor's (Seller's) Item Number
PO111 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
PO112 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
C3 Classification
This is used to indicate if the item has been pre-
classed by Wal-Mart.
PO113 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
N No
Y Yes
PO114 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
CA Case
PO115 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
Case ID
PO116 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
OT Internal Number
PO117 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
Wal-Mart internal shipping code
PO118 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
UK GTIN 14-digit Data Structure
Data structure for the 14 digit EAN.UCC (EAN
International.Uniform Code Council) Global Trade Item
Number (GTIN)
PO119 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
This is the product GTIN
PO120 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
PO121 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
PO122 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
PO123 234 Product/Service ID X 1 AN 1/48

51850-IM (005010) Wal-Mart Confidential 51


Identifying number for a product or service
PO124 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
PO125 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service

51850-IM (005010) Wal-Mart Confidential 52


Segment: CTP Pricing Information
Position: 0400
Loop: PO1-CTP
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify pricing information
Syntax Notes: 1 If either CTP04 or CTP05 is present, then the other is required.
2 If CTP06 is present, then CTP07 is required.
3 If CTP09 is present, then CTP02 is required.
4 If CTP10 is present, then CTP02 is required.
5 If CTP11 is present, then CTP03 is required.
Semantic Notes: 1 CTP07 is a multiplier factor to arrive at a final discounted price. A multiplier of .90
would be the factor if a 10% discount is given.
2 CTP08 is the rebate amount.
Comments: 1 See Figures Appendix for an example detailing the use of CTP03 and CTP04.
See Figures Appendix for an example detailing the use of CTP03, CTP04 and
CTP07.
Notes: This segment contains the net first cost for the item

Data Element Summary


Ref. Data
Des. Element Name Attributes
CTP01 687 Class of Trade Code O 1 ID 2/2
Code indicating class of trade
CTP02 236 Price Identifier Code X 1 ID 3/3
Code identifying pricing specification
FCP First Cost Price
CTP03 212 Unit Price X 1 R 1/17
Price per unit of product, service, commodity, etc.
The price is sent with a decimal point only when needed, e.g., $15.95 would
be sent as "15.95" and $29.00 would be sent as "29".
CTP04 380 Quantity X 1 R 1/15
Numeric value of quantity
CTP05 C001 Composite Unit of Measure X 1
To identify a composite unit of measure (See Figures Appendix for examples of
use)
C00101 355 Unit or Basis for Measurement Code M ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00102 1018 Exponent O R 1/15
Power to which a unit is raised
C00103 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00104 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00105 1018 Exponent O R 1/15
Power to which a unit is raised
C00106 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00107 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00108 1018 Exponent O R 1/15

51850-IM (005010) Wal-Mart Confidential 53


Power to which a unit is raised
C00109 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00110 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00111 1018 Exponent O R 1/15
Power to which a unit is raised
C00112 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00113 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00114 1018 Exponent O R 1/15
Power to which a unit is raised
C00115 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
CTP06 648 Price Multiplier Qualifier O 1 ID 3/3
Code indicating the type of price multiplier
CTP07 649 Multiplier X 1 R 1/10
Value to be used as a multiplier to obtain a new value
CTP08 782 Monetary Amount O 1 R 1/18
Monetary amount
CTP09 639 Basis of Unit Price Code O 1 ID 2/2
Code identifying the type of unit price for an item
CTP10 499 Condition Value O 1 AN 1/10
Identifies rate restrictions or provisions
CTP11 289 Multiple Price Quantity O 1 N0 1/2
Quantity of units for a given price, e.g., 3 for $10.00

51850-IM (005010) Wal-Mart Confidential 54


Segment: CUR Currency
Position: 0430
Loop: PO1-CTP
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify the currency (dollars, pounds, francs, etc.) used in a transaction
Syntax Notes: 1 If CUR08 is present, then CUR07 is required.
2 If CUR09 is present, then CUR07 is required.
3 If CUR10 is present, then at least one of CUR11 or CUR12 is required.
4 If CUR11 is present, then CUR10 is required.
5 If CUR12 is present, then CUR10 is required.
6 If CUR13 is present, then at least one of CUR14 or CUR15 is required.
7 If CUR14 is present, then CUR13 is required.
8 If CUR15 is present, then CUR13 is required.
9 If CUR16 is present, then at least one of CUR17 or CUR18 is required.
10 If CUR17 is present, then CUR16 is required.
11 If CUR18 is present, then CUR16 is required.
12 If CUR19 is present, then at least one of CUR20 or CUR21 is required.
13 If CUR20 is present, then CUR19 is required.
14 If CUR21 is present, then CUR19 is required.
Semantic Notes:
Comments: 1 See Figures Appendix for examples detailing the use of the CUR segment.
Notes: This segment is used to specify the currency for the price identified in the previous
CTP segment.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M CUR01 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
BY Buying Party (Purchaser)
M CUR02 100 Currency Code M 1 ID 3/3
Code (Standard ISO) for country in whose currency the charges are specified
This is the ISO code for the currency.
CUR03 280 Exchange Rate O 1 R 4/10
Value to be used as a multiplier conversion factor to convert monetary value
from one currency to another
CUR04 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
CUR05 100 Currency Code O 1 ID 3/3
Code (Standard ISO) for country in whose currency the charges are specified
CUR06 669 Currency Market/Exchange Code O 1 ID 3/3
Code identifying the market upon which the currency exchange rate is based
CUR07 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR08 373 Date O 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR09 337 Time O 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR10 374 Date/Time Qualifier X 1 ID 3/3

51850-IM (005010) Wal-Mart Confidential 55


Code specifying type of date or time, or both date and time
CUR11 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR12 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR13 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR14 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR15 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR16 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR17 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR18 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR19 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR20 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR21 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

51850-IM (005010) Wal-Mart Confidential 56


Segment: CTP Pricing Information
Position: 0400
Loop: PO1-CTP
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify pricing information
Syntax Notes: 1 If either CTP04 or CTP05 is present, then the other is required.
2 If CTP06 is present, then CTP07 is required.
3 If CTP09 is present, then CTP02 is required.
4 If CTP10 is present, then CTP02 is required.
5 If CTP11 is present, then CTP03 is required.
Semantic Notes: 1 CTP07 is a multiplier factor to arrive at a final discounted price. A multiplier of .90
would be the factor if a 10% discount is given.
2 CTP08 is the rebate amount.
Comments: 1 See Figures Appendix for an example detailing the use of CTP03 and CTP04.
See Figures Appendix for an example detailing the use of CTP03, CTP04 and
CTP07.
Notes: This segment contains the net first cost for the item for the currency listed in the
following CUR segment

Data Element Summary


Ref. Data
Des. Element Name Attributes
CTP01 687 Class of Trade Code O 1 ID 2/2
Code indicating class of trade
CTP02 236 Price Identifier Code X 1 ID 3/3
Code identifying pricing specification
ALT Alternate Price
CTP03 212 Unit Price X 1 R 1/17
Price per unit of product, service, commodity, etc.
The price is sent with a decimal point only when needed, e.g., $15.95 would
be sent as "15.95" and $29.00 would be sent as "29".
CTP04 380 Quantity X 1 R 1/15
Numeric value of quantity
CTP05 C001 Composite Unit of Measure X 1
To identify a composite unit of measure (See Figures Appendix for examples of
use)
C00101 355 Unit or Basis for Measurement Code M ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00102 1018 Exponent O R 1/15
Power to which a unit is raised
C00103 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00104 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00105 1018 Exponent O R 1/15
Power to which a unit is raised
C00106 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00107 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00108 1018 Exponent O R 1/15
51850-IM (005010) Wal-Mart Confidential 57
Power to which a unit is raised
C00109 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00110 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00111 1018 Exponent O R 1/15
Power to which a unit is raised
C00112 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00113 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00114 1018 Exponent O R 1/15
Power to which a unit is raised
C00115 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
CTP06 648 Price Multiplier Qualifier O 1 ID 3/3
Code indicating the type of price multiplier
CTP07 649 Multiplier X 1 R 1/10
Value to be used as a multiplier to obtain a new value
CTP08 782 Monetary Amount O 1 R 1/18
Monetary amount
CTP09 639 Basis of Unit Price Code O 1 ID 2/2
Code identifying the type of unit price for an item
CTP10 499 Condition Value O 1 AN 1/10
Identifies rate restrictions or provisions
CTP11 289 Multiple Price Quantity O 1 N0 1/2
Quantity of units for a given price, e.g., 3 for $10.00

51850-IM (005010) Wal-Mart Confidential 58


Segment: CUR Currency
Position: 0430
Loop: PO1-CTP
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify the currency (dollars, pounds, francs, etc.) used in a transaction
Syntax Notes: 1 If CUR08 is present, then CUR07 is required.
2 If CUR09 is present, then CUR07 is required.
3 If CUR10 is present, then at least one of CUR11 or CUR12 is required.
4 If CUR11 is present, then CUR10 is required.
5 If CUR12 is present, then CUR10 is required.
6 If CUR13 is present, then at least one of CUR14 or CUR15 is required.
7 If CUR14 is present, then CUR13 is required.
8 If CUR15 is present, then CUR13 is required.
9 If CUR16 is present, then at least one of CUR17 or CUR18 is required.
10 If CUR17 is present, then CUR16 is required.
11 If CUR18 is present, then CUR16 is required.
12 If CUR19 is present, then at least one of CUR20 or CUR21 is required.
13 If CUR20 is present, then CUR19 is required.
14 If CUR21 is present, then CUR19 is required.
Semantic Notes:
Comments: 1 See Figures Appendix for examples detailing the use of the CUR segment.
Notes: This segment may be used to specify the currency for the price identified in the
previous CTP segment.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M CUR01 98 Entity Identifier Code M 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
BY Buying Party (Purchaser)
M CUR02 100 Currency Code M 1 ID 3/3
Code (Standard ISO) for country in whose currency the charges are specified
This is the ISO currency code.
CUR03 280 Exchange Rate O 1 R 4/10
Value to be used as a multiplier conversion factor to convert monetary value
from one currency to another
CUR04 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
CUR05 100 Currency Code O 1 ID 3/3
Code (Standard ISO) for country in whose currency the charges are specified
CUR06 669 Currency Market/Exchange Code O 1 ID 3/3
Code identifying the market upon which the currency exchange rate is based
CUR07 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR08 373 Date O 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR09 337 Time O 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR10 374 Date/Time Qualifier X 1 ID 3/3

51850-IM (005010) Wal-Mart Confidential 59


Code specifying type of date or time, or both date and time
CUR11 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR12 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR13 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR14 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR15 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR16 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR17 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR18 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
CUR19 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
CUR20 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
CUR21 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

51850-IM (005010) Wal-Mart Confidential 60


Segment: PID Product/Item Description
Position: 0500
Loop: PO1-PID
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To describe a product or process in coded or free-form format
Syntax Notes: 1 If PID04 is present, then PID03 is required.
2 At least one of PID04 or PID05 is required.
3 If PID07 is present, then PID03 is required.
4 If PID08 is present, then PID04 is required.
5 If PID09 is present, then PID05 is required.
Semantic Notes: 1 Use PID03 to indicate the organization that publishes the code list being referred to.
2 PID04 should be used for industry-specific product description codes.
3 PID08 describes the physical characteristics of the product identified in PID04. A
"Y" indicates that the specified attribute applies to this item; an "N" indicates it does
not apply. Any other value is indeterminate.
4 PID09 is used to identify the language being used in PID05.
Comments: 1 If PID01 equals "F", then PID05 is used. If PID01 equals "S", then PID04 is used. If
PID01 equals "X", then both PID04 and PID05 are used.
2 Use PID06 when necessary to refer to the product surface or layer being described in
the segment.
3 PID07 specifies the individual code list of the agency specified in PID03.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M PID01 349 Item Description Type M 1 ID 1/1
Code indicating the format of a description
F Free-form
The description will be found in PID05.
PID02 750 Product/Process Characteristic Code O 1 ID 2/3
Code identifying the general class of a product or process characteristic
PID03 559 Agency Qualifier Code X 1 ID 2/2
Code identifying the agency assigning the code values
PID04 751 Product Description Code X 1 AN 1/12
A code from an industry code list which provides specific data about a product
characteristic
PID05 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
PID06 752 Surface/Layer/Position Code O 1 ID 2/2
Code indicating the product surface, layer or position that is being described
PID07 822 Source Subqualifier O 1 AN 1/15
A reference that indicates the table or text maintained by the Source Qualifier
PID08 1073 Yes/No Condition or Response Code O 1 ID 1/1
Code indicating a Yes or No condition or response
PID09 819 Language Code O 1 ID 2/3
Code designating the language used in text, from a standard code list
maintained by the International Standards Organization (ISO 639)

51850-IM (005010) Wal-Mart Confidential 61


Segment: PO4 Item Physical Details
Position: 0900
Loop: PO1
Level: Detail
Usage: Optional
Max Use: >1
Purpose: To specify the physical qualities, packaging, weights, and dimensions relating to the item
Syntax Notes: 1 If either PO402 or PO403 is present, then the other is required.
2 If PO405 is present, then PO406 is required.
3 If either PO406 or PO407 is present, then the other is required.
4 If either PO408 or PO409 is present, then the other is required.
5 If PO410 is present, then PO413 is required.
6 If PO411 is present, then PO413 is required.
7 If PO412 is present, then PO413 is required.
8 If PO413 is present, then at least one of PO410 PO411 or PO412 is required.
9 If PO417 is present, then PO416 is required.
10 If PO418 is present, then PO404 is required.
Semantic Notes: 1 PO415 is used to indicate the relative layer of this package or range of packages
within the layers of packaging. Relative Position 1 (value R1) is the innermost
package.
2 PO416 is the package identifier or the beginning package identifier in a range of
identifiers.
3 PO417 is the ending package identifier in a range of identifiers.
4 PO418 is the number of packages in this layer.
Comments: 1 PO403 - The "Unit or Basis for Measure Code" in this segment position is for
purposes of defining the unit of measure of the "Size" identified in the PO402. For
example: If the carton contains 24 12-Ounce packages, it would be described as
follows: Data element 356 = "24"; Data element 357 = "12"; Data element 355 =
"OZ".
2 PO413 defines the unit of measure for PO410, PO411, and PO412.
Notes: This segment is used to specify the packaging of the item in the case or carton.
There may be two levels of packaging specified. The first level is always specified by
using PO401 (Pack). The first level may be actual items, e.g., consumer units, or it
may be the number of smaller containers within the case. The second level, specified
using PO414 (Inner Pack), is the number of eaches in each inner container when
PO401 is the number of smaller containers within the case.

This segment can be used also to specify the weight and/or volume (cube) for the
item by using PO406 and PO407, and/or PO408 and PO409.

Data Element Summary


Ref. Data
Des. Element Name Attributes
PO401 356 Pack O 1 N0 1/6
The number of inner containers, or number of eaches if there are no inner
containers, per outer container
PO402 357 Size X 1 R 1/8
Size of supplier units in pack
PO403 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
PO404 103 Packaging Code X 1 AN 3/5
Code identifying the type of packaging; Part 1: Packaging Form, Part 2:
Packaging Material; if the Data Element is used, then Part 1 is always
required
PO405 187 Weight Qualifier O 1 ID 1/2
Code defining the type of weight
PO406 384 Gross Weight per Pack X 1 R 1/9

51850-IM (005010) Wal-Mart Confidential 62


Numeric value of gross weight per pack
PO407 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
KG Kilogram
PO408 385 Gross Volume per Pack X 1 R 1/9
Numeric value of gross volume per pack
PO409 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
CR Cubic Meter
PO410 82 Length X 1 R 1/8
Largest horizontal dimension of an object measured when the object is in the
upright position
PO411 189 Width X 1 R 1/8
Shorter measurement of the two horizontal dimensions measured with the
object in the upright position
PO412 65 Height X 1 R 1/8
Vertical dimension of an object measured when the object is in the upright
position
PO413 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
PO414 810 Inner Pack O 1 N0 1/6
The number of eaches per inner container
PO415 752 Surface/Layer/Position Code O 1 ID 2/2
Code indicating the product surface, layer or position that is being described
PO416 350 Assigned Identification X 1 AN 1/20
Alphanumeric characters assigned for differentiation within a transaction set
PO417 350 Assigned Identification O 1 AN 1/20
Alphanumeric characters assigned for differentiation within a transaction set
PO418 1470 Number O 1 N0 1/9
A generic number

51850-IM (005010) Wal-Mart Confidential 63


Segment: TD4 Carrier Details (Special Handling, or Hazardous Materials, or Both)
Position: 2700
Loop: PO1
Level: Detail
Usage: Optional
Max Use: 5
Purpose: To specify transportation special handling requirements, or hazardous materials
information, or both
Syntax Notes: 1 At least one of TD401 TD402 or TD404 is required.
2 If TD402 is present, then TD403 is required.
Semantic Notes: 1 TD405 identifies if a Material Safety Data Sheet (MSDS) exists for this product. A
"Y" indicates an MSDS exists for this product; an "N" indicates an MSDS does not
exist for this product.
Comments:
Notes: This segment identifies when an item has been fumigated or if the item is a
hazardous material needing special transport.

Data Element Summary


Ref. Data
Des. Element Name Attributes
TD401 152 Special Handling Code X 1 ID 2/3
Code specifying special transportation handling instructions
HAZ Hazardous Cargo
OFU Fumigation
The additional service charge or order for a transportation
carrier to fumigate a household goods shipment that is
insect infested
TD402 208 Hazardous Material Code Qualifier X 1 ID 1/1
Code which qualifies the Hazardous Material Class Code (209)
TD403 209 Hazardous Material Class Code X 1 AN 1/4
Code specifying the kind of hazard for a material
TD404 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
When TD401 is OFU, this is a combination of the date of fumigation and
the fumigation method. When TD401 is HAZ, this is the special handling
information.
TD405 1073 Yes/No Condition or Response Code O 1 ID 1/1
Code indicating a Yes or No condition or response

51850-IM (005010) Wal-Mart Confidential 64


Segment: SCH Line Item Schedule
Position: 2950
Loop: PO1-SCH
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify the data for scheduling a specific line-item
Syntax Notes: 1 If SCH03 is present, then SCH04 is required.
2 If SCH08 is present, then at least one of SCH09 or SCH10 is required.
3 If SCH09 is present, then SCH08 is required.
4 If SCH10 is present, then SCH08 is required.
Semantic Notes: 1 SCH12 is the schedule identification.
Comments: 1 SCH05 specifies the interpretation to be used for SCH06 and SCH07.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M SCH01 380 Quantity M 1 R 1/15
Numeric value of quantity
M SCH02 355 Unit or Basis for Measurement Code M 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
CA Case
EA Each
SCH03 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual
SCH04 93 Name X 1 AN 1/60
Free-form name
M SCH05 374 Date/Time Qualifier M 1 ID 3/3
Code specifying type of date or time, or both date and time
167 Most Recent Revision (or Initial Version)
M SCH06 373 Date M 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
SCH07 337 Time O 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-
59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds
are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
SCH08 374 Date/Time Qualifier X 1 ID 3/3
Code specifying type of date or time, or both date and time
SCH09 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
SCH10 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
SCH11 326 Request Reference Number O 1 AN 1/45
Reference number or RFQ number to use to identify a particular transaction set
and query (additional reference number or description which can be used with
contract number)
Wal-Mart Distribution Purchase Order Number
SCH12 350 Assigned Identification O 1 AN 1/20
51850-IM (005010) Wal-Mart Confidential 65
Alphanumeric characters assigned for differentiation within a transaction set
Wal-Mart Global Location Number (GLN) for the Wal-Mart distribution
center.

51850-IM (005010) Wal-Mart Confidential 66


Segment: N9 Extended Reference Information
Position: 3300
Loop: PO1-N9
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To transmit identifying information as specified by the Reference Identification Qualifier
Syntax Notes: 1 At least one of N902 or N903 is required.
2 If N906 is present, then N905 is required.
3 If either C04003 or C04004 is present, then the other is required.
4 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 N906 reflects the time zone which the time reflects.
2 N907 contains data relating to the value cited in N902.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N901 128 Reference Identification Qualifier M 1 ID 2/3
Code qualifying the Reference Identification
CR Customer Reference Number
N902 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
Quote sheet number
N903 369 Free-form Description X 1 AN 1/45
Free-form descriptive text
N904 373 Date O 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
N905 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
N906 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
N907 C040 Reference Identifier O 1
To identify one or more reference numbers or identification numbers as
specified by the Reference Qualifier
C04001 128 Reference Identification Qualifier M ID 2/3
Code qualifying the Reference Identification
C04002 127 Reference Identification M AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04003 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04004 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04005 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
51850-IM (005010) Wal-Mart Confidential 67
C04006 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier

51850-IM (005010) Wal-Mart Confidential 68


Segment: SLN Subline Item Detail
Position: 4700
Loop: PO1-SLN
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify product subline detail item data
Syntax Notes: 1 If either SLN04 or SLN05 is present, then the other is required.
2 If SLN07 is present, then SLN06 is required.
3 If SLN08 is present, then SLN06 is required.
4 If either SLN09 or SLN10 is present, then the other is required.
5 If either SLN11 or SLN12 is present, then the other is required.
6 If either SLN13 or SLN14 is present, then the other is required.
7 If either SLN15 or SLN16 is present, then the other is required.
8 If either SLN17 or SLN18 is present, then the other is required.
9 If either SLN19 or SLN20 is present, then the other is required.
10 If either SLN21 or SLN22 is present, then the other is required.
11 If either SLN23 or SLN24 is present, then the other is required.
12 If either SLN25 or SLN26 is present, then the other is required.
13 If either SLN27 or SLN28 is present, then the other is required.
Semantic Notes: 1 SLN01 is the identifying number for the subline item.
2 SLN02 is the identifying number for the subline level. The subline level is analogous
to the level code used in a bill of materials.
3 SLN03 is the configuration code indicating the relationship of the subline item to the
baseline item.
4 SLN08 is a code indicating the relationship of the price or amount to the associated
segment.
Comments: 1 See the Data Element Dictionary for a complete list of IDs.
2 SLN01 is related to (but not necessarily equivalent to) the baseline item number.
Example: 1.1 or 1A might be used as a subline number to relate to baseline number
1.
3 SLN09 through SLN28 provide for ten different product/service IDs for each item.
For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.
Notes: This loop will be repeated in the event that there are multiple customs declarations
for an item.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M SLN01 350 Assigned Identification M 1 AN 1/20
Alphanumeric characters assigned for differentiation within a transaction set
SLN02 350 Assigned Identification O 1 AN 1/20
Alphanumeric characters assigned for differentiation within a transaction set
M SLN03 662 Relationship Code M 1 ID 1/1
Code indicating the relationship between entities
O Information Only
Charges which relate to but may not be included in or
added to the unit price of the SLN. (i.e., compute WATS
calculation based upon usage amounts)
SLN04 380 Quantity X 1 R 1/15
Numeric value of quantity
SLN05 C001 Composite Unit of Measure X 1
To identify a composite unit of measure (See Figures Appendix for examples of
use)
C00101 355 Unit or Basis for Measurement Code M ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00102 1018 Exponent O R 1/15

51850-IM (005010) Wal-Mart Confidential 69


Power to which a unit is raised
C00103 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00104 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00105 1018 Exponent O R 1/15
Power to which a unit is raised
C00106 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00107 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00108 1018 Exponent O R 1/15
Power to which a unit is raised
C00109 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00110 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00111 1018 Exponent O R 1/15
Power to which a unit is raised
C00112 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
C00113 355 Unit or Basis for Measurement Code O ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
C00114 1018 Exponent O R 1/15
Power to which a unit is raised
C00115 649 Multiplier O R 1/10
Value to be used as a multiplier to obtain a new value
SLN06 212 Unit Price X 1 R 1/17
Price per unit of product, service, commodity, etc.
SLN07 639 Basis of Unit Price Code O 1 ID 2/2
Code identifying the type of unit price for an item
SLN08 662 Relationship Code O 1 ID 1/1
Code indicating the relationship between entities
SLN09 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
ZZ Mutually Defined
SLN10 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
Tariff Number
SLN11 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
CH Country of Origin Code
SLN12 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN13 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)

51850-IM (005010) Wal-Mart Confidential 70


CG Commodity Grouping
SLN14 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
Programs Indicator
NOTE: This code is not being used at this time, but is expected to be added
before the next version upgrade. Suppliers will be notified when it is
enabled.
SLN15 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN16 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN17 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN18 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN19 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN20 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN21 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN22 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN23 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN24 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN25 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN26 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service
SLN27 235 Product/Service ID Qualifier X 1 ID 2/2
Code identifying the type/source of the descriptive number used in
Product/Service ID (234)
SLN28 234 Product/Service ID X 1 AN 1/48
Identifying number for a product or service

51850-IM (005010) Wal-Mart Confidential 71


Segment: MTX Text
Position: 4750
Loop: PO1-SLN
Level: Detail
Usage: Optional
Max Use: >1
Purpose: To specify textual data
Syntax Notes: 1 If MTX01 is present, then MTX02 is required.
2 If MTX03 is present, then MTX02 is required.
3 If MTX05 is present, then MTX04 is required.
Semantic Notes: 1 MTX05 is the number of lines to advance before printing.
Comments: 1 If MTX04 is "AA - Advance the specific number of lines before print", then MTX05
is required.

Data Element Summary


Ref. Data
Des. Element Name Attributes
MTX01 363 Note Reference Code O 1 ID 3/3
Code identifying the functional area or purpose for which the note applies
MTX02 1551 Textual Data X 1 AN 1/4096
To transmit large volumes of message text
MTX03 1551 Textual Data O 1 AN 1/4096
To transmit large volumes of message text
MTX04 934 Printer Carriage Control Code X 1 ID 2/2
A field to be used for the control of the line feed of the receiving printer
MTX05 1470 Number O 1 N0 1/9
A generic number
MTX06 819 Language Code O 1 ID 2/3
Code designating the language used in text, from a standard code list
maintained by the International Standards Organization (ISO 639)

51850-IM (005010) Wal-Mart Confidential 72


Segment: N9 Extended Reference Information
Position: 5230
Loop: PO1-SLN -N9
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To transmit identifying information as specified by the Reference Identification Qualifier
Syntax Notes: 1 At least one of N902 or N903 is required.
2 If N906 is present, then N905 is required.
3 If either C04003 or C04004 is present, then the other is required.
4 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 N906 reflects the time zone which the time reflects.
2 N907 contains data relating to the value cited in N902.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N901 128 Reference Identification Qualifier M 1 ID 2/3
Code qualifying the Reference Identification
3R U.S. Customs Service (USCS) Binding Ruling Number
N902 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
N903 369 Free-form Description X 1 AN 1/45
Free-form descriptive text
N904 373 Date O 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
N905 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
N906 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
N907 C040 Reference Identifier O 1
To identify one or more reference numbers or identification numbers as
specified by the Reference Qualifier
C04001 128 Reference Identification Qualifier M ID 2/3
Code qualifying the Reference Identification
C04002 127 Reference Identification M AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04003 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04004 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04005 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04006 127 Reference Identification X AN 1/50
51850-IM (005010) Wal-Mart Confidential 73
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier

51850-IM (005010) Wal-Mart Confidential 74


Segment: N9 Extended Reference Information
Position: 5230
Loop: PO1-SLN -N9
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To transmit identifying information as specified by the Reference Identification Qualifier
Syntax Notes: 1 At least one of N902 or N903 is required.
2 If N906 is present, then N905 is required.
3 If either C04003 or C04004 is present, then the other is required.
4 If either C04005 or C04006 is present, then the other is required.
Semantic Notes: 1 N906 reflects the time zone which the time reflects.
2 N907 contains data relating to the value cited in N902.
Comments:

Data Element Summary


Ref. Data
Des. Element Name Attributes
M N901 128 Reference Identification Qualifier M 1 ID 2/3
Code qualifying the Reference Identification
87 Functional Category
An organization or groups of organizations with a
common operational orientation such as Quality Control
Engineering, etc
N902 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
Quota Category
N903 369 Free-form Description X 1 AN 1/45
Free-form descriptive text
N904 373 Date O 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
N905 337 Time X 1 TM 4/8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or
HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59),
S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are
expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
N906 623 Time Code O 1 ID 2/2
Code identifying the time. In accordance with International Standards
Organization standard 8601, time can be specified by a + or - and an
indication in hours in relation to Universal Time Coordinate (UTC) time; since
+ is a restricted character, + and - are substituted by P and M in the codes
that follow
N907 C040 Reference Identifier O 1
To identify one or more reference numbers or identification numbers as
specified by the Reference Qualifier
C04001 128 Reference Identification Qualifier M ID 2/3
Code qualifying the Reference Identification
C04002 127 Reference Identification M AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
C04003 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04004 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
51850-IM (005010) Wal-Mart Confidential 75
specified by the Reference Identification Qualifier
C04005 128 Reference Identification Qualifier X ID 2/3
Code qualifying the Reference Identification
C04006 127 Reference Identification X AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier

51850-IM (005010) Wal-Mart Confidential 76


Segment: SAC Service, Promotion, Allowance, or Charge Information
Position: 5260
Loop: PO1-SLN -SAC
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To request or identify a service, pro motion, allowance, or charge; to specify the amount
or percentage for the service, promotion, allowance, or charge
Syntax Notes: 1 At least one of SAC02 or SAC03 is required.
2 If either SAC03 or SAC04 is present, then the other is required.
3 If either SAC06 or SAC07 is present, then the other is required.
4 If either SAC09 or SAC10 is present, then the other is required.
5 If SAC11 is present, then SAC10 is required.
6 If SAC14 is present, then SAC13 is required.
7 If SAC16 is present, then SAC15 is required.
Semantic Notes: 1 If SAC01 is "A" or "C", then at least one of SAC05, SAC07, or SAC08 is required.
2 SAC05 is the total amount for the service, promotion, allowance, or charge.
If SAC05 is present with SAC07 or SAC08, then SAC05 takes precedence.
3 SAC08 is the allowance or charge rate per unit.
4 SAC10 and SAC11 is the quantity basis when the allowance or charge quantity is
different from the purchase order or invoice quantity.
SAC10 and SAC11 used together indicate a quantity range, which could be a dollar
amount, that is applicable to service, promotion, allowance, or charge.
5 SAC13 is used in conjunction with SAC02 or SAC04 to provide a specific reference
number as identified by the code used.
6 SAC14 is used in conjunction with SAC13 to identify an option when there is more
than one option of the promotion.
7 SAC16 is used to identify the language being used in SAC15.
Comments: 1 SAC04 may be used to uniquely identify the service, promotion, allowance, or
charge. In addition, it may be used in conjunction with SAC03 to further define
SAC02.
2 In some business applications, it is necessary to advise the trading partner of the
actual dollar amount that a particular allowance, charge, or promotion was based on
to reduce ambiguity. This amount is commonly referred to as "Dollar Basis
Amount". It is represented in the SAC segment in SAC10 using the qualifier "DO" -
Dollars in SAC09.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M SAC01 248 Allowance or Charge Indicator M 1 ID 1/1
Code which indicates an allowance or charge for the service specified
C Charge
SAC02 1300 Service, Promotion, Allowance, or Charge Code X 1 ID 4/4
Code identifying the service, promotion, allowance, or charge
A445 Anti-dumping Duty
B787 Countervailing Duty
B872 Customs Duty
Regular
ZZZZ Mutually Defined
Wal-Mart Stores, Inc., requires this code be used in
conjunction with the descriptive codes in SAC15.
SAC03 559 Agency Qualifier Code X 1 ID 2/2
Code identifying the agency assigning the code values
SAC04 1301 Agency Service, Promotion, Allowance, or Charge Code X 1 AN 1/10
Agency maintained code identifying the service, promotion, allowance, or
charge
51850-IM (005010) Wal-Mart Confidential 77
SAC05 610 Amount O 1 N2 1/15
Monetary amount
SAC06 378 Allowance/Charge Percent Qualifier X 1 ID 1/1
Code indicating on what basis allowance or charge percent is calculated
2 Item Net Cost
SAC07 332 Percent, Decimal Format X 1 R 1/6
Percent given in decimal format (e.g., 0.0 through 100.0 represents 0% through
100%)
The percent is sent with a decimal point only when needed, e.g., 10.5% is
sent as "10.5", and 2% is sent as "2".
SAC08 118 Rate O 1 R 1/9
Rate expressed in the standard monetary denomination for the currency
specified
SAC09 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
CA Case
CF Cubic Feet
EA Each
KG Kilogram
SAC10 380 Quantity X 1 R 1/15
Numeric value of quantity
SAC11 380 Quantity O 1 R 1/15
Numeric value of quantity
SAC12 331 Allowance or Charge Method of Handling Code O 1 ID 2/2
Code indicating method of handling for an allowance or charge
15 Information Only
When this code is used, the allowance or charge amounts
are not to be added or subtracted from the transaction; the
data is being provided for information purposes only
SAC13 127 Reference Identification X 1 AN 1/50
Reference information as defined for a particular Transaction Set or as
specified by the Reference Identification Qualifier
This is the classification value.
SAC14 770 Option Number O 1 AN 1/20
A unique number identifying available promotion or allowance options when
more than one is offered
SAC15 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
GSP General System Preferences
ISRAEL Products purchased from supplier in Israel
NAFTA North American Free Trade Agreement
PROTEST Items with protest filed with US customs for duty refunds
QIZ Qualified Industrial Zone
ROYALTY Dutiable royalty included in purchase order
SAC16 819 Language Code O 1 ID 2/3
Code designating the language used in text, from a standard code list
maintained by the International Standards Organization (ISO 639)

51850-IM (005010) Wal-Mart Confidential 78


Segment: CTT Transaction Totals
Position: 0100
Loop: CTT
Level: Summary
Usage: Optional
Max Use: 1
Purpose: To transmit a hash total for a specific element in the transaction set
Syntax Notes: 1 If either CTT03 or CTT04 is present, then the other is required.
2 If either CTT05 or CTT06 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment is intended to provide hash totals to validate transaction completeness
and correctness.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M CTT01 354 Number of Line Items M 1 N0 1/6
Total number of line items in the transaction set
The number of PO1 segments present in the transaction set
CTT02 347 Hash Total O 1 R 1/10
CTT03 81 Weight X 1 R 1/10
Numeric value of weight
CTT04 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
KG Kilogram
CTT05 183 Volume X 1 R 1/8
Value of volumetric measure
CTT06 355 Unit or Basis for Measurement Code X 1 ID 2/2
Code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
CR Cubic Meter
CTT07 352 Description O 1 AN 1/80
A free-form description to clarify the related data elements and their content

51850-IM (005010) Wal-Mart Confidential 79


Segment: SE Transaction Set Trailer
Position: 0300
Loop:
Level: Summary
Usage: Mandatory
Max Use: 1
Purpose: To indicate the end of the transaction set and provide the count of the transmitted
segments (including the beginning (ST) and ending (SE) segments)
Syntax Notes:
Semantic Notes:
Comments: 1 SE is the last segment of each transaction set.

Data Element Summary


Ref. Data
Des. Element Name Attributes
M SE01 96 Number of Included Segments M 1 N0 1/10
Total number of segments included in a transaction set including ST and SE
segments
M SE02 329 Transaction Set Control Number M 1 AN 4/9
Identifying control number that must be unique within the transaction set
functional group assigned by the originator for a transaction set
This must be the same number as is in the ST segment (ST02) for the
transaction set.

51850-IM (005010) Wal-Mart Confidential 80


850 Purchase Order – ANSI X12 Introduction

This X12 Transaction Set 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.

51850-IM (005010) Wal-Mart Confidential 81


850 Purchase Order – ANSI X12 Standards
Functional Group ID= PO
Heading:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
M 0100 ST Transaction Set Header M 1
M 0200 BEG Beginning Segment for Purchase Order M 1
0400 CUR Currency O 1
0500 REF Reference Information O >1
0600 PER Administrative Communications Contact O 3
0700 TAX Tax Reference O >1
0800 FOB F.O.B. Related Instructions O >1
0900 CTP Pricing Information O >1
0950 PAM Period Amount O 10
1100 CSH Sales Requirements O 5
1150 TC2 Commodity O >1
LOOP ID - SAC 25
1200 SAC Service, Promotion, Allowance, or Charge O 1
Information
1250 CUR Currency O 1

1300 ITD Terms of Sale/Deferred Terms of Sale O >1


1400 DIS Discount Detail O 20
1450 INC Installment Information O 1
1500 DTM Date/Time Reference O 10
1800 LIN Item Identification O 5 n1
1850 SI Service Characteristic Identification O >1
1900 PID Product/Item Description O 200
2000 MEA Measurements O 40
2100 PWK Paperwork O 25
2200 PKG Marking, Packaging, Loading O 200
2300 TD1 Carrier Details (Quantity and Weight) O 2
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2500 TD3 Carrier Details (Equipment) O 12
2600 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
2700 MAN Marks and Numbers Information O 10
2760 PCT Percent Amounts O >1
2800 CTB Restrictions/Conditions O 5
2850 TXI Tax Information O >1
LOOP ID - LDT >1
2855 LDT Lead Time O 1
2858 QTY Quantity Information O >1
2860 MTX Text O >1
2865 REF Reference Information O >1

LOOP ID - AMT >1


2870 AMT Monetary Amount Information O 1
2890 REF Reference Information O >1
2900 DTM Date/Time Reference O 1

51850-IM (005010) Wal-Mart Confidential 82


2920 PCT Percent Amounts O >1
LOOP ID - FA1 >1
2930 FA1 Type of Financial Accounting Data O 1
M 2940 FA2 Accounting Data M >1

LOOP ID - N9 1000
2950 N9 Extended Reference Information O 1
2970 DTM Date/Time Reference O >1
3000 MTX Text O >1
3050 PWK Paperwork O >1
3080 EFI Electronic Format Identification O >1

LOOP ID - N1 200
3100 N1 Party Identification O 1
3200 N2 Additional Name Information O 2
3250 IN2 Individual Name Structure Components O >1
3300 N3 Party Location O 2
3400 N4 Geographic Location O >1
3450 NX2 Location ID Component O >1
3500 REF Reference Information O 12
3600 PER Administrative Communications Contact O >1
3650 SI Service Characteristic Identification O >1
3700 FOB F.O.B. Related Instructions O 1
3800 TD1 Carrier Details (Quantity and Weight) O 2
3900 TD5 Carrier Details (Routing Sequence/Transit O 12
Time)
4000 TD3 Carrier Details (Equipment) O 12
4100 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
4200 PKG Marking, Packaging, Loading O 200

LOOP ID - LM >1
4300 LM Code Source Information O 1
M 4400 LQ Industry Code Identification M >1

LOOP ID - SPI >1


4500 SPI Specification Identifier O 1
4600 REF Reference Information O 5
4700 DTM Date/Time Reference O 5
4800 MTX Text O >1
LOOP ID - N1 20
4900 N1 Party Identification O 1
5000 N2 Additional Name Information O 2
5100 N3 Party Location O 2
5200 N4 Geographic Location O 1
5300 REF Reference Information O 20
5400 G61 Contact O 1
5500 MTX Text O >1

LOOP ID - CB1 >1


5600 CB1 Contract and Cost Accounting Standards Data O 1
5700 REF Reference Information O 20
5800 DTM Date/Time Reference O 5
5900 LDT Lead Time O 1
6000 MTX Text O >1

51850-IM (005010) Wal-Mart Confidential 83


LOOP ID - ADV >1
6100 ADV Advertising Demographic Information O 1
6200 DTM Date/Time Reference O >1
6300 MTX Text O >1

Detail:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
LOOP ID - PO1 100000
M 0100 PO1 Baseline Item Data M 1 n2
0150 LIN Item Identification O >1
0180 SI Service Characteristic Identification O >1
0200 CUR Currency O 1
0250 CN1 Contract Information O 1
0300 PO3 Additional Item Detail O 25
LOOP ID - CTP >1
0400 CTP Pricing Information O 1
0430 CUR Currency O 1

0450 PAM Period Amount O 10


0490 MEA Measurements O 40
LOOP ID - PID 1000
0500 PID Product/Item Description O 1
0600 MEA Measurements O 10

0700 PWK Paperwork O 25


0900 PO4 Item Physical Details O >1
1000 REF Reference Information O >1
1100 PER Administrative Communications Contact O 3
LOOP ID - SAC 25
1300 SAC Service, Promotion, Allowance, or Charge O 1
Information
1350 CUR Currency O 1
1370 CTP Pricing Information O 1

1400 IT8 Conditions of Sale O 1


1420 CSH Sales Requirements O >1
1500 ITD Terms of Sale/Deferred Terms of Sale O 2
1600 DIS Discount Detail O 20
1650 INC Installment Information O 1
1700 TAX Tax Reference O >1
1800 FOB F.O.B. Related Instructions O >1
1900 SDQ Destination Quantity O 500
2000 IT3 Additional Item Data O 5
2100 DTM Date/Time Reference O 10
2350 TC2 Commodity O >1
2400 TD1 Carrier Details (Quantity and Weight) O 1
2500 TD5 Carrier Details (Routing Sequence/Transit O 12
Time)
2600 TD3 Carrier Details (Equipment) O 12
2700 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
2760 PCT Percent Amounts O >1
2800 MAN Marks and Numbers Information O 10
2890 MTX Text O >1

51850-IM (005010) Wal-Mart Confidential 84


2900 SPI Specification Identifier O >1
2910 TXI Tax Information O >1
2920 CTB Restrictions/Conditions O >1
LOOP ID - QTY >1
2930 QTY Quantity Information O 1
2940 SI Service Characteristic Identification O >1

LOOP ID - SCH 200


2950 SCH Line Item Schedule O 1 n3
2960 TD1 Carrier Details (Quantity and Weight) O 2
2970 TD5 Carrier Details (Routing Sequence/Transit O 12
Time)
2980 TD3 Carrier Details (Equipment) O 12
2990 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
3000 REF Reference Information O >1

LOOP ID - PKG 200


3050 PKG Marking, Packaging, Loading O 1
3100 MEA Measurements O >1

3200 LS Loop Header O 1


LOOP ID - LDT >1
3210 LDT Lead Time O 1
3220 QTY Quantity Information O >1
3230 MTX Text O >1
3240 REF Reference Information O 3
LOOP ID - LM >1
3250 LM Code Source Information O 1
M 3260 LQ Industry Code Identification M >1

3270 LE Loop Trailer O 1


LOOP ID - N9 1000
3300 N9 Extended Reference Information O 1
3320 DTM Date/Time Reference O >1
3350 MEA Measurements O 40
3400 MTX Text O >1
3450 PWK Paperwork O >1
3480 EFI Electronic Format Identification O >1

LOOP ID - N1 200
3500 N1 Party Identification O 1
3600 N2 Additional Name Information O 2
3650 IN2 Individual Name Structure Components O >1
3700 N3 Party Location O 2
3800 N4 Geographic Location O 1
3830 QTY Quantity Information O >1
3850 NX2 Location ID Component O >1
3900 REF Reference Information O 12
4000 PER Administrative Communications Contact O 3
4050 SI Service Characteristic Identification O >1
4060 DTM Date/Time Reference O 1
4100 FOB F.O.B. Related Instructions O 1
4150 SCH Line Item Schedule O 200
4200 TD1 Carrier Details (Quantity and Weight) O 2
4300 TD5 Carrier Details (Routing Sequence/Transit O 12
51850-IM (005010) Wal-Mart Confidential 85
Time)
4400 TD3 Carrier Details (Equipment) O 12
4500 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
4600 PKG Marking, Packaging, Loading O 200
LOOP ID - LDT >1
4620 LDT Lead Time O 1
4640 MAN Marks and Numbers Information O 10
4660 QTY Quantity Information O 5
4680 MTX Text O >1
4690 REF Reference Information O 3

LOOP ID - SLN 1000


4700 SLN Subline Item Detail O 1
4750 MTX Text O >1
4800 SI Service Characteristic Identification O >1
4900 PID Product/Item Description O 1000
5000 PO3 Additional Item Detail O 104
5025 MEA Measurements O >1
5050 TC2 Commodity O >1
5130 ADV Advertising Demographic Information O >1
5150 DTM Date/Time Reference O 10
5160 CTP Pricing Information O 25
5170 PAM Period Amount O 10
5180 PO4 Item Physical Details O 1
5190 TAX Tax Reference O 3
LOOP ID - N9 >1
5230 N9 Extended Reference Information O 1
5240 DTM Date/Time Reference O >1
5250 MTX Text O >1

LOOP ID - SAC 25
5260 SAC Service, Promotion, Allowance, or Charge O 1
Information
5270 CUR Currency O 1
5280 CTP Pricing Information O 1

LOOP ID - QTY >1


5290 QTY Quantity Information O 1
5300 SI Service Characteristic Identification O >1

LOOP ID - N1 10
5350 N1 Party Identification O 1
5400 N2 Additional Name Information O 2
5450 IN2 Individual Name Structure Components O >1
5500 N3 Party Location O 2
5600 N4 Geographic Location O 1
5700 NX2 Location ID Component O >1
5800 REF Reference Information O 12
5900 PER Administrative Communications Contact O 3
5950 SI Service Characteristic Identification O >1

LOOP ID - AMT >1


6000 AMT Monetary Amount Information O 1
6100 REF Reference Information O >1
6120 PCT Percent Amounts O >1

51850-IM (005010) Wal-Mart Confidential 86


LOOP ID - LM >1
6200 LM Code Source Information O 1
M 6300 LQ Industry Code Identification M >1

Summary:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
LOOP ID - CTT 1
0100 CTT Transaction Totals O 1 n4
0200 AMT Monetary Amount Information O 1 n5

M 0300 SE Transaction Set Trailer M 1

Transaction Set Notes

1. If segment LIN is used, do not use LIN01.


2. PO102 is required.
3. The SCH segment is used to specify various quantities of items ordered that are to be scheduled. When this
segment is used the unit of measurement code (SCH02) should always be identical to the unit of
measurement code in the associated PO1 segment (PO103) and the sum of values of quantity (SCH01) should
always equal the quantity ordered (PO102) in the PO1 segment.
4. The number of line items (CTT01) is the accumulation of the number of PO1 segments. If used, hash total
(CTT02) is the sum of the value of quantities ordered (PO102) for each PO1 segment.
5. If AMT is used in the summary area, then AMT01 will = TT and AMT02 will indicate total transaction
amount as calculated by the sender.

51850-IM (005010) Wal-Mart Confidential 87


850 Purchase Order – VICS Introduction
This X12 Transaction Set 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.

Notes:

A functional profile that describes the use of this transaction set for Canada follows this implementation
guideline.

51850-IM (005010) Wal-Mart Confidential 88


850 Purchase Order – VICS Guidelines
Functional Group ID= PO
Heading:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
M 0100 ST Transaction Set Header M 1
M 0200 BEG Beginning Segment for Purchase Order M 1
0400 CUR Currency O 1
0500 REF Reference Information O >1
0600 PER Administrative Communications Contact O 3
0700 TAX Tax Reference O >1
0800 FOB F.O.B. Related Instructions O >1
1100 CSH Sales Requirements O 5
1150 TC2 Commodity O >1
LOOP ID - SAC 25
1200 SAC Service, Promotion, Allowance, or Charge O 1
Information
1300 ITD Terms of Sale/Deferred Terms of Sale O >1
1500 DTM Date/Time Reference O 10
1900 PID Product/Item Description O 200
2100 PWK Paperwork O 25
2200 PKG Marking, Packaging, Loading O 200
2400 TD5 Carrier Details (Routing Sequence/Transit O >1
Time)
2500 TD3 Carrier Details (Equipment) O 12
2600 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
2760 PCT Percent Amounts O >1
2800 CTB Restrictions/Conditions O 5
LOOP ID - N9 1000
2950 N9 Extended Reference Information O 1
3000 MTX Text O >1
3080 EFI Electronic Format Identification O >1

LOOP ID - N1 200
3100 N1 Party Identification O 1
3200 N2 Additional Name Information O 2
3300 N3 Party Location O 2
3400 N4 Geographic Location O >1
3500 REF Reference Information O 12
3600 PER Administrative Communications Contact O >1
4100 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)

Detail:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
LOOP ID - PO1 100000
M 0100 PO1 Baseline Item Data M 1 n1
LOOP ID - CTP >1

51850-IM (005010) Wal-Mart Confidential 89


0400 CTP Pricing Information O 1
0430 CUR Currency O 1

0490 MEA Measurements O 40


LOOP ID - PID 1000
0500 PID Product/Item Description O 1
0600 MEA Measurements O 10

0700 PWK Paperwork O 25


0900 PO4 Item Physical Details O >1
1000 REF Reference Information O >1
LOOP ID - SAC 25
1300 SAC Service, Promotion, Allowance, or Charge O 1
Information
1350 CUR Currency O 1
1370 CTP Pricing Information O 1

1500 ITD Terms of Sale/Deferred Terms of Sale O 2


1900 SDQ Destination Quantity O 500
2100 DTM Date/Time Reference O 10
2350 TC2 Commodity O >1
2500 TD5 Carrier Details (Routing Sequence/Transit O 12
Time)
LOOP ID - PKG 200
3050 PKG Marking, Packaging, Loading O 1

LOOP ID - N9 1000
3300 N9 Extended Reference Information O 1
3480 EFI Electronic Format Identification O >1

LOOP ID - N1 200
3500 N1 Party Identification O 1
3600 N2 Additional Name Information O 2
3700 N3 Party Location O 2
3800 N4 Geographic Location O 1
3900 REF Reference Information O 12
4000 PER Administrative Communications Contact O 3
4060 DTM Date/Time Reference O 1
4500 TD4 Carrier Details (Special Handling, or Hazardous O 5
Materials, or Both)
LOOP ID - SLN 1000
4700 SLN Subline Item Detail O 1
4900 PID Product/Item Description O 1000
5050 TC2 Commodity O >1
5160 CTP Pricing Information O 25
5180 PO4 Item Physical Details O 1
LOOP ID - SAC 25
5260 SAC Service, Promotion, Allowance, or Charge O 1
Information
5270 CUR Currency O 1
5280 CTP Pricing Information O 1

Summary:
Pos. Seg. Req. Loop Notes and
No. ID Name Des. Max.Use Repeat Comments
LOOP ID - CTT 1
0100 CTT Transaction Totals O 1 n2

51850-IM (005010) Wal-Mart Confidential 90


0200 AMT Monetary Amount Information O 1 n3

M 0300 SE Transaction Set Trailer M 1

Transaction Set Notes

1. PO102 is required.
2. The number of line items (CTT01) is the accumulation of the number of PO1 segments. If used, hash total
(CTT02) is the sum of the value of quantities ordered (PO102) for each PO1 segment.
3. If AMT is used in the summary area, then AMT01 will = TT and AMT02 will indicate total transaction
amount as calculated by the sender.

51850-IM (005010) Wal-Mart Confidential 91


Conventions used in these guidelines

1. Every data element on each segment is listed in the Data Element Summary section of the segment
documentation, including unused Elements.
2. Every data element has the ANSI X12 data element ID noted.
3. Every data element has the ANSI X12 data element title noted.
4. Every data element has the ANSI X12 data element attributes noted:
4.1. Data element requirement designation
4.1.1. Mandatory (M) This element is required to appear in the segment.
4.1.2. Optional (O) The appearance of this data element is at the option of the sending party or
is based on the mutual agreement of the interchange parties.
4.1.3. Relational (X) Relational conditions may exist between two or more data elements
within a segment based on the presence or absence of one of those data elements. The
relational condition is displayed under the heading “Syntax Notes.”
4.2. Data element type
4.2.1. Numeric (Nn) — The numeric type of data element is symbolized by the two-position
representation Nn. N indicates a numeric, and n indicates the decimal places to the right
of a fixed, implied decimal point. The decimal point is not transmitted in the character
stream. For negative values, the leading minus sign (-) is used. Absence of a sign
indicates a positive value. The plus sign (+) should not be transmitted. Leading zeros
should be suppressed unless necessary to satisfy a minimum length requirement. The
length of the data element is the number of digits used. The minus sign (-) is not counted
when determining the length of the data element value.
4.2.2. Decimal Number (R) — The decimal type of data element is symbolized by the
representation R. The decimal point is optional for integer values, but required for
fractional values. For negative values, the leading minus sign (-) is used. Absence of a
sign indicates a positive value. The plus sign (+) should not be transmitted. Leading
zeros should be suppressed unless necessary to satisfy a minimum length requirement.
The minus sign and the decimal point are not counted when determin ing the length of the
data element value.
4.2.3. Identifier (ID) — The identifier type of data element is symbolized by the representation
ID. An identifier data element must always contain a value from a predefined list of
values that is maintained by ASC X12 or other bodies that are recognized by ASC X12.
The value is left justified. Trailing spaces should be suppressed.
4.2.4. String (AN) — The string type of data element is symbolized by the representation AN.
Contents of string type data elements are a sequence of any letters, digits, spaces, and/or
special characters and contain at least one non-space character. The significant
characters must be left justified. Leading spaces, if used, are assumed to be significant
characters. Trailing spaces should be suppressed.
4.2.5. Date (DT) — The date type of data element is symbolized by the representation DT.
Format for the date type is CCYYMMDD. CC is the two digit Century (00-99). YY is
the last two digits of the year (00-99), MM is the numeric value of the month (01-12),
and DD is the numeric value of the day (01-31).
4.2.6. Time (TM) — The time type is symbolized by the representation TM. Format for this
type is expressed in 24-hour clock format, HHMMSSd..d. HH is the numeric expression
of the hour (00-23), MM is the numeric expression of the minute (00-59), SS is the
numeric expression of the second (00-59), and d..d is the numeric expression of decimal
seconds.
4.3. Data element length (minimum/maximum)
5. Data elements utilized by Wal-Mart applications are noted in bold type.
6. Data elements ignored by Wal-Mart application are noted in italicized type.
7. Every data element utilized by Wal-Mart applications has the ANSI X12 data element purpose noted.
8. ID-type data elements have the list of utilized values noted.
9. Industry comments relating to segments and data elements are noted in bold text with a shaded
background.
10. Wal-Mart comments relating to segments and data elements are noted in underlined bold text with a
shaded background.
51850-IM (005010) Wal-Mart Confidential 92
Example of Conventions

Segment: N1 Name
Position: 0400
Loop: N1
Level: Heading
Usage: Mandatory
Max Use: 1
Purpose: To identify a party by type of organization, name, and code
Syntax Notes: 1 At least one of N102 or N103 is required.
2 If either N103 or N104 is present, then the other is required.
Semantic Notes:
Comments: 1 This segment, 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.
2 N105 and N106 further define the type of entity in N101.
Notes: There must be at least one occurrence of the N1 segment in the header area to 9
identify the sender of the transaction in text or coded format.
This segment will always identify Wal-Mart Stores, Inc. as the sender of the
document 10

Data Element Summary


4.
1 Ref. Data 8 4.
Des. Element Name Attributes 3
M N101 98 Entity Identifier Code 1 M ID 2/3
2 Code identifying an organizational entity, a physical location, property or an
individual 4.
3 FR Message From 2
N102 93 Name X AN 1/60
Free-form name
N103 66 Identification Code Qualifier X ID 1/2
Code designating the system/method of code structure used for Identification
Code (67)
7
UL UCC/EAN Location Code
A globally unique 13 digit code for the identification of a
legal, functional or physical location within the Uniform
Code Council (UCC) and International Article Number
Association (EAN) numbering system
5 N104 67 Identification Code X AN 2/80
Code identifying a party or other code
1 N105 706 Entity Relationship Code O ID 2/2
Code describing entity relationship
6 N106 98 Entity Identifier Code O ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

51850-IM (005010) Wal-Mart Confidential 93


850 Purchase Order - Changes from Previous (4030) Version

Segment/Element Position Data Element Change Qualifier

CTP H0400 98, 100 Added Segment ALT

CUR H0430 236,212 Added Segment BY

TD4 H2700 152,352 Added Segment HAZ,OFU

51850-IM (005010) Wal-Mart Confidential 94


Change History

Date Version Description of Changes

November, 2004 0.1 Draft Version Published


January, 2005 0.2 Draft Version Released
January, 2005 1.0 Production Guide Released

51850-IM (005010) Wal-Mart Confidential 95

You might also like