X12 846 Inventory Inquiry/Advice
This Draft Standard for Trial Use contains the format and establishes the data contents of the Inventory Inquiry/Advice Transaction Set (846) for use within the context of 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.
- ~ Segment
- * Element
- > Component
Interchange Control Header
To start and identify an interchange of zero or more functional groups and interchange-related control segments
Code to identify the type of information in the Authorization Information
- 00
- No Authorization Information Present (No Meaningful Information in I02)
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)
Code to identify the type of information in the Security Information
- 00
- No Security Information Present (No Meaningful Information in I04)
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)
Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified
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
Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified
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
Code to identify the agency responsible for the control standard used by the message that is enclosed by the interchange header and trailer
- U
- U.S. EDI Community of ASC X12, TDCC, and UCS
This version number covers the interchange control segments
- 00401
- Draft Standards for Trial Use Approved for Publication by ASC X12 Procedures Review Board through October 1997
A control number assigned by the interchange sender
Code sent by the sender to request an interchange acknowledgment (TA1)
- 0
- No Acknowledgment Requested
- 1
- Interchange Acknowledgment Requested
Code to indicate whether data enclosed by this interchange envelope is test, production or information
- I
- Information
- P
- Production Data
- T
- Test Data
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
To indicate the beginning of a functional group and to provide control information
Code identifying a group of application related transaction sets
- IB
- Inventory Inquiry/Advice (846)
Code identifying party sending transmission; codes agreed to by trading partners
Code identifying party receiving transmission. Codes agreed to by trading partners
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)
Assigned number originated and maintained by the sender
Code used in conjunction with Data Element 480 to identify the issuer of the standard
- T
- Transportation Data Coordinating Committee (TDCC)
- X
- Accredited Standards Committee X12
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
- 004010
- Draft Standards Approved for Publication by ASC X12 Procedures Review Board through October 1997
Heading
Transaction Set Header
To indicate the start of a transaction set and to assign a control number
Code uniquely identifying a Transaction Set
- The transaction set identifier (ST01) used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set).
- 846
- Inventory Inquiry/Advice
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
Beginning Segment for Inventory Inquiry/Advice
To indicate the beginning of an Inventory Inquiry/Advice Transaction Set
Code indicating the title or contents of a document, report or supporting item
- SI
- Seller Inventory Report
Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier
- BIA03 identifies the number of the inquiry/advice that is transferred.
Unique Sequence Number (up to 6 digits).
Date expressed as CCYYMMDD
- BIA04 identifies the date of the inquiry/advice that is transferred.
Date of Inventory.
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)
- BIA05 identifies the time of the inquiry/advice that is transferred.
Code qualifying the Reference Identification
- VR
- Vendor ID Number
Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier
Distribution Facility ID.
A free-form description to clarify the related data elements and their content
Name of the Distribution Facility.
Detail
Item Identification
To specify basic item identification data
Alphanumeric characters assigned for differentiation within a transaction set
- LIN01 is the line item identification
Sequence Number.
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
- LIN02 through LIN31 provide for fifteen different product/service IDs for each item. For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.
Walmart UPC Code Qualifier.
- UP
- U.P.C. Consumer Package Code (1-5-5-1)
Identifying number for a product or service
Walmart 13 digits UPC number (first 13 digits of the GTIN).
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
- VN
- Vendor's (Seller's) Item Number
Identifying number for a product or service
Supplier SKU or model number.
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
Walmart.com Item ID Qualifier.
- BP
- Buyer's Part Number
Identifying number for a product or service
Walmart.com item ID/number.
Code qualifying the Reference Identification
- ZZ
- Mutually Defined
Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier
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.
- 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 the Days are not specified, then 0 to 1 business days is assumed. - 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.
- DT
- Deleted
Item isn't available for purchase and may be
deleted from the catalog. - 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. - NA
- Not Active
Item isn't available for purchase at this time.
- 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 may 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). - RO
- Run Out
Item is being discontinued and will not be
restocked. The Availability End Date is required to
indicate the last date on which 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). - 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).
Measurements
To specify physical measurements or counts, including dimensions, tolerances, variances, and weights
(See Figures Appendix for example of use of C001)
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- DA
- Days
The value specifying the minimum of the measurement range
- When citing dimensional tolerances, any measurement requiring a sign (+ or -), or any measurement where a positive (+) value cannot be assumed, use MEA05 as the negative (-) value and MEA06 as the positive (+) value.
The minimum number of business days to fulfill an order for this item.
The value specifying the maximum of the measurement range
The maximum number of business days to fulfill an order for this item.
Summary
Transaction Totals
To transmit a hash total for a specific element in the transaction set
- Number of line items (CTT01) is the accumulation of number of LIN segments. If used, hash total (CTT02) is the sum of the values of the quantities (QTY02) of each QTY segment.
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)
Total number of segments included in a transaction set including ST and SE segments
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
Functional Group Trailer
To indicate the end of a functional group and to provide control information
Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element
Assigned number originated and maintained by the sender
Interchange Control Trailer
To define the end of an interchange of zero or more functional groups and interchange-related control segments
Sample
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
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.