Walmart
/
Inventory Inquiry/Advice
  • 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 846 Inventory Inquiry/Advice

X12 Release 4010
Delimiters
  • ~ Segment
  • * Element
  • > Component
EDI sample
  • Sample
View the latest version of this implementation guide as an interactive webpage
https://www.stedi.com/app/guides/view/walmart-edi/inventory-inquiryadvice/01GYCX0J2G72328DRV44A91V3V
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
detail
LIN Loop
LIN
010
Item Identification
Max use 1
Required
REF
140
Reference Identification
Max use 1
Required
QTY Loop
GE
-
Functional Group Trailer
Max use 1
Required
IEA
-
Interchange Control Trailer
Max use 1
Required
ISA

Interchange Control Header

RequiredMax use 1
Example
ISA-01
I01
Authorization Information Qualifier
Required
Identifier (ID)
00
No Authorization Information Present (No Meaningful Information in I02)
ISA-02
I02
Authorization Information
Required
String (AN)
Min 10Max 10
ISA-03
I03
Security Information Qualifier
Required
Identifier (ID)
00
No Security Information Present (No Meaningful Information in I04)
ISA-04
I04
Security Information
Required
String (AN)
Min 10Max 10
ISA-05
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2
Codes
ISA-06
I06
Interchange Sender ID
Required
String (AN)
Min 15Max 15
ISA-07
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2
Codes
ISA-08
I07
Interchange Receiver ID
Required
String (AN)
Min 15Max 15
ISA-09
I08
Interchange Date
Required
Date (DT)
YYMMDD format
ISA-10
I09
Interchange Time
Required
Time (TM)
HHMM format
ISA-11
I10
Interchange Control Standards Identifier
Required
Identifier (ID)
U
U.S. EDI Community of ASC X12, TDCC, and UCS
ISA-12
I11
Interchange Control Version Number
Required
Identifier (ID)
00401
Draft Standards for Trial Use Approved for Publication by ASC X12 Procedures Review Board through October 1997
ISA-13
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9
ISA-14
I13
Acknowledgment Requested
Required
Identifier (ID)
Min 1Max 1
0
No Acknowledgment Requested
1
Interchange Acknowledgment Requested
ISA-15
I14
Usage Indicator
Required
Identifier (ID)
Min 1Max 1
I
Information
P
Production Data
T
Test Data
ISA-16
I15
Component Element Separator
Required
String (AN)
Min 1Max 1
>
Component Element Separator

Functional Group Header

RequiredMax use 1
Example
GS-01
479
Functional Identifier Code
Required
Identifier (ID)
IB
Inventory Inquiry/Advice (846)
GS-02
142
Application Sender's Code
Required
String (AN)
Min 2Max 15
GS-03
124
Application Receiver's Code
Required
String (AN)
Min 2Max 15
Required
Date (DT)
CCYYMMDD format
Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
GS-06
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9
GS-07
455
Responsible Agency Code
Required
Identifier (ID)
Min 1Max 2
T
Transportation Data Coordinating Committee (TDCC)
X
Accredited Standards Committee X12
GS-08
480
Version / Release / Industry Identifier Code
Required
String (AN)
004010
Draft Standards Approved for Publication by ASC X12 Procedures Review Board through October 1997

Heading

ST
010
Heading > ST

Transaction Set Header

RequiredMax use 1
Example
ST-01
143
Transaction Set Identifier Code
Required
Identifier (ID)
846
Inventory Inquiry/Advice
ST-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9
BIA
020
Heading > BIA

Beginning Segment for Inventory Inquiry/Advice

RequiredMax use 1
Example
BIA-01
353
Transaction Set Purpose Code
Required
Identifier (ID)
00
Original
BIA-02
755
Report Type Code
Required
Identifier (ID)
SI
Seller Inventory Report
BIA-03
127
Reference Identification
Required
String (AN)
Min 1Max 30
Usage notes
Required
Date (DT)
CCYYMMDD format
Usage notes
Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
REF
060
Heading > REF

Reference Identification

RequiredMax use 12
Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
VR
Vendor ID Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 30
Usage notes
REF-03
352
Description
Required
String (AN)
Min 1Max 80
Usage notes
Heading end

Detail

LIN Loop
RequiredMax >1
LIN
010
Detail > LIN Loop > LIN

Item Identification

RequiredMax use 1
Example
If either Product/Service ID Qualifier (LIN-06) or Product/Service ID (LIN-07) is present, then the other is required
LIN-01
350
Assigned Identification
Required
String (AN)
Min 1Max 20
Usage notes
LIN-02
235
Product/Service ID Qualifier
Required
Identifier (ID)
Usage notes
UP
U.P.C. Consumer Package Code (1-5-5-1)
LIN-03
234
Product/Service ID
Required
String (AN)
Min 1Max 48
Usage notes
LIN-04
235
Product/Service ID Qualifier
Required
Identifier (ID)
VN
Vendor's (Seller's) Item Number
LIN-05
234
Product/Service ID
Required
String (AN)
Min 1Max 48
Usage notes
LIN-06
235
Product/Service ID Qualifier
Optional
Identifier (ID)
Usage notes
BP
Buyer's Part Number
LIN-07
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
REF
140
Detail > LIN Loop > REF

