Walmart
/
Organizational Relationships
  • Specification
  • EDI Inspector
Stedi maintains this guide based on public documentation from Walmart. Contact Walmart for official EDI specifications. To report any errors in this guide, please contact us.
Go to Stedi Network
Walmart logo

X12 816 Organizational Relationships

X12 Release 5010

This X12 Transaction Set contains the format and establishes the data contents of the Organizational Relationships Transaction Set (816) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used to transmit pertinent information about a parent organization, its members and the relationship of a member to another member, and/or to the parent organization. A parent organization could be an association, a multi-hospital system, a chain of retail stores, a holding company, etc.

This transaction set can be used to convey the identity and relationship of members to a parent organization; identify eligibility to purchase under the terms and conditions negotiated by a parent organization on behalf of its members; and to update application databases.

Delimiters
  • ~ Segment
  • * Element
  • > Component
  • ^ Repetition
EDI samples
  • Weekly Full File
View the latest version of this implementation guide as an interactive webpage
https://www.stedi.com/app/guides/view/walmart-edi/organizational-relationships/01GQNTF4NPGXWMYNQKFERGT6S3
Powered by
Build EDI implementation guides at stedi.com
Overview
ISA
-
Interchange Control Header
Max use 1
Required
GS
-
Functional Group Header
Max use 1
Required
heading
ST
0100
Transaction Set Header
Max use 1
Required
BHT
0200
Beginning of Hierarchical Transaction
Max use 1
Required
N1 Loop
detail
HL Loop
HL
0100
Hierarchical Level
Max use 1
Required
HL Loop
HL
0100
Hierarchical Level
Max use 1
Required
N1 Loop Store
SE
1100
Transaction Set Trailer
Max use 1
Required
GE
-
Functional Group Trailer
Max use 1
Required
IEA
-
Interchange Control Trailer
Max use 1
Required
ISA

Interchange Control Header

RequiredMax use 1

To start and identify an interchange of zero or more functional groups and interchange-related control segments

Example
ISA-01
I01
Authorization Information Qualifier
Required
Identifier (ID)

Code identifying the type of information in the Authorization Information

00
No Authorization Information Present (No Meaningful Information in I02)
ISA-02
I02
Authorization Information
Required
String (AN)
Min 10Max 10

Information used for additional identification or authorization of the interchange sender or the data in the interchange; the type of information is set by the Authorization Information Qualifier (I01)

ISA-03
I03
Security Information Qualifier
Required
Identifier (ID)

Code identifying the type of information in the Security Information

00
No Security Information Present (No Meaningful Information in I04)
ISA-04
I04
Security Information
Required
String (AN)
Min 10Max 10

This is used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier (I03)

ISA-05
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2

Code indicating the system/method of code structure used to designate the sender or receiver ID element being qualified

Codes
ISA-06
I06
Interchange Sender ID
Required
String (AN)
Min 15Max 15

Identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element

ISA-07
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2

Code indicating the system/method of code structure used to designate the sender or receiver ID element being qualified

Codes
ISA-08
I07
Interchange Receiver ID
Required
String (AN)
Min 15Max 15

Identification code published by the receiver of the data; When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them

ISA-09
I08
Interchange Date
Required
Date (DT)
YYMMDD format

Date of the interchange

ISA-10
I09
Interchange Time
Required
Time (TM)
HHMM format

Time of the interchange

ISA-11
I65
Repetition Separator
Required
String (AN)
Min 1Max 1

Type is not applicable; the repetition separator is a delimiter and not a data element; this field provides the delimiter used to separate repeated occurrences of a simple data element or a composite data structure; this value must be different than the data element separator, component element separator, and the segment terminator

^
Repetition Separator
ISA-12
I11
Interchange Control Version Number
Required
Identifier (ID)

Code specifying the version number of the interchange control segments

00501
Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003
ISA-13
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9

A control number assigned by the interchange sender

