X12 870 Retail Order Status Report

X12 Release 4010

Delimiters

• ~ Segment
• * Element
• > Component

ISA Interchange Control Header

Required · Max use 1

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 10 Max 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 10 Max 10

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

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

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

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

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

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

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

• I: Information
• P: Production Data
• T: Test Data

ISA-16 · I15 · Component Element Separator · Required · String (AN) · Min 1 Max 1

• >: Component Element Separator

GS Functional Group Header

Required · Max use 1

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

• RS: Order Status Information (869, 870)

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

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

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

GS-05 · 337 · Time · Required · Time (TM) · HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

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

GS-07 · 455 · Responsible Agency Code · Required · Identifier (ID) · Min 1 Max 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

010 Heading > ST

ST Transaction Set Header

Required · Max use 1

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

• 870: Order Status Report

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

020 Heading > BSR

BSR Beginning Segment for Order Status Report

Required · Max use 1

BSR-01 · 850 · Status Report Code · Required · Identifier (ID)

• 3: Unsolicited Report

BSR-02 · 847 · Order/Item Code · Required · Identifier (ID)

• PP: Selected Orders - Selected Items

BSR-03 · 127 · Reference Identification · Required · String (AN) · Min 1 Max 30

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

REF Department Number Required Max >1

Variants (all may be used)

Internal Vendor Number

046 Heading > Department Number > REF

REF Reference Identification

Required · Max use 1

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

• DP: Department Number

REF-02 · 127 · Reference Identification · Optional · String (AN) · Min 1 Max 3

REF Internal Vendor Number Required Max >1

Variants (all may be used)

Department Number

046 Heading > Internal Vendor Number > REF

REF Reference Identification

Required · Max use 1

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

• IA: Internal Vendor Number

REF-02 · 127 · Reference Identification · Optional · String (AN) · Min 1 Max 30

N1 Loop Optional Max >1

050 Heading > N1 Loop > N1

N1 Name

Required · Max use 1

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)

• BS: Bill and Ship To

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

• 92: Assigned by Buyer or Buyer's Agent

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

Detail

HL Loop Required Max >1

010 Detail > HL Loop > HL

HL Hierarchical Level

Required · Max use 1

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

HL-03 · 735 · Hierarchical Level Code · Required · Identifier (ID)

• O: Order

HL-04 · 736 · Hierarchical Child Code · Optional · Identifier (ID)

• 1: Additional Subordinate HL Data Segment in This Hierarchical Structure.

020 Detail > HL Loop > PRF

PRF Purchase Order Reference

Required · Max use 1

PRF-01 · 324 · Purchase Order Number · Required · String (AN) · Min 1 Max 22

PRF-02 · 328 · Release Number · Optional · String (AN) · Min 1 Max 30

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

N1 Loop Required Max >1

090 Detail > HL Loop > N1 Loop > N1

N1 Name

Required · Max use 1

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

• MA: Party for whom Item is Ultimately Intended
• ST: Ship To

N1-03 · 66 · Identification Code Qualifier · Required · Identifier (ID)

• 92: Assigned by Buyer or Buyer's Agent

N1-04 · 67 · Identification Code · Required · String (AN) · Min 2 Max 4

HL Loop Required Max >1

010 Detail > HL Loop > HL Loop > HL

HL Hierarchical Level

Required · Max use 1

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

HL-02 · 734 · Hierarchical Parent ID Number · Required · String (AN) · Min 1 Max 12

HL-03 · 735 · Hierarchical Level Code · Required · Identifier (ID)

• I: Item

HL-04 · 736 · Hierarchical Child Code · Optional · Identifier (ID)

• 0: No Subordinate HL Segment in This Hierarchical Structure.

PO1 Loop Required Max >1

150 Detail > HL Loop > HL Loop > PO1 Loop > PO1

PO1 Baseline Item Data

Required · Max use 1

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

If either Product/Service ID Qualifier (PO1-08) or Product/Service ID (PO1-09) is present, then the other is required

If either Product/Service ID Qualifier (PO1-10) or Product/Service ID (PO1-11) is present, then the other is required

PO1-01 · 350 · Assigned Identification · Optional · String (AN) · Min 1 Max 20

PO1-02 · 330 · Quantity Ordered · Required · Decimal number (R) · Min 1 Max 15

PO1-03 · 355 · Unit or Basis for Measurement Code · Required · Identifier (ID)

• CA: Case
• EA: Each
• LB: Pound

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

• CB: Buyer's Catalog Number
• EN: European Article Number (EAN) (2-5-5-1)
• EO: EAN/UCC - 8
• IN: Buyer's Item Number
• UP: U.P.C. Consumer Package Code (1-5-5-1)

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

PO1-08 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

• CB: Buyer's Catalog Number
• EN: European Article Number (EAN) (2-5-5-1)
• EO: EAN/UCC - 8
• IN: Buyer's Item Number
• UP: U.P.C. Consumer Package Code (1-5-5-1)

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

PO1-10 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

• CB: Buyer's Catalog Number
• EN: European Article Number (EAN) (2-5-5-1)
• EO: EAN/UCC - 8
• IN: Buyer's Item Number
• UP: U.P.C. Consumer Package Code (1-5-5-1)

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

ISR Loop Required Max >1

210 Detail > HL Loop > HL Loop > PO1 Loop > ISR Loop > ISR

ISR Item Status Report

Required · Max use 1

ISR-01 · 368 · Shipment/Order Status Code · Required · Identifier (ID)

• CP: Partial Shipment on (Date), Considered No Backorder
• IC: Item Canceled

ISR-02 · 373 · Date · Optional · Date (DT) · CCYYMMDD format

230 Detail > HL Loop > HL Loop > PO1 Loop > ISR Loop > QTY

QTY Quantity

Optional · Max use 4

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

• 01: Discrete Quantity

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

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)

• CA: Case
• EA: Each
• LB: Pound

Summary

010 Summary > CTT

CTT Transaction Totals

Required · Max use 1

CTT-01 · 354 · Number of Line Items · Required · Numeric (N0) · Min 1 Max 6

020 Summary > SE

SE Transaction Set Trailer

Required · Max use 1

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

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

GE Functional Group Trailer

Required · Max use 1

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

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

IEA Interchange Control Trailer

Required · Max use 1

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

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

EDI Samples

Sample 870

ISA*00*          *00*          *ZZ*SENDER         *ZZ*RECEIVER       *231002*2353*U*00401*000000001*0*T*>
GS*RS*SENDERGS*RECEIVERGS*20231002*235331*000000001*X*004010
ST*870*0001
BSR*3*PP*12*20000312
REF*IA*1234567
REF*DP*012
N1*BS**92*0551
HL*1**O
PRF*1234-0456789-1234***20000312
N1*ST**92*0999
HL*2*1*I
PO1*1*99*EA***CB*099090999*UP*999999999999
ISR*CP*20000312
QTY*01*120*EA
CTT*99
SE*14*0001
GE*1*000000001
IEA*1*000000001