Walgreens
/
Receiving/Invoice Variance Notification (Combined Guide) for Direct Store Delivery (DSD)
  • Specification
  • EDI Inspector
Stedi maintains this guide based on public documentation from Walgreens. Contact Walgreens for official EDI specifications. To report any errors in this guide, please contact us.
Go to Stedi Network
Walgreens logo

X12 861 Receiving/Invoice Variance Notification (Combined Guide) for Direct Store Delivery (DSD)

X12 Release 4010
Delimiters
  • ~ Segment
  • * Element
  • > Component
EDI samples
  • None included
View the latest version of this implementation guide as an interactive webpage
https://www.stedi.com/app/guides/view/walgreens/receivinginvoice-variance-notification-combined-guide-for-direct-store-delivery-dsd/01H40WZETATG2AR2ZVBRM03EBQ
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
BRA
020
Beginning Segment for Receiving Advice or Acceptance Certificate
Max use 1
Required
REF
050
Reference Identification Internal Vendor Number
Max use 1
Required
REF
050
Reference Identification Invoice Number
Max use 1
Optional
DTM
070
Date/Time Reference Invoice date
Max use 1
Optional
DTM
070
Date/Time Reference Posted Date
Max use 1
Required
PRF
080
Purchase Order Reference
Max use 25
Required
N1 Loop
detail
RCD 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)
RC
Receiving Advice/Acceptance Certificate (861)
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)
861
Receiving Advice/Acceptance Certificate
ST-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9
BRA
020
Heading > BRA

Beginning Segment for Receiving Advice or Acceptance Certificate

RequiredMax use 1
Example
BRA-01
127
Reference Identification
Required
String (AN)
Min 1Max 30
Usage notes
Required
Date (DT)
CCYYMMDD format
Usage notes
BRA-03
353
Transaction Set Purpose Code
Required
Identifier (ID)
Usage notes
00
Original
01
Cancellation
5C
Chargeable Resubmission
BRA-04
962
Receiving Advice or Acceptance Certificate Type Code
Required
Identifier (ID)
2
Post Receipt Advice
REF
050
Heading > REF

Reference Identification Internal Vendor Number

RequiredMax use 1
Example
Variants (all may be used)
REFReference Identification Invoice Number
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
IA
Internal Vendor Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 30
Usage notes
REF
050
Heading > REF

Reference Identification Invoice Number

OptionalMax use 1
Usage notes
Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)
IK
Invoice Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 30
Usage notes
DTM
070
Heading > DTM

Date/Time Reference Invoice date

OptionalMax use 1
Example
Variants (all may be used)
DTMDate/Time Reference Posted Date
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
003
Invoice
Required
Date (DT)
CCYYMMDD format
DTM
070
Heading > DTM

Date/Time Reference Posted Date

RequiredMax use 1
Usage notes
Example
Variants (all may be used)
DTMDate/Time Reference Invoice date
DTM-01
374
Date/Time Qualifier
Required
Identifier (ID)
809
Posted
Required
Date (DT)
CCYYMMDD format
Usage notes
PRF
080
Heading > PRF

Purchase Order Reference

RequiredMax use 25
Example
PRF-01
324
Purchase Order Number
Required
String (AN)
Min 1Max 22
Usage notes
Optional
Date (DT)
CCYYMMDD format
Usage notes
N1 Loop
RequiredMax 1
N1
130
Heading > N1 Loop > N1

Name

RequiredMax use 1
Example
N1-01
98
Entity Identifier Code
Required
Identifier (ID)
SN
Store
N1-03
66
Identification Code Qualifier
Required
Identifier (ID)
92
Assigned by Buyer or Buyer's Agent
N1-04
67
Identification Code
Required
String (AN)
Min 2Max 80
Usage notes
N1 Loop end
Heading end

Detail

RCD Loop
OptionalMax 200000
RCD
010
Detail > RCD Loop > RCD

Receiving Conditions

RequiredMax use 1
Usage notes
Example
RCD-02
663
Quantity Units Received or Accepted
Required
Decimal number (R)
Min 1Max 9
Usage notes
RCD-03
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)
EA
Each
RCD-06
667
Quantity in Question
Required
Decimal number (R)
Min 1Max 9
Usage notes
RCD-07
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
Optional
Identifier (ID)
EA
Each
RCD-08
412
Receiving Condition Code
Required
Identifier (ID)
02
Quantity Short
03
Quantity Over
14
Quantity Received and Processed with No Matching Ship Notice/Manifest
SN1
020
Detail > RCD Loop > SN1

Item Detail (Shipment)

OptionalMax use 1
Usage notes
Example
If either Quantity Ordered (SN1-05) or Unit or Basis for Measurement Code (SN1-06) is present, then the other is required
SN1-02
382
Number of Units Shipped
Required
Decimal number (R)
Min 1Max 10
Usage notes
SN1-03
355
Unit or Basis for Measurement Code
Required
Identifier (ID)
EA
Each
SN1-05
330
Quantity Ordered
Optional
Decimal number (R)
Min 1Max 15
Usage notes
SN1-06
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
EA
Each
LIN
040
Detail > RCD Loop > LIN

Item Identification

RequiredMax use 100
Example
LIN-01
350
Assigned Identification
Optional
String (AN)
Min 1Max 20
LIN-02
235
Product/Service ID Qualifier
Required
Identifier (ID)
Usage notes
EN
European Article Number (EAN) (2-5-5-1)
ND
National Drug Code (NDC)
UI
U.P.C. Consumer Package Code (1-5-5)
UK
U.P.C./EAN Shipping Container Code (1-2-5-5-1)
UP
U.P.C. Consumer Package Code (1-5-5-1)
VN
Vendor's (Seller's) Item Number
LIN-03
234
Product/Service ID
Required
String (AN)
Min 1Max 48
Usage notes
SAC
170
Detail > RCD Loop > SAC

Service, Promotion, Allowance, or Charge Information

OptionalMax use 10
Usage notes
Example
If either Unit or Basis for Measurement Code (SAC-09) or Quantity (SAC-10) is present, then the other is required
SAC-01
248
Allowance or Charge Indicator
Required
Identifier (ID)
Usage notes
C
Charge
N
No Allowance or Charge
Q
Charge Request
SAC-02
1300
Service, Promotion, Allowance, or Charge Code
Optional
Identifier (ID)
E065
Invoice Adjustment
F680
Price Deviation
SAC-05
610
Amount
Optional
Numeric (N2)
Min 1Max 15
Optional
Decimal number (R)
Min 1Max 9
SAC-09
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
EA
Each
SAC-10
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
MAN
180
Detail > RCD Loop > MAN

Marks and Numbers

RequiredMax use >1
Usage notes
Example
MAN-01
88
Marks and Numbers Qualifier
Required
Identifier (ID)
GM
SSCC-18 and Application Identifier
MAN-02
87
Marks and Numbers
Required
String (AN)
Min 1Max 48
RCD Loop end
Detail end

Summary

CTT
010
Summary > CTT

Transaction Totals

RequiredMax use 1
Example
CTT-01
354
Number of Line Items
Required
Numeric (N0)
Min 1Max 6
CTT-02
347
Hash Total
Optional
Decimal number (R)
Min 1Max 10
SE
020
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

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.