Stedi maintains this guide based on public documentation from AT&T. Contact AT&T for official EDI specifications. To report any errors in this guide, please contact us.

X12 867 Product Transfer and Resale Report

X12 Release 4010Revised

Nov 20, 2023, 4:09 AM

—

Delimiters

~ Segment
* Element
> Component

EDI sample

—

Sample

View the latest version of this implementation guide as an interactive webpage

https://portal.stedi.com/app/guides/view/at-t/product-transfer-and-resale-report/01H2WZWCSJ21G3W0H7MJMCDZJB

Build EDI implementation guides at stedi.com

Overview

ISA

Interchange Control Header

Max use 1

Required

Functional Group Header

Transaction Set Header

Beginning Segment for Product Transfer and Resale

Product Transfer and Resale Detail

Additional Name Information

Administrative Communications Contact

Seller's Invoice Number

Administrative Communications Contact

Transaction Set Trailer

Max use 1

Required

Functional Group Trailer

Max use 1

Required

IEA

Interchange Control Trailer

Max use 1

Required

ISA

Interchange Control Header

RequiredMax use 1

—

Example

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

—

ISA-05

I05

Interchange ID Qualifier

Required

Identifier (ID)

Min 2Max 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 15Max 15

—

ISA-07

I05

Interchange ID Qualifier

Required

Identifier (ID)

Min 2Max 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 15Max 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 9Max 9

—

ISA-14

I13

Acknowledgment Requested

Required

Identifier (ID)

Min 1Max 1

—

0: No Acknowledgment Requested
1: Interchange Acknowledgment Requested

ISA-15

I14

Usage Indicator

Required

Identifier (ID)

Min 1Max 1

—

I: Information
P: Production Data
T: Test Data

ISA-16

I15

Component Element Separator

Required

String (AN)

Min 1Max 1

—

>: Component Element Separator

Functional Group Header

RequiredMax use 1

—

Example

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 2Max 15

—

GS-03

124

Application Receiver's Code

Required

String (AN)

Min 2Max 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

Group Control Number

Required

Numeric (N0)

Min 1Max 9

—

GS-07

455

Responsible Agency Code

Required

Identifier (ID)

Min 1Max 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

Transaction Set Header

RequiredMax use 1

—

Example

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 4Max 9

—

BPT

020

Heading > BPT

Beginning Segment for Product Transfer and Resale

RequiredMax use 1

—

Usage notes

—

Example

BPT-01

353

Transaction Set Purpose Code

Required

Identifier (ID)

—

00: Original

BPT-02

127

Reference Identification

Required

String (AN)

Min 1Max 30

—

BPT-03

373

Date

Required

Date (DT)

CCYYMMDD format

—

BPT-04

755

Report Type Code

Required

Identifier (ID)

—

01: Product Transfer
—
02: Resale
—

N1 Resale Dealer

RequiredMax >1

Variants (all may be used)

Store or Warehouse

080

Heading > Resale Dealer > N1

Name

RequiredMax use 1

—

Usage notes

—

Example

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

DU: Resale Dealer

N1-02

Name

Required

String (AN)

Min 1Max 60

—

N1-03

Identification Code Qualifier

Required

Identifier (ID)

—

94: Code assigned by the organization that is the ultimate destination of the transaction set

N1-04

Identification Code

Required

String (AN)

Min 2Max 80

—

N1 Resale Dealer end

N1 Store or Warehouse

RequiredMax >1

Variants (all may be used)

Resale Dealer

080

Heading > Store or Warehouse > N1

Name

RequiredMax use 1

—

Usage notes

—

Example

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

SN: Store
WH: Warehouse

N1-02

Name

Required

String (AN)

Min 1Max 60

—

N1-03

Identification Code Qualifier

Required

Identifier (ID)

—

92: Assigned by Buyer or Buyer's Agent

N1-04

Identification Code

Required

String (AN)

Min 2Max 80

—

100

Heading > Store or Warehouse > N3

Address Information

RequiredMax use 2

—

Usage notes

—

Example

N3-01

166

Address Information

Required

String (AN)

Min 1Max 55

—

110

Heading > Store or Warehouse > N4

Geographic Location

