214Import5010

Wal-Mart Stores, Inc.
Electronic Data Interchange Implementation Guideline

ANSI X12 Version 5010
5
0
1
0
214 Transportation Carrier Shipment Status Message
Transportation Carrier Shipment Status Message
Business Usage:
Import Shipment Status
EDI Direction: To Wal-Mart
Implementation Guide Version 1.0

Published January 2005
Last Changed January 2005
Table of Contents
214 Transportation Carrier Shipment Status Message - Wal-Mart Stores, Inc. Introduction............................................. 3
214 Transportation Carrier Shipment Status Message – Wal-Mart Stores, Inc. Implementation...................................... 4
Wal-Mart Business Example of a 214 Document...................................................................................................................... 5
214 Transportation Carrier Shipment Status Message – ANSI X12 Introduction.............................................................. 27
214 Transportation Carrier Shipment Status Message – ANSI X12 Guidelines ................................................................ 28
214 Transportation Carrier Shipment Status – VICS (ATA) Introduction.......................................................................... 29
Conventions used in these guidelines......................................................................................................................................... 30
Example of Conventions.............................................................................................................................................................. 31
214 Transportation Carrier Shipment Status Message - Changes from Previous (4030) Version................................... 32
Change History............................................................................................................................................................................... 33
51214-IM (004030) Wal-Mart Confidential 2

214 Transportation Carrier Shipment Status Message - Wal-
Mart Stores, Inc. Introduction
Wal-Mart uses the 214 for tracking shipment status of import merchandise on a point-to-point
basis, from the time the shipment enters the port to the time it is dropped off at the final
destination (distribution center, store, or club).
Functional Acknowledgment
A Functional Acknowledgment, VICS/EDI transaction set 997 will be sent within 24 hours of
receipt of originating transmission to acknowledge receipt or to notify the sender of format or
syntax errors.

214 Transportation Carrier Shipment Status Message – Wal-
Mart Stores, Inc. Implementation
Functional Group ID= QM
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 B10 Beginning Segment for Transportation Carrier M 1
Shipment Status Message
Detail:
LOOP ID - 1000 999999
M 0100 LX Assigned Number M 1
0200 L11 Business Instructions and Reference Number O 10
0400 Q7 Lading Exception Code O 10
0600 AT5 Bill of Lading Handling Requirements O 10
0700 AT8 Shipment Weight, Packaging and Quantity Data O 10
LOOP ID - 1100 10
M 0800 AT7 Shipment Status Details M 1
0900 MS1 Equipment, Shipment, or Real Property O 1
Location
1000 MS2 Equipment or Container Owner and Type O 2
1200 M7 Seal Numbers O 1
LOOP ID - 1200 5
1300 N1 Name O 1
1300 N1 Name O 1
LOOP ID - 1300 999999

1900 OID Order Identification Detail O 1
M 2100 SE Transaction Set Trailer M 1

Wal-Mart Business Example of a 214 Document
EDI TRANSMISSION DATA EXPLANATION
ST*214*0001 214 is the Transaction Set Identifier Code. "214" indicates

