H-E-B
/
Product Transfer and Resale Report
  • Specification
  • EDI Inspector
Stedi maintains this guide based on public documentation from H-E-B. Contact H-E-B for official EDI specifications. To report any errors in this guide, please contact us.
Go to Stedi Network
H-E-B logo

X12 867 Product Transfer and Resale Report

X12 Release 4010
Delimiters
  • ~ Segment
  • * Element
  • > Component
EDI sample
  • Sample
View the latest version of this implementation guide as an interactive webpage
https://www.stedi.com/app/guides/view/h-e-b/product-transfer-and-resale-report/01H66JCAX7G5JK83AJ9SHEHTMT
Powered by
Build EDI implementation guides at stedi.com
Overview
ISA
-
Interchange Control Header
Max use 1
Required
GS
-
Functional Group Header
Max use 1
Required
heading
ST
010
Transaction Set Header
Max use 1
Required
BPT
020
Beginning Segment for Product Transfer and Resale
Max use 1
Required
DTM
050
Report End
Max use 10
Optional
DTM
050
Report Start
Max use 10
Optional
Distributor Branch
detail
PTD Loop
GE
-
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
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
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
Required
Date (DT)
CCYYMMDD format
Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
GS-06
28
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

ST
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
Example
BPT-01
353
Transaction Set Purpose Code
Required
Identifier (ID)
00
Original
Required
Date (DT)
CCYYMMDD format
BPT-04
755
Report Type Code
Optional
Identifier (ID)
SS
Seller Sales Report
BPT-10
786
Security Level Code
Optional
Identifier (ID)
Min 2Max 2
DTM
050
Heading > DTM

Report End

OptionalMax use 10
Usage notes
Example
Variants (all may be used)
DTMReport Start
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
091
Report End
Optional
Date (DT)
CCYYMMDD format
DTM
050
Heading > DTM

Report Start

OptionalMax use 10
Usage notes
Example
Variants (all may be used)
DTMReport End
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
090
Report Start
Optional
Date (DT)
CCYYMMDD format
N1 Distributor Branch
OptionalMax >1
Variants (all may be used)
Supplier/Manufacturer
N1
080
Heading > Distributor Branch > N1

Name

RequiredMax use 1
Usage notes
Example
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)
DB
Distributor Branch
Optional
String (AN)
Min 1Max 60
Usage notes
N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)
11
Drug Enforcement Administration (DEA)
N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80
Usage notes
N1 Distributor Branch end
N1 Supplier/Manufacturer
OptionalMax >1
Variants (all may be used)
Distributor Branch
N1
080
Heading > Supplier/Manufacturer > N1

Name

RequiredMax use 1
Example
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)
SU
Supplier/Manufacturer
Optional
String (AN)
Min 1Max 60
Usage notes
N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)
11
Drug Enforcement Administration (DEA)
N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80
Usage notes
N1 Supplier/Manufacturer 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
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)
RP
Return of List Price
SS
Stock Sale
PTD-04
128
Reference Identification Qualifier
Optional
Identifier (ID)
DI
Distributor Invoice Number
PTD-05
127
Reference Identification
Optional
String (AN)
Min 1Max 30
Usage notes
DTM
020
Detail > PTD Loop > DTM

Invoice

OptionalMax use 10
Usage notes
Example
Variants (all may be used)
DTMOrderDTMShipped
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
003
Invoice
Optional
Date (DT)
CCYYMMDD format
DTM
020
Detail > PTD Loop > DTM

Order

OptionalMax use 10
Usage notes
Example
Variants (all may be used)
DTMInvoiceDTMShipped
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
938
Order
Optional
Date (DT)
CCYYMMDD format
DTM
020
Detail > PTD Loop > DTM

Shipped

OptionalMax use 10
Usage notes
Example
Variants (all may be used)
DTMInvoiceDTMOrder
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
011
Shipped
Optional
Date (DT)
CCYYMMDD format
N1 Loop
RequiredMax >1
N1
050
Detail > PTD Loop > N1 Loop > N1

Name

RequiredMax use 1
Usage notes
Example
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)
ST
Ship To
Optional
String (AN)
Min 1Max 60
N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)
11
Drug Enforcement Administration (DEA)
N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80
Usage notes
N3
070
Detail > PTD Loop > N1 Loop > N3

Address Information

OptionalMax use 2
Usage notes
Example
N3-01
166
Address Information
Required
String (AN)
Min 1Max 55
N3-02
166
Address Information
Optional
String (AN)
Min 1Max 55
N4
080
Detail > PTD Loop > N1 Loop > N4

Geographic Location

OptionalMax use 1
Usage notes
Example
N4-01
19
City Name
Optional
String (AN)
Min 2Max 30
N4-02
156
State or Province Code
Optional
Identifier (ID)
Min 2Max 2
N4-03
116
Postal Code
Optional
Identifier (ID)
Min 3Max 15
N4-04
26
Country Code
Optional
Identifier (ID)
Min 2Max 3
SII Loop
OptionalMax >1
SII
105
Detail > PTD Loop > N1 Loop > SII Loop > SII

