Walgreens
/
Invoices for Direct Store Deliveries (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 810 Invoices for Direct Store Deliveries (DSD)

X12 Release 4010

This Draft Standard for Trial Use contains the format and establishes the data contents of the Invoice Transaction Set (810) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice relative to the billing for goods and services provided.

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/invoices-for-direct-store-deliveries-dsd/01H40WXKJ8T4RWG1TX5VK7M6Y4
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
BIG
020
Beginning Segment for Invoice
Max use 1
Required
REF
050
Reference Identification
Max use 12
Optional
N1 Loop Ship to
ITD
130
Terms of Sale/Deferred Terms of Sale
Max use 1
Required
detail
IT1 Loop
IT1
010
Baseline Item Data (Invoice)
Max use 1
Required
PO4
100
Item Physical Details
Max use 1
Optional
SAC Loop
GE
-
Functional Group Trailer
Max use 1
Required
IEA
-
Interchange Control Trailer
Max use 1
Required
ISA

Interchange Control Header

RequiredMax use 1

To start and identify an interchange of zero or more functional groups and interchange-related control segments

Example
ISA-01
I01
Authorization Information Qualifier
Required
Identifier (ID)

Code to identify the type of information in the Authorization Information

00
No Authorization Information Present (No Meaningful Information in I02)
ISA-02
I02
Authorization Information
Required
String (AN)
Min 10Max 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)

ISA-03
I03
Security Information Qualifier
Required
Identifier (ID)

Code to identify the type of information in the Security Information

00
No Security Information Present (No Meaningful Information in I04)
ISA-04
I04
Security Information
Required
String (AN)
Min 10Max 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)

ISA-05
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2

Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified

Codes
ISA-06
I06
Interchange Sender ID
Required
String (AN)
Min 15Max 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

ISA-07
I05
Interchange ID Qualifier
Required
Identifier (ID)
Min 2Max 2

Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified

Codes
ISA-08
I07
Interchange Receiver ID
Required
String (AN)
Min 15Max 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

ISA-09
I08
Interchange Date
Required
Date (DT)
YYMMDD format

Date of the interchange

ISA-10
I09
Interchange Time
Required
Time (TM)
HHMM format

Time of the interchange

ISA-11
I10
Interchange Control Standards Identifier
Required
Identifier (ID)

Code to identify the agency responsible for the control standard used by the message that is enclosed by the interchange header and trailer

U
U.S. EDI Community of ASC X12, TDCC, and UCS
ISA-12
I11
Interchange Control Version Number
Required
Identifier (ID)

This version number covers the interchange control segments

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

A control number assigned by the interchange sender

ISA-14
I13
Acknowledgment Requested
Required
Identifier (ID)
Min 1Max 1

Code sent by the sender to request an interchange acknowledgment (TA1)

0
No Acknowledgment Requested
1
Interchange Acknowledgment Requested
ISA-15
I14
Usage Indicator
Required
Identifier (ID)
Min 1Max 1

Code to indicate whether data enclosed by this interchange envelope is test, production or information

I
Information
P
Production Data
T
Test Data
ISA-16
I15
Component Element Separator
Required
String (AN)
Min 1Max 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

>
Component Element Separator

Functional Group Header

RequiredMax use 1

To indicate the beginning of a functional group and to provide control information

Example
GS-01
479
Functional Identifier Code
Required
Identifier (ID)

Code identifying a group of application related transaction sets

IN
Invoice Information (810,819)
GS-02
142
Application Sender's Code
Required
String (AN)
Min 2Max 15

Code identifying party sending transmission; codes agreed to by trading partners

GS-03
124
Application Receiver's Code
Required
String (AN)
Min 2Max 15

Code identifying party receiving transmission. Codes agreed to by trading partners

Required
Date (DT)
CCYYMMDD format

Date expressed as CCYYMMDD

Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

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)

GS-06
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

Assigned number originated and maintained by the sender

GS-07
455
Responsible Agency Code
Required
Identifier (ID)
Min 1Max 2

Code used in conjunction with Data Element 480 to identify the issuer of the standard

T
Transportation Data Coordinating Committee (TDCC)
X
Accredited Standards Committee X12
GS-08
480
Version / Release / Industry Identifier Code
Required
String (AN)

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

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

To indicate the start of a transaction set and to assign a control number