ISA-14
I13
Acknowledgment Requested
Required
Identifier (ID)
Min 1Max 1

Code indicating sender's request for an interchange acknowledgment

0
No Interchange Acknowledgment Requested
1
Interchange Acknowledgment Requested (TA1)
ISA-15
I14
Interchange Usage Indicator
Required
Identifier (ID)
Min 1Max 1

Code indicating whether data enclosed by this interchange envelope is test, production or information

I
Information
P
Production Data
T
Test Data
ISA-16
I15
Component Element Separator
Required
String (AN)
Min 1Max 1

Type is not applicable; the component element separator is a delimiter and not a data element; this field provides the delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator

>
Component Element Separator

Functional Group Header

RequiredMax use 1

To indicate the beginning of a functional group and to provide control information

Example
GS-01
479
Functional Identifier Code
Required
Identifier (ID)

Code identifying a group of application related transaction sets

OR
Organizational Relationships (816)
GS-02
142
Application Sender's Code
Required
String (AN)
Min 2Max 15

Code identifying party sending transmission; codes agreed to by trading partners

GS-03
124
Application Receiver's Code
Required
String (AN)
Min 2Max 15

Code identifying party receiving transmission; codes agreed to by trading partners

Required
Date (DT)
CCYYMMDD format

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

Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

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)

GS-06
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

Assigned number originated and maintained by the sender

GS-07
455
Responsible Agency Code
Required
Identifier (ID)
Min 1Max 2

Code identifying the issuer of the standard; this code is used in conjunction with Data Element 480

T
Transportation Data Coordinating Committee (TDCC)
X
Accredited Standards Committee X12
GS-08
480
Version / Release / Industry Identifier Code
Required
String (AN)

Code indicating the version, release, subrelease, and industry identifier of the EDI standard being used, including the GS and GE segments; if code in DE455 in GS segment is X, then in DE 480 positions 1-3 are the version number; positions 4-6 are the release and subrelease, level of the version; and positions 7-12 are the industry or trade association identifiers (optionally assigned by user); if code in DE455 in GS segment is T, then other formats are allowed

005010
Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003

Heading

ST
0100
Heading > ST

Transaction Set Header

RequiredMax use 1

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

Example
ST-01
143
Transaction Set Identifier Code
Required
Identifier (ID)

Code uniquely identifying a Transaction Set

  • 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).
816
Organizational Relationships
ST-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9

Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

BHT
0200
Heading > BHT

Beginning of Hierarchical Transaction

RequiredMax use 1

To define the business hierarchical structure of the transaction set and identify the business application purpose and reference data, i.e., number, date, and time

  • BHT03 and BHT04 are mandatory.
Example
BHT-01
1005
Hierarchical Structure Code
Required
Identifier (ID)

Code indicating the hierarchical application structure of a transaction set that utilizes the HL segment to define the structure of the transaction set

0065
Company, Operating Unit

Location Address Structure

BHT-02
353
Transaction Set Purpose Code
Required
Identifier (ID)

Code identifying purpose of transaction set

00
Original
04
Change

This code is used in the weekly resynchronization file. This code is sent in the weekly changes file.

BHT-03
127
Reference Identification
Optional
String (AN)
Min 1Max 50

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

  • BHT03 is the number assigned by the originator to identify the transaction within the originator's business application system.
Optional
Date (DT)
CCYYMMDD format

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

  • BHT04 is the date the transaction was created within the business application system.
N1 Loop
RequiredMax >1
N1
0400
Heading > N1 Loop > N1

Party Identification

RequiredMax use 1

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

  • The N1 loop shall identify the transaction set issuer and optionally provide contact information if necessary.
Usage notes

There must be at least one occurrence of the N1 segment in the header area to identify the sender of the transaction in text or coded format.

Example
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

FR
Message From
Required
String (AN)
Min 1Max 60

Free-form name

N1 Loop end
Heading end

Detail

HL Loop
RequiredMax >1
Usage notes