Sales Item Information

RequiredMax use 1
Example
SII-01
235
Product/Service ID Qualifier
Required
Identifier (ID)
Min 2Max 2
SII-02
234
Product/Service ID
Required
String (AN)
Min 1Max 48
SII-03
380
Quantity
Required
Decimal number (R)
Min 1Max 15
SII-04
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)
Min 2Max 2
C001-02
1018
Exponent
Optional
Decimal number (R)
Min 1Max 15
C001-03
649
Multiplier
Optional
Decimal number (R)
Min 1Max 10
C001-04
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
Min 2Max 2
C001-05
1018
Exponent
Optional
Decimal number (R)
Min 1Max 15
C001-06
649
Multiplier
Optional
Decimal number (R)
Min 1Max 10
C001-07
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
Min 2Max 2
C001-08
1018
Exponent
Optional
Decimal number (R)
Min 1Max 15
C001-09
649
Multiplier
Optional
Decimal number (R)
Min 1Max 10
C001-10
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
Min 2Max 2
C001-11
1018
Exponent
Optional
Decimal number (R)
Min 1Max 15
C001-12
649
Multiplier
Optional
Decimal number (R)
Min 1Max 10
C001-13
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
Min 2Max 2
C001-14
1018
Exponent
Optional
Decimal number (R)
Min 1Max 15
C001-15
649
Multiplier
Optional
Decimal number (R)
Min 1Max 10
SII-05
212
Unit Price
Optional
Decimal number (R)
Min 1Max 15
SII-06
212
Unit Price
Optional
Decimal number (R)
Min 1Max 15
SII-07
782
Monetary Amount
Optional
Decimal number (R)
Min 1Max 15
N9
107
Detail > PTD Loop > N1 Loop > SII Loop > N9

Reference Identification

OptionalMax use 1
Example
At least one of Reference Identification (N9-02) or Free-form Description (N9-03) is required
If Time Code (N9-06) is present, then Time (N9-05) is required
N9-01
128
Reference Identification Qualifier
Required
Identifier (ID)
Min 2Max 3
N9-02
127
Reference Identification
Optional
String (AN)
Min 1Max 30
N9-03
369
Free-form Description
Optional
String (AN)
Min 1Max 45
Optional
Date (DT)
CCYYMMDD format
Optional
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
N9-06
623
Time Code
Optional
Identifier (ID)
Min 2Max 2
N9-07
C040
Reference Identifier
OptionalMax use 1
To identify one or more reference numbers or identification numbers as specified by the Reference Qualifier
If either Reference Identification Qualifier (C040-03) or Reference Identification (C040-04) is present, then the other is required
If either Reference Identification Qualifier (C040-05) or Reference Identification (C040-06) is present, then the other is required
C040-01
128
Reference Identification Qualifier
Required
Identifier (ID)
Min 2Max 3
C040-02
127
Reference Identification
Required
String (AN)
Min 1Max 30
C040-03
128
Reference Identification Qualifier
Optional
Identifier (ID)
Min 2Max 3
C040-04
127
Reference Identification
Optional
String (AN)
Min 1Max 30
C040-05
128
Reference Identification Qualifier
Optional
Identifier (ID)
Min 2Max 3
C040-06
127
Reference Identification
Optional
String (AN)
Min 1Max 30
SII Loop end
N1 Loop end
QTY Loop
OptionalMax >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
QTY-02
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
QTY-03
C001
Composite Unit of Measure
OptionalMax 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)
CA
Case
CT
Carton
EA
Each
LIN
120
Detail > PTD Loop > QTY Loop > LIN

Item Identification

OptionalMax 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-01
350
Assigned Identification
Optional
String (AN)
Min 1Max 20
LIN-02
235
Product/Service ID Qualifier
Required
Identifier (ID)
N4
National Drug Code in 5-4-2 Format
LIN-03
234
Product/Service ID
Required
String (AN)
Min 1Max 48
LIN-04
235
Product/Service ID Qualifier
Optional
Identifier (ID)
PI
Purchaser's Item Code
LIN-05
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
LIN-06
235
Product/Service ID Qualifier
Optional
Identifier (ID)
MG
Manufacturer's Part Number
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)
CA
Case
CT
Carton
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)
WH
Wholesale
AMT
140
Detail > PTD Loop > QTY Loop > AMT

Monetary Amount

OptionalMax use 12
Usage notes
Example
AMT-01
522
Amount Qualifier Code
Required
Identifier (ID)
TT
Total Transaction Amount
AMT-02
782
Monetary Amount
Required
Decimal number (R)
Min 1Max 15
AMT-03
478
Credit/Debit Flag Code
Optional
Identifier (ID)
Min 1Max 1
PID
150
Detail > PTD Loop > QTY Loop > PID

Product/Item Description

