X12 870 DTC 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)

• 00400: Standard Issued as ANSI X12.5-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)

• 004000: ASC X12 Standards Approved by ANSI in 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)

• PA: Selected Orders - All Items

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

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

BSR-11 · 353 · Transaction Set Purpose Code · Optional · Identifier (ID)

• 00: Original
• 04: Change

045 Heading > DTM

DTM Date/Time Reference

Optional · Max use 10

DTM-01 · 374 · Date/Time Qualifier · Required · Identifier (ID)

• 068: Current Schedule Ship

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

REF Loop Optional Max >1

046 Heading > REF Loop > 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 Bill-to-Party Optional Max 1

Variants (all may be used)

Ship FromShip To

050 Heading > Bill-to-Party > N1

N1 Name

Required · Max use 1

At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required

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)

• BT: Bill-to-Party

N1-02 · 93 · Name · Optional · String (AN) · Min 1 Max 60

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)

5509

070 Heading > Bill-to-Party > N3

N3 Address Information

Optional · Max use 2

N3-01 · 166 · Address Information · Required · String (AN) · Min 1 Max 55

080 Heading > Bill-to-Party > N4

N4 Geographic Location

Optional · Max use 1

N4-01 · 19 · City Name · Optional · String (AN) · Min 2 Max 30

N4-02 · 156 · State or Province Code · Optional · Identifier (ID) · Min 2 Max 2

N4-03 · 116 · Postal Code · Optional · Identifier (ID) · Min 3 Max 15

N4-04 · 26 · Country Code · Optional · Identifier (ID) · Min 2 Max 3

N1 Ship From Optional Max 1

Variants (all may be used)

Bill-to-PartyShip To

050 Heading > Ship From > N1

N1 Name

Required · Max use 1

At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required

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)

• SF: Ship From

N1-02 · 93 · Name · Optional · String (AN) · Min 1 Max 60

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 80

070 Heading > Ship From > N3

N3 Address Information

Optional · Max use 2

N3-01 · 166 · Address Information · Required · String (AN) · Min 1 Max 55

080 Heading > Ship From > N4

N4 Geographic Location

Optional · Max use 1

N4-01 · 19 · City Name · Optional · String (AN) · Min 2 Max 30

N4-02 · 156 · State or Province Code · Optional · Identifier (ID) · Min 2 Max 2

N4-03 · 116 · Postal Code · Optional · Identifier (ID) · Min 3 Max 15

N4-04 · 26 · Country Code · Optional · Identifier (ID) · Min 2 Max 3

N1 Ship To Optional Max 1

Variants (all may be used)

Bill-to-PartyShip From

050 Heading > Ship To > N1

N1 Name

Required · Max use 1

At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required

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)

• ST: Ship To

N1-02 · 93 · Name · Optional · String (AN) · Min 1 Max 60

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)

9999

070 Heading > Ship To > N3

N3 Address Information

Optional · Max use 2

N3-01 · 166 · Address Information · Required · String (AN) · Min 1 Max 55

080 Heading > Ship To > N4

N4 Geographic Location

Optional · Max use 1

N4-01 · 19 · City Name · Optional · String (AN) · Min 2 Max 30

N4-02 · 156 · State or Province Code · Optional · Identifier (ID) · Min 2 Max 2

N4-03 · 116 · Postal Code · Optional · Identifier (ID) · Min 3 Max 15

N4-04 · 26 · Country Code · Optional · Identifier (ID) · Min 2 Max 3

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)

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

020 Detail > HL Loop > PRF

PRF Purchase Order Reference

Optional · Max use 1

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

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

ISR Loop Optional Max >1

030 Detail > HL Loop > ISR Loop > ISR

ISR Item Status Report

Required · Max use 1

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

• ED: Expect to Ship By (Date)

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

ISR-03 · 641 · Status Reason Code · Optional · Identifier (ID) · Min 3 Max 3

PO1 Loop Optional Max >1

150 Detail > 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)

• EA: Each

PO1-04 · 212 · Unit Price · Optional · Decimal number (R) · Min 1 Max 15

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

• 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)

• VN: Vendor's (Seller's) Item Number

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

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

• IN: Buyer's Item Number

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

180 Detail > HL Loop > PO1 Loop > PID

PID Product/Item Description

Optional · Max use 1000

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

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

ISR Loop Optional Max >1

210 Detail > 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)

• ED: Expect to Ship By (Date)

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

ISR-03 · 641 · Status Reason Code · Optional · Identifier (ID) · Min 3 Max 3

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

QTY Quantity

Optional · Max use 4

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

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

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

Summary

010 Summary > CTT

CTT Transaction Totals

Optional · 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