867 Vendor Product Transfer and Resale Report
D&H · X12 004010
D&H ’s published 867 specification, rendered as an interactive guide. Expand any segment to see its elements, data types, lengths and accepted codes — then validate your own document against it below.
Specification
29 of 29 segments
HEADING
ST
Transaction Set Header ST
pos 010
Optional
max —
BPT
Beginning Segment For Product Transfer And Resale BPT
D&H Sample Data:
BPT*00*PROD. TRANS. & RESALE - P-O-S*20160226*02
pos 020
Required
max —
CUR
Currency CUR
D&H Sample Data:
CUR*DS*USD
pos 040
Required
max —
DTM
Date Time Reference DTM
D&H Sample Data:
DTM*090*20160129
DTM*091*20160205
pos 050
Required
max 10
N1 Looprequired
N1
Name N1
D&H Usage Notes:
N1 Segment content will vary, depending on the report format (Consolidated vs By-Branch, see Document Notes).
N104 Segment is the D&H Warehouse/Branch Code, for By-Branch Reported or "CONSOLIDATED" for Consolidated Reporting.
The current D&H Warehouse/Branch details can be found on the D&H EDI Documentation Site (www.dandh.com/docs).
D&H Sample Data:
Consolidated Example:
N1*DS*D&H Distributing*92*CONSOLIDATED
By-Branch Example:
N1*DS*D&H Harrisburg*92*01
pos 080
Required
max —
N3
Address Information N3
D&H Sample Data:
N3*909 KATIE COURT*UNION SQUARE IND PK
pos 100
Optional
max 2
N4
Geographic Location N4
D&H Sample Data:
N4*HARRISBURG*PA*17109*US
pos 110
Required
max —
PER Looprequired
PER
Administrative Communications Contact PER
D&H Sample Data:
PER*SH*D&H Distributing*EM*edi@dandh.com*TE*7172368001
pos 130
Required
max —
DETAIL
PTD Looprequired
PTD
Product Transfer And Resale Detail PTD
D&H Sample Data:
PTD*SD
pos 010
Required
max —
REF
D&H Purchase Order # (for Factory Direct orders)variant 1 of 3
D&H Sample Data:
REF*1V*908704L
pos 030
Optional
max 20
REF
Seller's (D&H) Invoice Numbervariant 2 of 3
D&H Sample Data:
REF*IV*1098765432
pos 030
Optional
max 20
REF
Customer/Reseller Order Numbervariant 3 of 3
D&H Sample Data:
REF*PO*A123456
pos 030
Optional
max 20
N1 Looprequired
N1
Name N1
D&H Usage Notes:
For N1*SF, N104 represents the D&H Branch/Warehouse ID Number
The current D&H Warehouse/Branch details can be found on the D&H EDI Documentation Site (www.dandh.com/docs).
For N1*ST and N1*BT, N104 represents the Reseller ID, if enabledBill To, Ship From, and Ship To address loops are reported in all cases. End User information is available with purchasing management approval and setup.
D&H Sample Data:
N1*BT*XX
N1*ST*XX
N1*SF*Harrisburg*92*01
NOTE: Due to security concerns the Bill To/Ship To Customer Names (N102) and IDs (N104) are not provided in the POS report.
pos 050
Required
max —
N3
Address Information N3
D&H Sample Data:
N3*909 KATIE COURT*UNION SQUARE IND PK
pos 070
Optional
max 2
N4
Geographic Location N4
D&H Sample Data:
N4*HARRISBURG*PA*17109*US
pos 080
Required
max —
QTY Looprequired
QTY
Quantity QTY
D&H Sample Data:
Sales Transaction:
QTY*39*1
Return Transaction:
QTY*76*4
pos 110
Required
max —
LIN
Item Identification LIN
D&H Usage Notes:
VP qualifier identifies D&H SKU
D&H Sample Data:
LIN*1*VP*I57552858BLK*MG*I5755-2858BLK*UP*047505999999
LIN*2*VP*I57552858WHT*MG*I5755-2858WHT
pos 120
Required
max —
UIT
Unit Detail UIT
D&H Usage Notes:
RS Resale Price (Distributor cost) reflects the standard cost for D&H to purchase the product from the manufacturer
D&H Sample Data:
UIT*EA*544.16*RS
pos 130
Required
max 12
PID
Product Item Description PID
D&H Sample Data:
PID*F****17.3" AMD A8 7410 8GB 1TB
pos 150
Required
max 200
REF
D&H Assigned Vendor ID Numbervariant 1 of 2
D&H Sample Data:
REF*IA*99999
pos 190
Required
max —
REF
Serial Numbervariant 2 of 2
D&H Sample Data:
REF*SE*SERIAL12345
REF*SE*SERIAL12347
REF*SE*SERIAL12987
pos 190
Optional
max —
DTM
Invoicevariant 1 of 2
D&H Usage Notes:
Invoice Date (003) will be included with all transactions.
D&H Sample Data:
DTM*003*20160226
pos 210
Required
max 10
DTM
Shippedvariant 2 of 2
D&H Usage Notes:
Shipped Date (011) will be included only when the order has shipped prior to the POS report date.
D&H Sample Data:
DTM*011*20160226
pos 210
Optional
max 10
LX Loop
LX
Assigned Number LX
D&H Usage Notes:
For products with vendor rebates
D&H Sample Data:
LX*0001
pos 280
Required
max —
REF
Promotion/Deal Numbervariant 1 of 2
D&H Usage Notes:
Rebate Deal IDs (SPA, Big Deal, SOX, DPA, etc.) are reported in the REF02 and REF03 (PD Qualifier) as described below;
REF02 (PD) - Character length is limited to 30 characters, and displayed whenever PD qualifier is present
REF03 (PD) - Used only when the Rebate Deal ID character length is longer than 30 characters. When used, REF03 contains the entire Rebate Deal ID # (limited to 80 characters)
D&H Sample Data:
Rebate Deal ID length is 30 characters or less
REF*PD*SPA125328
Rebate Deal ID length is greater than 30 characters
REF*PD*AAAAAAAAAABBBBBBBBBBCCCCCCCCCC*AAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDD
pos 290
Optional
max —
REF
Rebate Numbervariant 2 of 2
D&H Usage Notes:
Rebate Amount is reported in the REF02 (RY Qualifier) using a 2-digit explicit decimal
D&H Sample Data:
REF*RY*12.43
REF*RY*7.5
REF*RY*10
REF*RY*.78
pos 290
Optional
max —
DTM
Date Time Reference DTM
D&H Usage Notes:
DTM06 is a concatenated field, with a hyphen "-" separator as follows; [RebateStartDate]-[RebateEndDate]
D&H Sample Data:
DTM*007****RD*07012019-12312022
pos 300
Optional
max —
SUMMARY
CTT Looprequired
CTT
Transaction Totals CTT
D&H Sample Data:
CTT*163
pos 010
Required
max —
SE
Transaction Set Trailer SE
pos 030
Optional
max —
Validate a 867
Paste or upload a document and check it against D&H ’s published rules — segment order and repetition, required elements, field lengths, data types and accepted codes. Nothing is stored.
Go live on D&H ’s 867 in days, not months
Weredi maps this guide to your ERP, runs the test cycle with D&H , and keeps the spec current as it changes.