X12 846 Inventory Inquiry/Advice

X12 Release 4010

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.

Delimiters

• ~ Segment
• * Element
• > Component

ISA Interchange Control Header

Required · Max use 1

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

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

Code to identify 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 10 Max 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 to identify 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 10 Max 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 2 Max 2

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

Codes

• 01: Duns (Dun & Bradstreet)
• 02: SCAC (Standard Carrier Alpha Code)
• 03: FMC (Federal Maritime Commission)
• 04: IATA (International Air Transport Association)
• 08: UCC EDI Communications ID (Comm ID)
• 09: X.121 (CCITT)
• 10: Department of Defense (DoD) Activity Address Code
• 11: DEA (Drug Enforcement Administration)
• 12: Phone (Telephone Companies)
• 13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
• 14: Duns Plus Suffix
• 15: Petroleum Accountants Society of Canada Company Code
• 16: Duns Number With 4-Character Suffix
• 17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
• 18: Association of American Railroads (AAR) Standard Distribution Code
• 19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
• 20: Health Industry Number (HIN)
• 21: Integrated Postsecondary Education Data System, or (IPEDS)
• 22: Federal Interagency Commission on Education, or FICE
• 23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
• 24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
• 25: American College Testing Program 4-Digit Code of Postsecondary Institutions, or ACT
• 26: Statistics of Canada List of Postsecondary Institutions
• 27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
• 29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 30: U.S. Federal Tax Identification Number
• 31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
• 32: U.S. Federal Employer Identification Number (FEIN)
• 33: National Association of Insurance Commissioners Company Code (NAIC)
• 34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
• 35: Statistics Canada Canadian College Student Information System Institution Codes
• 36: Statistics Canada University Student Information System Institution Codes
• 37: Society of Property Information Compilers and Analysts
• AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
• NR: National Retail Merchants Association (NRMA) - Assigned
• SN: Standard Address Number
• ZZ: Mutually Defined

ISA-06 · I06 · Interchange Sender ID · Required · String (AN) · Min 15 Max 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)

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

Flxpoint uses "ZZ" for our Receiver ID Qualifier.

• ZZ: Mutually Defined

ISA-08 · I07 · Interchange Receiver ID · Required · String (AN) · Min 15 Max 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.

Flxpoint uses either "FLXPOINT" or "FLX#####" for our Receiver ID, where ##### is the AID of the client.

Example values

• FLXPOINT       

• FLX12345       

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 · I10 · Interchange Control Standards Identifier · Required · Identifier (ID)

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

ISA-12 · I11 · Interchange Control Version Number · Required · Identifier (ID)

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

ISA-13 · I12 · Interchange Control Number · Required · Numeric (N0) · Min 9 Max 9

A control number assigned by the interchange sender

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

Code sent by the sender to request an interchange acknowledgment (TA1)

• 0: No Acknowledgment Requested
• 1: Interchange Acknowledgment Requested

ISA-15 · I14 · Usage Indicator · Required · Identifier (ID) · Min 1 Max 1

Code to indicate 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 1 Max 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

GS Functional Group Header

Required · Max use 1

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

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

Code identifying a group of application related transaction sets

• IB: Inventory Inquiry/Advice (846)

GS-02 · 142 · Application Sender's Code · Required · String (AN) · Min 2 Max 15

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

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

Code identifying party receiving transmission. Codes agreed to by trading partners

GS-04 · 373 · Date · Required · Date (DT) · CCYYMMDD format

Date expressed as CCYYMMDD

GS-05 · 337 · Time · 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 1 Max 9

Assigned number originated and maintained by the sender

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

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

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

• 004010VICS: Voluntary Inter-Industry Commerce Standards; The EDI Standards maintained and utilized by the retail industry.

Heading

010 Heading > ST

ST Transaction Set Header

Required · Max use 1

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

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

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

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

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

Note: Unique number that is incremented by 1 for each transaction set sent.

020 Heading > BIA

BIA Beginning Segment for Inventory Inquiry/Advice

Required · Max use 1

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

BIA-01 · 353 · Transaction Set Purpose Code · Required · Identifier (ID)

Code identifying purpose of transaction set

• 00: Original

BIA-02 · 755 · Report Type Code · Required · Identifier (ID)

Code indicating the title or contents of a document, report or supporting item

• MM: Manufacturer Inventory Report

BIA-03 · 127 · Reference Identification · Required · Numeric (N0) · Min 1 Max 9

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.

Note: Sequential Reference Number

