X12
Inbound

Sysco Corporation X12 867 Product Transfer and Resale Report

Sysco Corporation (via iTrade Network)
The EDI 867 provides point-of-sale and product movement data from Sysco Corporation to suppliers. It includes units sold, store-level detail, and inventory movement — enabling demand planning and sales analysis.
25segments
6loops
6mandatory

Schema Reference

25 segments · X12 867 Product Transfer and Resale Report

ISA ISA Interchange Control Header
Mandatory Max: 1
ISA01 Authorization Information Qualifier
M ID 2-2
ISA02 Authorization Information
M AN 10-10
ISA03 Security Information Qualifier
M ID 2-2
ISA04 Security Information
M AN 10-10
ISA05 Interchange ID Qualifier
M ID 2-2
ISA06 Interchange Sender ID
M AN 15-15
ISA07 Interchange ID Qualifier
M ID 2-2
ISA08 Interchange Receiver ID
M AN 15-15
ISA09 Interchange Date
M DT 6-6
ISA10 Interchange Time
M TM 4-4
ISA11 Interchange Control Standards Identifier
M ID 1-1
ISA12 Interchange Control Version Number
M ID 5-5
ISA13 Interchange Control Number
M N0 9-9
ISA14 Acknowledgment Requested
M ID 1-1
ISA15 Usage Indicator
M ID 1-1
GS GS Functional Group Header
Mandatory Max: 1
GS01 Functional Identifier Code
M ID 2-2
GS02 Application Sender's Code
M AN 2-15
GS03 Application Receiver's Code
M AN 2-15
GS04 Date
M DT 8-8
GS05 Time
M TM 4-8
GS06 Group Control Number
M N0 1-9
GS07 Responsible Agency Code
M ID 1-2
GS08 Version / Release / Industry Identifier Code
M AN 1-12
ST Transaction Set Header
Mandatory Max: 1
ST01 Transaction Set Identifier Code
M ID 3-3
ST02 Transaction Set Control Number
M AN 4-9
BPT Beginning Segment for Product Transfer and Resale
Mandatory Max: 1
BPT01 Transaction Set Purpose Code
M ID 2-2
BPT02 Reference Identification
O AN 1-30
BPT03 Date
M DT 8-8
BPT04 Report Type Code
O ID 2-2
BPT09 Reference Identification
O AN 1-30
DTM Date/Time Reference
Optional Max: 10
DTM01 Date/Time Qualifier
M ID 3-3
DTM02 Date
C DT 8-8
REF Reference Identification
Optional Max: 12
REF01 Reference Identification Qualifier
M ID 2-3
REF02 Reference Identification
C AN 1-30
REF03 Description
C AN 1-80
N1 Loop Repeat: 5
N1 Name
Optional Max: 1
N101 Entity Identifier Code
M ID 2-3
N102 Name
C AN 1-60
N103 Identification Code Qualifier
C ID 1-2
N104 Identification Code
C AN 2-80
N3 Address Information
Optional Max: 2
N301 Address Information
M AN 1-55
N302 Address Information
O AN 1-55
N4 Geographic Location
Optional Max: 1
N401 City Name
O AN 2-30
N402 State or Province Code
O ID 2-2
N403 Postal Code
O ID 3-15
N404 Country Code
O ID 2-3
PER Loop
PER Administrative Communications Contact
Optional Max: 1
PER01 Contact Function Code
M ID 2-2
PER02 Name
O AN 1-60
PER03 Communication Number Qualifier
C ID 2-2
PER04 Communication Number
C AN 1-80
PTD Loop Repeat: 5
PTD Product Transfer and Resale Detail
Mandatory Max: 1
PTD01 Product Transfer Type Code
M ID 2-2
N1 Loop Repeat: 5
N1 Name
Optional Max: 1
N101 Entity Identifier Code
M ID 2-3
N102 Name
C AN 1-60
N103 Identification Code Qualifier
C ID 1-2
N104 Identification Code
C AN 2-80
N3 Address Information
Optional Max: 2
N301 Address Information
M AN 1-55
N302 Address Information
O AN 1-55
N4 Geographic Location
Optional Max: 1
N401 City Name
O AN 2-30
N402 State or Province Code
O ID 2-2
N403 Postal Code
O ID 3-15
N404 Country Code
O ID 2-3
QTY Loop
QTY Quantity
Optional Max: 1
QTY01 Quantity Qualifier
M ID 2-2
QTY02 Quantity
C R 1-15
LIN Item Identification
Optional Max: 1
LIN01 Assigned Identification
O AN 1-20
LIN02 Product/Service ID Qualifier
M ID 2-2
LIN03 Product/Service ID
M AN 1-48
LIN04 Product/Service ID Qualifier
C ID 2-2
LIN05 Product/Service ID
C AN 1-48
LIN06 Product/Service ID Qualifier
C ID 2-2
LIN07 Product/Service ID
C AN 1-48
LIN08 Product/Service ID Qualifier
C ID 2-2
LIN09 Product/Service ID
C AN 1-48
LIN10 Product/Service ID Qualifier
C ID 2-2
LIN11 Product/Service ID
C AN 1-48
PO4 Item Physical Details
Optional Max: 1
PO401 Pack
O N0 1-6
PO405 Weight Qualifier
O ID 1-2
PO406 Gross Weight per Pack
C R 1-9
PO407 Unit or Basis for Measurement Code
C ID 2-2
PO408 Gross Volume per Pack
C R 1-9
PO409 Unit or Basis for Measurement Code
C ID 2-2
PO410 Length
C R 1-8
PO411 Width
C R 1-8
PO412 Height
C R 1-8
PO413 Unit or Basis for Measurement Code
C ID 2-2
UIT Unit Detail
Optional Max: 12
UIT02 Unit Price
C R 1-17
UIT03 Basis of Unit Price Code
O ID 2-2
AMT Monetary Amount
Optional Max: 12
AMT01 Amount Qualifier Code
M ID 1-3
AMT02 Monetary Amount
M R 1-18
PID Product/Item Description
Optional Max: 200
PID01 Item Description Type
M ID 1-1
PID05 Description
C AN 1-80
REF Reference Identification
Optional Max: 12
REF01 Reference Identification Qualifier
M ID 2-3
REF02 Reference Identification
C AN 1-30
REF03 Description
C AN 1-80
DTM Date/Time Reference
Optional Max: 10
DTM01 Date/Time Qualifier
M ID 3-3
DTM02 Date
C DT 8-8
CTT Loop Repeat: 1
CTT Transaction Totals
Optional Max: 1
CTT01 Number of Line Items
M N0 1-6
CTT02 Hash Total
O R 1-10
CTT05 Volume
C R 1-8
CTT06 Unit or Basis for Measurement Code
C ID 2-2
AMT Monetary Amount
Optional Max: 12
AMT01 Amount Qualifier Code
M ID 1-3
AMT02 Monetary Amount
M R 1-18
SE Transaction Set Trailer
Mandatory Max: 1
SE01 Number of Included Segments
M N0 1-10
SE02 Transaction Set Control Number
M AN 4-9
How It Works