"Purchase Order Acknowledgment".
0001 is the Transaction Set Control Number.
B10*007326746*03485502*HJBT 007326746 is the Reference Identification Number.
03485502 is the Shipment Identification Number.
HJBT is the Standard Carrier Alpha Code.
LX*1 1 is the Reference Assigned Number. “1” is the
differentiation code within a transaction set
L11*361568636BW*BM 361568636BW is the Reference Identification.
BM is the Reference Identification Qualifier. "BM"
indicates "Bill of Lading Number".
L11*03485502*AO 03485502 is the Reference Identification.
AO is the Reference Identification Qualifier. "AO" indicates
"Appointment Number".
L11*03485502*IX 03485502 is the Reference Identification.
IX is the Reference Identification Qualifier. "IX" indicates
"Item Number".
Q7*A*CAS A is the Lading Exception Code. “A” indicates “All Short”.
CAS is the Packaging Form Code . "CAS" indicates "Case
Pack".
AT5*OFU OFU is the . “OFU” indicates “Fumigation”.
AT8*G*K*15000*60*600*X*27 G is the Weight Qualifier. “G” indicates “Gross Weight”
K is the Weight Unit Code. "K" indicates "Kilograms".
15000 is the Weight. 15000. "15000" indicates 15,000
Kilograms.
60 is the Lading Quantity. "60" indicates 60 Units (Pallets or
Containers.
600 is the Lading Quantity. "600" indicates 600 Total Pieces
in all Units.
X is the Volume Unit Qualifier. "X" indicates Cubic Meters.
27 is the Volume. "27" indicates 27 Cubic Meters.
AT7*X3*NS*AA*NS*20010107*1300*LT X3 is the Shipment Status Code . “X3” indicates “Arrived at
Pick-Up Location”.
NS is the Shipment Status or Appointment Reason Code.
“NS” indicates “Normal Status”.
AA is the Shipment Appointment Status Code. “AA”
indicates “Pick-up Appointment Date and/or Time”.
NS is the Shipment Status or Appointment Reason Code.
“NS” indicates “Normal Status”.
20010107 is the Date .
1300 is the Time.
LT is the Time Code. “LT” indicates “Local Time”.
MS1*BENTONVILLE*AR*US BENTONVILLE is the City Name (Free Form).
AR is the State/Province. "AR" indicates "the State of
Arkansas.
US is the Country Code . "US" indicates "United States.
MS2*AAA*870004478*CN AAA is the Standard Carrier Alpha Code.
870004478 is the Equipment Code.
CN is the Equipment Description Code. "CN" indicates
"Container".
M7*356079845342 356079845342 is the Seal Number.
N1*SF*WAL-MART DC 6020 SF is the Entity Identifier Code. “SF” indicates “Ship
From".
WAL-MART DC 6020 is the Name.
N1*ST**UL*0078742000008 ST is the Entity Identifier Code. "ST" indicates "Ship To"
UL is the Identification Code Qualifier. "UL" indicates
UCC/EAN Number (GLN) Global Location Number.
0078742000008 is the UCC/EAN Number (GLN) Global
Location Number. "0078742000008" indicates "Wal-Mart
Home Office".
OID*PO*0000000012*32*CAS*600*K*15000*X*27 PO is the Reference Identification. "PO" indicates "Purchase

Order".
0000000012 is the Purchase Order Number (non-Intelligent).
32 is the Reference Identification.
CAS is the Packaging Form Code. "CAS" indicates "Case".
600 is the Quantity.
K is the Weight Unit Code. "K" indicates "Kilograms".
15000 is the Weight. "15000" indicates 15,000 Kilograms".
X is the Volume Unit Qualifier. "X" indicates "Cubic
Meters".
27 is the Volume. "27" indicates "27 Cubic Meters".
SE*17*0001 17 is the total number of segments included in a transaction
set including ST and SE segments.
0001 is the same control number as in the ST02 segment,
identifying the transaction set.

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.
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
214 Transportation Carrier Shipment Status Message
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

Segment: B10 Beginning Segment for Transportation Carrier Shipment Status Message
Position: 0200
Loop:
Level: Heading
Usage: Mandatory
Max Use: 1
Purpose: To transmit identifying numbers and other basic data relating to the transaction set
Syntax Notes: 1 At least one of B1001 or B1006 is required.
2 Only one of B1001 or B1005 may be present.
3 If either B1005 or B1006 is present, then the other is required.
4 If either B1008 or B1009 is present, then the other is required.
Semantic Notes: 1 B1001 is the carrier assigned reference number.
2 B1007 indicates if the reference numbers included in this transmission were
transmitted to the carrier via EDI or key entered by the carrier. A "Y" indicates that
the carrier received the reference numbers in an EDI transmission; an "N" indicates
that the carrier did not receive the reference numbers in an EDI transmission and key
entered the data from a shipper supplied document.
3 B1008 is the transaction creation date.
4 B1009 is the transaction creation time.
Comments: 1 B1001 is the carrier's PRO (invoice number) that identifies the shipment.
2 B1003 is required when used in Transaction Set 214.
3 B1006 is the carrier assigned bar code identification or another carrier assigned
shipment identification, such as a manifest number.

Ref. Data
B1001 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
Carrier's PRO Number or identifying number
B1002 145 Shipment Identification Number O 1 AN 1/30
Identification number assigned to the shipment by the shipper that uniquely
identifies the shipment from origin to ultimate destination and is not subject to
modification; (Does not contain blanks or special characters)
M B1003 140 Standard Carrier Alpha Code M 1 ID 2/4
Standard Carrier Alpha Code
B1004 71 Inquiry Request Number O 1 N0 1/3
Identifying number assigned by inquirer
B1005 128 Reference Identification Qualifier X 1 ID 2/3
Code qualifying the Reference Identification
B1006 127 Reference Identification X 1 AN 1/50
B1007 1073 Yes/No Condition or Response Code O 1 ID 1/1
Code indicating a Yes or No condition or response
B1008 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of the
calendar year
B1009 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)