Example
ST-01
143
Transaction Set Identifier Code
Required
Identifier (ID)

Code uniquely identifying a Transaction Set

  • The transaction set identifier (ST01) used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set).
810
Invoice
ST-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9

Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

BIG
020
Heading > BIG

Beginning Segment for Invoice

RequiredMax use 1

To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates

Example
Required
Date (DT)
CCYYMMDD format

Date expressed as CCYYMMDD

  • BIG01 is the invoice issue date.
BIG-02
76
Invoice Number
Required
String (AN)
Min 1Max 22

Identifying number assigned by issuer

Required
Date (DT)
CCYYMMDD format

Date expressed as CCYYMMDD

  • BIG03 is the date assigned by the purchaser to purchase order.
BIG-04
324
Purchase Order Number
Required
String (AN)
Min 1Max 22

Identifying number for Purchase Order assigned by the orderer/purchaser

Usage notes

This must be either the Walgreens Legacy 6-digit store-level PO Number or the 10-digit SAP Purchase Order number, as communicated to you on the Purchase Order. The future Walgreens SAP back-end environment will only support maximum PO length of 10 characters – items sent with values beyond 10 characters will fail in the future Walgreens SAP Environment.
Failure to use the exact same PO number throughout all transactions related to order, shipment and invoice may result in payment resolution issues in the Invoice Reconciliation/3-Way Match processes.

BIG-07
640
Transaction Type Code
Required
Identifier (ID)

Code specifying the type of transaction

  • BIG07 is used only to further define the type of invoice when needed.
Usage notes

As the signs (+, -) for dollar amounts can vary depending on the partner's application, Walgreens will use the BIG07 value to determine the sign needed for Walgreens AP processing. The BIG07 will be used to distinguish an invoice from a credit memo. (Positive and negative lines are not accepted in the same transaction. The BIG07 determines a debit or credit.)

CR
Credit Memo
DI
Debit Invoice
REF
050
Heading > REF

Reference Identification

OptionalMax use 12

To specify identifying information

Usage notes

This segment must be sent for all 340-B Rx Invoices

Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

Usage notes

The AAT code is used for 340B Rx invoices.

AAT
Distributor's Account Number

The AAT code is used for 340B Rx invoices.

REF-02
127
Reference Identification
Optional
String (AN)
Min 1Max 30

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

N1 Loop Ship to
RequiredMax 1
Usage notes

DIRECT STORE DELIVERY invoices MUST contain ALL of the following values, in addition to your Walgreens A/P number in REF02 (REF*VR) to ensure correct payment of invoices:
When N101 = "RE" N102 = Remit To Name
When N101 = "ST" N103 = "92" N104 = Walgreens Store Number
When N101 = "VN" N103 = "92" N104 = Walgreens Legacy 6-digit Marketing or 10-digit SAP Vendor Number

Variants (all may be used)
N1 Loop VendorParty to receive commercial invoice remittance
N1
070
Heading > N1 Loop Ship to > N1

Name

RequiredMax use 1

To identify a party by type of organization, name, and code

Example
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

ST
Ship To
Optional
String (AN)
Min 1Max 60

Free-form name

N1-03
66
Identification Code Qualifier
Required
Identifier (ID)

Code designating the system/method of code structure used for Identification Code (67)

92
Assigned by Buyer or Buyer's Agent
N1-04
67
Identification Code
Required
String (AN)
Min 2Max 80

Code identifying a party or other code

  • This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.
Usage notes

This must be either the Walgreens Legacy 5-character store number or 4-character SAP Site number, as communicated to you on the Purchase Order.
See example in this section for correct formatting details

N1 Loop Ship to end
N1 Loop Vendor
RequiredMax 1
Usage notes

DIRECT STORE DELIVERY invoices MUST contain ALL of the following values, in addition to your Walgreens A/P number in REF02 (REF*VR) to ensure correct payment of invoices:
When N101 = "RE" N102 = Remit To Name
When N101 = "ST" N103 = "92" N104 = Walgreens Store Number
When N101 = "VN" N103 = "92" N104 = Walgreens Legacy 6-digit Marketing or 10-digit SAP Vendor Number

N1
070
Heading > N1 Loop Vendor > N1

Name

RequiredMax use 1

To identify a party by type of organization, name, and code

Example
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

VN
Vendor
Optional
String (AN)
Min 1Max 60

Free-form name

