X12 867 Product Transfer & Resale

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 · Optional · String (AN) · Min 1 Max 30

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

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

• CR: Letter of Credit
• IV: Invoice

050 Heading > DTM

DTM Date/Time Reference

Optional · Max use 10

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

• 004: Purchase Order
• 035: Delivered

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

060 Heading > REF

REF Reference Identification Affiliation Number

Optional · Max use 1

Variants (all may be used)

REFReference Identification Others

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

• 4P: Affiliation Number

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

REF-03 · 352 · Description · Optional · String (AN) · Min 1 Max 80

060 Heading > REF

REF Reference Identification Others

Optional · Max use 12

Variants (all may be used)

REFReference Identification Affiliation Number

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

• CM: Buyer's Credit Memo
• DL: Seller's Debit Memo
• F8: Original Reference Number
• IV: Seller's Invoice Number
• PO: Purchase Order Number
• VN: Vendor Order Number

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

N1 Loop Optional Max 5

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)

• BT: Bill-to-Party
• ST: Ship To

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

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

• 91: Assigned by Seller or Seller's Agent

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

100 Heading > 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

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

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

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)

• SU: Summary

030 Detail > PTD Loop > REF

REF Reference Identification

Optional · Max use 20

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

• SL: Sales/Territory Code

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

QTY Loop Optional Max >1

110 Detail > PTD Loop > QTY Loop > QTY

QTY Quantity

Required · Max use 1

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

• 39: Shipped Quantity

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)

• BG: Bag
• CA: Case
• DR: Drum
• EA: Each
• GA: Gallon
• PA: Pail
• TE: Tote

120 Detail > PTD Loop > QTY Loop > LIN

LIN Item Identification

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

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

• UA: U.P.C./EAN Case Code (2-5-5)
• UK: U.P.C./EAN Shipping Container Code (1-2-5-5-1)

LIN-03 · 234 · Product/Service ID · Required · 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)

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

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

130 Detail > PTD Loop > QTY Loop > UIT

UIT Unit Detail

Optional · Max use 12

If Basis of Unit Price Code (UIT-03) is present, then Unit Price (UIT-02) is required

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)

• BG: Bag
• CA: Case
• DR: Drum
• EA: Each
• GA: Gallon
• LB: Pound
• PA: Pail
• TE: Tote

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

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

• NT: Net

140 Detail > PTD Loop > QTY Loop > AMT

AMT Monetary Amount

Optional · Max use 12

AMT-01 · 522 · Amount Qualifier Code · Required · Identifier (ID)

• 1: Line Item Total

AMT-02 · 782 · Monetary Amount · Required · Decimal number (R) · Min 1 Max 15

AMT-03 · 478 · Credit/Debit Flag Code · Optional · Identifier (ID)

• C: Credit
• D: Debit

141 Detail > PTD Loop > QTY Loop > ITA

ITA Allowance, Charge or Service

Optional · Max use 10

ITA-01 · 248 · Allowance or Charge Indicator · Required · Identifier (ID)

• P: Promotion

ITA-04 · 331 · Allowance or Charge Method of Handling Code · Required · Identifier (ID)

• 02: Off Invoice

ITA-06 · 359 · Allowance or Charge Rate · Optional · Decimal number (R) · Min 1 Max 15

ITA-07 · 360 · Allowance or Charge Total Amount · Optional · Numeric (N2) · Min 1 Max 15

150 Detail > PTD Loop > QTY Loop > PID

PID Product/Item Description

Optional · Max use 200

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

• F: Free-form

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

160 Detail > PTD Loop > QTY Loop > MEA

MEA Measurements

Optional · Max use 40

MEA-01 · 737 · Measurement Reference ID Code · Optional · Identifier (ID)

• WT: Weights

MEA-02 · 738 · Measurement Qualifier · Optional · Identifier (ID)

• G: Gross Weight
• N: Actual Net Weight

MEA-03 · 739 · Measurement Value · Optional · Decimal number (R) · Min 1 Max 15

MEA-04 · 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)

• KG: Kilogram
• LB: Pound

220 Detail > PTD Loop > QTY Loop > CUR

CUR Currency

Optional · Max use 1

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

• BY: Buying Party (Purchaser)

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

• CAD: Canadian Dollar
• USD: US Dollar

Summary

CTT Loop Optional 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

020 Summary > CTT Loop > AMT

AMT Monetary Amount

Optional · Max use 12

AMT-01 · 522 · Amount Qualifier Code · Required · Identifier (ID)

• 5: Total Invoice Amount

AMT-02 · 782 · Monetary Amount · Required · Decimal number (R) · Min 1 Max 15

AMT-03 · 478 · Credit/Debit Flag Code · Optional · Identifier (ID)

• C: Credit
• D: Debit

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

Sample from DOT Foods 1