Segment: LX Assigned Number
Position: 0100
Loop: 1000
Level: Detail
Usage: Mandatory
Max Use: 1
Purpose: To reference a line number in a transaction set
Syntax Notes:
Semantic Notes:
Comments:

Ref. Data
M LX01 554 Assigned Number M 1 N0 1/6
Number assigned for differentiation within a transaction set

Segment: L11 Business Instructions and Reference Number
Position: 0200
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Purpose: To specify instructions in this business relationship or a reference number
Syntax Notes: 1 At least one of L1101 or L1103 is required.
2 If either L1101 or L1102 is present, then the other is required.
Semantic Notes:
Comments:

Ref. Data
L1101 127 Reference Identification X 1 AN 1/50
L1102 128 Reference Identification Qualifier X 1 ID 2/3
BM Bill of Lading Number
L1103 352 Description X 1 AN 1/80
A free-form description to clarify the related data elements and their content
L1104 373 Date O 1 DT 8/8
calendar year

Position: 0200
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Semantic Notes:
Comments:

Ref. Data
BN Booking Number
L1104 373 Date O 1 DT 8/8
calendar year

Position: 0200
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Semantic Notes:
Comments:
Notes: Only one item number may be transmitted in a single 214 transaction.

Ref. Data
Wal-Mart item number
IX Item Number
L1104 373 Date O 1 DT 8/8
calendar year

Position: 0200
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Semantic Notes:
Comments:

Ref. Data
AO Appointment Number
L1104 373 Date O 1 DT 8/8
calendar year

Position: 0200
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Semantic Notes:
Comments:

Ref. Data
OB Ocean Bill of Lading
L1104 373 Date O 1 DT 8/8
calendar year

Segment: Q7 Lading Exception Code
Position: 0400
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Purpose: To specify the status of the shipment in terms of lading exception information
Syntax Notes: 1 If Q702 is present, then Q703 is required.
Semantic Notes:
Comments:

Ref. Data
M Q701 33 Lading Exception Code M 1 ID 1/1
Code indicating the condition of the shipment
A All Short
D Damaged
O Overage
Q702 211 Packaging Form Code O 1 ID 3/3
Code for packaging form of the lading quantity
CAS Case
Q703 80 Lading Quantity X 1 N0 1/7
Number of units (pieces) of the lading commodity

Segment: AT5 Bill of Lading Handling Requirements
Position: 0600
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Purpose: To identify Bill of Lading handling and service requirements
Syntax Notes: 1 Only one of AT501 or AT503 may be present.
2 Only one of AT502 or AT503 may be present.
3 If AT504 is present, then at least one of AT505 or AT506 is required.
4 If AT505 is present, then AT504 is required.
Semantic Notes: 1 AT505 is the minimum temperature.
2 AT506 is the maximum temperature.
Comments:

Ref. Data
AT501 152 Special Handling Code X 1 ID 2/3
Code specifying special transportation handling instructions
OFU Fumigation
The additional service charge or order for a transportation
carrier to fumigate a household goods shipment that is
insect infested
AT502 560 Special Services Code X 1 ID 2/10
Code identifying the special service
AT503 153 Special Handling Description X 1 AN 2/30
Free-form additional description of special handling instructions to appear on
printed bill if special handling code is not adequate
AT504 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
AT505 408 Temperature X 1 R 1/4
Temperature
AT506 408 Temperature X 1 R 1/4
Temperature

