X12 867 Vendor Product Transfer and Resale Report

Beginning Segment for Product Transfer and Resale

Functional Group Header

Transaction Set Header

Administrative Communications Contact

Transaction Set Trailer

Functional Group Trailer

Interchange Control Trailer

IEA

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

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

Reference Identification

Required

String (AN)

Min 1Max 30

—

BPT-03

Date

Required

Date (DT)

CCYYMMDD format

—

BPT-04

755

Report Type Code

Required

Identifier (ID)

—

02: Resale

CUR

040

Heading > CUR

Currency

RequiredMax use 1

—

Usage notes

—

Example

CUR-01

Entity Identifier Code

Required

Identifier (ID)

—

DS: Distributor

CUR-02

100

Currency Code

Required

Identifier (ID)

—

CAD: Canadian Dollar
USD: US Dollar

050

Heading > DTM

Date/Time Reference

RequiredMax use 10

—

Usage notes

—

Example

Date/Time Qualifier

Required

Identifier (ID)

—

090: Report Start
091: Report End

DTM-02

Date

Required

Date (DT)

CCYYMMDD format

—

N1 Loop

RequiredMax >1

080

Heading > N1 Loop > N1

Name

RequiredMax use 1

—

Usage notes

—

Example

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

DS: Distributor

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 > N1 Loop > N3

Address Information

OptionalMax use 2

—

Usage notes

—

Example

N3-01

Address Information

Required

String (AN)

Min 1Max 55

—

N3-02

Address Information

Optional

String (AN)

Min 1Max 55

—

110

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

RequiredMax >1

PER

130

Heading > N1 Loop > PER Loop > PER

Administrative Communications Contact

RequiredMax use 1

—

Usage notes

—

Example

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

Required

Identifier (ID)

—

SH: Shipper Contact

PER-02

Name

Required

String (AN)

Min 1Max 60

—

PER-03

365

Communication Number Qualifier

Required

Identifier (ID)

—

EM: Electronic Mail

PER-04

364

Communication Number

Required

String (AN)

Min 1Max 80

—

PER-05

365

Communication Number Qualifier

Optional

Identifier (ID)

—

TE: Telephone

PER-06

364

Communication Number

Optional

String (AN)

Min 1Max 80

—

PER Loop end

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

REFD&H Purchase Order # (for Factory Direct orders)REFSeller's (D&H) Invoice Number

030

Detail > PTD Loop > REF

Customer/Reseller Order Number

OptionalMax use 20

—

Usage notes

—

Example

Variants (all may be used)

Reference Identification Qualifier

Required

Identifier (ID)

—

PO: Purchase Order Number

Reference Identification

Required

String (AN)

Min 1Max 30

—

REFCustomer/Reseller Order Number REFSeller's (D&H) Invoice Number

030

Detail > PTD Loop > REF

D&H Purchase Order # (for Factory Direct orders)

OptionalMax use 20

—

Usage notes

—

Example

Variants (all may be used)

Reference Identification Qualifier

Required

Identifier (ID)

—

1V: Related Vendor Order Number
—

Reference Identification

Required

String (AN)

Min 1Max 30

—

REFCustomer/Reseller Order Number REFD&H Purchase Order # (for Factory Direct orders)

030

Detail > PTD Loop > REF

Seller's (D&H) Invoice Number

OptionalMax use 20

—

Usage notes

—

Example

Variants (all may be used)

Reference Identification Qualifier

Required

Identifier (ID)

—

IV: Seller's Invoice Number

Reference Identification

Required

String (AN)

Min 1Max 30

—

N1 Loop

RequiredMax >1

050

Detail > PTD Loop > N1 Loop > N1

Name

RequiredMax use 1

—

Usage notes

—

Example

If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

BT: Bill-to-Party
EN: End User
SF: Ship From
ST: Ship To

N1-02

Name

Required

String (AN)

Min 1Max 60

—

N1-03

Identification Code Qualifier

Optional

Identifier (ID)

—

92: Assigned by Buyer or Buyer's Agent

N1-04

Identification Code

Optional

String (AN)