ST*867*000000001~ 
BPT*00*3600067*20050704*IV~ 
DTM*004*20050629~ 
DTM*035*20050704~ 
REF*PO*083304~ 
REF*VN*1104501~ 
REF*4P*004*UNIPRO~ 
REF*IV*3600067~ 
N1*BT*ABC CUSTOMER*91*001234000~ 
N3*1000 MAIN ST~ 
N4*YOUR CITY*IL*623530000*US~ 
N1*ST*ABC CUSTOMER*91*001234000~ 
N3*1000 MAIN ST~ 
N4*YOUR CITY*IL*623530000*US~ 
PTD*SU~ 
REF*SL*99~ 
QTY*39*2*CA~ 
LIN**UK*10023456005195*MG*57744*VN*200700~ 
UIT*CA*42.82*NT~ 
AMT*1*85.64~ 
PID*F****ABC CLEAN-GP AL PPS 707 4-1 GA~ 
MEA*WT*N*70*LB~ 
MEA*WT*G*76*LB~ 
CUR*BY*USD~ 
PTD*SU~ 
REF*SL*210600~ 
QTY*39*3*CA~ 
LIN**UK*10023456008374*MG*837*VN*406597~ 
UIT*CA*22.44*NT~ 
AMT*1*67.32~ 
PID*F****ABC FUE-LAMP LIQ WAX PCRT 1-36 CNT~ 
MEA*WT*N*33*LB~ 
MEA*WT*G*33*LB~ 
CUR*BY*USD~ 
CTT*2~ 
AMT*5*152.96~ 
SE*37*000000001~ 

Sample from DOT Foods 2

ST*867*000000001~ 
BPT*00*1663175*20191101*CR~ 
DTM*004*20190923~ 
DTM*035*20190923~ 
REF*PO*N A~ 
REF*VN*3770624~ 
REF*4P*000*INDEPENDENT FOODSERVICE~ 
REF*CM*1663175~ 
REF*F8*1023440~
N1*BT*ABC COMPANY*91*123456000~ 
N3*1 MAPLE AVE~ 
N4*YOUR TOWN*IL*12345*US~ 
N1*ST*ABC COMPANY*91*123456000~ 
N3*1 MAPLE AVE~ 
N4*YOUR TOWN*Il*12345*US~ 
PTD*SU~ 
REF*SL*OPEN~ 
QTY*39*-9*CA~ 
LIN**UK*00123456009876*MG*A210-5678*VN*123456~ 
UIT*CA*-192.24*NT~ 
AMT*1*-192.24*C~ 
PID*F****ABC 8.25" B STRW POLW 10-300 EA~ 
MEA*WT*N*-79.65*LB~ 
MEA*WT*G*-79.65*LB~ 
CUR*BY*USD~ 
CTT*1~ 
AMT*5*-192.24*C~ 
SE*28*000000001~

Sample from DOT Foods 3

ST*867*000000001~ 
BPT*00*1663108*20191101*CR~ 
DTM*004*20191015~ 
DTM*035*20191015~ 
REF*PO*N A~ 
REF*VN*3950154~ 
REF*4P*005*SYSCO~ 
REF*DL*1663108~ 
REF*F8*9118757~
N1*BT*ABC CUSTOMER*91*123456000~ 
N3*500 JACKSON AVE~ 
N4*MY TOWN*NY*111110000*US~ 
N1*ST*ABC CUSTOMER*91*123456000~ 
N3*500 JACKSON AVE~ 
N4*MY TOWN*NY*111110000*US~ 
PTD*SU~ 
REF*SL*OPEN~ 
QTY*39*9*CA~ 
LIN**UK*10012345119601*MG*11000-12345*VN*396263~ 
UIT*CA*284.4*NT~ 
AMT*1*284.40*D~ 
PID*F****ABC SNPK HNYNT CHERO CERE 70-.81 OZ~ 
MEA*WT*N*31.86*LB~ 
MEA*WT*G*61.2*LB~ 
CUR*BY*USD~ 
CTT*1~ 
AMT*5*284.40*D~ 
SE*28*000000001~ 

Sample from DOT Foods 4

ST*867*000000001~ 
BPT*00*1677144*20191105*IV~ 
DTM*004*20191030~ 
DTM*035*20191104~ 
REF*PO*27978AR~ 
REF*VN*3897613~ 
REF*4P*019*GOLBON~ 
REF*IV*1677144~ 
N1*BT*ABC CUSTOMER*91*123456000~ 
N3*1000 COMMERCE COURT~ 
N4*MY TOWN*AZ*876540000*US~ 
N1*ST*ABC CUSTOMER LLC*91*123456001~ 
N3*1000 COMMERCE CT~ 
N4*MY TOWN*AZ*876540000*US~ 
PTD*SU~ 
REF*SL*OPEN~ 
QTY*39*5*CA~ 
LIN**UK*00012345177281*MG*74747-17728*VN*460690~ 
UIT*CA*18.8*NT~ 
AMT*1*94.00~ 
ITA*P***02**0.19*95~ 
PID*F****ABC YCY OG RAS & PCH W RF 48-4 OZ~ 
MEA*WT*N*60*LB~ 
MEA*WT*G*66.1*LB~ 
CUR*BY*USD~ 
CTT*1~ 
AMT*5*94.00~ 
SE*28*000000001~