Segment: AT8 Shipment Weight, Packaging and Quantity Data
Position: 0700
Loop: 1000
Level: Detail
Usage: Optional
Max Use: 10
Purpose: To specify shipment details in terms of weight, and quantity of handling units
Syntax Notes: 1 If any of AT801 AT802 or AT803 is present, then all are required.
2 If either AT806 or AT807 is present, then the other is required.
Semantic Notes: 1 AT804 is the quantity of handling units that are not unitized (for example a carton).
When added to the quantity in AT805, it is the total quantity of handling units in the
shipment.
2 AT805 is the quantity of handling units that are unitized (for example on a pallet or
slip sheet). When added to the quantity in AT804 it is the total quantity of handling
units for the shipment.
Comments:

Ref. Data
AT801 187 Weight Qualifier X 1 ID 1/2
Code defining the type of weight
G Gross Weight
N Actual Net Weight
AT802 188 Weight Unit Code X 1 ID 1/1
Code specifying the weight unit
K Kilograms
AT803 81 Weight X 1 R 1/10
Numeric value of weight
AT804 80 Lading Quantity O 1 N0 1/7
AT805 80 Lading Quantity O 1 N0 1/7
AT806 184 Volume Unit Qualifier X 1 ID 1/1
Code identifying the volume unit
X Cubic Meters
AT807 183 Volume X 1 R 1/8
Value of volumetric measure

Segment: AT7 Shipment Status Details
Position: 0800
Loop: 1000-1100
Level: Detail
Usage: Mandatory
Max Use: 1
Purpose: To specify the status of a shipment, the reason for that status, the date and time of the
status and the date and time of any appointments scheduled.
Syntax Notes: 1 Only one of AT701 or AT703 may be present.
Semantic Notes: 1 If AT701 is present, AT705 is the date the status occurred. If AT703 is present,
AT705 is a date related to an appointment.
If AT701 is present, AT706 is the time of the status. If AT703 is present, AT706 is
the time of the appointment.
2 If AT707 is not present then AT706 represents local time of the status.
Comments:

Ref. Data
AT701 1650 Shipment Status Code X 1 ID 2/2
Code indicating the status of a shipment
AF Carrier Departed Pick-up Location with Shipment
Container Picked-up from Terminal (49)
AV Available for Delivery
Trailer Dispatched (51)
B6 Estimated to Arrive at Carrier Terminal
Expected Time of Arrival (Dest. Airport) (63)
CD Carrier Departed Delivery Location
In Flight (138)
CL Trailer Closed Out
Empty Container Returned (53)
CP Completed Loading at Pick-up Location
Transloaded (50)
I1 In-Gate
Container in Yard (69)
J1 Delivered to Connecting Line
Merchandise Picked up at Vendors or Delivered
from Vendor (58)
K1 Arrived at Customs
Customs Release Received (54)
L1 Loading
Container Working (70)
OO Paperwork Received - Did not Receive Shipment or
Equipment
Distribution Received in Detail (45)
P1 Departed Terminal Location
Driver Dispatched to Port (48)
PR U.S. Customs Hold at In-Bond Location
Awaiting Customs Clearance (140) -- Date submitted
for clearance by customs.
X1 Arrived at Delivery Location
Proof of Delivery (62) -- Delivered to either a Wal-
Mart DC or De-Consolidator.
X3 Arrived at Pick-up Location
Available from Terminal (47)
X4 Arrived at Terminal Location
Flight Arrived at Destination Terminal (139) --
Flight has arrived at final destination.
X6 En Route to Delivery Location
Trailer Departs to Wal-Mart DC (52)
XB Shipment Acknowledged
Cleared Customs (61) -- Customs has released
merchandise.
AT702 1651 Shipment Status or Appointment Reason Code O 1 ID 2/2
Code indicating the reason a shipment status or appointment reason was
transmitted
NS Normal Status
AT703 1652 Shipment Appointment Status Code X 1 ID 2/2
Code indicating the status of an appointment to pick-up or deliver a shipment
AA Pick-up Appointment Date and/or Time
Booked the Freight (67) -- Vendor calls Air Carrier
for Pick up.
X9 Delivery Appointment Secured on This Date and/or Time
Expected time of Departure (59) -- Estimated time
and date of flight departure.
AT704 1651 Shipment Status or Appointment Reason Code O 1 ID 2/2
Code indicating the reason a shipment status or appointment reason was
transmitted
NS Normal Status
AT705 373 Date X 1 DT 8/8
Date expressed as CCYYMMDD where CC represents the first two digits of
the calendar year
AT706 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)
AT707 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
LT Local Time