The FULL file for the 816 will have an iteration of the HL loop for every WALMART and SAMS location.

HL
0100
Detail > HL Loop > HL

Hierarchical Level

RequiredMax use 1

To identify dependencies among and the content of hierarchically related groups of data segments

Example
HL-01
628
Hierarchical ID Number
Required
String (AN)
Min 1Max 12

A unique number assigned by the sender to identify a particular data segment in a hierarchical structure

  • HL01 shall contain a unique alphanumeric number for each occurrence of the HL segment in the transaction set. For example, HL01 could be used to indicate the number of occurrences of the HL segment, in which case the value of HL01 would be "1" for the initial HL segment and would be incremented by one in each subsequent HL segment within the transaction.
HL-03
735
Hierarchical Level Code
Required
Identifier (ID)

Code defining the characteristic of a level in a hierarchical structure

  • HL03 indicates the context of the series of segments following the current HL segment up to the next occurrence of an HL segment in the transaction. For example, HL03 is used to indicate that subsequent segments in the HL loop form a logical grouping of data referring to shipment, order, or item-level information.
35
Company/Corporation
HL-04
736
Hierarchical Child Code
Optional
Identifier (ID)

Code indicating if there are hierarchical child data segments subordinate to the level being described

  • HL04 indicates whether or not there are subordinate (or child) HL segments related to the current HL segment.
1
Additional Subordinate HL Data Segment in This Hierarchical Structure.
N1 Loop
RequiredMax >1
N1
0200
Detail > HL Loop > N1 Loop > N1

Party Identification

RequiredMax use 1

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

  • N105, when used, defines the relationship of the entity designated in N102 or N104 to its parent organization.
Usage notes

This segment is used to specify the corporate office name or place of business for locations specified in the associated detail loops.

Example
At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required
If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

CQ
Corporate Office
Optional
String (AN)
Min 1Max 60

Free-form name

N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)

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.

N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80

Code identifying a party or other code

  • 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.
Usage notes

13 Digit GLN Number

N3
0400
Detail > HL Loop > N1 Loop > N3

Party Location

OptionalMax use 2

To specify the location of the named party

Example
N3-01
166
Address Information
Required
String (AN)
Min 1Max 55

Address information

N3-02
166
Address Information
Optional
String (AN)
Min 1Max 55

Address information

N4
0500
Detail > HL Loop > N1 Loop > N4

Geographic Location

OptionalMax use 1

To specify the geographic place of the named party

Example
N4-01
19
City Name
Optional
String (AN)
Min 2Max 30

Free-form text for city name

  • A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
N4-02
156
State or Province Code
Optional
Identifier (ID)
Min 2Max 2

Code (Standard State/Province) as defined by appropriate government agency

  • N402 is required only if city name (N401) is in the U.S. or Canada.
N4-03
116
Postal Code
Optional
Identifier (ID)
Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04
26
Country Code
Optional
Identifier (ID)
Min 2Max 3

Code identifying the country

REF
0700
Detail > HL Loop > N1 Loop > REF

Reference Information

OptionalMax use 12

To specify identifying information

Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

DNS
D-U-N-S+4, D-U-N-S Number with Four Character Suffix
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 50

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

N1 Loop end
HL Loop
RequiredMax >1
Usage notes

The FULL file for the 816 will have an iteration of the HL loop for every WALMART and SAMS location.

HL
0100
Detail > HL Loop > HL Loop > HL

Hierarchical Level

RequiredMax use 1

To identify dependencies among and the content of hierarchically related groups of data segments

Example
HL-01
628
Hierarchical ID Number
Required
String (AN)
Min 1Max 12

A unique number assigned by the sender to identify a particular data segment in a hierarchical structure

  • HL01 shall contain a unique alphanumeric number for each occurrence of the HL segment in the transaction set. For example, HL01 could be used to indicate the number of occurrences of the HL segment, in which case the value of HL01 would be "1" for the initial HL segment and would be incremented by one in each subsequent HL segment within the transaction.