N1-03
66
Identification Code Qualifier
Required
Identifier (ID)

Code designating the system/method of code structure used for Identification Code (67)

92
Assigned by Buyer or Buyer's Agent
N1-04
67
Identification Code
Required
String (AN)
Min 2Max 80

Code identifying a party or other code

  • This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.
Usage notes

This element must be your Legacy 6-digit Walgreens Marketing Vendor number or 10-digit SAP Vendor Number, as provided on the original Purchase Order.

REF
110
Heading > N1 Loop Vendor > REF

Reference Identification Bill of Lading Number

OptionalMax use 1

To specify identifying information

Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

BM
Bill of Lading Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 30

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

Usage notes

This is your Walgreens AP Vendor Number, up to 10 digits

REF
110
Heading > N1 Loop Vendor > REF

Reference Identification Carrier's Reference Number (PRO/Invoice)

OptionalMax use 1

To specify identifying information

Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

CN
Carrier's Reference Number (PRO/Invoice)
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 30

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

Usage notes

This is your Walgreens AP Vendor Number, up to 10 digits

REF
110
Heading > N1 Loop Vendor > REF

Reference Identification Vendor ID number

RequiredMax use 1

To specify identifying information

Usage notes

In order for your invoices to be processed and paid correctly, all invoices REQUIRE one occurrence of the REF segment for the AP Vendor Number.
Required values are:
REF01 = "VR" REF02 = Walgreens AP Vendor Number

Example
REF-01
128
Reference Identification Qualifier
Required
Identifier (ID)

Code qualifying the Reference Identification

VR
Vendor ID Number
REF-02
127
Reference Identification
Required
String (AN)
Min 1Max 30

Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

Usage notes

This is your Walgreens AP Vendor Number, up to 9 digits.

N1 Loop Vendor end
N1 Party to receive commercial invoice remittance
RequiredMax 1
Usage notes

DIRECT STORE DELIVERY invoices MUST contain ALL of the following values, in addition to your Walgreens A/P number in REF02 (REF*VR) to ensure correct payment of invoices:
When N101 = "RE" N102 = Remit To Name
When N101 = "ST" N103 = "92" N104 = Walgreens Store Number
When N101 = "VN" N103 = "92" N104 = Walgreens Legacy 6-digit Marketing or 10-digit SAP Vendor Number

Variants (all may be used)
N1 Loop Ship toN1 Loop Vendor
N1
070
Heading > Party to receive commercial invoice remittance > N1

Name

RequiredMax use 1

To identify a party by type of organization, name, and code

Example
N1-01
98
Entity Identifier Code
Required
Identifier (ID)

Code identifying an organizational entity, a physical location, property or an individual

RE
Party to receive commercial invoice remittance
Required
String (AN)
Min 1Max 60

Free-form name

N3
090
Heading > Party to receive commercial invoice remittance > N3

Address Information

OptionalMax use 2

To specify the location of the named party

Example
N3-01
166
Address Information
Required
String (AN)
Min 1Max 55

Address information

N3-02
166
Address Information
Optional
String (AN)
Min 1Max 55

Address information

N4
100
Heading > Party to receive commercial invoice remittance > N4

Geographic Location

OptionalMax use 1

To specify the geographic place of the named party

Example
N4-01
19
City Name
Required
String (AN)
Min 2Max 30

Free-form text for city name

  • A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
N4-02
156
State or Province Code
Required
Identifier (ID)
Min 2Max 2

Code (Standard State/Province) as defined by appropriate government agency

  • N402 is required only if city name (N401) is in the U.S. or Canada.
N4-03
116
Postal Code
Required
Identifier (ID)
Min 3Max 15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

N4-04
26
Country Code
Optional
Identifier (ID)
Min 2Max 3

Code identifying the country

N1 Party to receive commercial invoice remittance end
ITD
130
Heading > ITD

Terms of Sale/Deferred Terms of Sale

RequiredMax use 1

To specify terms of sale

Usage notes

If terms include a discount, the following elements must be populated:
ITD01, ITD02, ITD03, ITD04, ITD05, ITD06, ITD07, ITD08 & ITD12

If terms do not include a discount, the following elements are required:
ITD01, ITD02, ITD06, ITD07 & ITD12

At this time, Walgreens is unable to accept invoices with split payment terms via EDI.

Example
ITD-01
336
Terms Type Code
Required
Identifier (ID)