Segment: MS1 Equipment, Shipment, or Real Property Location
Position: 0900
Loop: 1000-1100
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify the location of a piece of equipment, a shipment, or real property in terms of
city and state or longitude and latitude or postal code
Syntax Notes: 1 If MS101 is present, then at least one of MS102 or MS103 is required.
2 Only one of MS101 or MS104 may be present.
3 If MS102 is present, then MS101 is required.
5 If either MS104 or MS105 is present, then the other is required.
Semantic Notes: 1 MS104 is the longitude expressed in Degrees, Minutes, and Seconds.
2 MS105 is the latitude expressed in Degrees, Minutes, and Seconds.
3 MS106 may only be 'E' or 'W'.
4 MS107 may only be 'N' or 'S'.
Comments:

Ref. Data
MS101 19 City Name X 1 AN 2/30
Free-form text for city name
MS102 156 State or Province Code X 1 ID 2/2
Code (Standard State/Province) as defined by appropriate government agency
MS103 26 Country Code X 1 ID 2/3
Code identifying the country
MS104 1654 Longitude Code X 1 ID 7/7
Code indicating the longitude in degrees (3 positions), minutes (2 positions),
and seconds (2 positions)
MS105 1655 Latitude Code X 1 ID 7/7
Code indicating the latitude in degrees (3 positions), minutes (2 positions),
seconds (2 positions)
MS106 1280 Direction Identifier Code O 1 ID 1/1
Code identifying geographic direction
MS107 1280 Direction Identifier Code O 1 ID 1/1
Code identifying geographic direction
MS108 116 Postal Code O 1 ID 3/15
Code defining international postal zone code excluding punctuation and blanks
(zip code for United States)

Segment: MS2 Equipment or Container Owner and Type
Position: 1000
Loop: 1000-1100
Level: Detail
Usage: Optional
Max Use: 2
Purpose: To specify the owner, the identification number assigned by that owner, and the type of
equipment
Syntax Notes: 1 If either MS201 or MS202 is present, then the other is required.
Semantic Notes:
Comments: 1 MS203 identifies the type for the equipment specified in MS202.
Notes: This segment is required by Wal-Mart Stores, Inc. Only one instance of this segment
is allowed by Wal-Mart within a single 214 transaction.

Ref. Data
MS201 140 Standard Carrier Alpha Code X 1 ID 2/4
Standard Carrier Alpha Code
MS202 207 Equipment Number X 1 AN 1/10
Sequencing or serial part of an equipment unit's identifying number (pure
numeric form for equipment number is preferred)
MS203 40 Equipment Description Code O 1 ID 2/2
Code identifying type of equipment used for shipment
This data element is required by Wal-Mart Stores, Inc.
AF Air Freight (Break Bulk)
CN Container
TL Trailer (not otherwise specified)
MS204 761 Equipment Number Check Digit O 1 N0 1/1
Number which designates the check digit applied to a piece of equipment

Segment: M7 Seal Numbers
Position: 1200
Loop: 1000-1100
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To record seal numbers used and the organization that applied the seals
Syntax Notes:
Semantic Notes:
Comments: 1 M705 indicates the name of the organization which applied the seal(s).

Ref. Data
M M701 225 Seal Number M 1 AN 2/15
Unique number on seal used to close a shipment
M702 225 Seal Number O 1 AN 2/15
M705 98 Entity Identifier Code O 1 ID 2/3
Code identifying an organizational entity, a physical location, property or an
individual

Segment: N1 Name
Position: 1300
Loop: 1000-1200
Level: Detail
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.
Notes: This segment is required by Wal-Mart Stores, Inc.

Ref. Data
M N101 98 Entity Identifier Code M 1 ID 2/3
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)
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
individual

Segment: N1 Name
Position: 1300
Loop: 1000-1200
Level: Detail
Usage: Optional
Max Use: 1
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.
Notes: This segment is required by Wal-Mart Stores, Inc.