RequiredMax use 1

—

Usage notes

—

Example

N4-01

City Name

Required

String (AN)

Min 2Max 30

—

N4-02

156

State or Province Code

Required

Identifier (ID)

Min 2Max 2

—

N4-03

116

Postal Code

Required

Identifier (ID)

Min 3Max 15

—

N4-04

Country Code

Required

Identifier (ID)

Min 2Max 3

—

N1 Store or Warehouse end

Heading end

Detail

PTD Loop

RequiredMax >1

PTD

010

Detail > PTD Loop > PTD

Product Transfer and Resale Detail

RequiredMax use 1

—

Usage notes

—

Example

PTD-01

521

Product Transfer Type Code

Required

Identifier (ID)

—

SD: Ship and Debit Sale

N1 Loop

OptionalMax >1

Usage notes

—

050

Detail > PTD Loop > N1 Loop > N1

Name

RequiredMax use 1

—

Usage notes

—

Example

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

EN: End User
ST: Ship To

N1-02

Name

Required

String (AN)

Min 1Max 60

—

N1-03

Identification Code Qualifier

Required

Identifier (ID)

—

92: Assigned by Buyer or Buyer's Agent

N1-04

Identification Code

Required

String (AN)

Min 2Max 80

—

060

Detail > PTD Loop > N1 Loop > N2

Additional Name Information

OptionalMax use 2

—

Usage notes

—

Example

N2-01

Name

Required

String (AN)

Min 1Max 60

—

070

Detail > PTD Loop > N1 Loop > N3

Address Information

RequiredMax use 2

—

Usage notes

—

Example

N3-01

166

Address Information

Required

String (AN)

Min 1Max 55

—

080

Detail > PTD Loop > N1 Loop > N4

Geographic Location

RequiredMax use 1

—

Usage notes

—

Example

N4-01

City Name

Required

String (AN)

Min 2Max 30

—

N4-02

156

State or Province Code

Required

Identifier (ID)

Min 2Max 2

—

N4-03

116

Postal Code

Required

Identifier (ID)

Min 3Max 15

—

N4-04

Country Code

Required

Identifier (ID)

Min 2Max 3

—

PER

100

Detail > PTD Loop > N1 Loop > PER

Administrative Communications Contact

OptionalMax use 3

—

Usage notes

—

Example

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

PER-01

366

Contact Function Code

Required

Identifier (ID)

—

IC: Information Contact

PER-02

Name

Optional

String (AN)

Min 1Max 60

—

PER-03

365

Communication Number Qualifier

Optional

Identifier (ID)

—

TE: Telephone

PER-04

364

Communication Number

Optional

String (AN)

Min 1Max 80

—

N1 Loop end

QTY Loop

RequiredMax >1

QTY

110

Detail > PTD Loop > QTY Loop > QTY

Quantity

RequiredMax use 1

—

Usage notes

—

Example

QTY-01

673

Quantity Qualifier

Required

Identifier (ID)

—

32: Quantity Sold
76: Returns

QTY-02

380

Quantity

Required

Decimal number (R)

Min 1Max 15

—

LIN

120

Detail > PTD Loop > QTY Loop > LIN

Item Identification

RequiredMax use 1

—

Usage notes

—

Example

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)

—

MG: Manufacturer's Part Number

LIN-03

234

Product/Service ID

Required

String (AN)

Min 1Max 48

—

LIN-04

235

Product/Service ID Qualifier

Optional

Identifier (ID)

—

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

LIN-05

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

—

LIN-06

235

Product/Service ID Qualifier

Optional

Identifier (ID)

—

UP: U.P.C. Consumer Package Code (1-5-5-1)

LIN-07

234

Product/Service ID

Optional

String (AN)

Min 1Max 48

—

UIT

130

Detail > PTD Loop > QTY Loop > UIT

Unit Detail

OptionalMax use 12

—

Usage notes

—

Example

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

UIT-01

C001

Composite Unit of Measure

RequiredMax 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

Optional

Decimal number (R)

Min 1Max 15

—

UIT-03

639

Basis of Unit Price Code

Optional

Identifier (ID)

—

CP: Current Price (Subject to Change)