Code identifying type of payment terms

  • If the code in ITD01 is "04", then ITD07 or ITD09 is required and either ITD10 or ITD11 is required; if the code in ITD01 is "05", then ITD06 or ITD07 is required.
ZZ
Mutually Defined
ITD-02
333
Terms Basis Date Code
Required
Identifier (ID)

Code identifying the beginning of the terms period

ZZ
Mutually Defined
ITD-03
338
Terms Discount Percent
Optional
Decimal number (R)
Min 1Max 6

Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date

Usage notes

3 decimal positions will be accepted.

ITD-04
370
Terms Discount Due Date
Optional
Date (DT)
CCYYMMDD format

Date payment is due if discount is to be earned expressed in format CCYYMMDD

ITD-05
351
Terms Discount Days Due
Optional
Numeric (N0)
Min 1Max 3

Number of days in the terms discount period by which payment is due if terms discount is earned

ITD-06
446
Terms Net Due Date
Required
Date (DT)
CCYYMMDD format

Date when total invoice amount becomes due expressed in format CCYYMMDD

ITD-07
386
Terms Net Days
Required
Numeric (N0)
Min 1Max 3

Number of days until total invoice amount is due (discount not applicable)

ITD-08
362
Terms Discount Amount
Optional
Numeric (N2)
Min 1Max 10

Total amount of terms discount

ITD-12
352
Description
Optional
String (AN)
Min 1Max 80

A free-form description to clarify the related data elements and their content

Heading end

Detail

IT1 Loop
RequiredMax 1000
IT1
010
Detail > IT1 Loop > IT1

Baseline Item Data (Invoice)

RequiredMax use 1

To specify the basic and most frequently used line item data for the invoice and related transactions

Usage notes

IT1-14 must have MD qualifier for "dropship" items. Only used when product is delivered direct from other supplier or manufacturer and when use of this process has been approved by Walgreens EDI Services.
IT1-15 must contain variant of word "dropship." Only used when product is delivered direct from other supplier or manufacturer and when use of this process has been approved by Walgreens EDI Services.

Example
If either Product/Service ID Qualifier (IT1-08) or Product/Service ID (IT1-09) is present, then the other is required
If either Product/Service ID Qualifier (IT1-10) or Product/Service ID (IT1-11) is present, then the other is required
If either Product/Service ID Qualifier (IT1-12) or Product/Service ID (IT1-13) is present, then the other is required
If either Product/Service ID Qualifier (IT1-14) or Product/Service ID (IT1-15) is present, then the other is required
IT1-01
350
Assigned Identification
Required
String (AN)
Min 1Max 20

Alphanumeric characters assigned for differentiation within a transaction set

  • IT101 is the purchase order line item identification.
Usage notes

The Invoice Line Number must be sent. For optimal processing in our systems, you must turn around the exact line number value from the original Purchase Order (P0101).

IT1-02
358
Quantity Invoiced
Required
Decimal number (R)
Min 1Max 10

Number of units invoiced (supplier units)

Usage notes

2 decimals positions will be accepted

IT1-03
355
Unit or Basis for Measurement Code
Required
Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

Usage notes

The Legacy Walgreens Store systems are only capable of handling eaches; however, the future SAP environment should allow more.

EA
Each

This UOM measure (EA) is the Mandatory qualifier to be used for vendors on the Three-Way Match Program/Invoice Reconciliation in the Legacy Walgreens environment. Other values, such as "CA," may become available after Walgreens has finished its SAP deployment across all internal systems.

IT1-04
212
Unit Price
Required
Decimal number (R)
Min 1Max 15

Price per unit of product, service, commodity, etc.

Usage notes

For invoices for orders originating out of our Legacy/SIMS environment, only send up to 2 decimal positions; however, those for our future SAP system generated orders will accept up to 4 significant decimal places

IT1-05
639
Basis of Unit Price Code
Optional
Identifier (ID)

Code identifying the type of unit price for an item

PE
Price per Each
IT1-06
235
Product/Service ID Qualifier
Required
Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

  • IT106 through IT125 provide for ten different product/service IDs for each item. For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.
EN
European Article Number (EAN) (2-5-5-1)
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

The VN qualifier is used ONLY for expense items.

IT1-07
234
Product/Service ID
Required
String (AN)
Min 1Max 48

Identifying number for a product or service