Ref. Data
M N101 98 Entity Identifier Code M 1 ID 2/3
individual
ST Ship To
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 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
This will always be the Wal-Mart Global Location
Number (GLN).
N104 67 Identification Code X 1 AN 2/80
Wal-Mart Global Location Number (GLN)
N105 706 Entity Relationship Code O 1 ID 2/2
N106 98 Entity Identifier Code O 1 ID 2/3
individual

Segment: OID Order Identification Detail
Position: 1900
Loop: 1000-1300
Level: Detail
Usage: Optional
Max Use: 1
Purpose: To specify order identification detail
Syntax Notes: 1 At least one of OID01 or OID02 is required.
2 If OID03 is present, then OID02 is required.
3 If either OID04 or OID05 is present, then the other is required.
Semantic Notes: 1 OID01 is the seller's order identification number.
2 OID03 is the number assigned by the consignee to further define the purchase order
number.
3 OID11 specifies the sorting and/or segregating number for each receiving location
(processing area).
Comments:
Notes: This segment is required by Wal-Mart Stores, Inc. Only one instance of this segment
is allowed by Wal-Mart Stores, Inc. within a single 214 transaction.

Ref. Data
OID01 127 Reference Identification X 1 AN 1/50
Wal-Mart assigned order type
OID02 324 Purchase Order Number X 1 AN 1/22
Identifying number for Purchase Order assigned by the orderer/purchaser
This data element is required by Wal-Mart Stores, Inc.
OID03 127 Reference Identification O 1 AN 1/50
Wal-Mart assigned department number
OID04 211 Packaging Form Code X 1 ID 3/3
Code for packaging form of the lading quantity
OID05 380 Quantity X 1 R 1/15
Numeric value of quantity
OID06 188 Weight Unit Code X 1 ID 1/1
Code specifying the weight unit
OID07 81 Weight X 1 R 1/10
Numeric value of weight
OID08 184 Volume Unit Qualifier X 1 ID 1/1
Code identifying the volume unit
OID09 183 Volume X 1 R 1/8
Value of volumetric measure
OID10 647 Application Error Condition Code O 1 ID 1/3
Code indicating application error condition
OID11 127 Reference Identification O 1 AN 1/50

Segment: SE Transaction Set Trailer
Position: 2100
Loop:
Level: Detail
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.

Ref. Data
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.

214 Transportation Carrier Shipment Status Message –
ANSI X12 Introduction
This X12 Transaction Set contains the format and establishes the data contents of the Transportation Carrier
Shipment Status Message Transaction Set (214) for use within the context of an Electronic Data Interchange (EDI)
environment. This transaction set can be used by a transportation carrier to provide shippers, consignees, and their
agents with the status of shipments in terms of dates, times, locations, route, identifying numbers, and conveyance.

214 Transportation Carrier Shipment Status Message –
ANSI X12 Guidelines
Functional Group ID= QM
Heading:
M 0100 ST Transaction Set Header M 1
M 0200 B10 Beginning Segment for Transportation Carrier M 1
Shipment Status Message
0300 MS3 Interline Information O 12
Detail:
LOOP ID - 1000 999999
M 0100 LX Transaction Set Line Number M 1
0300 MAN Marks and Numbers Information O 9999
0400 Q7 Lading Exception Status O 10
0500 K1 Remarks O 10
0600 AT5 Bill of Lading Handling Requirements O 10
0700 AT8 Shipment Weight, Packaging and Quantity Data O 10
LOOP ID - 1100 10
M 0800 AT7 Shipment Status Details M 1
0900 MS1 Equipment, Shipment, or Real Property O 1
Location
1000 MS2 Equipment or Container Owner and Type O 2
1100 K1 Remarks O 1
1200 M7 Seal Numbers O 1
LOOP ID - 1200 5
1300 N1 Party Identification O 1
1400 N2 Additional Name Information O 1
1500 N3 Party Location O 2
1600 N4 Geographic Location O 1
1700 G62 Date/Time O 1 n1
LOOP ID - 1300 999999

1900 OID Order Information Detail O 1
2000 SDQ Destination Quantity O 10
M 2100 SE Transaction Set Trailer M 1
Transaction Set Notes
1. The G62 segment shall not be used to report shipment status dates and/or times.