Min 2Max 80

—

070

Detail > PTD Loop > N1 Loop > N3

Address Information

OptionalMax use 2

—

Usage notes

—

Example

N3-01

Address Information

Required

String (AN)

Min 1Max 55

—

N3-02

Address Information

Optional

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

—

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)

—

39: Shipped Quantity
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-06) or Product/Service ID (LIN-07) is present, then the other is required

LIN-01

350

Assigned Identification

Required

String (AN)

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

—

LIN-04

235

Product/Service ID Qualifier

Required

Identifier (ID)

—

MG: Manufacturer's Part Number

LIN-05

234

Product/Service ID

Required

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

RequiredMax use 12

—

Usage notes

—

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)

—

EA: Each

UIT-02

212

Unit Price

Required

Decimal number (R)

Min 1Max 15

—

UIT-03

639

Basis of Unit Price Code

Required

Identifier (ID)

—

RS: Resale Price

PID

150

Detail > PTD Loop > QTY Loop > PID

Product/Item Description

RequiredMax use 200

—

Usage notes

—

Example

PID-01

349

Item Description Type

Required

Identifier (ID)

—

F: Free-form

PID-05

352

Description

Required

String (AN)

Min 1Max 80

—

190

Detail > PTD Loop > QTY Loop > REF

D&H Assigned Vendor ID Number

RequiredMax use >1

—

Usage notes

—

Example

Variants (all may be used)

REFSerial Number

Reference Identification Qualifier

Required

Identifier (ID)

—

IA: Internal Vendor Number

Reference Identification

Required

String (AN)

Min 1Max 30

—

REFD&H Assigned Vendor ID Number

190

Detail > PTD Loop > QTY Loop > REF

Serial Number

OptionalMax use >1

—

Usage notes

—

Example

Variants (all may be used)

Reference Identification Qualifier

Required

Identifier (ID)

—

SE: Serial Number

Reference Identification

Required

String (AN)

Min 1Max 30

—

210

Detail > PTD Loop > QTY Loop > DTM

Invoice

RequiredMax use 10

—

Usage notes

—

Example

Variants (all may be used)

DTMShipped

Date/Time Qualifier

Required

Identifier (ID)

—

003: Invoice

DTM-02

Date

Required

Date (DT)

CCYYMMDD format

—

210

Detail > PTD Loop > QTY Loop > DTM

Shipped

OptionalMax use 10

—

Usage notes

—

Example

Variants (all may be used)

DTMInvoice

Date/Time Qualifier

Required

Identifier (ID)

—

011: Shipped

DTM-02

Date

Required

Date (DT)

CCYYMMDD format

—

LX Loop

OptionalMax >1

280

Detail > PTD Loop > QTY Loop > LX Loop > LX

Assigned Number

RequiredMax use 1

—

Usage notes

—

Example

LX-01

554

Assigned Number

Required

Numeric (N0)

Min 1Max 6

—

290

Detail > PTD Loop > QTY Loop > LX Loop > REF

Promotion/Deal Number

OptionalMax use >1

—

Usage notes

—

Example

Variants (all may be used)

REFRebate Number

At least one of Reference Identification (REF-02) or Description (REF-03) is required

Reference Identification Qualifier

Required

Identifier (ID)

—

PD: Promotion/Deal Number

Reference Identification

Optional

String (AN)

Min 1Max 30

—

REF-03

352

Description

Optional

String (AN)

Min 1Max 80

—

290

Detail > PTD Loop > QTY Loop > LX Loop > REF

Rebate Number

OptionalMax use >1

—

Usage notes

—

Example

Variants (all may be used)

REFPromotion/Deal Number

Reference Identification Qualifier

Required

Identifier (ID)

—

RY: Rebate Number

Reference Identification

Optional

String (AN)

Min 1Max 30

—

300

Detail > PTD Loop > QTY Loop > LX Loop > DTM

Date/Time Reference

OptionalMax use 1

—

Usage notes

—

Example

If either Date Time Period Format Qualifier (DTM-05) or Date Time Period (DTM-06) is present, then the other is required