Automating Sysco Corporation EDI 867

Stacksync validates, transforms, and delivers your 867 transactions automatically — so your team can focus on operations, not EDI compliance.

Validate
Transform
Route
Monitor
Stacksync syncs Sysco Corporation 867 POS and product movement data to your analytics or planning system — giving you store-level sales visibility for better demand forecasting and replenishment.

Sysco Corporation EDI 867 FAQ

Common questions about 867 Product Transfer and Resale Report transactions with Sysco Corporation.

What is a Sysco Corporation EDI 867 Product Transfer and Resale Report?

The Sysco Corporation EDI 867 Product Transfer and Resale Report is an X12 transaction set used to exchange Product Transfer and Resale Report data electronically between trading partners. As a inbound document, it standardizes the communication of Product Transfer and Resale Report information between Sysco Corporation and their suppliers, carriers, or partners. Stacksync processes Sysco Corporation 867 transactions automatically, parsing the X12 segments and mapping them to the corresponding records in your ERP, WMS, or database. This eliminates manual data entry, reduces errors, and ensures your systems stay in sync with Sysco Corporation's requirements in real time.

How does Stacksync automate Sysco Corporation EDI 867 Product Transfer and Resale Report transactions?

Stacksync handles Sysco Corporation EDI 867 Product Transfer and Resale Report transactions through an automated pipeline: receive the X12 document, validate the envelope and segment structure, map fields to your system's schema, and sync the data in real time. For inbound 867 transactions, Stacksync either generates the document from your system's data or processes incoming documents and routes them to the correct records. The platform includes built-in compliance validation so every Sysco Corporation 867 document meets their specific formatting requirements before transmission or after receipt.

What are common Sysco Corporation EDI 867 errors and how do I fix them?

Common errors in Sysco Corporation EDI 867 Product Transfer and Resale Report transactions include missing mandatory segments, invalid qualifier codes, incorrect date or time formats, and data values exceeding maximum field lengths. Reference number mismatches between related documents (e.g., PO numbers that don't match) also cause rejections. Stacksync validates Sysco Corporation 867 documents against known requirements before transmission and after receipt, catching errors proactively. When issues occur, the platform provides human-readable error descriptions with the specific segment and element that failed, rather than raw X12 error codes.

How long does it take to set up Sysco Corporation EDI 867 with Stacksync?

Most Sysco Corporation EDI 867 Product Transfer and Resale Report integrations with Stacksync go live within 3 to 5 business days. The setup involves authenticating your EDI connection (AS2, SFTP, or VAN), configuring field mappings between Sysco Corporation's 867 format and your system, running test transactions, and completing Sysco Corporation's certification process if required. Stacksync includes pre-built mappings for Sysco Corporation's most common 867 configurations, which accelerates the setup. Your team can monitor the integration from a single dashboard without managing EDI infrastructure directly.

Can I customize Sysco Corporation EDI 867 field mappings in Stacksync?

Yes. Stacksync provides a visual field mapping tool that lets you define exactly how Sysco Corporation EDI 867 segments and elements map to your system's fields. You can set data transformations (date format conversion, code translation tables), conditional routing rules, and default values for optional fields. The mappings are version-controlled, so changes can be reviewed and rolled back if needed. If Sysco Corporation updates their 867 specification, Stacksync highlights the affected mappings and suggests adjustments, ensuring your integration stays compliant without a full reconfiguration.

Ready to automate Sysco Corporation EDI?

a blue checkmark icon
POC from integration engineers
a blue checkmark icon
No-code EDI setup
a blue checkmark icon
Real-time compliance monitoring
a blue checkmark icon
White-glove onboarding