REF

190

Detail > PTD Loop > QTY Loop > REF

Seller's Invoice Number

RequiredMax use >1

—

Usage notes

—

Example

Variants (all may be used)

REFSerial Number

REF-01

128

Reference Identification Qualifier

Required

Identifier (ID)

—

IV: Seller's Invoice Number

REF-02

127

Reference Identification

Required

String (AN)

Min 1Max 30

—

REF

190

Detail > PTD Loop > QTY Loop > REF

Serial Number

RequiredMax use >1

—

Usage notes

—

Example

Variants (all may be used)

REFSeller's Invoice Number

REF-01

128

Reference Identification Qualifier

Required

Identifier (ID)

—

SE: Serial Number

REF-02

127

Reference Identification

Required

String (AN)

Min 1Max 30

—

PER

200

Detail > PTD Loop > QTY Loop > PER

Administrative Communications Contact

OptionalMax use 3

—

Usage notes

—

Example

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

PER-01

366

Contact Function Code

Required

Identifier (ID)

—

IC: Information Contact

PER-02

Name

Optional

String (AN)

Min 1Max 60

—

PER-03

365

Communication Number Qualifier

Optional

Identifier (ID)

—

TE: Telephone

PER-04

364

Communication Number

Optional

String (AN)

Min 1Max 80

—

DTM

210

Detail > PTD Loop > QTY Loop > DTM

Date/Time Reference

RequiredMax use 10

—

Usage notes

—

Example

DTM-01

374

Date/Time Qualifier

Required

Identifier (ID)

—

003: Invoice

DTM-02

373

Date

Required

Date (DT)

CCYYMMDD format

—

QTY Loop end

PTD Loop end

Detail end

Summary

CTT Loop

RequiredMax >1

CTT

010

Summary > CTT Loop > CTT

Transaction Totals

RequiredMax use 1

—

Usage notes

—

Example

CTT-01

354

Number of Line Items

Required

Numeric (N0)

Min 1Max 6

—

CTT Loop end

030

Summary > SE

Transaction Set Trailer

RequiredMax use 1

—

Example

SE-01

Number of Included Segments

Required

Numeric (N0)

Min 1Max 10

—

SE-02

329

Transaction Set Control Number

Required

Numeric (N)

Min 4Max 9

—

Summary end

Functional Group Trailer

RequiredMax use 1

—

Example

GE-01

Number of Transaction Sets Included

Required

Numeric (N0)

Min 1Max 6

—

GE-02

Group Control Number

Required

Numeric (N0)

Min 1Max 9

—

IEA

Interchange Control Trailer

RequiredMax use 1

—

Example

IEA-01

I16

Number of Included Functional Groups

Required

Numeric (N0)

Min 1Max 5

—

IEA-02

I12

Interchange Control Number

Required

Numeric (N0)

Min 9Max 9

—

EDI Samples

Sample

ISA*00* *00* *ZZ*SENDER *ZZ*RECEIVER *231120*0409*U*00401*000000001*0*T*>~
GS*PT*SENDERGS*RECEIVERGS*20231120*040905*000000001*X*004010~
ST*867*0001~
BPT*00*242*20070101*02~
N1*DU*AT&T MOBILITY*94*261802~
N1*SN*STORE 123456*92*123456~
N3*1234 STOREFRONT ROAD~
N3*SUITE 123~
N4*ATLANTA*GA*30303*US~
PTD*SD~
N1*ST*National Retailer*92*987654~
N2*Additional Name~
N3*1234 RETAIL ROAD~
N3*WAREHOUSE 123~
N4*ATLANTA*GA*30303*US~
PER*IC*Contact Name*TE*408-123-4567 x999~
QTY*32*1~
LIN**MG*RG1100VIA*VP*12345*UP*123456789012~
UIT*EA*12150*CP~
REF*IV*1234567890123~
REF*SE*123456789012345~
PER*IC*Contact Name*TE*408-123-4567 x999~
DTM*003*20070101~
CTT*1~
SE*23*0001~
GE*1*000000001~
IEA*1*000000001~

Stedi is a registered trademark of Stedi, Inc. All names, logos, and brands of third parties listed on this page are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.