X12 Release 4010
Delimiters: ~ Segment * Element > Component
Certified January 27, 2024
Cardinal Health - CARDINAL
X12 867 Product Transfer and Resale Report
This Draft Standard for Trial Use contains the format and establishes the data contents of the Product Transfer and Resale Report Transaction Set (867) for use within the context of an Electronic Data Interchange (EDI) environment.
ISA
Interchange Control Header
Required
Max Use 1
To start and identify an interchange of zero or more functional groups and interchange-related control segments
ISA01
I01
Authorization Information Qualifier
Required
ID
Min 2 Max 2
Code to identify the type of information in the Authorization Information
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA02
I02
Authorization Information
Required
alphanumeric (AN)
Min 10 Max 10
Information used for additional identification or authorization of the interchange sender or the data in the interchange; the type of information is set by the Authorization Information Qualifier (I01)
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA03
I03
Security Information Qualifier
Required
ID
Min 2 Max 2
Code to identify the type of information in the Security Information
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA04
I04
Security Information
Required
alphanumeric (AN)
Min 10 Max 10
This is used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier (I03)
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA05
I05
Interchange ID Qualifier
Required
ID
Min 2 Max 2
Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA06
I06
Interchange Sender ID
Required
alphanumeric (AN)
Min 15 Max 15
Identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA07
I05
Interchange ID Qualifier
Required
ID
Min 2 Max 2
Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA08
I07
Interchange Receiver ID
Required
alphanumeric (AN)
Min 15 Max 15
Identification code published by the receiver of the data; When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA09
I08
Interchange Date
Required
date (DT)
Min 6 Max 6
Date of the interchange
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA10
I09
Interchange Time
Required
time (TM)
Min 4 Max 4
Time of the interchange
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA11
I10
Interchange Control Standards Identifier
Required
ID
Min 1 Max 1
Code to identify the agency responsible for the control standard used by the message that is enclosed by the interchange header and trailer
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA12
I11
Interchange Control Version Number
Required
ID
Min 5 Max 5
This version number covers the interchange control segments
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA13
I12
Interchange Control Number
Required
numeric (N0)
Min 9 Max 9
A control number assigned by the interchange sender
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA14
I13
Acknowledgment Requested
Required
ID
Min 1 Max 1
Code sent by the sender to request an interchange acknowledgment (TA1)
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA15
I14
Usage Indicator
Required
ID
Min 1 Max 1
Code to indicate whether data enclosed by this interchange envelope is test, production or information
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ISA16
I15
Component Element Separator
Required
undefined ()
Min 1 Max 1
Type is not applicable; the component element separator is a delimiter and not a data element; this field provides the delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS
Functional Group Header
Required
Max Use 1
To indicate the beginning of a functional group and to provide control information
GS01
479
Functional Identifier Code
Required
ID
Min 2 Max 2
Code identifying a group of application related transaction sets
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS02
142
Application Sender's Code
Required
alphanumeric (AN)
Min 2 Max 15
Code identifying party sending transmission; codes agreed to by trading partners
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS03
124
Application Receiver's Code
Required
alphanumeric (AN)
Min 2 Max 15
Code identifying party receiving transmission. Codes agreed to by trading partners
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS04
373
Date
Required
longDate (DT)
Min 8 Max 8
Date expressed as CCYYMMDD
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS05
337
Time
Required
time (TM)
Min 4 Max 8
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS06
28
Group Control Number
Required
numeric (N0)
Min 1 Max 9
Assigned number originated and maintained by the sender
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS07
455
Responsible Agency Code
Required
ID
Min 1 Max 2
Code used in conjunction with Data Element 480 to identify the issuer of the standard
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
GS08
480
Version / Release / Industry Identifier Code
Required
alphanumeric (AN)
Min 1 Max 12
Code indicating the version, release, subrelease, and industry identifier of the EDI standard being used, including the GS and GE segments; if code in DE455 in GS segment is X, then in DE 480 positions 1-3 are the version number; positions 4-6 are the release and subrelease, level of the version; and positions 7-12 are the industry or trade association identifiers (optionally assigned by user); if code in DE455 in GS segment is T, then other formats are allowed
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
ST
Transaction Set Header
Required
Max Use 1
To indicate the start of a transaction set and to assign a control number
ST01
143
Transaction Set Identifier Code
Required
ID
Min 3 Max 3
Code uniquely identifying a Transaction Set
867
Product Transfer and Resale Report
ST02
329
Transaction Set Control Number
Required
alphanumeric (AN)
Min 4 Max 9
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
BPT
Beginning Segment for Product Transfer and Resale
Required
Max Use 1
To indicate the beginning of the Product Transfer and Resale Report Transaction Set and transmit identifying data
Syntax Notes
If any of BPT05 or BPT06 are present, then all are required.
BPT01
353
Transaction Set Purpose Code
Required
ID
Min 2 Max 2
Code identifying purpose of transaction set
00
Original
BPT02
127
Reference Identification
Optional
alphanumeric (AN)
Min 1 Max 30
Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
BPT03
373
Date
Required
longDate (DT)
Min 8 Max 8
Date expressed as CCYYMMDD
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
BPT04
755
Report Type Code
Optional
ID
Min 2 Max 2
Code indicating the title or contents of a document, report or supporting item
SS
Seller Sales Report
DTM
Date/Time Reference
Optional
Max Use 2
To specify pertinent dates and times
Syntax Notes
At least one of DTM02, DTM03 or DTM05 is required.
If DTM04 is present, then and DTM03 is required.
If any of DTM05 or DTM06 are present, then all are required.
DTM01
374
Date/Time Qualifier
Required
ID
Min 3 Max 3
Code specifying type of date or time, or both date and time
090
Report Start
DTM02
373
Date
Required
longDate (DT)
Min 8 Max 8
Date expressed as CCYYMMDD
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N1 loop
Min Items
Max Loop 2
N1
Name
Required
Max Use 1
To identify a party by type of organization, name, and code
Syntax Notes
At least one of N102 or N103 is required.
If any of N103 or N104 are present, then all are required.
N101
98
Entity Identifier Code
Required
ID
Min 2 Max 3
Code identifying an organizational entity, a physical location, property or an individual
DB
Distributor Branch
N102
93
Name
Optional
alphanumeric (AN)
Min 1 Max 60
Free-form name
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N103
66
Identification Code Qualifier
Optional
ID
Min 1 Max 2
Code designating the system/method of code structure used for Identification Code (67)
11
Drug Enforcement Administration (DEA)
21
Health Industry Number (HIN)
N104
67
Identification Code
Optional
alphanumeric (AN)
Min 2 Max 80
Code identifying a party or other code
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N1
Name
Required
Max Use 1
To identify a party by type of organization, name, and code
Syntax Notes
At least one of N102 or N103 is required.
If any of N103 or N104 are present, then all are required.
N101
98
Entity Identifier Code
Required
ID
Min 2 Max 3
Code identifying an organizational entity, a physical location, property or an individual
SU
Supplier/Manufacturer
N102
93
Name
Optional
alphanumeric (AN)
Min 1 Max 60
Free-form name
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N103
66
Identification Code Qualifier
Optional
ID
Min 1 Max 2
Code designating the system/method of code structure used for Identification Code (67)
11
Drug Enforcement Administration (DEA)
N104
67
Identification Code
Optional
alphanumeric (AN)
Min 2 Max 80
Code identifying a party or other code
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
PTD loop
Required
Min Items
Max Loop undefined
PTD
Product Transfer and Resale Detail
Required
Max Use 1
To indicate the start of detail information relating to the transfer/resale of a product and provide identifying data
Syntax Notes
If any of PTD02 or PTD03 are present, then all are required.
If any of PTD04 or PTD05 are present, then all are required.
PTD01
521
Product Transfer Type Code
Required
ID
Min 2 Max 2
Code identifying the type of product transfer
CR
Credit Rebill
DS
Drop Ship Sale
IB
Interbranch
RU
Return to Usable Inventory
SS
Stock Sale
TD
Transfer for Disposal
PTD04
128
Reference Identification Qualifier
Optional
ID
Min 2 Max 3
Code qualifying the Reference Identification
DI
Distributor Invoice Number – External Sale
92
Internal Cardinal Health Transfer
CT
Contract Number
PTD05
127
Reference Identification
Optional
alphanumeric (AN)
Min 1 Max 30
Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
DTM
Date/Time Reference
Optional
Max Use 10
To specify pertinent dates and times
Syntax Notes
At least one of DTM02, DTM03 or DTM05 is required.
If DTM04 is present, then and DTM03 is required.
If any of DTM05 or DTM06 are present, then all are required.
DTM01
374
Date/Time Qualifier
Required
ID
Min 3 Max 3
Code specifying type of date or time, or both date and time
003
Invoice
DTM02
373
Date
Optional
longDate (DT)
Min 8 Max 8
Date expressed as CCYYMMDD
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
REF
Reference Identification
Optional
Max Use 20
To specify identifying information
Syntax Notes
At least one of REF02 or REF03 is required.
REF01
128
Reference Identification Qualifier
Required
ID
Min 2 Max 3
Code qualifying the Reference Identification
CT
Contract Number
REF02
127
Reference Identification
Optional
alphanumeric (AN)
Min 1 Max 30
Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N1 loop
Optional
Max Loop 5
N1
98
Name
Optional
Min 1 Max 1
Max Use 1
To identify a party by type of organization, name, and code
Syntax Notes
At least one of N102 or N103 is required.
If any of N103 or N104 are present, then all are required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N101
98
Entity Identifier Code
Optional
ID
Min 2 Max 3
Code identifying an organizational entity, a physical location, property or an individual
ST
Ship To
N102
93
Name
Optional
alphanumeric (AN)
Min 1 Max 60
Free-form name
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N103
66
Identification Code Qualifier
Optional
ID
Min 1 Max 2
Code designating the system/method of code structure used for Identification Code (67)
11
Drug Enforcement Administration (DEA)
21
Health Industry Number (HIN)
N104
67
Identification Code
Optional
alphanumeric (AN)
Min 2 Max 80
Code identifying a party or other code
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N3
98
Address Information
Optional
Min 1 Max 1
Max Use 2
To specify the location of the named party
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N301
166
Address Information
Optional
alphanumeric (AN)
Min 1 Max 55
Address information
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N302
166
Address Information
Optional
alphanumeric (AN)
Min 1 Max 55
Address information
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N4
98
Geographic Location
Optional
Min 1 Max 1
Max Use 1
To specify the geographic place of the named party
Syntax Notes
If N406 is present, then and N405 is required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N401
19
City Name
Optional
alphanumeric (AN)
Min 2 Max 30
Free-form text for city name
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N402
156
State or Province Code
Optional
ID
Min 2 Max 2
Code (Standard State/Province) as defined by appropriate government agency
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
N403
116
Postal Code
Optional
ID
Min 3 Max 15
Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
REF
98
Reference Identification
Optional
Min 1 Max 1
Max Use 20
To specify identifying information
Syntax Notes
At least one of REF02 or REF03 is required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
QTY loop
Optional
QTY
98
Quantity
Optional
Min 1 Max 1
Max Use 1
To specify quantity information
Syntax Notes
At least one of QTY02 or QTY04 is required.
oneOrNone
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
QTY01
673
Quantity Qualifier
Optional
ID
Min 2 Max 2
Code specifying the type of quantity
32
Quantity Sold
76
Returns
QTY02
380
Quantity
Optional
decimal (R)
Min 1 Max 15
Numeric value of quantity
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
QTY0301
355
Unit or Basis for Measurement Code
Optional
ID
Min 2 Max 2
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
CA
Case
CT
Carton
EA
Each
LIN
98
Item Identification
Optional
Min 1 Max 1
Max Use 1
To specify basic item identification data
Syntax Notes
If any of LIN04 or LIN05 are present, then all are required.
If any of LIN06 or LIN07 are present, then all are required.
If any of LIN08 or LIN09 are present, then all are required.
If any of LIN10 or LIN11 are present, then all are required.
If any of LIN12 or LIN13 are present, then all are required.
If any of LIN14 or LIN15 are present, then all are required.
If any of LIN16 or LIN17 are present, then all are required.
If any of LIN18 or LIN19 are present, then all are required.
If any of LIN20 or LIN21 are present, then all are required.
If any of LIN22 or LIN23 are present, then all are required.
If any of LIN24 or LIN25 are present, then all are required.
If any of LIN26 or LIN27 are present, then all are required.
If any of LIN28 or LIN29 are present, then all are required.
If any of LIN30 or LIN31 are present, then all are required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
LIN02
235
Product/Service ID Qualifier
Optional
ID
Min 2 Max 2
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
N4
National Drug Code in 5-4-2 Format
LIN03
234
Product/Service ID
Optional
alphanumeric (AN)
Min 1 Max 48
Identifying number for a product or service
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
LIN04
235
Product/Service ID Qualifier
Optional
ID
Min 2 Max 2
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
PI
Purchaser's Item Code
LIN05
234
Product/Service ID
Optional
alphanumeric (AN)
Min 1 Max 48
Identifying number for a product or service
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
LIN06
235
Product/Service ID Qualifier
Optional
ID
Min 2 Max 2
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
MG
Manufacturer's Part Number
LIN07
234
Product/Service ID
Optional
alphanumeric (AN)
Min 1 Max 48
Identifying number for a product or service
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
UIT
98
Unit Detail
Optional
Min 1 Max 1
Max Use 12
To specify item unit data
Syntax Notes
If UIT03 is present, then and UIT02 is required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
UIT0101
355
Unit or Basis for Measurement Code
Optional
ID
Min 2 Max 2
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
CA
Case
CT
Carton
EA
Each
UIT02
212
Unit Price
Optional
decimal (R)
Min 1 Max 17
Price per unit of product, service, commodity, etc.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
UIT03
639
Basis of Unit Price Code
Optional
ID
Min 2 Max 2
Code identifying the type of unit price for an item
WH
Wholesale
AMT
98
Monetary Amount
Optional
Min 1 Max 1
Max Use 12
To indicate the total monetary amount
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
AMT01
522
Amount Qualifier Code
Optional
ID
Min 1 Max 3
Code to qualify amount
1
Line Item Total
AMT02
782
Monetary Amount
Optional
decimal (R)
Min 1 Max 18
Monetary amount
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
PID
98
Product/Item Description
Optional
Min 1 Max 1
Max Use 200
To describe a product or process in coded or free-form format
Syntax Notes
If PID04 is present, then and PID03 is required.
At least one of PID04 or PID05 is required.
If PID07 is present, then and PID03 is required.
If PID08 is present, then and PID04 is required.
If PID09 is present, then and PID05 is required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
PID01
349
Item Description Type
Optional
ID
Min 1 Max 1
Code indicating the format of a description
F
Free-form
PID05
352
Description
Optional
alphanumeric (AN)
Min 1 Max 80
A free-form description to clarify the related data elements and their content
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
REF
98
Reference Identification
Optional
Min 1 Max 1
Max Use 20
To specify identifying information
Syntax Notes
At least one of REF02 or REF03 is required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
DTM
98
Date/Time Reference
Optional
Min 1 Max 1
Max Use 10
To specify pertinent dates and times
Syntax Notes
At least one of DTM02, DTM03 or DTM05 is required.
If DTM04 is present, then and DTM03 is required.
If any of DTM05 or DTM06 are present, then all are required.
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
CTT loop
Min Items
Max Loop 1
CTT
Transaction Totals
Optional
Max Use 1
To transmit a hash total for a specific element in the transaction set
Syntax Notes
If any of CTT03 or CTT04 are present, then all are required.
If any of CTT05 or CTT06 are present, then all are required.
CTT01
354
Number of Line Items
Required
numeric (N0)
Min 1 Max 6
Total number of line items in the transaction set
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
SE
Transaction Set Trailer
Required
Max Use 1
To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
SE01
96
Number of Included Segments
Required
numeric (N0)
Min 1 Max 10
Total number of segments included in a transaction set including ST and SE segments
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here
SE02
329
Transaction Set Control Number
Required
alphanumeric (AN)
Min 4 Max 9
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
123
Description Goes Here
123
Description Goes Here
123
Description Goes Here