846 Inventory Inquiry

Follow the guidelines in this article to use the Inventory Inquiry and Advice Transaction set (846) with an EDI interface.

Note: You can also view this article in Word format: Walmart.com Drop Ship Vendor_846_4010_EDI.docx

Functional Group IB

This Draft Standard for Trial Use contains the format and establishes the Inventory Inquiry/Advice Transaction Set (846) data for use within an Electronic Data Interchange (EDI) environment. The transaction set can be used in the following ways: (1) for a seller of goods and services to provide inventory information to a prospective purchaser, with no obligation to the purchaser to acquire these goods or services; (2) for a representative of a seller of goods and services to supply inventory information to that seller; (3) for one location to supply another location with inventory information; and (4) for an inquiry as to the availability of inventory with no obligation on the seller of goods and services to reserve that inventory.

Heading

Detail

Summary

Sample Inventory File

---

ISA*00* *00* *12*123456789012 *01*12571829 *200717*0601*U*00401*002382154*0*P*>
GS*IB*123456789012*12571829*20200717*06011177*1719732*X*004010
ST*846*00001
BIA*00*SI*055846*20200717*06011177
REF*VR*11223344*SAM WALTZ, LLC
LIN*1*UP*0088904833374*VN*VTH211A-9*BP*55672488
REF*ZZ*AC
QTY*17*120
MEA****DA*0*1
LIN*2*UP*0088904824734*VN*VTH211A-28*BP*55672567
REF*ZZ*AC
QTY*17*58
MEA****DA*0*1
LIN*3*UP*0088904803692*VN*ADR113B-5*BP*48553530
REF*ZZ*AC
QTY*17*26
MEA****DA*0*1
LIN*4*UP*0088904823903*VN*PLS726A-2020*BP*140038872
REF*ZZ*AC
QTY*17*567
MEA****DA*0*1
LIN*5*UP*0068372650923*VN*CY5146A-5*BP*15802629
REF*ZZ*AC
QTY*17*15
MEA****DA*0*1
LIN*6*UP*0088904857080*VN*SGU210A-3*BP*643599154
REF*ZZ*AC
QTY*17*0
MEA****DA*0*1
LIN*7*UP*0088904811292*VN*EVK226D-3*BP*48825966
REF*ZZ*AC
QTY*17*8
MEA****DA*0*1
LIN*8*UP*0088904818285*VN*EVK256A-3*BP*48825658
REF*ZZ*AC
QTY*17*0
MEA****DA*0*1
LIN*9*UP*0088904807829*VN*CLV121A-6*BP*48618577
REF*ZZ*AC
QTY*17*13
MEA****DA*0*1
LIN*10*UP*0088904817522*VN*EVK256S-3*BP*48826809
REF*ZZ*AC
QTY*17*30
MEA****DA*0*1
CTT*10
SE*45*00001
GE*1*1719732
IEA*1*002382154

ST Transaction Set Header

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

• Pos: 010
• Max: 1
• Heading – Mandatory
• Loop: N/A
• Elements: 2

Element Summary

BIA Beginning Segment for Inventory Inquiry/Advice

To indicate the beginning of an Inventory Inquiry/Advice Transaction Set.

• Pos: 020
• Max: 1
• Heading – Mandatory
• Loop: N/A
• Elements: 5

Element Summary

REF Reference Identification

To specify identifying information.

• Pos: 060
• Max: 1
• Heading – Mandatory
• Loop: N/A
• Elements: 3

Element Summary

LIN Item Identification

To specify basic item identification data.

• Pos: 010
• Max: 1
• Detail – Mandatory
• Loop: LIN
• Elements: 7

Element Summary

REF Reference Identification

To specify identifying information.

• Pos: 140
• Max: 1
• Detail – Mandatory
• Loop: LIN (Mandatory)
• Elements: 2

Element Summary

Usage Notes

Many availability code values exist. They are listed and described in the following.

Note: Two availability code values will automatically remove an item from the Walmart.com site catalog. The “NA” code is used if it’s possible that the item UPC may return at some time in the future and “DT” is used if the item UPC won’t return (e.g. UPC is discontinued). In either case, please send at least two consecutive updates messages before the UPC is removed from the inventory feed.

Availability Codes:

• AC: Active – Item can be ordered only if the number of items on hand is sufficient to fulfill the amount ordered. An On Hand Quantity is required and Minimum and Maximum Days to Ship are optional. If Days are not specified, 0 to 1 business day is assumed.
• PO: Pre-Order – Supplier is accepting pre-orders for the item. An Availability Start Date is required to indicate when orders are expected to ship. In addition, an On Hand Quantity is required to determine how many items can be pre-ordered. After the start date, it acts like an active item (On Hand Quantity is required and Minimum and Maximum Days to Ship are optional).
• JT: Just in Time – Item is stocked on demand. Minimum and Maximum Days to Ship are required to indicate how long it will take to fulfill an order.
• BO: Build to Order – Item is pre-configured and manufactured on demand. Minimum and Maximum Days to Ship are required to indicate how long it will take to fulfill an order. Since the supplier configures these items before the order is placed, it’s assumed that the item will always ship and backorders aren't allowed.
• SE: Seasonal – Item is available, but it's seasonal and orders are only accepted during a specified date range. Both Availability Start and End Dates are required to indicate the date range. Within the date range, it behaves like an active item (On Hand Quantity is required and Minimum and Maximum Days to Ship are optional).
• RO: Run Out – Item is discontinued and will not be restocked. The Availability End Date is required to indicate the last date orders will be accepted. Before the end date, it behaves like an active item (On Hand Quantity is required and Minimum and Maximum Days to Ship are optional).
• NA: Not Active – Item isn't available for purchase at this time.
• DT: Deleted – Item isn't available for purchase and can be deleted from the catalog.

QTY Quantity

To specify quantity information.

• Pos: 320
• Max: 1
• Detail – Optional
• Loop: QTY (Mandatory)
• Elements: 2

Element Summary

MEA Measurements

To specify physical measurements or counts, including dimensions, tolerances, variances, and weights.

• Pos: 340
• Max: 1
• Detail – Optional
• Loop: QTY (Mandatory)
• Elements: 4

Element Summary

DTM Date/Time Reference

To specify pertinent dates and times.

• Pos: 355
• Max: 1
• Detail – Optional
• Loop: QTY (Mandatory)
• Elements: 2

Element Summary

DTM Date/Time Reference

To specify pertinent dates and times.

• Pos: 356
• Max: 1
• Detail – Optional
• Loop: QTY (Mandatory)
• Elements: 2

Element Summary

CTT Transaction Totals

To transmit a hash total for a specific element in the transaction set.

• Pos: 010
• Max: 1
• Summary – Mandatory
• Loop: N/A
• Elements: 1

Element Summary

SE Transaction Set Trailer

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

• Pos: 020
• Max: 1
• Summary – Mandatory
• Loop: N/A
• Elements: 1

Element Summary