IT1-08
235
Product/Service ID Qualifier
Optional
Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

Usage notes

For additional validation in the event an invalid UPC number is transmitted, it is requested that DC invoices contain a value of 'IN' in this position and the corresponding 6-digit Walgreens Item Code (WIC), as sent to you on the original Purchase Order.

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
IT1-09
234
Product/Service ID
Optional
String (AN)
Min 1Max 48

Identifying number for a product or service

IT1-10
235
Product/Service ID Qualifier
Optional
Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

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
IT1-11
234
Product/Service ID
Optional
String (AN)
Min 1Max 48

Identifying number for a product or service

IT1-12
235
Product/Service ID Qualifier
Optional
Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

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
IT1-13
234
Product/Service ID
Optional
String (AN)
Min 1Max 48

Identifying number for a product or service

IT1-14
235
Product/Service ID Qualifier
Optional
Identifier (ID)

Code identifying the type/source of the descriptive number used in Product/Service ID (234)

EN
European Article Number (EAN) (2-5-5-1)
MD
Method of Delivery Code
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
IT1-15
234
Product/Service ID
Optional
String (AN)
Min 1Max 48

Identifying number for a product or service

PID Loop
RequiredMax 1
PID
060
Detail > IT1 Loop > PID Loop > PID

Product/Item Description

RequiredMax use 1

To describe a product or process in coded or free-form format

Example
PID-01
349
Item Description Type
Required
Identifier (ID)

Code indicating the format of a description

  • If PID01 equals "F", then PID05 is used. If PID01 equals "S", then PID04 is used. If PID01 equals "X", then both PID04 and PID05 are used.
F
Free-form
PID-05
352
Description
Required
String (AN)
Min 1Max 80

A free-form description to clarify the related data elements and their content

PID Loop end
PO4
100
Detail > IT1 Loop > PO4

Item Physical Details

OptionalMax use 1

To specify the physical qualities, packaging, weights, and dimensions relating to the item

Example
If either Size (PO4-02) or Unit or Basis for Measurement Code (PO4-03) is present, then the other is required
If either Gross Weight per Pack (PO4-06) or Unit or Basis for Measurement Code (PO4-07) is present, then the other is required
If either Gross Volume per Pack (PO4-08) or Unit or Basis for Measurement Code (PO4-09) is present, then the other is required
Optional
Numeric (N0)
Min 1Max 6

The number of inner containers, or number of eaches if there are no inner containers, per outer container

Optional
Decimal number (R)
Min 1Max 8

Size of supplier units in pack

Usage notes

1 decimal position will be accepted

PO4-03
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

  • PO403 - The "Unit or Basis for Measure Code" in this segment position is for purposes of defining the pack (PO401) /size (PO402) measure which indicates the quantity in the inner pack unit. For example: If the carton contains 24 12-Ounce packages, it would be described as follows: Data element 356 = "24"; Data element 357 = "12"; Data element 355 = "OZ".
AS
Assortment
CA
Case
DE
Deal
DZ
Dozen
EA
Each
PO4-06
384
Gross Weight per Pack
Optional
Decimal number (R)
Min 1Max 9

Numeric value of gross weight per pack

Usage notes

1 decimal position will be accepted

PO4-07
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

EA
Each

This UOM measure (EA) is the Mandatory qualifier to be used for vendors on the Three-Way Match Program/Invoice Reconciliation in the Legacy Walgreens environment. Other values, such as "CA," may become available after Walgreens has finished its SAP deployment across all internal systems

PO4-08
385
Gross Volume per Pack
Optional
Decimal number (R)
Min 1Max 9

Numeric value of gross volume per pack

Usage notes

1 decimal position will be accepted

PO4-09
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

EA
Each

This UOM measure (EA) is the Mandatory qualifier to be used for vendors on the Three-Way Match Program/Invoice Reconciliation in the Legacy Walgreens environment. Other values, such as "CA," may become available after Walgreens has finished its SAP deployment across all internal systems

SAC Loop
OptionalMax 4
SAC
180
Detail > IT1 Loop > SAC Loop > SAC

Service, Promotion, Allowance, or Charge Information

RequiredMax use 1

To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

Usage notes

