850 Import 5010
850 Import 5010
850 Import 5010
5
0
1
0
850 Purchase Order
Purchase Order
Business Usage:
Imports Products
Consolidator
De-Consolidator
Customs Broker
Change History.............................................................................................................................................................................95
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.
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
LOOP ID - N9 1000
3300 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
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.
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.
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.
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
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
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 - 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 - 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
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
Notes:
A functional profile that describes the use of this transaction set for Canada follows this implementation
guideline.
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
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
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.
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