BIA-04 · 373 · Date · Required · Date (DT) · CCYYMMDD format

Date expressed as CCYYMMDD

• BIA04 identifies the date of the inquiry/advice that is transferred.

060 Heading > REF

REF Reference Identification

Required · Max use 12

To specify identifying information

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

Code qualifying the Reference Identification

• IA: Internal Vendor Number

REF-02 · 127 · Reference Identification · Required · String (AN) · Min 1 Max 10

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

FLX assigned vendor number. Max size: 10

Detail

LIN Loop Required Max >1

010 Detail > LIN Loop > LIN

LIN Item Identification

Required · Max use 1

To specify basic item identification data

If either Product/Service ID Qualifier (LIN-04) or Product/Service ID (LIN-05) is present, then the other is required

If either Product/Service ID Qualifier (LIN-06) or Product/Service ID (LIN-07) is present, then the other is required

LIN-02 · 235 · Product/Service ID Qualifier · Required · Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

• LIN02 must be "SK" for SKU. Flxpoint uses SKU as the primary identifier.

• SK: Stock Keeping Unit (SKU)

LIN-03 · 234 · Product/Service ID · Required · String (AN) · Min 1 Max 48

Identifying number for a product or service

LIN03 will serve as the primary identifier in Flxpoint. Send a SKU here if you wish to receive the SKU in 850s

Exact size: UPC=12, EAN=13 Max size: SKU=30
Must be unique across all items

LIN-04 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

• EN: European Article Number (EAN) (2-5-5-1)
• SK: Stock Keeping Unit (SKU)
• UP: U.P.C. Consumer Package Code (1-5-5-1)

LIN-05 · 234 · Product/Service ID · Optional · String (AN) · Min 1 Max 48

Identifying number for a product or service

LIN-06 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

• EN: European Article Number (EAN) (2-5-5-1)
• SK: Stock Keeping Unit (SKU)
• UP: U.P.C. Consumer Package Code (1-5-5-1)

LIN-07 · 234 · Product/Service ID · Optional · String (AN) · Min 1 Max 48

Identifying number for a product or service

030 Detail > LIN Loop > PID

PID Product/Item Description

Optional · Max use 200

To describe a product or process in coded or free-form format

PID-01 · 349 · Item Description Type · Required · Identifier (ID)

Code indicating the format of a description

• If PID01 equals "F", then PID05 is used. If PID01 equals "S", then PID04 is used. If PID01 equals "X", then both PID04 and PID05 are used.

• F: Free-form

PID-02 · 750 · Product/Process Characteristic Code · Optional · Identifier (ID)

Code identifying the general class of a product or process characteristic

• 08: Product

PID-05 · 352 · Description · Optional · String (AN) · Min 1 Max 80

A free-form description to clarify the related data elements and their content

Freeform product title

110 Detail > LIN Loop > CTP

CTP Pricing Information

Optional · Max use 25

To specify pricing information

CTP-02 · 236 · Price Identifier Code · Required · Identifier (ID)

Code identifying pricing specification

• UCP: Unit cost price
• WHL: Wholesale

CTP-03 · 212 · Unit Price · Required · Decimal number (R) · Min 1 Max 15

Price per unit of product, service, commodity, etc.

• See Figures Appendix for an example detailing the use of CTP03 and CTP04.
• See Figures Appendix for an example detailing the use of CTP03, CTP04 and CTP07.

QTY Loop Required Max >1

320 Detail > LIN Loop > QTY Loop > QTY

QTY Quantity

Required · Max use 1

To specify quantity information

QTY-01 · 673 · Quantity Qualifier · Required · Identifier (ID)

Code specifying the type of quantity

• 33: Quantity Available for Sale (stock quantity)

QTY-02 · 380 · Quantity · Required · Decimal number (R) · Min 1 Max 15

Numeric value of quantity that is available for sale.

QTY-03 · C001 · Composite Unit of Measure · Required Max 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)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

• EA: Each

Summary

020 Summary > SE

SE Transaction Set Trailer

Required · Max 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)

SE-01 · 96 · Number of Included Segments · Required · Numeric (N0) · Min 1 Max 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 4 Max 9

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

GE Functional Group Trailer

Required · Max use 1

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

GE-01 · 97 · Number of Transaction Sets Included · Required · Numeric (N0) · Min 1 Max 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 1 Max 9

Assigned number originated and maintained by the sender

IEA Interchange Control Trailer

Required · Max use 1

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

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

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

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

A control number assigned by the interchange sender