OptionalMax use 200
Usage notes
Example
PID-01
349
Item Description Type
Required
Identifier (ID)
F
Free-form
PID-05
352
Description
Optional
String (AN)
Min 1Max 80
REF
190
Detail > PTD Loop > QTY Loop > REF

Reference Identification

OptionalMax use >1
Usage notes
Example
At least one of Reference Identification (REF-02) or Description (REF-03) is required
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
DI
Distributor Invoice Number
REF-02
127
Reference Identification
Optional
String (AN)
Min 1Max 30
Usage notes
REF-03
352
Description
Optional
String (AN)
Min 1Max 80
Usage notes
DTM
210
Detail > PTD Loop > QTY Loop > DTM

Date/Time Reference

OptionalMax use 10
Usage notes
Example
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
003
Invoice
Optional
Date (DT)
CCYYMMDD format
QTY Loop end
PTD Loop end
Detail end

Summary

CTT Loop
OptionalMax >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
SE
030
Summary > SE

Transaction Set Trailer

RequiredMax use 1
Example
SE-01
96
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
97
Number of Transaction Sets Included
Required
Numeric (N0)
Min 1Max 6
GE-02
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

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 *231106*1427*U*00401*000000001*0*T*>
GS*PT*SENDERGS*RECEIVERGS*20231106*142737*000000001*X*004010
ST*867*540001
BPT*00**20100426*SS
DTM*090*20100420
DTM*091*20100425
N1*DB*H-E-B*11*RH0277067
N1*SU*ABC & CO, INC (EFT)*11*AA2223331
PTD*SS***DI*6158
DTM*938*20100418
DTM*003*20100418
DTM*011*20100419
N1*ST*TRADING PARTNER INFO*11*BH9673941
N3* TRADING PARTNER INFO
N4*AUSTIN*TX*39419*USA
QTY*32*1*EA
LIN**N4*AAAAAAAAAAA*PI*0012028*MG*CCCCCCC
UIT*EA*1537.849*WH
AMT*TT*1537.849
PID*F****ZOSTAVAX VIAL
REF*DI*6158*ZOSTAVAX VIAL
DTM*003*20100418
PTD*SS***DI*1659
DTM*938*20100419
DTM*003*20100419
DTM*011*20100420
N1*ST* TRADING PARTNER INFO *11*BH7514462
N3* TRADING PARTNER INFO
N4*SAN ANTONIO*TX*44621*USA
QTY*32*1*EA
LIN**N4*AAAAAAAAAAA*PI*0012028*MG*CCCCCCC
UIT*EA*1537.849*WH
AMT*TT*1537.849
PID*F****ZOSTAVAX VIAL
REF*DI*1659*ZOSTAVAX VIAL
DTM*003*20100419
PTD*SS***DI*1829
DTM*938*20100419
DTM*003*20100419
DTM*011*20100420
N1*ST* TRADING PARTNER INFO *11*BH7489063
N3*TRADING PARTNER INFO
N4*GATESVILLE*TX*90638*USA
QTY*32*1*EA
LIN**N4*AAAAAAAAAAA*PI*0012028*MG*CCCCCCC
UIT*EA*1537.849*WH
AMT*TT*1537.849
PID*F****ZOSTAVAX VIAL
REF*DI*1829*ZOSTAVAX VIAL
DTM*003*20100419
PTD*SS***DI*7184
DTM*938*20100420
DTM*003*20100420
DTM*011*20100420
N1*ST*TRADING PARTNER INFO*11*BH7866405
N3*TRADING PARTNER INFO
N4*FREDERICKSBURG*TX*64054*USA
QTY*32*1*EA
LIN**N4*AAAAAAAAAAA*PI*0012028*MG*CCCCCCC
UIT*EA*1537.849*WH
AMT*TT*1537.849
PID*F****ZOSTAVAX VIAL
REF*DI*7184*ZOSTAVAX VIAL
DTM*003*20100420
PTD*SS***DI*7267
DTM*938*20100420
DTM*003*20100420
DTM*011*20100421
N1*ST* TRADING PARTNER INFO *11*BH7487780
N3* TRADING PARTNER INFO
N4*SAN ANTONIO*TX*77803*USA
QTY*32*1*EA
LIN**N4*AAAAAAAAAAA*PI*0012028*MG*CCCCCCC
UIT*EA*1537.849*WH
AMT*TT*1537.849
PID*F****ZOSTAVAX VIAL
REF*DI*7267*ZOSTAVAX VIAL
DTM*003*20100420
PTD*SS***DI*8322
DTM*938*20100422
DTM*003*20100422
DTM*011*20100423
N1*ST*TRADING PARTNER INFO*11*BH7488718
N3* TRADING PARTNER INFO
N4*SAN ANTONIO*TX*87187*USA
QTY*32*1*EA
LIN**N4*AAAAAAAAAAA*PI*0012028*MG*CCCCCCC
UIT*EA*1537.849*WH
AMT*TT*1537.849
PID*F****ZOSTAVAX VIAL
REF*DI*8322*ZOSTAVAX VIAL
DTM*003*20100422
CTT*6
SE*92*540001
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.