To start and identify an interchange of zero or more functional groups and interchange-related control segments
Border States X12 867 Product Transfer and Resale Report
X12 867 (Product Transfer and Resale Report) is the EDI transaction exchanged between Border States (Border States Electric Supply) and its trading partners. Stacksync handles full compliance, mapping, and real-time delivery.
- Segments
- 19
- Loops
- 4
- X12 867
- All partners ↗
Transaction context
Where 867 Product Transfer and Resale Report fits on Border States Electric Supply
- Border States channels
- 1 of 1
- Trading partners
- 10
- Channels
- 11
1 of Border States's 1 channel carries 867
partners across the Stacksync network trade 867
channels network-wide carry 867
The 867 reports what happened to product after the initial sale: resales to end customers (sell-through or point-of-sale data), transfers between company locations, and customer returns. Manufacturers and suppliers use it for visibility into channel sales and inventory movement, and report lines can carry purchase order and contract identifiers that tie reported activity back to specific agreements. A reseller, typically a distributor, wholesaler, or retailer, sends the 867 upstream to the manufacturer or supplier whose product it moved, although the standard allows either party to originate it.
When it fires: A distributor or retailer closes a reporting period and transmits an 867 detailing units sold, transferred between locations, or returned during that period.
- Product identifiers on reported lines that do not match the manufacturer's item catalog, so resale lines cannot be matched and processed automatically.
- Missing or incomplete ship-from, ship-to, or end-customer identification, which prevents the manufacturer from attributing reported sales to the right locations or accounts.
- Quantity or unit-of-measure inconsistencies between reported resales and the distributor's purchases, producing reconciliation disputes.
- Transaction type codes that fail to distinguish sales, transfers, and returns, distorting downstream demand reporting.
Specification summary
X12 867 Product Transfer and Resale Report at the element level
The X12 867 specification defines 30 segments carrying 90 data elements, 50 of which are mandatory.
- Segments
- 30
- Data elements
- 90
- Mandatory elements
- 50
| Segment | Elements | Mandatory |
|---|---|---|
| BPT | 4 | 2 |
| DTM | 2 | 1 |
| REF | 2 | 1 |
| N1 | 4 | 1 |
| N3 | 2 | 1 |
| PTD | 3 | 1 |
| N2 | 1 | 1 |
| QTY | 2 | 1 |
| LIN | 11 | 2 |
- Transaction Set Purpose Code
- Date
- Date/Time Qualifier
- Reference Identification Qualifier
- Entity Identifier Code
- Address Information
- Product Transfer Type Code
- Name
Full segment guideline — 19 segments 4 loops · X12 867 Product Transfer and Resale Report
To indicate the beginning of a functional group and to provide control information
To indicate the start of a transaction set and to assign a control number
To indicate the beginning of the Product Transfer and Resale Report Transaction Set and transmit identifying data
To specify pertinent dates and times
To identify a party by type of organization, name, and code
To specify the location of the named party
To specify the geographic place of the named party
To indicate the start of detail information relating to the transfer/resale of a product and provide identifying data
To transmit a hash total for a specific element in the transaction set
To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
To identify a person or office to whom administrative communications should be directed
To specify quantity information
To specify basic item identification data
To specify item unit data
To indicate the total monetary amount
To describe a product or process in coded or free-form format
To specify identifying information
To specify the currency (dollars, pounds, francs, etc.) used in a transaction
Trading partners
6+ trading partners.
And every channel covered.
We connect to every major retailer, distributor, and 3PL on the EDI network. Type to search the directory, or browse the full catalogue.
Border States Border States Electric Supply EDI 867 FAQ
Common questions about 867 Product Transfer and Resale Report on the Border States Electric Supply channel.
What is X12 867 Product Transfer and Resale Report?
Does Border States Border States Electric Supply require 867 for trading partners?
How fast can I integrate Border States 867 with Stacksync?
Which documents accompany 867 on Border States Electric Supply?
Ready to automate your Border States EDI?
Most teams go live in days, not months. Talk to our team and we'll walk you through your specific setup.