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)

• 01: Product Transfer
• 02: Resale

N1 Loop Optional Max 200

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 · Optional · Identifier (ID)

• DS: Distributor (CDW sources direct)
• DU: Resale Dealer (CDW sources indirect)

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

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

100 Heading > N1 Loop > N3

N3 Address Information

Optional · Max use 1

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

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

110 Heading > N1 Loop > 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

PER Loop Optional Max >1

130 Heading > N1 Loop > PER Loop > PER

PER Administrative Communications Contact

Required · Max use 1

If either Communication Number Qualifier (PER-03) or Communication Number (PER-04) is present, then the other is required

If either Communication Number Qualifier (PER-05) or Communication Number (PER-06) is present, then the other is required

PER-01 · 366 · Contact Function Code · Optional · Identifier (ID)

• IC: Information Contact

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

PER-03 · 365 · Communication Number Qualifier · Optional · Identifier (ID)

• TE: Telephone

PER-04 · 364 · Communication Number · Optional · String (AN) · Min 1 Max 80

PER-05 · 365 · Communication Number Qualifier · Optional · Identifier (ID)

• EM: Electronic Mail

PER-06 · 364 · Communication Number · Optional · String (AN) · Min 1 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)

• RV: Return to Vendor
• SD: Ship and Debit Sale

N1 Loop Optional Max 200

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 · Optional · Identifier (ID) · Min 2 Max 3

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

N1-03 · 66 · Identification Code Qualifier · Optional · Identifier (ID) · Min 1 Max 2

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

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

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
• 39: Shipped Quantity
• 76: Return Quantity (EU)

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

120 Detail > PTD Loop > QTY Loop > LIN

LIN Item Identification

Required · Max use 1

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

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

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

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

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

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

• BP: CDW’s part number

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

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

• MG: Manufacturer’s Part Number

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

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

• VP: Vendor’s Part Number

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

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

• OE: OEM Part Number

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

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

• UP: U.P.C. Consumer Package Code

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

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

• UR: UCC/EAN-128 Code

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

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

• AC: Aggregation Code (Used to Consolidate Part Families)

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

150 Detail > PTD Loop > QTY Loop > PID

PID Product/Item Description

Optional · Max use 200

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

• F: Free-form

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

190 Detail > PTD Loop > QTY Loop > REF

REF Reference Identification

Optional · Max use >1

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

• IV: Invoice number

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

210 Detail > PTD Loop > QTY Loop > DTM

DTM Date/Time Reference

Optional · Max use 10

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

• 003: Invoice
• 011: Shipped

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

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

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

EDI Samples

CDW Product Transfer and Resale Report

ISA*00*          *00*          *ZZ*SENDER         *ZZ*RECEIVER       *231101*0140*U*00401*000000001*0*T*>
GS*PT*SENDERGS*RECEIVERGS*20231101*014026*000000001*X*004010
ST*867*690001
BPT*00*950501*19950501*02
N1*DU*CDW COMPUTER CENTERS, INC.*1*107627952
N3*200 NORTH MILWAUKEE AVENUE
N4*VERNON HILLS*IL*60061
PER*IC*JOHN DOE*TE*847-465-6000
PTD*SD
N1*BT*XYZ CORP
N4*VERNON HILLS*IL*60061
QTY*39*1
LIN**BP*CDW123*MG*MFG123*VP*VND123*OE*OEM123*UP*885976230442
PID*F****PRODUCT DESCRIPTION
REF*IV*123456
DTM*003*20110101
CTT*1
SE*16*690001
GE*1*000000001
IEA*1*000000001