Reference Identification

RequiredMax use >1
Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
ZZ
Mutually Defined
REF-02
127
Reference Identification
Required
String (AN)
Usage notes
AC
Active
BO
Build to Order
DT
Deleted
JT
Just in Time
NA
Not Active
PO
Pre-Order
RO
Run Out
SE
Seasonal
QTY Loop
OptionalMax >1
QTY
320
Detail > LIN Loop > QTY Loop > QTY

Quantity

RequiredMax use 1
Example
QTY-01
673
Quantity Qualifier
Required
Identifier (ID)
17
Quantity on Hand
QTY-02
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
MEA
340
Detail > LIN Loop > QTY Loop > MEA

Measurements

OptionalMax use 25
Example
If Range Minimum (MEA-05) is present, then Composite Unit of Measure (MEA-04) is required
If Range Maximum (MEA-06) is present, then Composite Unit of Measure (MEA-04) is required
MEA-04
C001
Composite Unit of Measure
OptionalMax use 1
To identify a composite unit of measure (See Figures Appendix for examples of use)
C001-01
355
Unit or Basis for Measurement Code
Required
Identifier (ID)
DA
Days
MEA-05
740
Range Minimum
Optional
Decimal number (R)
Min 1Max 15
Usage notes
MEA-06
741
Range Maximum
Optional
Decimal number (R)
Min 1Max 15
Usage notes
DTM
355
Detail > LIN Loop > QTY Loop > DTM

End

OptionalMax use 10
Example
Variants (all may be used)
DTMStart
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
197
End
Optional
Date (DT)
CCYYMMDD format
Usage notes
DTM
355
Detail > LIN Loop > QTY Loop > DTM

Start

OptionalMax use 10
Example
Variants (all may be used)
DTMEnd
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
196
Start
Optional
Date (DT)
CCYYMMDD format
Usage notes
QTY Loop end
LIN Loop end
Detail end

Summary

CTT
010
Summary > CTT

Transaction Totals

RequiredMax use 1
Example
CTT-01
354
Number of Line Items
Required
Numeric (N0)
Min 1Max 6
SE
020
Summary > SE

Transaction Set Trailer

RequiredMax use 1
Example
SE-01
96
Number of Included Segments
Required
Numeric (N0)
Min 1Max 10
SE-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9
Summary end

Functional Group Trailer

RequiredMax use 1
Example
GE-01
97
Number of Transaction Sets Included
Required
Numeric (N0)
Min 1Max 6
GE-02
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

Interchange Control Trailer

RequiredMax use 1
Example
IEA-01
I16
Number of Included Functional Groups
Required
Numeric (N0)
Min 1Max 5
IEA-02
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9
EDI Samples

Sample

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *231106*1404*U*00401*000000001*0*T*>
GS*IB*SENDERGS*RECEIVERGS*20231106*140439*000000001*X*004010
ST*846*00001
BIA*00*SI*439471*20200603*13010186
REF*VR*123456789*ABC DSV, Inc.
LIN*1*UP*0081534002010*VN*CCWENKS3M26CFVA*BP*48006765
REF*ZZ*AC
QTY*17*1344
LIN*2*UP*0081534002012*VN*CCWENKS2M26DGRA*BP*48006776
REF*ZZ*AC
QTY*17*1354
LIN*3*UP*0081534002015*VN*CCHRFKS2M26BKVA*BP*48006764
REF*ZZ*AC
QTY*17*2093
LIN*4*UP*0898672000004*VN*SA-CPAS3O2580-P*BP*195837179
REF*ZZ*AC
QTY*17*158
LIN*5*UP*0081218901126*VN*SC-CRYS3LU2012*BP*789420524
REF*ZZ*AC
QTY*17*0
LIN*6*UP*0081218901127*VN*SC-CRYS3LU2051*BP*501266429
REF*ZZ*AC
QTY*17*1878
LIN*7*UP*0812189010042*VN*LS3-SLA-EKB*BP*10216737
REF*ZZ*NA
QTY*17*0
LIN*8*UP*0084005323070*VN*SATNRQNM4045*BP*868836186
REF*ZZ*AC
QTY*17*0
LIN*9*UP*0815340027798*VN*CCHRFKS2M26DGRA*BP*55322740
REF*ZZ*AC
QTY*17*0
LIN*10*UP*0812189016778*VN*LS3-SLA-QNB*BP*35276572
REF*ZZ*AC
QTY*17*0
LIN*11*UP*0840053222963*VN*RO-SPDS2EO3064*BP*289865449
REF*ZZ*AC
QTY*17*30
LIN*12*UP*0084005320358*VN*RO-BTAMO2451*BP*449958849
REF*ZZ*AC
QTY*17*14
LIN*13*UP*0081365602829*VN*SC-NLS-S3F28-BK*BP*49971630
REF*ZZ*AC
QTY*17*359
LIN*14*UP*0815340024285*VN*SCNLSS3F28BK*BP*126304544
REF*ZZ*AC
QTY*17*359
LIN*15*UP*0840053233631*VN*LS-CROCTBK*BP*427930443
REF*ZZ*DT
QTY*17*0
CTT*15
SE*50*00001
GE*1*000000001
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.