HL-02
734
Hierarchical Parent ID Number
Required
String (AN)
Min 1Max 12

Identification number of the next higher hierarchical data segment that the data segment being described is subordinate to

  • HL02 identifies the hierarchical ID number of the HL segment to which the current HL segment is subordinate.
HL-03
735
Hierarchical Level Code
Required
Identifier (ID)

Code defining the characteristic of a level in a hierarchical structure

  • HL03 indicates the context of the series of segments following the current HL segment up to the next occurrence of an HL segment in the transaction. For example, HL03 is used to indicate that subsequent segments in the HL loop form a logical grouping of data referring to shipment, order, or item-level information.
36
Operating Unit
HL-04
736
Hierarchical Child Code
Optional
Identifier (ID)

Code indicating if there are hierarchical child data segments subordinate to the level being described

  • HL04 indicates whether or not there are subordinate (or child) HL segments related to the current HL segment.
0
No Subordinate HL Segment in This Hierarchical Structure.
N1 Loop Store
OptionalMax >1
Variants (all may be used)
N1 Loop Warehouse
N1
0200
Detail > HL Loop > HL Loop > N1 Loop Store > N1

Party Identification

RequiredMax use 1

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

  • N105, when used, defines the relationship of the entity designated in N102 or N104 to its parent organization.
Usage notes

This segment is used to specify the corporate office name or place of business for locations specified in the associated detail loops.

Example
At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required
If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

SN
Store
Optional
String (AN)
Min 1Max 60

Free-form name

Usage notes

This data element may be used to provide additional clarity, e.g., Northridge Mall.

N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)

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.

N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80

Code identifying a party or other code

  • 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.
N3
0400
Detail > HL Loop > HL Loop > N1 Loop Store > N3

Party Location

OptionalMax use 2

To specify the location of the named party

Example
N3-01
166
Address Information
Required
String (AN)
Min 1Max 55

Address information

N3-02
166
Address Information
Optional
String (AN)
Min 1Max 55

Address information

N4
0500
Detail > HL Loop > HL Loop > N1 Loop Store > N4

Geographic Location

OptionalMax use 1

To specify the geographic place of the named party

Example
N4-01
19
City Name
Optional
String (AN)
Min 2Max 30

Free-form text for city name

  • A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
N4-02
156
State or Province Code
Optional
Identifier (ID)
Min 2Max 2

Code (Standard State/Province) as defined by appropriate government agency

  • N402 is required only if city name (N401) is in the U.S. or Canada.
N4-03
116
Postal Code
Optional
Identifier (ID)
Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04
26
Country Code
Optional
Identifier (ID)
Min 2Max 3

Code identifying the country

PER
0600
Detail > HL Loop > HL Loop > N1 Loop Store > PER

Administrative Communications Contact

OptionalMax use >1

To identify a person or office to whom administrative communications should be directed

Example
If either Communication Number Qualifier (PER-03) or Communication Number (PER-04) is present, then the other is required
PER-01
366
Contact Function Code
Required
Identifier (ID)

Code identifying the major duty or responsibility of the person or group named

IC
Information Contact
Optional
String (AN)
Min 1Max 60

Free-form name

PER-03
365
Communication Number Qualifier
Optional
Identifier (ID)

Code identifying the type of communication number

TE
Telephone
PER-04
364
Communication Number
Optional
String (AN)
Min 1Max 256

Complete communications number including country or area code when applicable

REF
0700
Detail > HL Loop > HL Loop > N1 Loop Store > REF

Reference Information Duns

OptionalMax use 12

To specify identifying information

Usage notes

This segment is sent in the weekly change file only.

Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

DNS
D-U-N-S+4, D-U-N-S Number with Four Character Suffix
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 50

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

REF
0700
Detail > HL Loop > HL Loop > N1 Loop Store > REF

Reference Information Store

OptionalMax use 12

To specify identifying information