214 Transportation Carrier Shipment Status – VICS (ATA)
Introduction
The purpose of this section is to present and explain the application of the ASC X12 standards as
they pertain to the motor carrier and retail industry implementation of the Transportation Carrier
Shipment Status Message Transaction Set.
The 214 is used primarily by truckload and less than truckload carriers to report the status of a
shipment to the shipper, consignee and other parties to the shipment. In addition, the 214 can be
used to provide customers with carrier performance data. The 214 can provide pick-up or
delivery dates and times, as well as information concerning shipments in transit.
Small package carriers use the Motor Carrier Package (240) to report package status information.
Various reference numbers will be provided in a shipment status message. For LTL carriers, the
PRO number will be provided along with a unique carton identification number if assigned by
the shipper and transmitted in a 211. Truckload carriers can provide an identification number
assigned by the carrier as well as a bill of lading number.
Most carriers send shipment status messages on a scheduled basis pre-agreed to by the trading
partners. The two most common times for the 214’s to be transmitted are at the time of pick-up
and time of delivery.
The transaction set can be used to transmit status information for both a single shipment, with
only one ship- from and ship-to, and multi-stop shipments.
The complete implementation guidelines are contained in the “Motor Carrier Industry Guide to
EDI Implementations and Conventions”. Any UCC member can receive a copy of the guide at
American Trucking Associations’ member price.

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 determining 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.
Example of Conventions
Segment: N1 Name
Position: 0400
Loop: N1
Level: Heading
Usage: Mandatory
Max Use: 1
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.
Notes: There must be at least one occurrence of the N1 segment in the header 9
area to identify the sender of the transaction in text or coded format.
This segment will always identify Wal-Mart Stores, Inc. as the sender
10
of the document
Data Element Summary 4.

1 Ref. Data 8 4. 3
Des. Element Name 1 Attributes
M N101 98 Entity Identifier Code 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
5 (UCC) and International Article Number
Association (EAN) numbering system
N104 67 Identification Code X AN 2/80
1 N105 706 Entity Relationship Code O ID 2/2
6 N106 98 Entity Identifier Code O ID 2/3
Code identifying an organizational entity, a physical location,
property or an individual
214 Transportation Carrier Shipment Status Message -
Changes from Previous (4030) Version
Segment/Element Position Change Qualifier

Data Element
AT5 H0600 152 Added Element OFU

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

214Import5010

Uploaded by

Copyright:

Available Formats

214Import5010

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

214Import5010

Uploaded by

Copyright:

Available Formats

Wal-Mart Stores, Inc.

Electronic Data Interchange Implementation Guideline

EDI Direction: To Wal-Mart

Implementation Guide Version 1.0

Wal-Mart Business Example of a 214 Document...................................................................................................................... 5

214 Transportation Carrier Shipment Status Message – ANSI X12 Introduction.............................................................. 27

214 Transportation Carrier Shipment Status – VICS (ATA) Introduction.......................................................................... 29

Conventions used in these guidelines......................................................................................................................................... 30

51214-IM (004030) Wal-Mart Confidential 2

51214-IM (004030) Wal-Mart Confidential 3

LOOP ID - 1300 999999

M 2100 SE Transaction Set Trailer M 1

51214-IM (004030) Wal-Mart Confidential 4

EDI TRANSMISSION DATA EXPLANATION

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

OID*PO*0000000012*32*CAS*600*K*15000*X*27 PO is the Reference Identification. "PO" indicates "Purchase

51214-IM (004030) Wal-Mart Confidential 6

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 7

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 8

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 9

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 10

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 11

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 12

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 13

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 14

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 15

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 16

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 17

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 19

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 20

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 21

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 22

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 23

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 24

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 25

Data Element Summary

51214-IM (004030) Wal-Mart Confidential 26

51214-IM (004030) Wal-Mart Confidential 27

LOOP ID - 1300 999999

M 2100 SE Transaction Set Trailer M 1

Transaction Set Notes

51214-IM (004030) Wal-Mart Confidential 28

ST2140001 214 is the Transaction Set Identifier Code. "214" indicates

OIDPO000000001232CAS600K*15000X27 PO is the Reference Identification. "PO" indicates "Purchase