X12 810 Invoices for Distribution Center
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.
- ~ Segment
- * Element
- > Component
- None included
Interchange Control Header
To start and identify an interchange of zero or more functional groups and interchange-related control segments
Code to identify the type of information in the Authorization Information
- 00
- No Authorization Information Present (No Meaningful Information in I02)
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)
Code to identify the type of information in the Security Information
- 00
- No Security Information Present (No Meaningful Information in I04)
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)
Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified
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
Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified
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
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
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
A control number assigned by the interchange sender
Code sent by the sender to request an interchange acknowledgment (TA1)
- 0
- No Acknowledgment Requested
- 1
- Interchange Acknowledgment Requested
Code to indicate whether data enclosed by this interchange envelope is test, production or information
- I
- Information
- P
- Production Data
- T
- Test Data
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
To indicate the beginning of a functional group and to provide control information
Code identifying a group of application related transaction sets
- IN
- Invoice Information (810,819)
Code identifying party sending transmission; codes agreed to by trading partners
Code identifying party receiving transmission. Codes agreed to by trading partners
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)
Assigned number originated and maintained by the sender
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
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
Transaction Set Header
To indicate the start of a transaction set and to assign a control number
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
Beginning Segment for Invoice
To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates
Date expressed as CCYYMMDD
- BIG01 is the invoice issue date.
Date expressed as CCYYMMDD
- BIG03 is the date assigned by the purchaser to purchase order.
Identifying number for Purchase Order assigned by the orderer/purchaser
This must be either the Walgreens Legacy 8-digit DC 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, which is an integral part of the SAP-based system being implemented by Walgreens and is new to the DC Vendor community
DISTRIBUTION CENTER invoices must contain the following values in this segment:
Format for Legacy generated orders
N101 = "ST"
N103 = '9'
N104 = Legacy Walgreens DUNS # + 4 character warehouse ID
Format for future SAP system generated orders
N101 = "ST"
N103 = '92'
N104 = Future SAP 4 alphanumeric Site numbeR
Name
To identify a party by type of organization, name, and code
Code identifying an organizational entity, a physical location, property or an individual
- ST
- Ship To
Code designating the system/method of code structure used for Identification Code (67)
- 9
- D-U-N-S+4, D-U-N-S Number with Four Character Suffix
- 92
- Assigned by Buyer or Buyer's Agent
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.
The DUNS number is specified as '008965063W###'. where '###' is the 3-digit Walgreens Distribution Center to which you are shipping.
A current list of DC numbers is available from our SupplierNet website.
Legacy DC Purchase Orders sent the 13-character DUNS+4 value (with leading zeroes) in this element; however, when the Purchase Orders come from our future SAP system, the 4-character (alphanumeric) Site number must be sent in this element
DISTRIBUTION CENTER invoices must contain the following values in this segment:
When N101 = "VN"
N103 = '92'
N104 = Walgreens 6-digit Marketing Vendor #/10-digit SAP Vendor #
Name
To identify a party by type of organization, name, and code
Code identifying an organizational entity, a physical location, property or an individual
- VN
- Vendor
Code designating the system/method of code structure used for Identification Code (67)
- 92
- Assigned by Buyer or Buyer's Agent
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.
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.
Bill of Lading Number
To specify identifying information
Code qualifying the Reference Identification
- BM
- Bill of Lading Number
Reference Identification Carrier's Reference Number (PRO/Invoice)
To specify identifying information
Code qualifying the Reference Identification
- CN
- Carrier's Reference Number (PRO/Invoice)
Vendor ID Number
To specify identifying information
All invoices require one occurrence of the REF segment for the AP Vendor Number.
Required values are:
REF01 = "VR"
REF02 = Walgreens AP Vendor Number
Code qualifying the Reference Identification
- VR
- Vendor ID Number
DISTRIBUTION CENTER invoices must contain the following values in this segment: When N101 = "RE" N102 = Remit To NamE
Name
To identify a party by type of organization, name, and code
Address Information
To specify the location of the named party
Geographic Location
To specify the geographic place of the named party
Free-form text for city name
- A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
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.
Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
Terms of Sale/Deferred Terms of Sale
To specify terms of sale
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
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
Code identifying the beginning of the terms period
- ZZ
- Mutually Defined
Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date
3 decimal positions will be accepted.
Date payment is due if discount is to be earned expressed in format CCYYMMDD
Number of days in the terms discount period by which payment is due if terms discount is earned
Date when total invoice amount becomes due expressed in format CCYYMMDD
Number of days until total invoice amount is due (discount not applicable)
F.O.B. Related Instructions
To specify transportation instructions relating to shipment
The user must send this FOB segment when the shipment method of payment is collect.
The corresponding freight cost is indicated in the Summary level SAC segment.
Detail
Baseline Item Data (Invoice)
To specify the basic and most frequently used line item data for the invoice and related transactions
Alphanumeric characters assigned for differentiation within a transaction set
- IT101 is the purchase order line item identification.
The Invoice Line Number must be sent. For optimal processing in the future SAP-based system, you must turn around the exact line number value from the original Purchase Order (P0101).
Number of units invoiced (supplier units)
2 decimals positions will be accepted
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- AS
- Assortment
- CA
- Case
- DE
- Deal
- DZ
- Dozen
- EA
- Each
Price per unit of product, service, commodity, etc.
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 place
Code identifying the type of unit price for an item
- PE
- Price per Each
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)
- ND
- National Drug Code (NDC)
- UI
- U.P.C. Consumer Package Code (1-5-5)
- 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.
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
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)
- IN
- Buyer's Item Number
- ND
- National Drug Code (NDC)
- UI
- U.P.C. Consumer Package Code (1-5-5)
- UP
- U.P.C. Consumer Package Code (1-5-5-1)
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
- EN
- European Article Number (EAN) (2-5-5-1)
- IN
- Buyer's Item Number
- ND
- National Drug Code (NDC)
- UI
- U.P.C. Consumer Package Code (1-5-5)
- UP
- U.P.C. Consumer Package Code (1-5-5-1)
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
- EN
- European Article Number (EAN) (2-5-5-1)
- IN
- Buyer's Item Number
- ND
- National Drug Code (NDC)
- UI
- U.P.C. Consumer Package Code (1-5-5)
- UP
- U.P.C. Consumer Package Code (1-5-5-1)
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
- EN
- European Article Number (EAN) (2-5-5-1)
- IN
- Buyer's Item Number
- ND
- National Drug Code (NDC)
- UI
- U.P.C. Consumer Package Code (1-5-5)
- UP
- U.P.C. Consumer Package Code (1-5-5-1)
Product/Item Description
To describe a product or process in coded or free-form format
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
Item Physical Details
To specify the physical qualities, packaging, weights, and dimensions relating to the item
The number of inner containers, or number of eaches if there are no inner containers, per outer container
Size of supplier units in pack
1 decimal position will be accepted
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
Numeric value of gross weight per pack
1 decimal position will be accepted
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- AS
- Assortment
- CA
- Case
- DE
- Deal
- DZ
- Dozen
- EA
- Each
Numeric value of gross volume per pack
1 decimal position will be accepted
Service, Promotion, Allowance, or Charge Information
To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge
If item specific allowances, deals, or promotions exist, the user must send this segment.
For DC invoices containing the SAC at item level, the user must send the following elements:
SAC01, SAC02, SAC05, SAC08, SAC09, SAC10 & SAC15
DC - STATE TAX SEGMENT - Item Level
***For DC PR invoices carrying state tax, the user must send the following
Elements in the SAC at item level:
SAC01 = "C"
SAC02 = "H770" or "H850"
SAC05 = Total Tax Amount
SAC08 = Rate
SAC09 = Unit of Measure
SAC10 = Quantity
SAC15 = 2 character State Code (PR)
For all other taxes the user must send the following values:
SAC01 = "C"
SAC02 = "H700"
SAC05 = Total Tax Amount
SAC08 = Rate
SAC09 = Unit of Measure
SAC10 = Quantity
SAC15 = Description of Tax
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
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
The user must send "D240" in the Summary Level
SAC02 when FOB01 = "CC" - 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
- 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
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 expressed in the standard monetary denomination for the currency specified
- SAC08 is the allowance or charge rate per unit.
2 decimal positions will be accepted.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- AS
- Assortment
- CA
- Case
- DE
- Deal
- DZ
- Dozen
- EA
- Each
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.
2 decimal positions will be accepted
Numeric value of quantity
2 decimal positions will be accepted
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
Summary
Total Monetary Value Summary
To specify the total invoice discounts and amounts
To expedite processing, Walgreens would prefer to receive the TDS02, TDS03, and the TDS04 in addition to the TDS01.
Monetary amount
- TDS01 is the total amount of invoice (including charges, less allowances) before terms discount (if discount is applicable).
Gross Invoice Amount = Extended Line Total less allowances, deals and promotions.
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.
Amount to which cash terms discount is applied. This value varies based on Walgreens/Vendor business relationship. If you have questions about this value, call the Walgreens EDI Invoicing Staff.
Monetary amount
- TDS03 is the amount of invoice due if paid by terms discount due date (total invoice or installment amount less cash discount).
Discounted (Net) Invoice Amount = Gross Invoice Amount (TDS01) less Cash Terms Discount Amount (TDS04).
Service, Promotion, Allowance, or Charge Information
To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge
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
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
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 expressed in the standard monetary denomination for the currency specified
- SAC08 is the allowance or charge rate per unit.
3 decimal positions will be accepted.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- AS
- Assortment
- CA
- Case
- DE
- Deal
- DZ
- Dozen
- EA
- Each
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.
2 decimal positions will be accepted
Numeric value of quantity
2 decimal positions will be accepted
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
Transaction Totals
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.
Total number of line items in the transaction set
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.
-.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.
Transaction Set Trailer
To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
Total number of segments included in a transaction set including ST and SE segments
Functional Group Trailer
To indicate the end of a functional group and to provide control information
Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element
Interchange Control Trailer
To define the end of an interchange of zero or more functional groups and interchange-related control segments
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.