Example
Variants (all may be used)
REFReference Information Duns
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

AEM
Distribution Center Number
ST
Store Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 50

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

DTM
0900
Detail > HL Loop > HL Loop > N1 Loop Store > DTM

Date/Time Reference

OptionalMax use 10

To specify pertinent dates and times

Usage notes

This segment is present in the weekly changes file to denote future effective dates.

Example
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)

Code specifying type of date or time, or both date and time

007
Effective
Required
Date (DT)
CCYYMMDD format

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

ASI
1000
Detail > HL Loop > HL Loop > N1 Loop Store > ASI

Action or Status Indicator

OptionalMax use 1

To indicate the action to be taken with the information provided or the status of the entity described

Usage notes

When BHT01 contains code 0065 and BHT02 contains code 04, this segment is required to specify the maintenance action for the location specified in the associated N1 segment.

When ASI02 contains code 001, all data about a location is to be replaced. That is, the sender should replace the entire location address record rather than just the data which changed, e.g., telephone number.

This segment is sent in the weekly change file only.

Example
ASI-01
306
Action Code
Required
Identifier (ID)

Code indicating type of action

2
Change (Update)
ASI-02
875
Maintenance Type Code
Required
Identifier (ID)

Code identifying the specific type of item maintenance

001
Change

Replace. All data about the location is replaced.

002
Delete

Location is to be deleted.

021
Addition

New location to be added.

ASI-03
641
Status Reason Code
Optional
Identifier (ID)
Min 3Max 3

Code indicating the status reason

N1 Loop Store end
N1 Loop Warehouse
OptionalMax 1
Variants (all may be used)
N1 Loop Store
N1
0200
Detail > HL Loop > HL Loop > N1 Loop Warehouse > N1

Party Identification

RequiredMax use 1

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

  • N105, when used, defines the relationship of the entity designated in N102 or N104 to its parent organization.
Usage notes

This segment is used to specify the corporate office name or place of business for locations specified in the associated detail loops.

Example
At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required
If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

WH
Warehouse

Distribution Center

Optional
String (AN)
Min 1Max 60

Free-form name

Usage notes

This data element may be used to provide additional clarity, e.g., Northridge Mall.

N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)

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.

N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80

Code identifying a party or other code

  • 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.
N3
0400
Detail > HL Loop > HL Loop > N1 Loop Warehouse > N3

Party Location

OptionalMax use 2

To specify the location of the named party

Example
N3-01
166
Address Information
Required
String (AN)
Min 1Max 55

Address information

N3-02
166
Address Information
Optional
String (AN)
Min 1Max 55

Address information

N4
0500
Detail > HL Loop > HL Loop > N1 Loop Warehouse > N4

Geographic Location

OptionalMax use 1

To specify the geographic place of the named party

Example
N4-01
19
City Name
Optional
String (AN)
Min 2Max 30

Free-form text for city name

  • A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
N4-02
156
State or Province Code
Optional
Identifier (ID)
Min 2Max 2

Code (Standard State/Province) as defined by appropriate government agency

  • N402 is required only if city name (N401) is in the U.S. or Canada.
N4-03
116
Postal Code
Optional
Identifier (ID)
Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04
26
Country Code
Optional
Identifier (ID)
Min 2Max 3

Code identifying the country

PER
0600
Detail > HL Loop > HL Loop > N1 Loop Warehouse > PER

Administrative Communications Contact

OptionalMax use >1

To identify a person or office to whom administrative communications should be directed

Example
If either Communication Number Qualifier (PER-03) or Communication Number (PER-04) is present, then the other is required
PER-01
366
Contact Function Code
Required
Identifier (ID)

Code identifying the major duty or responsibility of the person or group named

IC
Information Contact
Optional
String (AN)
Min 1Max 60

Free-form name

PER-03
365
Communication Number Qualifier
Optional
Identifier (ID)

Code identifying the type of communication number