If item specific allowances, deals, or promotions exist, the user must send this segment.
For DSD invoices containing the SAC at item level, the user must send the following elements:
SAC01, SAC02, SAC05, SAC08, SAC09, SAC10 & SAC15
DSD - BOTTLE DEPOSIT SEGMENT - Item Level
***DSD invoices for the following states: CA, CT, DE, HI, IA, IL, MA, MD, ME, MI, NY, OR, and VT carrying Bottle Deposit charges, must send the values listed below:
SAC01 = "C"
SAC02 = "B570" and or "C090"
SAC05 = Total Deposit Amount
SAC08 = Rate
SAC09 = Unit of Measure
SAC10 = Quantity
SAC15 = 2 character State Code

Example
SAC-01
248
Allowance or Charge Indicator
Required
Identifier (ID)

Code which indicates an allowance or charge for the service specified

  • If SAC01 is "A" or "C", then at least one of SAC05, SAC07, or SAC08 is required.
A
Allowance
C
Charge
SAC-02
1300
Service, Promotion, Allowance, or Charge Code
Required
Identifier (ID)

Code identifying the service, promotion, allowance, or charge

A170
Adjustments
A360
Alcoholic Beverage Report Charge
A600
Bill of Lading Charge
B560
Container Allowance
B570
Container Deposits
B800
Credit
C040
Delivery
C090
Deposit Charges
C110
Deposit
C260
Discount - Incentive
C300
Discount - Special
C310
Discount
C320
Display Allowance
D170
Free Goods
D240
Freight
D340
Goods and Services Charge
D350
Goods and Services Credit Allowance
D360
Goods and Services Tax Charge
E065
Invoice Adjustment
E070
Invoice Services
E080
Invoice with Goods
E580
Memo Returnable Container
E710
New Discount
E720
New Distribution Allowance
E730
New Item Allowance
E740
New Store Allowance
E750
New Store Discount
E760
New Warehouse Discount
F240
Per Item Charge
F280
Performance Allowance
F800
Promotional Allowance
F810
Promotional Discount
F910
Quantity Discount
G740
Service Charge
G880
Shrinkage Allowance
H000
Special Allowance
H030
Special Credit
H490
Subject To Tax On Resale
H630
Tax - City Sales Tax (Only)
H700
Tax - Local Tax
H770
Tax - State Tax
H850
Tax
ZZZZ
Mutually Defined
SAC-05
610
Amount
Required
Numeric (N2)
Min 1Max 15

Monetary amount

  • SAC05 is the total amount for the service, promotion, allowance, or charge.
  • If SAC05 is present with SAC07 or SAC08, then SAC05 takes precedence.
Required
Decimal number (R)
Min 1Max 9

Rate expressed in the standard monetary denomination for the currency specified

  • SAC08 is the allowance or charge rate per unit.
Usage notes

2 decimal positions will be accepted.

SAC-09
355
Unit or Basis for Measurement Code
Required
Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

EA
Each

This UOM measure (EA) is the Mandatory qualifier tobe used for vendors on the Three-Way Match Program/Invoice Reconciliation in the Legacy Walgreens environment. Other values, such as "CA," may become available after Walgreens has finished its SAP deployment across all internal systems.

SAC-10
380
Quantity
Required
Decimal number (R)
Min 1Max 15

Numeric value of quantity

  • SAC10 and SAC11 is the quantity basis when the allowance or charge quantity is different from the purchase order or invoice quantity.
  • SAC10 and SAC11 used together indicate a quantity range, which could be a dollar amount, that is applicable to service, promotion, allowance, or charge.
  • In some business applications, it is necessary to advise the trading partner of the actual dollar amount that a particular allowance, charge, or promotion was based on to reduce ambiguity. This amount is commonly referred to as "Dollar Basis Amount". It is represented in the SAC segment in SAC10 using the qualifier "DO" - Dollars in SAC09.
Usage notes

2 decimal positions will be accepted

SAC-11
380
Quantity
Optional
Decimal number (R)
Min 1Max 15

Numeric value of quantity

Usage notes

2 decimal positions will be accepted

SAC-12
331
Allowance or Charge Method of Handling Code
Optional
Identifier (ID)

Code indicating method of handling for an allowance or charge

01
Bill Back
02
Off Invoice
03
Vendor Check to Customer
04
Credit Customer Account
05
Charge to be Paid by Vendor
SAC-15
352
Description
Required
String (AN)
Min 1Max 80

A free-form description to clarify the related data elements and their content

SAC Loop end
IT1 Loop end
Detail end

Summary

