**These specifications are a base model. All customers are responsible for ensuring their map or EDI is compliant with their trading partner's most current specifications.
X12 810 Invoices for Direct Store Deliveries (DSD)
Revised February 23, 2024
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
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*00* *00* *XX*XXXXXXXXXXXXXXX*XX*XXXXXXXXXXXXXXX*240806*0626*U*00401*000000000*X*X*>~
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)
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)
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)
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)
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
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
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
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
Interchange Date
Required
Date (DT)
YYMMDD format
Date of the interchange
Interchange Time
Required
Time (TM)
HHMM format
Time of the interchange
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
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
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9
A control number assigned by the interchange sender
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
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
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*IN*XX*XX*20240806*0908*00000000*XX*004010~
Functional Identifier Code
Required
Identifier (ID)
Code identifying a group of application related transaction sets
IN
Invoice Information (810,819)
Application Sender's Code
Required
String (AN)
Min 2Max 15
Code identifying party sending transmission; codes agreed to by trading partners
Application Receiver's Code
Required
String (AN)
Min 2Max 15
Code identifying party receiving transmission. Codes agreed to by trading partners
Date
Required
Date (DT)
CCYYMMDD format
Date expressed as CCYYMMDD
Time
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)
Group Control Number
Required
Numeric (N0)
Min 1Max 9
Assigned number originated and maintained by the sender
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
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
010
Transaction Set Header
RequiredMax use 1
To indicate the start of a transaction set and to assign a control number
Example
ST*810*0001~
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
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
020
Beginning Segment for Invoice
RequiredMax use 1
To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates
Example
BIG*20230616*INV12345*20230616*PO456678***CR~
Date
Required
Date (DT)
CCYYMMDD format
Date expressed as CCYYMMDD
- BIG01 is the invoice issue date.
Invoice Number
Required
String (AN)
Min 1Max 22
Identifying number assigned by issuer
Date
Required
Date (DT)
CCYYMMDD format
Date expressed as CCYYMMDD
- BIG03 is the date assigned by the purchaser to purchase order.
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.
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
050
Reference Identification
OptionalMax use 12
To specify identifying information
Usage notes
This segment must be sent for all 340-B Rx Invoices
Example
REF*AAT*REF~
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.
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
070
Name
RequiredMax use 1
To identify a party by type of organization, name, and code
Example
N1*ST*Walgreens Store*92*01234~
Entity Identifier Code
Required
Identifier (ID)
Code identifying an organizational entity, a physical location, property or an individual
ST
Ship To
Name
Optional
String (AN)
Min 1Max 60
Free-form name
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
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 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
Variants (all may be used)
N1 Loop Ship toParty to receive commercial invoice remittance
070
Name
RequiredMax use 1
To identify a party by type of organization, name, and code
Example
N1*VN*VENDOR-NAME*92*9999999999~
Entity Identifier Code
Required
Identifier (ID)
Code identifying an organizational entity, a physical location, property or an individual
VN
Vendor
Name
Optional
String (AN)
Min 1Max 60
Free-form name
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
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.
110
Reference Identification Bill of Lading Number
OptionalMax use 1
To specify identifying information
Example
REF*BM*7890123~
Variants (all may be used)
REFReference Identification Carrier's Reference Number (PRO/Invoice)REFReference Identification Vendor ID number
Reference Identification Qualifier
Required
Identifier (ID)
Code qualifying the Reference Identification
BM
Bill of Lading Number
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
110
Reference Identification Carrier's Reference Number (PRO/Invoice)
OptionalMax use 1
To specify identifying information
Example
REF*CN*7890123~
Variants (all may be used)
REFReference Identification Bill of Lading NumberREFReference Identification Vendor ID number
Reference Identification Qualifier
Required
Identifier (ID)
Code qualifying the Reference Identification
CN
Carrier's Reference Number (PRO/Invoice)
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
110
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*VR*012345678~
Variants (all may be used)
REFReference Identification Bill of Lading NumberREFReference Identification Carrier's Reference Number (PRO/Invoice)
Reference Identification Qualifier
Required
Identifier (ID)
Code qualifying the Reference Identification
VR
Vendor ID Number
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 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)
070
Name
RequiredMax use 1
To identify a party by type of organization, name, and code
Example
N1*RE*VENDOR-NAME-HERE~
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
Name
Required
String (AN)
Min 1Max 60
Free-form name
090
Address Information
OptionalMax use 2
To specify the location of the named party
Example
N3*ADDR1*ADDR2~
Address Information
Required
String (AN)
Min 1Max 55
Address information
Address Information
Optional
String (AN)
Min 1Max 55
Address information
100
Geographic Location
OptionalMax use 1
To specify the geographic place of the named party
Example
N4*CITY*XX*XXXXXX*XXX~
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.
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.
Postal Code
Required
Identifier (ID)
Min 3Max 15
Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
Country Code
Optional
Identifier (ID)
Min 2Max 3
Code identifying the country
130
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*ZZ*ZZ*00000*20230616*00*20230616*30*000****DESCRIPTION~
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
Terms Basis Date Code
Required
Identifier (ID)
Code identifying the beginning of the terms period
ZZ
Mutually Defined
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.
Terms Discount Due Date
Optional
Date (DT)
CCYYMMDD format
Date payment is due if discount is to be earned expressed in format CCYYMMDD
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
Terms Net Due Date
Required
Date (DT)
CCYYMMDD format
Date when total invoice amount becomes due expressed in format CCYYMMDD
Terms Net Days
Required
Numeric (N0)
Min 1Max 3
Number of days until total invoice amount is due (discount not applicable)
Terms Discount Amount
Optional
Numeric (N2)
Min 1Max 10
Total amount of terms discount
Description
Optional
String (AN)
Min 1Max 80
A free-form description to clarify the related data elements and their content
Detail
IT1 Loop
RequiredMax 1000
010
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
IT1*XXXX*10*EA*20*PE*VN*ITID1234*EN*ID1*UP*ID2*ND*ID3*UI*ID4~
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
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).
Quantity Invoiced
Required
Decimal number (R)
Min 1Max 10
Number of units invoiced (supplier units)
Usage notes
2 decimals positions will be accepted
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.
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
Basis of Unit Price Code
Optional
Identifier (ID)
Code identifying the type of unit price for an item
PE
Price per Each
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.
Product/Service ID
Required
String (AN)
Min 1Max 48
Identifying number for a product or service
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
Product/Service ID
Optional
String (AN)
Min 1Max 48
Identifying number for a product or service
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
Product/Service ID
Optional
String (AN)
Min 1Max 48
Identifying number for a product or service
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
Product/Service ID
Optional
String (AN)
Min 1Max 48
Identifying number for a product or service
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
Product/Service ID
Optional
String (AN)
Min 1Max 48
Identifying number for a product or service
PID Loop
RequiredMax 1
060
Product/Item Description
RequiredMax use 1
To describe a product or process in coded or free-form format
Example
PID*F****DESCRIPTION~
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
Description
Required
String (AN)
Min 1Max 80
A free-form description to clarify the related data elements and their content
100
Item Physical Details
OptionalMax use 1
To specify the physical qualities, packaging, weights, and dimensions relating to the item
Example
PO4*2*12*CA***30*EA*45*EA~
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
Pack
Optional
Numeric (N0)
Min 1Max 6
The number of inner containers, or number of eaches if there are no inner containers, per outer container
Size
Optional
Decimal number (R)
Min 1Max 8
Size of supplier units in pack
Usage notes
1 decimal position will be accepted
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
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
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
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
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
180
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*A*C090***300***350*EA*20*0000000000000*05***DESCRIPTION~
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
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
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.
Rate
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.
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.
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
Quantity
Optional
Decimal number (R)
Min 1Max 15
Numeric value of quantity
Usage notes
2 decimal positions will be accepted
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
Description
Required
String (AN)
Min 1Max 80
A free-form description to clarify the related data elements and their content
Summary
010
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*0*00000000000000*000000000000000*00000~
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
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.
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).
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
040
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
SAC*C*G880***00000000***0000000*EA*000000000*0000*03***DESCRIPTION~
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
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
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
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.
Rate
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.
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.
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
Quantity
Optional
Decimal number (R)
Min 1Max 15
Numeric value of quantity
Usage notes
2 decimal positions will be accepted
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
Description
Required
String (AN)
Min 1Max 80
A free-form description to clarify the related data elements and their content
070
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*1*000000000~
Number of Line Items
Required
Numeric (N0)
Min 1Max 6
Total number of line items in the transaction set
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.
080
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*000*0001~
Number of Included Segments
Required
Numeric (N0)
Min 1Max 10
Total number of segments included in a transaction set including ST and SE segments
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
Functional Group Trailer
RequiredMax use 1
To indicate the end of a functional group and to provide control information
Example
GE*00000*0000000~
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
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*0*000000000~
Number of Included Functional Groups
Required
Numeric (N0)
Min 1Max 5
A count of the number of functional groups included in an interchange
Interchange Control Number
Required
Numeric (N0)
Min 9Max 9
A control number assigned by the interchange sender
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article