TE
Telephone
PER-04
364
Communication Number
Optional
String (AN)
Min 1Max 256

Complete communications number including country or area code when applicable

REF
0700
Detail > HL Loop > HL Loop > N1 Loop Warehouse > REF

Reference Information Duns

OptionalMax use 12

To specify identifying information

Usage notes

This segment is sent in the weekly change file only.

Example
Variants (all may be used)
REFReference Information Store
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

DNS
D-U-N-S+4, D-U-N-S Number with Four Character Suffix
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 50

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

REF
0700
Detail > HL Loop > HL Loop > N1 Loop Warehouse > REF

Reference Information Store

OptionalMax use 12

To specify identifying information

Example
Variants (all may be used)
REFReference Information Duns
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

AEM
Distribution Center Number
ST
Store Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 50

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

DTM
0900
Detail > HL Loop > HL Loop > N1 Loop Warehouse > DTM

Date/Time Reference

OptionalMax use 10

To specify pertinent dates and times

Usage notes

This segment is present in the weekly changes file to denote future effective dates.

Example
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)

Code specifying type of date or time, or both date and time

007
Effective
Required
Date (DT)
CCYYMMDD format

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

ASI
1000
Detail > HL Loop > HL Loop > N1 Loop Warehouse > ASI

Action or Status Indicator

OptionalMax use 1

To indicate the action to be taken with the information provided or the status of the entity described

Usage notes

When BHT01 contains code 0065 and BHT02 contains code 04, this segment is required to specify the maintenance action for the location specified in the associated N1 segment.

When ASI02 contains code 001, all data about a location is to be replaced. That is, the sender should replace the entire location address record rather than just the data which changed, e.g., telephone number.

This segment is sent in the weekly change file only.

Example
ASI-01
306
Action Code
Required
Identifier (ID)

Code indicating type of action

2
Change (Update)
ASI-02
875
Maintenance Type Code
Required
Identifier (ID)

Code identifying the specific type of item maintenance

001
Change

Replace. All data about the location is replaced.

002
Delete

Location is to be deleted.

021
Addition

New location to be added.

ASI-03
641
Status Reason Code
Optional
Identifier (ID)
Min 3Max 3

Code indicating the status reason

N1 Loop Warehouse end
HL Loop end
HL Loop end
SE
1100
Detail > SE

Transaction Set Trailer

RequiredMax use 1

To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

Example
SE-01
96
Number of Included Segments
Required
Numeric (N0)
Min 1Max 10

Total number of segments included in a transaction set including ST and SE segments

SE-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9

Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

Detail end

Functional Group Trailer

RequiredMax use 1

To indicate the end of a functional group and to provide control information

Example
GE-01
97
Number of Transaction Sets Included
Required
Numeric (N0)
Min 1Max 6

Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element

GE-02
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

Assigned number originated and maintained by the sender

Interchange Control Trailer

RequiredMax use 1

To define the end of an interchange of zero or more functional groups and interchange-related control segments

Example
IEA-01
I16
Number of Included Functional Groups
Required
Numeric (N0)
Min 1Max 5

A count of the number of functional groups included in an interchange

IEA-02
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9

A control number assigned by the interchange sender

EDI Samples