TDS
010
Summary > TDS

Total Monetary Value Summary

RequiredMax use 1

To specify the total invoice discounts and amounts

Usage notes

To expedite processing, Walgreens would prefer to receive the TDS02, TDS03, and the TDS04 in addition to the TDS01.

Example
TDS-01
610
Amount
Required
Numeric (N2)
Min 1Max 15

Monetary amount

  • TDS01 is the total amount of invoice (including charges, less allowances) before terms discount (if discount is applicable).
Usage notes

Gross Invoice Amount = Extended Line Total less allowances, deals, and
promotions

TDS-02
610
Amount
Optional
Numeric (N2)
Min 1Max 15

Monetary amount

  • TDS02 indicates the amount upon which the terms discount amount is calculated.
  • TDS02 is required if the dollar value subject to discount is not equal to the dollar value of TDS01.
Usage notes

Amount to which cash terms discount is applied.

TDS-03
610
Amount
Optional
Numeric (N2)
Min 1Max 15

Monetary amount

  • TDS03 is the amount of invoice due if paid by terms discount due date (total invoice or installment amount less cash discount).
Usage notes

Discounted (Net) Invoice Amount = Gross Invoice Amount (TDS01) less Cash Terms Discount Amount (TDS04).

TDS-04
610
Amount
Optional
Numeric (N2)
Min 1Max 15

Monetary amount

  • TDS04 indicates the total amount of terms discount.
Usage notes

Cash Terms Discount Amount (same as ITD08).

SAC Loop
OptionalMax 4
SAC
040
Summary > SAC Loop > SAC

Service, Promotion, Allowance, or Charge Information

RequiredMax use 1

To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

Usage notes

If invoice level allowances, deals or promotions exist, the user must send this SAC summary level segment.

DSD - STATE TAX SEGMENT- Summary Level
***For DSD invoices carrying CT, MA, LA, NY RI or PR state tax, the user must send the following Elements in the SAC at the summary level:
SAC01 = "C"
SAC02 = "H770" or "H850"
SAC05 = Total Tax Amount
SAC15 = 2 character State Code

For all other taxes the user must send the following values:
SAC01 = "C"
SAC02 = "H700"
SAC05 = Total Tax Amount
SAC15 = description of tax

If freight is billed on the invoice, the user must send SAC02 containing a value of "D240" and the FOB01containing a value of "CC".
DSD - BOTTLE DEPOSIT SEGMENT - Summary Leve

***DSD invoices for the following states: CA, CT, DE, HI, IA, IL, MA, MD, ME, MI, NY, OR, and VT carrying Bottle Deposit charges, must send the values listed below:
SAC01 = "C"
SAC02 = "B570" and or "C090"
SAC05 = Total Deposit Amount
SAC15 = 2 character State Code

Example
If either Unit or Basis for Measurement Code (SAC-09) or Quantity (SAC-10) is present, then the other is required
If Quantity (SAC-11) is present, then Quantity (SAC-10) is required
SAC-01
248
Allowance or Charge Indicator
Required
Identifier (ID)

Code which indicates an allowance or charge for the service specified

  • If SAC01 is "A" or "C", then at least one of SAC05, SAC07, or SAC08 is required.
A
Allowance
C
Charge
SAC-02
1300
Service, Promotion, Allowance, or Charge Code
Required
Identifier (ID)

Code identifying the service, promotion, allowance, or charge

A170
Adjustments
A360
Alcoholic Beverage Report Charge
A600
Bill of Lading Charge
B560
Container Allowance
B570
Container Deposits
B800
Credit
C040
Delivery
C090
Deposit Charges
C110
Deposit
C260
Discount - Incentive
C300
Discount - Special
C310
Discount
C320
Display Allowance
D170
Free Goods
D240
Freight
D340
Goods and Services Charge
D350
Goods and Services Credit Allowance
D360
Goods and Services Tax Charge
E065
Invoice Adjustment
E070
Invoice Services
E080
Invoice with Goods
E580
Memo Returnable Container
E710
New Discount
E720
New Distribution Allowance
E730
New Item Allowance
E740
New Store Allowance
E750
New Store Discount
E760
New Warehouse Discount
F240
Per Item Charge
F280
Performance Allowance
F800
Promotional Allowance
F810
Promotional Discount
F910
Quantity Discount
G740
Service Charge
G880
Shrinkage Allowance
H000
Special Allowance
H030
Special Credit
H490
Subject To Tax On Resale
H630
Tax - City Sales Tax (Only)
H700
Tax - Local Tax
H770
Tax - State Tax
H850
Tax
ZZZZ
Mutually Defined
SAC-05
610
Amount
Optional
Numeric (N2)
Min 1Max 15

