ECIA

X12 867 Product Transfer and Resale 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)

• PT: Product Transfer and Resale Report (867)

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)

• 867: Product Transfer and Resale Report

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

020 Heading > BPT

BPT Beginning Segment for Product Transfer and Resale

Required · Max use 1

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

• 00: Original

BPT-02 · 127 · Reference Identification · Required · String (AN) · Min 1 Max 30

BPT-03 · 373 · Date · Required · Date (DT) · CCYYMMDD format

BPT-04 · 755 · Report Type Code · Optional · Identifier (ID)

• 02: Resale

050 Heading > DTM

DTM Period End

Optional · Max use 10

Variants (all may be used)

DTMPeriod Start

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

• 194: Period End

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

050 Heading > DTM

DTM Period Start

Optional · Max use 10

Variants (all may be used)

DTMPeriod End

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

• 193: Period Start

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

060 Heading > REF

REF Reference Identification

Optional · Max use 12

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

• PO: Purchase Order Number

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

N1 Loop Required Max >1

080 Heading > N1 Loop > 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)

• DB: Distributor Branch
• DS: Distributor

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

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

• 1: D-U-N-S Number, Dun & Bradstreet
• 9: D-U-N-S+4, D-U-N-S Number with Four Character Suffix
• 91: Assigned by Seller or Seller's Agent
• 92: Assigned by Buyer or Buyer's Agent

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

Detail

PTD Loop Required Max >1

010 Detail > PTD Loop > PTD

PTD Product Transfer and Resale Detail

Required · Max use 1

PTD-01 · 521 · Product Transfer Type Code · Required · Identifier (ID)

• SD: Ship and Debit Sale
• SS: Stock Sale

N1 Loop Required Max >1

050 Detail > PTD Loop > N1 Loop > 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)

• EC: Exchanger
• EN: End User
• MA: Party for whom Item is Ultimately Intended

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

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

• 1: D-U-N-S Number, Dun & Bradstreet
• 9: D-U-N-S+4, D-U-N-S Number with Four Character Suffix
• 91: Assigned by Seller or Seller's Agent
• 92: Assigned by Buyer or Buyer's Agent

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

070 Detail > PTD Loop > N1 Loop > N3

N3 Address Information

Optional · Max use 2

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

N3-02 · 166 · Address Information · Optional · String (AN) · Min 1 Max 55

080 Detail > PTD Loop > N1 Loop > N4

N4 Geographic Location

Required · Max use 1

N4-01 · 19 · City Name · Required · 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 · Required · Identifier (ID) · Min 2 Max 3

QTY Loop Required Max >1

110 Detail > PTD Loop > QTY Loop > QTY

QTY Quantity

Required · Max use 1

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

• 32: Quantity Sold

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)

• EA: Each

120 Detail > PTD Loop > QTY Loop > LIN

LIN Item Identification

Required · Max use 1

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

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

• VP: Vendor's (Seller's) Part Number

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

130 Detail > PTD Loop > QTY Loop > UIT

UIT Unit Detail

Required · Max use 12

UIT-01 · 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)

• EA: Each

UIT-02 · 212 · Unit Price · Required · Decimal number (R) · Min 1 Max 15

UIT-03 · 639 · Basis of Unit Price Code · Required · Identifier (ID)

• LE: Catalog Price per Each
• QE: Quoted Price per Each
• RE: Retail Price per Each

190 Detail > PTD Loop > QTY Loop > REF

REF Agreement Number or Authorization to Meet Competition Number

Optional · Max use >1

Variants (all may be used)

REFDistributor Invoice Number

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

• AH: Agreement Number
• AU: Authorization to Meet Competition Number

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

190 Detail > PTD Loop > QTY Loop > REF

REF Distributor Invoice Number

Required · Max use >1

Variants (all may be used)

REFAgreement Number or Authorization to Meet Competition Number

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

• DI: Distributor Invoice Number

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

210 Detail > PTD Loop > QTY Loop > DTM

DTM Date/Time Reference

Required · Max use 10

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

• 003: Invoice
• 011: Shipped

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

220 Detail > PTD Loop > QTY Loop > CUR

CUR Currency

Required · Max use 1

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

• SE: Selling Party

CUR-02 · 100 · Currency Code · Required · Identifier (ID)

• CAD: Canadian Dollar
• MXN: Mexican Peso
• USD: US Dollar

Summary

CTT Loop Required Max >1

010 Summary > CTT Loop > CTT

CTT Transaction Totals

Required · Max use 1

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

CTT-02 · 347 · Hash Total · Required · Decimal number (R) · Min 1 Max 10

030 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