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

X12 867 Product Transfer and Resale Report

X12 Release 4010

—

Delimiters

~ Segment
* Element
> Component

EDI samples

None included

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

https://www.stedi.com/app/guides/view/sears/product-transfer-and-resale-report/01H4NCZP4HA6QW3XYQNFB7XE4D

Build EDI implementation guides at stedi.com

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)

—

SM: Shipping Manifests

REF

060

Heading > REF

Reference Identification

RequiredMax use 1

—

Example

REF-01

128

Reference Identification Qualifier

Required

Identifier (ID)

—

Usage notes

—

DP: Department Number

REF-02

127

Reference Identification

Required

String (AN)

—

Usage notes

—

098: Department number for repair parts

Heading end

Detail

PTD Loop

RequiredMax >1

PTD

010

Detail > PTD Loop > PTD

Product Transfer and Resale Detail

RequiredMax use 1

—

Example

If either Reference Identification Qualifier (PTD-04) or Reference Identification (PTD-05) is present, then the other is required

PTD-01

521

Product Transfer Type Code

Required

Identifier (ID)

—

DS: Drop Ship Sale
SS: Stock Sale
SU: Summary

PTD-04

128

Reference Identification Qualifier

Optional

Identifier (ID)

—

PO: Purchase Order Number

PTD-05

127

Reference Identification

Optional

String (AN)

Min 1Max 30

—

Usage notes

—

DTM

020

Detail > PTD Loop > DTM

Date/Time Reference

RequiredMax use 1

—

Usage notes

—

Example

DTM-01

374

Date/Time Qualifier

Required

Identifier (ID)

—

011: Shipped

DTM-02

373

Date

Required

Date (DT)

CCYYMMDD format

—

REF

030

Detail > PTD Loop > REF

Reference Identification

RequiredMax use 3

—

Usage notes

—

Example

REF-01

128

Reference Identification Qualifier

Required

Identifier (ID)

—

19: Division Identifier
MR: Merchandise Type Code
ST: Store Number

REF-02

127

Reference Identification

Required

String (AN)

Min 1Max 30

—

Usage notes

—

QTY Loop

RequiredMax >1

QTY

110

Detail > PTD Loop > QTY Loop > QTY

Quantity

RequiredMax use 1

—

Example

QTY-01

673

Quantity Qualifier

Required

Identifier (ID)

—

39: Shipped Quantity
46: Total transactions

QTY-02

380

Quantity

Required

Decimal number (R)

Min 1Max 15

—

LIN

120

Detail > PTD Loop > QTY Loop > LIN

Item Identification

OptionalMax use 1

—

Example

LIN-02

235

Product/Service ID Qualifier

Required

Identifier (ID)

—

PN: Company Part Number

LIN-03

234

Product/Service ID

Required

String (AN)

Min 1Max 48

—

Usage notes

—

UIT

130

Detail > PTD Loop > QTY Loop > UIT

Unit Detail

RequiredMax use 1

—

Example

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)

—

M4: Monetary Value

UIT-02

212

Unit Price

Required

Decimal number (R)

Min 1Max 15

—

UIT-03

639

Basis of Unit Price Code

Required

Identifier (ID)

—

RT: Retail

AMT

140

Detail > PTD Loop > QTY Loop > AMT

Monetary Amount

RequiredMax use 1

—

Usage notes

—

Example

AMT-01

522

Amount Qualifier Code

Required

Identifier (ID)

—

1: Line Item Total
2: Batch Total

AMT-02

782

Monetary Amount

Required

Decimal number (R)

Min 1Max 15

—

REF

190

Detail > PTD Loop > QTY Loop > REF

Reference Identification

OptionalMax use 4

—

Example

REF-01

128

Reference Identification Qualifier

Required

Identifier (ID)

—

08: Carrier Assigned Package Identification Number
CR: Customer Reference Number
PL: Price List Number
SCA: Standard Carrier Alpha Code (SCAC)

REF-02

127

Reference Identification

Required

String (AN)

Min 1Max 30

—

Usage notes

—

QTY Loop end

PTD Loop end

Detail end

Summary

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

—

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.