Monetary amount

  • SAC05 is the total amount for the service, promotion, allowance, or charge.
  • If SAC05 is present with SAC07 or SAC08, then SAC05 takes precedence.
Optional
Decimal number (R)
Min 1Max 9

Rate expressed in the standard monetary denomination for the currency specified

  • SAC08 is the allowance or charge rate per unit.
Usage notes

3 decimal positions will be accepted.

SAC-09
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)

Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken

EA
Each

This UOM measure (EA) is the Mandatory qualifier tobe used for vendors on the Three-Way Match Program/Invoice Reconciliation in the Legacy Walgreens environment. Other values, such as "CA," may become available after Walgreens has finished its SAP deployment across all internal systems.

SAC-10
380
Quantity
Optional
Decimal number (R)
Min 1Max 15

Numeric value of quantity

  • SAC10 and SAC11 is the quantity basis when the allowance or charge quantity is different from the purchase order or invoice quantity.
  • SAC10 and SAC11 used together indicate a quantity range, which could be a dollar amount, that is applicable to service, promotion, allowance, or charge.
  • In some business applications, it is necessary to advise the trading partner of the actual dollar amount that a particular allowance, charge, or promotion was based on to reduce ambiguity. This amount is commonly referred to as "Dollar Basis Amount". It is represented in the SAC segment in SAC10 using the qualifier "DO" - Dollars in SAC09.
Usage notes

2 decimal positions will be accepted

SAC-11
380
Quantity
Optional
Decimal number (R)
Min 1Max 15

Numeric value of quantity

Usage notes

2 decimal positions will be accepted

SAC-12
331
Allowance or Charge Method of Handling Code
Optional
Identifier (ID)

Code indicating method of handling for an allowance or charge

01
Bill Back
02
Off Invoice
03
Vendor Check to Customer
04
Credit Customer Account
05
Charge to be Paid by Vendor
SAC-15
352
Description
Required
String (AN)
Min 1Max 80

A free-form description to clarify the related data elements and their content

SAC Loop end
CTT
070
Summary > CTT

Transaction Totals

RequiredMax use 1

To transmit a hash total for a specific element in the transaction set

  • Number of line items (CTT01) is the accumulation of the number of IT1 segments.
    If used, hash total (CTT02) is the sum of the value of quantities invoiced (IT102) for each IT1 segment.
Example
CTT-01
354
Number of Line Items
Required
Numeric (N0)
Min 1Max 6

Total number of line items in the transaction set

CTT-02
347
Hash Total
Optional
Decimal number (R)
Min 1Max 10

Sum of values of the specified data element. All values in the data element will be summed without regard to decimal points (explicit or implicit) or signs. Truncation will occur on the left most digits if the sum is greater than the maximum size of the hash total of the data element.

## Example:
-.0018 First occurrence of value being hashed.
.18 Second occurrence of value being hashed.
1.8 Third occurrence of value being hashed.
18.01 Fourth occurrence of value being hashed.

1855 Hash total prior to truncation.
855 Hash total after truncation to three-digit field.

SE
080
Summary > SE

Transaction Set Trailer

RequiredMax 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)

Example
SE-01
96
Number of Included Segments
Required
Numeric (N0)
Min 1Max 10

Total number of segments included in a transaction set including ST and SE segments

SE-02
329
Transaction Set Control Number
Required
Numeric (N)
Min 4Max 9

Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set

Summary end

Functional Group Trailer

RequiredMax use 1

To indicate the end of a functional group and to provide control information

Example
GE-01
97
Number of Transaction Sets Included
Required
Numeric (N0)
Min 1Max 6

Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element

GE-02
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

Assigned number originated and maintained by the sender

Interchange Control Trailer

RequiredMax use 1

To define the end of an interchange of zero or more functional groups and interchange-related control segments

Example
IEA-01
I16
Number of Included Functional Groups
Required
Numeric (N0)
Min 1Max 5

A count of the number of functional groups included in an interchange

IEA-02
I12
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9

A control number assigned by the interchange sender

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.