Weekly Full File

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *241009*0234*^*00501*000000001*0*T*>~
GS*OR*SENDERGS*RECEIVERGS*20241009*023413*1*X*005010~
ST*816*0001~
BHT*0065*00*200505070945N000000*20050507~
N1*FR*WAL-MART STORES, INC.~
HL*0000001**35~
N1*CQ*WAL-MART STORES*UL*0078742000008~
N3*HOME OFFICE*702 SW 8TH STREET~
N4*BENTONVILLE*AR*72716*US~
REF*DNS*0519577690000~
HL*0000002*0000001*36~
N1*SN*WAL-MART SUPERCENTER 0001*UL*0078742000015~
N3*2110 WEST WALNUT~
N4*ROGERS*AR*72756*US~
PER*IC**TE*479-636-3222~
REF*DNS*0519577690001~
REF*ST*00001~
HL*0000003*0000001*36~
N1*SN*WAL-MART SUPERCENTER 0002*UL*0078742000022~
N3*1417 HWY 62/65 N~
N4*HARRISON*AR*72601*US~
PER*IC**TE*870-365-8400~
REF*DNS*0519577690002~
REF*ST*00002~
HL*0005153*0000001*36~
N1*SN*SAMS DISTRIBUTION ADM.*UL*0605388006592~
N3*708 SOUTHWEST 8TH STREET~
N4*BENTONVILLE*AR*72716*US~
PER*IC**TE*501-000-0000~
REF*DNS*0519577699189~
REF*ST*09189~
SE*30*0001~
GE*1*1~
IEA*1*000000001~

Weekly Update File (Addition)

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *241009*0239*^*00501*000000001*0*T*>~
GS*OR*SENDERGS*RECEIVERGS*20241009*023910*1*X*005010~
ST*816*0001~
BHT*0065*04*200505070948N000000*20050507~
N1*FR*WAL-MART STORES, INC.~
HL*0000001**35~
N1*CQ*WAL-MART STORES*UL*0078742000008~
N3*HOME OFFICE*702 SW 8TH STREET~
N4*BENTONVILLE*AR*72716*US~
REF*DNS*0519577690000~
HL*0000002*0000001*36~
N1*SN*WAL-MART NEIGHBORHOOD MARKET 2393*UL*0078742023144~
N3*2110 WEST WALKER~
N4*OKLAHOMA CITY*OK*73132*US~
PER*IC**TE*405-720-8182~
REF*DNS*0519577699999~
REF*ST*09999~
DTM*007*20050516~
ASI*2*021~
SE*18*0001~
GE*1*1~
IEA*1*000000001~

Weekly Update File (Change)

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *241009*0235*^*00501*000000001*0*T*>~
GS*OR*SENDERGS*RECEIVERGS*20241009*023542*1*X*005010~
ST*816*0001~
BHT*0065*04*200505070946N000000*20050507~
N1*FR*WAL-MART STORES, INC.~
HL*0000001**35~
N1*CQ*WAL-MART STORES*UL*0078742000008~
N3*HOME OFFICE*702 SW 8TH STREET~
N4*BENTONVILLE*AR*72716*US~
REF*DNS*0519577690000~
HL*0000002*0000001*36~
N1*SN*WAL-MART SUPERCENTER 0002*UL* 0078742000022~
N3* 1417 HWY 62/65 N~
N4* HARRISON*AR* 72601*US~
PER*IC**TE* 870-365-8400~
REF*DNS* 0519577690002~
REF*ST*00002~
DTM*007*20050507~
ASI*2*001~
SE*18*0001~
GE*1*1~
IEA*1*000000001~

Weekly Update File (Delete)

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *241009*0237*^*00501*000000001*0*T*>~
GS*OR*SENDERGS*RECEIVERGS*20241009*023717*1*X*005010~
ST*816*0001~
BHT*0065*04*200505070945N000000*20050507~
N1*FR*WAL-MART STORES, INC.~
HL*0000001**35~
N1*CQ*WAL-MART STORES*UL*0078742000008~
N3*HOME OFFICE*702 SW 8TH STREET~
N4*BENTONVILLE*AR*72716*US~
REF*DNS*0519577690000~
HL*0000002*0000001*36~
N1*SN*WAL-MART SUPERCENTER 0001*UL*0078742000015~
N3*2110 WEST WALNUT~
N4*ROGERS*AR*72756*US~
PER*IC**TE*970-522-8182~
REF*DNS*0519577690001~
REF*ST*00001~
DTM*007*20050507~
ASI*2*002~
SE*18*0001~
GE*1*1~
IEA*1*000000001~

Stedi is a registered trademark of Stedi, Inc. All names, logos, and brands of third parties listed on this page are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.